phpMyAdmin uploads

[enquirer66]

I'm trying to upload a csv file of data (by the way not had much luck with easypopulate and don't wish to use it). So, the question is how do I upload data to the DB on my ZenCart installation. If I download all the tables relating to 'products' from the database confusingly it does not include either a name or description of the product. For that one has to download 'products_description' tables. The question is how do I match these two tables?

For example, suppose I upload 100 new products into the products table of the DB. I don't know what the Product ID will be until it has been uploaded. The MySQL DB will assign these IDs automatically (auto-increment). How will I know which products have been assigned which ID which I will need in order to marry the other upload which must be to the 'products_description' tables?

Thanks for any help.

[RodG]

The question is how do I match these two tables?
.

I'm not trying to be a smartass (for a change) but you'll find the following tutorial to be very beneficial:
http://www.w3schools.com/SQl/default.asp

Cheers
Rod

[enquirer66]

Thanks, a useful site but I prefer to work with phpMyAdmin. Anyway, I have resolved this now.

[CoolCarPartsOnline]

I have been using EP (paid version for years) I upload patches of thousands of products with no problems and I can assign the product_id before I add them. (EP tell you the last number in database so you don't have conflict).

Some things are easier done in phpmyadmin but adding a product isn't one of them since there are multiple tables associated with products. Just my 2 cents.

[enquirer66]

I've developed a system which I hope will speed up phpmyadmin uploads but the problem I've now got is as follows:

I uploaded three trial products along with the relevant data. I can see them in the DB (using phpMyAdmin) but I can't see them in my shop - they are nowhere to be found. Can anyone suggest why this is?

[CoolCarPartsOnline]

Because the product id are usually associated with more than one or 2 tables. Which is why we recommend EP. If you added the product correctly in myphpadmin there are no reason why they won't show up in store front or admin.