Home | Store | osCommerce Tutorials

osCommerce Database: Table products_to_categories

In order that visitors and buyers can browse all products easily, the osCommerce products are organized into different categories. The default osCommerce sample shop has: 27 products with 20 categories.

The database table products_to_categories assign products to their corresponding categories. Three examples are illustrated below. The table products and table categories_description are also attached here for your reference.

Example 1:

product_id 1 (Matrox G200 MMS) belong to categories_id 4 (Graphics Cards)

Please click the image below to see the details:

product_id 1 (Matrox G200 MMS) belong to categories_id 4 (Graphics Cards)

Example 2:

product_id 2 (Matrox G400 32MB ) belong to categories_id 4 (Graphics Cards)

product_id 2 (Matrox G400 32MB ) belong to categories_id 4 (Graphics Cards)

Example 3:

product_id 3 (Microsoft IntelliMouse Pro ) belong to categories_id 9 (Mice)

product_id 3 (Microsoft IntelliMouse Pro ) belong to categories_id 9 (Mice)

This is the end of osCommerce Database : Table products_to_categories

oscommerce mySQL database tutorial, oscommerce database structure