DB - Importing products

From Zen Cart(tm) Wiki

For a much more detailed understanding of relationships between tables, see the Database Schema documentation.

In order to create a basic product, you'll need to enter data into the following tables:

• products
• products_description
• products_to_categories
• categories
• categories_description
• manufacturers
• manufacturers_info

If you also want to add attributes to your products, add these:

• products_attributes
• products_attributes_download
• products_options
• products_options_values
• products_options_values_to_products_options

For music type products:

• product_music_extra
• music_genre
• record_artists
• record_artists_info
• record_company
• record_company_info