Hey Guys,
Has anyone had an experience on importing product reviews? I have them on a SQL DB I can create anything out of..
I just have 100's and 100's I don't want to lose when switching into Able.
Product Reviews - Importing Question
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Product Reviews - Importing Question
I was able to do it for a site. It was easier because I was moving from an Able 5 to an Able 7 store and the product ids stayed the same.
I used SQL backend to put the data into the appropriate tables, but since they had to have an existing reviewer in Able, I just created one called Customer Reviewer and used that ID in the references to the reviews.
I used SQL backend to put the data into the appropriate tables, but since they had to have an existing reviewer in Able, I just created one called Customer Reviewer and used that ID in the references to the reviews.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: Product Reviews - Importing Question
I saw product ID's as being my limitation.
In the database Able doesn't reference the SKU or anything besides the product ID correct?
In the database Able doesn't reference the SKU or anything besides the product ID correct?
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Product Reviews - Importing Question
Correct, it uses the Product_id to hook things up. You might be able to match in excel or something by using SKUs. I think the reviews give you such good content it would be worth the trouble.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx