Manually Adding Products into Database

[hercules151]

Hi, all. I am just getting started with Oscommerce and would like to know how to add a product manually into my Mysql oscommerce database. I am interested to know what fields in what tables are required to have content in order to have a product show up for visitors to the site. I searched the support forum for this, but could not find it. I would greatly appreciate any help.

 

Thanks,

Aaron

[♥ecartz]

You may want to look into the Easy Populate contribution. To appear in the store, a product needs entries in the products, products_description, and products_to_categories tables.

 

Hth,

Matt

[kepa]

Easy populate works well with bulk additions.

a product manually into my Mysql oscommerce database.

For that, why wouldn't you just do it through admin?

[bglkk]

It also depends if you've got product attributes--that brings a lot more tables & fields into play. So then you've got at least these tables to look at:

 

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

[hercules151]

Thanks for the help, guys. That points me in the right direction. FYI, I did see easy populate, but it seemed to need a lot of info that I couldnt provide. I wanted to know what fields were mandatory to have products listed. The end result is to have a file exported form a MS SQL database and imported into oscommerce. Right now I am wanting to keep this as simple as possible. When I looked at the Easy Populate code, I was a little overwhelmed. :) Thanks again for the help, guys.