Bulk Creation of Products Directly in the Database

[brettdalton]

I am currently setting up an online store and I'm trying to add around 5000 products in bulk by writing them directly to the database. I've pulled a data dump from my supplier in csv to get the product details. I created one product manually in the first instance through the normal Virtuemart interface in Joomla so I could see where the data was being written. From there, I went through each of the product tables and "massaged" the data so it fit the fields in the table. The products and related dependancies all appear to be ok, I can see the products on the front end buyt I can't see them in the control panel at the backend. Is there something I'm missing here? I kind of need to see them in the backend so I can make changes, edit them and add images as required.

Please help. I'm not a Joomla newbie but I am a Virtuemart newbie.

[GJC Web Design]

language table? vendor id?

[brettdalton]

Vendor ID was the offending field! Thanks