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

Zen Cart Audit

Zen Cart Audit

The Audit mod runs a series of consistency checks on your database.

Donate: This is free software. Show your appreciation by supporting my efforts. Donate

Relevance: Zen Cart™ 1.5.4 and above

Current Version: 1.0a

Support Thread: Audit 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: Audit in Zen Cart Plugins


Overview:

Audit runs a series of checks on your database. When it finds problems, it makes recommendations on how to fix them.

Operation:

First, let's see what audit reports on a site with no issues. The table border is green, and a success message is shown.
Zen Cart Audit finds no issues

If there are issues, the table border is red, and the columns show the issue and possible ways to resolve it.

  1. Product not present in Products to Categories table
    Each product should have one or more entries in the products_to_categories table. You can press the link to add an entry in the table and resolve this issue.
    Zen Cart Audit finds missing product,category pair in products_to_categories table

  2. Missing Product ID, Master Categories ID pair
    Each product should have one or more entries in the products_to_categories table. You can press the link to add an entry in the table and resolve this issue.

    The difference between this and the previous issue is that in this case, there is at least one entry in the products_to_categories table (but not the expected entry of {products_id, master categories_id})
    Zen Cart Audit finds missing product,category pair in products_to_categories table

  3. Master category ID 0
    Each product should have a non-zero master category, indicating the parent the product is underneath. You can press the link to move the product to the correct category. As an interim step, the product will be moved to the SAFE_CATEGORY.
    Note that a similar message is issued if the product's master category is the safe category, since this is designed to be a temporary holding place only.

    Zen Cart Audit finds missing product,category pair in products_to_categories table

    Part of the process of moving a product with the audit tool is removing any existing linked categories, so if the product is linked, you will need to re-add it to any linked categories.

  4. Empty Categories
    Empty categories may be deleted using the Delete Category link. Note that deleting one or more categories may lead to the reporting of additional empty categories if the deleted categories were children of a parent category with no more children.
    Zen Cart Audit finds empty categories

  5. Product with type 0
    Products can be misconfigured with type 0 in a variety of ways. You'll want to correct this. The most common product type is 1, so the fix link sets it to this value; you can further modify that in the normal Zen Cart editor.
    Zen Cart Audit finds product with type 0

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 audit.sql file against your database, using Admin->Tools->Install SQL Patches.
  4. Create a category named SAFE. This will be used as a temporary holding place for products being moved.
  5. Run Audit from under Admin->Tools.


Major Versions

  • 1.0a 10/04/2019 - Fix PHP notice
  • 1.0 10/01/2019 - First Release