Two auto increments on products ID?

[Guest]

I'm trying to add a catalog via phpmyadmin. I popped the products into the products table, then I realized that the products description table's product_id is also auto-increment. Is there some means of linking tables I don't know about? When you add a product, how do two tables auto-increment independently? Shouldn't the product description table take the id from the products table?

[nimz]

no not really. two tables don't work together although they both get populated with new products when they are added.

If you are inserting new products using sql then you will need to insert into both tables manually

[♥geoffreywalton]

I was wondering why you would want to use phpmyadmin to add products when adding them through the shop admin area takes care of all the "relationships".

 

An even better way is to install the Easy Populate contribution which allows you to upload from a csv file.

 

Sorry if this is teaching you to suck eggs

[Guest]

I was wondering why you would want to use phpmyadmin to add products when adding them through the shop admin area takes care of all the "relationships".

 

An even better way is to install the Easy Populate contribution which allows you to upload from a csv file.

 

Sorry if this is teaching you to suck eggs

 

Teaching me to suck eggs? That's the funniest analogy I don't understand. :)

 

I'm over-cautious with contributions by default. I did see that one and I am considering it.

 

I guess I'm just trying to delve into the topics of database normalization and how osCommerce works. I would think that having two auto increments counts on the fact that the two will never be off. If a query fails somewhere along the line or something else happens, the to could be incrementing different values.

 

but thanks. The mention of Easy Populate serves as a reference. Maybe I'll try it.