How does the Database work?

[devilj]

Hello Everyone,

 

I was wondering how the database worked. I was interested in the Easy Populate Contrib. but was told that you do not have the ability to add product attributes at the same time (Use attribute copier). Is this because the attributes uses the product ID instead of the product name, in essence you need to create a product id before you can give it attributes. Is this correct?

 

Could one build an interface that would do the following:

 

1) Add to db a product with name, description, keywords, image, etc.

2) Query the db for the product_id using the Product Name

3) Create product attributes using the product id.

 

It would be a two stage db process.

 

My question in a nutshell, is the product id the key to entering product attributes, as I suspect?

 

Thanks for your time!

[devilj]

:D Anyone..anyone..

[Guest]

there is a bit more to it than that, your best bet to understand it, is to look into the database and see what happens, from creating the category, the product, then the option value, then the product option value to the products options values to products id, and finally the products attributes. . . not a simple task . .

[♥yesudo]

download a fresh copy of osc here: http://www.oscommerce.com/solutions/downloads to a spare dir and checkout the pdf file that comes with it showing the table relations.

 

may help.