VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: carbar on January 01, 2013, 10:02:09 AM

Title: Populate Product Tables
Post by: carbar on January 01, 2013, 10:02:09 AM
Hi,

I'm using VM 2.0.16 on Joomla 2.5.7.
I have 60+ products whose information is available in another database (oscommerce format).
I see the tables virtuemart_products and virtuemart_products_fa_ir containing the data I enter manually, and I was wondering if populating these two tables automatically would suffice.

Thanks for any guidance
:)
Title: Re: Populate Product Tables
Post by: PolishedGeek on January 01, 2013, 15:48:09 PM
There are other related tables you'll need to populate correctly to avoid having any errors. If you aren't familiar with the VM2 database, and just need to do a one time move, I recommend using a migration utility like Cart2Cart: http://www.shopping-cart-migration.com/supported-carts
Title: Re: Populate Product Tables
Post by: carbar on January 05, 2013, 10:57:14 AM
Quote from: PolishedGeek on January 01, 2013, 15:48:09 PM
There are other related tables you'll need to populate correctly to avoid having any errors. If you aren't familiar with the VM2 database, and just need to do a one time move, I recommend using a migration utility like Cart2Cart: http://www.shopping-cart-migration.com/supported-carts
Thanks but I have made modifications to the original osc database and a third party migration would create more headache. Is there a documentation on VM DB?
Title: Re: Populate Product Tables
Post by: jenkinhill on January 05, 2013, 16:52:52 PM
You could export the product data from Oscom as csv and import (after arranging the fields)  into VM2 using CSVI - http://csvimproved.com/
Title: Re: Populate Product Tables
Post by: carbar on January 20, 2013, 08:25:10 AM
Thanks for your reply :)