Zen Cart View SchemaThe 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.0 (version history)
Support Thread: View Schema Support Thread
Cost: Free, but donation appreciated
Installed Cost: $60.00 Buy Professional Installation by That Software Guy
Installation Difficulty: Easy
Installation Instructions: click here
Location: Zen Cart Plugins, under Admin Tools
Download: View Schema in Zen Cart Plugins
FAQ: click here
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_idis bolded, since it is the primary key for the table.
- The field
customers_idis a link, because it is a foreign key. Clicking the link takes you to the entry for the
- 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.
- 1.0 04/01/2020 - First Release
FAQQ: 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