Add New Product Page to Drill Down

The category id to URL path relationship is maintained in the url_cats table.

The cat_id value matches the CatID field in Website_Categories (part of the Access to MySQL dump).

Each level is entered in its own column (level1, level2, level3…) These should be entered in lowercase and use dashes (-) as the word separator.

There should be no duplicates for either the cat_id or the full level1 to level6 expansion.

If you are CHANGING the path for an existing category, you will want to FIRST add entries to the intercept_404 table which will create a 301 redirect that points from the URL to the new URL for the category ID (good_cat)/product ID (good_prod). This is currently a manual process but it could have a admin page developed to handle this procedure.

The follwing script needs to be run to empty and replace the contents of the url_lookup table where the expanded paths for the category pages and the sku level pages are kept: https://www.beacontechnology.com/admin/create_urls.php (also linked to in admin)

You would then want to refresh the sitemap to ensure the new additions/changes are published to the search engines: https://www.beacontechnology.com/admin/googlexml.php (also linked to in admin)