Table categories description
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Contains all the information about a given category that can reasonably be translated into multiple languages. Each language for a given category will have it's own record in this table.
- Non-language specific data about each category is found in the categories table.
Table Details
Primary Keys
Indexed Fields
Columns
categories_id 
- Links the record to the corresponding data in the categories table. Foreign key to categories.categories_id.
Type: int(11) Null: No Default: 0
language_id
- Links the record to the corresponding data in the languages table. Foreign key to languages.languages_id.
Type: int(11) Null: No Default: 1
categories_name 
- The language-specific name of the category.
Type: varchar(32) Null: No Default:
categories_description
- The language-specific description of the category.
Type: text Null: No Default:
Default Entries (assuming demo data installed)
categories_id: 1 language_id: 1 caegories_name: Hardware categories_description: We offer a variety of Hardware from printers to graphics cards and mice to keyboards.
categories_id: 2 language_id: 1 caegories_name: Software categories_description: Select from an exciting list of software titles. <br /><br />Not seeing a title that you are looking for?
categories_id: 3 language_id: 1 caegories_name: DVD Movies categories_description: We offer a variety of DVD movies enjoyable for the whole family.<br /><br />Please browse the various categories to find your favorite movie today!
categories_id: 4 language_id: 1 caegories_name: Graphics Cards categories_description:
categories_id: 5 language_id: 1 caegories_name: Printers categories_description:
categories_id: 6 language_id: 1 caegories_name: Monitors categories_description:
categories_id: 7 language_id: 1 caegories_name: Speakers categories_description:
categories_id: 8 language_id: 1 caegories_name: Keyboards categories_description:
categories_id: 9 language_id: 1 caegories_name: Mice categories_description: Pick the right mouse for your individual computer needs!<br /><br />Contact Us if you are looking for a particular mouse that we do not currently have in stock.
categories_id: 10 language_id: 1 caegories_name: Action categories_description: <p>Get into the action with our Action collection of DVD movies!<br /><br />Don't miss the excitement and order your's today!<br /><br /></p>
categories_id: 11 language_id: 1 caegories_name: Science Fiction categories_description:
categories_id: 12 language_id: 1 caegories_name: Comedy categories_description:
categories_id: 13 language_id: 1 caegories_name: Cartoons categories_description: Something you can enjoy with children of all ages!
categories_id: 14 language_id: 1 caegories_name: Thriller categories_description:
categories_id: 15 language_id: 1 caegories_name: Drama categories_description:
categories_id: 16 language_id: 1 caegories_name: Memory categories_description:
categories_id: 17 language_id: 1 caegories_name: CDROM Drives categories_description:
categories_id: 18 language_id: 1 caegories_name: Simulation categories_description:
categories_id: 19 language_id: 1 caegories_name: Action categories_description:
categories_id: 20 language_id: 1 caegories_name: Strategy categories_description:
categories_id: 60 language_id: 1 caegories_name: Downloads categories_description:
categories_id: 58 language_id: 1 caegories_name: Real Sale categories_description:
categories_id: 21 language_id: 1 caegories_name: Gift Certificates categories_description: Send a Gift Certificate today!<br /><br />Gift Certificates are good for anything in the store.
categories_id: 57 language_id: 1 caegories_name: Text Pricing categories_description:
categories_id: 56 language_id: 1 caegories_name: Attributes categories_description:
categories_id: 22 language_id: 1 caegories_name: Big Linked categories_description: All of these products are "Linked Products".<br /><br />This means that they appear in more than one Category.<br /><br />However, you only have to maintain the product in one place.<br /><br />The Master Product is used for pricing purposes.
categories_id: 55 language_id: 1 caegories_name: Discount Qty categories_description: <p>Discount Quantities can be set for Products or on the individual attributes.<br /><br />Discounts on the Product do NOT reflect on the attributes price.<br /><br />Only discounts based on Special and Sale Prices are applied to attribute prices.</p>
categories_id: 23 language_id: 1 caegories_name: Test Examples categories_description:
categories_id: 24 language_id: 1 caegories_name: Free Call Stuff categories_description:
categories_id: 25 language_id: 1 caegories_name: Test 10% by Attrib categories_description:
categories_id: 27 language_id: 1 caegories_name: $5.00 off categories_description:
categories_id: 28 language_id: 1 caegories_name: Test 10% categories_description:
categories_id: 31 language_id: 1 caegories_name: 10% off Skip categories_description:
categories_id: 32 language_id: 1 caegories_name: 10% off Price categories_description:
categories_id: 47 language_id: 1 caegories_name: 10% off Attrib categories_description:
categories_id: 33 language_id: 1 caegories_name: A Top Level Cat categories_description: <p>This is a top level catagories description.</p>
categories_id: 34 language_id: 1 caegories_name: SubLevel 2 A categories_description: This is a sublevel categories description.
categories_id: 35 language_id: 1 caegories_name: SubLevel 2 B categories_description:
categories_id: 36 language_id: 1 caegories_name: SubLevel 2 C categories_description:
categories_id: 37 language_id: 1 caegories_name: Sub Sub Cat 2B1 categories_description:
categories_id: 38 language_id: 1 caegories_name: Sub Sub Cat 2B2 categories_description:
categories_id: 39 language_id: 1 caegories_name: Sub Sub Cat 2B3 categories_description:
categories_id: 40 language_id: 1 caegories_name: Sub Sub Cat 2A1 categories_description: This is a sub-sub level categories description.
categories_id: 41 language_id: 1 caegories_name: Sub Sub Cat 2C1 categories_description:
categories_id: 42 language_id: 1 caegories_name: Sub Sub Cat 2C3 categories_description:
categories_id: 43 language_id: 1 caegories_name: Sub Sub Cat 2A2 categories_description:
categories_id: 44 language_id: 1 caegories_name: Sub Sub Cat 2C2 categories_description:
categories_id: 45 language_id: 1 caegories_name: 10% off categories_description:
categories_id: 46 language_id: 1 caegories_name: Set $100 categories_description:
categories_id: 48 language_id: 1 caegories_name: Sale Percentage categories_description:
categories_id: 49 language_id: 1 caegories_name: Sale Deduction categories_description:
categories_id: 50 language_id: 1 caegories_name: Sale New Price categories_description:
categories_id: 51 language_id: 1 caegories_name: Set $100 Skip categories_description:
categories_id: 52 language_id: 1 caegories_name: $5.00 off Skip categories_description:
categories_id: 53 language_id: 1 caegories_name: Big Unlinked categories_description:
categories_id: 54 language_id: 1 caegories_name: New v1.2 categories_description: <p>The New Products show many of the newest features that have been added to Zen Cart.<br /><br />Take the time to review these and the other Demo Products to better understand all the options and features that Zen Cart has to offer.</p>
categories_id: 61 language_id: 1 caegories_name: Real categories_description:
categories_id: 62 language_id: 1 caegories_name: Music categories_description:
categories_id: 63 language_id: 1 caegories_name: Documents categories_description: Documents can now be added to the category tree. For example you may want to add servicing/Technical documents. Or use Documents as an integrated FAQ system on your site. The implemetation here is fairly spartan, but could be expanded to offer PDF downloads, links to purchaseable download files. The possibilities are endless and left to your imagination.
categories_id: 64 language_id: 1 caegories_name: Mixed Product Types categories_description: This is a category with mixed product types. This includes both products and documents. There are two types of documents - Documents that are for reading and Documents that are for reading and purchasing.
