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 of mysql_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 the customers 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.