Adding items to the database

[mrickert]

So I'm trying to add items into the database "on the fly" when my users query another database. I have all the information about the product, but it is not in the OSC database.

 

When I examine the OSC database, there is a table named PRODUCTS. The fields in this table are:

products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered.

 

If I write my own script to populate these fields, will this new item be available to add the the OSC cart? Or are there more tables to add things to?

 

Thanks

 

Matt

[kgt]

You need a category entry (categories and categories_description) and an entry to match your product to a category (products_to_categories). You also need an entry in the products_description table.

[mrickert]

Great, thanks for the info.