
Zen Cart View Schema
The View Schema mod allows you to see your database schema.Donate: This is free software. Show your appreciation by supporting my efforts.

Relevance: Zen Cart™ 1.5.1 and above
Current Version: 1.1 (version history)
Support Thread: View Schema Support Thread
Cost: Free, but donation appreciated
Installed Cost: $100.00 Buy Professional Installation by That Software Guy
Installation Difficulty: Easy
Installation Instructions: click here for installation instructions
Location: Zen Cart Plugins, under Admin Tools
Download: View Schema in Zen Cart Plugins
FAQ: click here for FAQ
Related: You may also be interested in my Mod List contribution.
Overview:
View Schema in a Zen Cart can help you quickly track down problems with your database. Compare the results of View Schema with a copy ofmysql_zencart.sql
(the database creation script) for your
version of Zen Cart.
Here's how it looks:
View Schema in Zen Cart Admin

Two things to notice:
- the field
address_book_id
is bolded, since it is the primary key for the table. - The field
customers_id
is a link, because it is a foreign key. Clicking the link takes you to the entry for thecustomers
table.
Installation Instructions:
- Back up everything! Try this in a test environment prior to installing it on a live shop.
- Copy the contents of the unzipped folder to the root directory of your shop.
- Run the view_schema.sql file against your database, using Admin > Tools > Install SQL Patches.
Major Versions
- 1.1 03/07/2024 - Update for 2.0.0 (uses admin_html_head).
- 1.0a 07/05/2020 - Fixed filename definition bug
- 1.0 04/01/2020 - First Release
FAQ
Q: How do I know what the original schema for my version looked like?A: The most common versions of Zen Cart have schema documentation loaded on the documentation site.
- Zen Cart 1.5.6 Schema
- Zen Cart 1.5.5 Schema
- Zen Cart 1.5.4 Schema
- Zen Cart 1.5.1 Schema
- Zen Cart 1.3.9 Schema