Zen Cart custom software development, Zen Cart modules, Zen Cart Expert eCommerce with Zen Cart!

Zen Cart View Schema

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. Donate

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

Zen Cart View Schema

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:

  1. Back up everything! Try this in a test environment prior to installing it on a live shop.
  2. Copy the contents of the unzipped folder to the root directory of your shop.
  3. Run the view_schema.sql file against your database, using Admin > Tools > Install SQL Patches.

Major Versions

  • 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.