Home | Store | osCommerce Tutorials

osCommerce Database: Categories Description

Categories Description Table

The most important table of osCommerce database should be the categories_description. It contains the description of all categories, both main categories (e.g. Hardware, Softwares, etc.) and sub-categories (e.g. CDROM Drives, Graphics Cards, etc.).

There are a total of 20 Categories of default osCommerce shop:

  • Hardware has 9 categories,
  • Software has 4 categories, and
  • DVD Movies has 7 categories.
The categories description are saved under the categories_name field. The languages of each category description are saved under the language_id, 1 for English, 2 for Deutsch and 3 for Espanol in this online shop.

oscommerce mySQL database tutorial, oscommerce database structure