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.
language table? vendor id?
Vendor ID was the offending field! Thanks :)