Adding a child table to the products table
How to add a table linked to the products table by a foreign key
Database
Database structure, schema history, and database-related development topics
Use this section for table changes, querying patterns, schema history, and other database-related development work.
Start with:
Adding a field to the customers table
How to add a field to the customers table
Adding a field to the products table
How to add a field to the products table
Adding a Status History Record to an Order
How to use the zen_update_orders_history function
Audit tool
Finding issues in your database
Creating or Modifying a table
Modifying the database schema
Missing Products Description records
Handling product table records which lack matching product_description records
Modifying a field in the products table
How to modify a field in the products table
Products and Categories at the Same Level
Restrictions on category contents
Querying the Database
Using QueryFactory
Schema
How the Zen Cart Database is structured
Last modified May 27, 2026 by Ian Wilson (e07ac859).