============================================================================= Catalog Optimizer [NAT] - Opencart.com Combined Title, Description, Docs & Keywords ============================================================================= ============================================================================= 1. TITLE ============================================================================= Catalog Optimizer [NAT]: Hide Empty Categories/Brands by Cron, Sort Order 9999 & Database Cleanup of Unused Attributes/Options ============================================================================= 2. SHORT DESCRIPTION ============================================================================= Automatic (Cron) & manual control over empty categories/brands visibility (3 methods). SEO-pessimization (9999 sorting) and stock status updates for out-of-stock items. Deep database cleanup of unused options, attributes, ocFilter, dead SEO URLs, and downloads (with file unlinking). Smart attribute trimming & merging. Fast AJAX chunked table backups in ZIP & simulation dry-run mode for total safety! ============================================================================= 3. FULL DESCRIPTION (BB CODE, NO EMOJIS, NO SIZE TAGS) ============================================================================= [b]Catalog Optimizer [NAT]: Hide Empty Categories/Brands, Out-of-Stock SEO-Pessimization (Sort Order 9999) & Deep Database Cleanup of Unused Attributes, Options, Filters & Downloads[/b] [b]Compatibility:[/b] OpenCart, ocStore 2.3.x, 3.0.x, 3.0 Cloud [b]Languages:[/b] English, Ukrainian, Russian (Full Localization) [b]PHP Versions:[/b] 7.1 - 8.2 [b]Series:[/b] [NAT] Zero-Trust Web Extensions [hr] [b]OFFICIAL DEMO STAND:[/b] [b]Login / Password:[/b] demo / demo [b]Admin Panel Link:[/b] [url=https://oc3-demo.nat.od.ua/admin/index.php?route=extension/module/catalog_optimizer_nat]ADMIN CONTROL PANEL (DEMO)[/url] [hr] [b]What is the main challenge with managing large OpenCart catalogs?[/b] Managing a large e-commerce catalog often becomes an endless routine. When products sell out, "ghost" empty categories and brands remain active on the storefront. Customers click on them, find "No products match" page, and immediately bounce—killing your conversion rates and search engine rankings. In addition, manually deleting products leaves behind orphaned metadata, attributes, empty filters, and broken SEO URLs. This clutters database tables, degrades filter module performance (such as ocFilter), and generates 404 crawl errors that hurt search visibility. [b]Core problems for store managers:[/b] * [b]Empty Sections:[/b] Manually searching and disabling categories without stock takes hours of daily work. * [b]Database Bloat:[/b] Deleted products leave behind thousands of orphaned attributes, options, and filters, slowing down queries. * [b]SEO Penalties:[/b] Deleting out-of-stock products destroys their Google ranking history. At the same time, keeping them active at the top of the listings pushes available goods out of view. * [b]Incorrect Breadcrumbs:[/b] Products linked to multiple categories often display incorrect parent paths in SEO Pro instead of the deepest path. [hr] [b]Why does Catalog Optimizer [NAT] solve these pain points completely?[/b] This module is designed to fully automate catalog management and database cleanup. It dynamically hides empty categories/manufacturers, moves out-of-stock items to the bottom of listing pages (Sort Order 9999), fixes main categories to the deepest path for accurate breadcrumbs, and purges orphaned databases and downloads folders. Zero manual work required. All actions run through a visual simulation tool beforehand, support instant chunked AJAX table backups, and can run autonomously in the background via Cron! [hr] [b]What does the Catalog Optimizer [NAT] module offer?[/b] [table] [tr] [td][b]Feature / Tool[/b][/td] [td][b]What problem does it solve?[/b][/td] [td][b]How it works and Result[/b][/td] [/tr] [tr] [td][b]1. Category Management[/b][/td] [td]Empty storefront categories driving customers away and ruining Google rankings.[/td] [td]Automatically hides categories if the count of active products falls below your threshold (e.g. 1). Re-enables the category once stock is replenished.[/td] [/tr] [tr] [td][b]2. Brand Hiding (3 Methods)[/b][/td] [td]Empty manufacturer pages. Standard OpenCart lacks status control for brands.[/td] [td]Hides empty brands using 3 options: adding a status field, setting noindex meta tags (for ocStore), or Store Unlink (removes link from main store, 100% compatible with OpenCart Cloud).[/td] [/tr] [tr] [td][b]3. SEO Pessimization[/b][/td] [td]Out-of-stock items appearing at the top of listings and hiding available products.[/td] [td]Detects zero-stock products and bulk assigns them a Sort Order of 9999 (pushes to the bottom of the list). Reverts order to 1 when restocked.[/td] [/tr] [tr] [td][b]4. Stock Status & Zero Price[/b][/td] [td]Manually changing stock status tags or handling products with zero price (0.00).[/td] [td]Automatically updates zero-qty items to a specific stock status ID (e.g. "Pre-order") or disables them. Safely handles zero-price products.[/td] [/tr] [tr] [td][b]5. Deepest Category Path[/b][/td] [td]Incorrect breadcrumb trails and short, non-optimal URLs in SEO Pro configurations.[/td] [td]Scans product-to-category associations and assigns the deepest nested subcategory as the main category.[/td] [/tr] [tr] [td][b]6. DB Options & Filters Cleanup[/b][/td] [td]Orphaned attributes, options, and filters slowing down queries and storefront searches.[/td] [td]Scans catalog tables and purges attributes, options, option values, and filters not connected to any active product.[/td] [/tr] [tr] [td][b]7. ocFilter Cleanup[/b][/td] [td]ocFilter automatically re-generating empty, unused specification filters.[/td] [td]Fully purges unused ocFilter specifications and values, preventing them from spawning back.[/td] [/tr] [tr] [td][b]8. Downloads Cleanup[/b][/td] [td]Orphaned manual/certificate attachments consuming web hosting storage space.[/td] [td]Scans files and database, deletes unused download records, and unlinks the files physically from your server disk using php unlink function.[/td] [/tr] [tr] [td][b]9. Trim & Merge Attributes[/b][/td] [td]Duplicate attribute descriptors (e.g. "Color", "color", "Color ") causing filter issues.[/td] [td]Trims whitespaces from attribute values. Merges case-insensitive duplicate attributes, migrating product associations to the primary ID.[/td] [/tr] [tr] [td][b]10. SEO URLs & Duplicates[/b][/td] [td]Orphaned SEO URL links generating mass 404 errors, and duplicate keyword conflicts.[/td] [td]Deletes dead SEO URLs linked to deleted items. Scans and highlights keyword duplicates (where one link targets multiple URLs) for easy manual fixes.[/td] [/tr] [tr] [td][b]11. AJAX Backup & Simulation[/b][/td] [td]Risk of damaging database tables when performing bulk changes on large stores.[/td] [td]Simulation mode outputs detailed logs beforehand. Fast AJAX table backup generates contextual tables ZIP files in seconds without timeouts.[/td] [/tr] [/table] [hr] [b]Detailed description of tabs and settings:[/b] [b]1. Categories Tab:[/b] * [b]Product Threshold:[/b] Automatically toggles category visibility if the active product count drops below the threshold. * [b]Flexible Calculations:[/b] Filter active items by status (status = 1), stock levels (quantity > 0), or exclude specific product IDs. * [b]Exclusions List:[/b] Enter category IDs that must remain active under all conditions (e.g. promo or root sections). * [b]Simulation & Backup:[/b] Runs a test configuration and displays category tree before writing database changes. [b]2. Brands Tab:[/b] * [b]Three Brand Hiding Strategies:[/b] Status flag injection, noindex tag deployment (ocStore), or Store Layout Unlink (removes link from main store, forces safe 404, zero core changes, perfect for OpenCart Cloud). * [b]Rules Matching:[/b] Same as category rules: set active product thresholds, stock status conditions, and exclusion lists. [b]3. Products Tab:[/b] * [b]SEO Pessimization:[/b] Bulk toggles out-of-stock items to sort order 9999, pushing them to page ends, and reverts back on restock. * [b]Stock Status Automation:[/b] Sets custom stock labels (e.g. "Pre-order") dynamically for zero-quantity items. * [b]Zero Price Control:[/b] Automate status disabling or warehouse stock labels for zero-price products. * [b]Main Category Correction:[/b] Assigns the deepest nested category path as the main category to resolve breadcrumbs and SEO Pro conflicts. * [b]Scope Control:[/b] Restrict product updates to specific categories or manufacturers. [b]4. Cleanup Tab:[/b] * [b]Purge Junk Records:[/b] Cleans empty attributes, options, values, filters, ocFilter parameters, and unused download files. * [b]Interactive Logs:[/b] Inspect found junk items and uncheck any you wish to keep before purging. * [b]Attributes Dedup & Norm:[/b] Trim spaces and merge attributes with matching names. * [b]SEO URL Audit:[/b] Purges dead keywords of deleted items, and scans for duplicated keyword conflicts. [b]5. Auto Import (CRON) Tab:[/b] * [b]Background Automation:[/b] Map category, brand, product sorting, and cleanup tasks to run on schedule via server Cron. * [b]Secure URL Token:[/b] Access key (cron_key) protection against unauthorized executions. [b]6. Database Backup Tab:[/b] * [b]Targeted Table Backup:[/b] Dumps only affected category/brand/product tables into ZIP archives. * [b]AJAX Chunked Processing:[/b] Splits dumps into 2000-line packages to avoid PHP execution limits and timeouts. [hr] [b]Other Modules in the [NAT] Series:[/b] [list] [*][b]Database Optimizer [NAT]:[/b] Intelligent DB garbage cleanup, table compression, system log management, and critical index analyzer to speed up your site. [*][b]Catalog Optimizer [NAT]:[/b] Automatically hide empty categories and brands, push out-of-stock products to the end of the list (SEO pessimization), and clean up unused attributes. [*][b]Image Optimizer [NAT]:[/b] Compress and resize original photos to WebP and bulk delete unused or junk images from your hosting server. [*][b]Domain Scanner [NAT]:[/b] Search and safely replace external links and HTTP images in your database and theme files. Essential for HTTPS migration. [*][b]New Arrivals [NAT]:[/b] Display products by true chronological sorting (Date Added). Features auto-generated SEO pages, smart widgets, and date archives. [*][b]Poll Widget [NAT]:[/b] Create simple polls, custom voting forms, and view real-time statistics directly on your store pages to boost customer engagement. [*][b]Easy Import/Export [NAT]:[/b] Fast price and stock import/export with synonym dictionaries auto-mapping, visual previews, WAF-safe filters, and price backups. [*][b]Admin Tools [NAT]:[/b] Handy administrator tools: login as customer, admin customization, user permissions management, and hiding unnecessary menu items. [*][b]Order UTM Tracker [NAT]:[/b] Automatic tracking of UTM tags during checkout. Saves the traffic source, campaign, keywords, and displays this data in order details to analyze advertising effectiveness. [*][b]Promo Top Bar [NAT]:[/b] Create interactive promo bars and header slideshows with a block builder, countdown timers, subscription forms, and flexible targeting. [/list] ============================================================================= 4. TECHNICAL DOCUMENTATION & INSTRUCTIONS ============================================================================= [b]Technical Documentation & Instructions[/b] [hr] [b]1. Installation Guide[/b] [b]For Standard OpenCart & ocStore 3.0.x / 2.3.x Installations:[/b] [list=1] [*]Go to your OpenCart admin panel: [b]Extensions[/b] -> [b]Installer[/b]. [*]Click the Upload button and upload the [code]catalog_optimizer_nat_oc30.ocmod.zip[/code] archive (or [code]catalog_optimizer_nat_oc23.ocmod.zip[/code] if using OpenCart 2.3). [*]Go to [b]Extensions[/b] -> [b]Modifications[/b] and click the blue [b]Refresh[/b] button at the top right to clear the system modifications cache. [*]Go to [b]System[/b] -> [b]Users[/b] -> [b]User Groups[/b], edit your Top Administrator group (e.g. Administrator). Click [b]Select All[/b] for both Access and Modify permissions, then click Save. [*]Go to [b]Extensions[/b] -> [b]Extensions[/b] -> choose [b]Modules[/b] from the dropdown, find [b]Catalog Optimizer [NAT][/b], click the green [b]Install[/b] button, and then click [b]Edit[/b]. [/list] [b]For OpenCart 3.0 Cloud / Event-Based Installations (Without XML):[/b] [list=1] [*]Go to OpenCart admin panel: [b]Extensions[/b] -> [b]Installer[/b]. [*]Click the Upload button and upload the [code]catalog_optimizer_nat_oc30cloud.ocmod.zip[/code] archive. Note that Cloud version relies purely on OpenCart events, so no XML modification modifications cache refresh is required. [*]Go to [b]System[/b] -> [b]Users[/b] -> [b]User Groups[/b], edit the Administrator group, and grant Access and Modify permissions for the controller route [code]extension/module/catalog_optimizer_nat[/code]. [*]Go to [b]Extensions[/b] -> [b]Extensions[/b] -> choose [b]Modules[/b] from the dropdown, find [b]Catalog Optimizer [NAT][/b] and click [b]Install[/b], then [b]Edit[/b]. [/list] [hr] [b]2. Module Update Instructions[/b] [list=1] [*]Go to [b]Extensions[/b] -> [b]Installer[/b] and upload the new zip file directly over the old version. [*]Go to [b]Extensions[/b] -> [b]Modifications[/b] and click the blue [b]Refresh[/b] button (applicable for Standard installations only). [*]Hard refresh your browser cache (press [b]Ctrl+F5[/b] on Windows or [b]Cmd+Shift+R[/b] on Mac) on the module settings page to load updated Javascript and stylesheet assets. [/list] [hr] [b]3. Uninstallation Instructions[/b] [list=1] [*]Go to [b]Extensions[/b] -> [b]Extensions[/b] -> [b]Modules[/b], scroll to [b]Catalog Optimizer [NAT][/b], and click the red [b]Uninstall[/b] button. [*]Go to [b]Extensions[/b] -> [b]Installer[/b], find the extension in the installation history table, and click [b]Delete[/b]. [*]Go to [b]Extensions[/b] -> [b]Modifications[/b] and click the blue [b]Refresh[/b] button (for standard installations). [/list] [hr] [b]4. Automating Updates via CRON[/b] To run catalog optimizations automatically in the background, you can schedule task executions on your web server using CRON: [list=1] [*]Configure a synchronization profile under the [b]Auto Import (CRON)[/b] tab. [*]Select the tasks and copy the command generated by the script in the [b]CRON Command for Hosting[/b] field. [*]The Cron URL format will resemble: [code]wget -q -O - "https://yourdomain.com/index.php?route=extension/module/catalog_optimizer_nat/cron&key=YOUR_CRON_SECRET_TOKEN" >/dev/null 2>&1[/code] [*]Log into your hosting control panel (e.g. cPanel, ISPmanager, Plesk), open [b]Cron Jobs[/b] or [b]Task Scheduler[/b], paste the command, and set the schedule (e.g. every day at midnight: [code]0 0 * * *[/code]). [/list] [hr] [b]5. Terms & Conditions (License & Support Policy)[/b] By purchasing and downloading this extension, you strictly agree to the following terms: [list] [*][b]Single Domain License:[/b] One purchase allows you to install and use the extension on exactly one (1) live domain and one (1) local/test environment. You need a separate License Key for each additional live project. [*][b]License Activation:[/b] The module requires a License Key to function. Please email [b]info@nat.od.ua[/b] with your Order ID and Domain Name after purchase to receive your key. [*][b]Support:[/b] We provide free technical support for bugs and standard installation issues. Support is available via email. Please allow up to 24-48 hours for a response. [*][b]Compatibility:[/b] The module is guaranteed to work on standard OpenCart / ocStore installations. We cannot guarantee out-of-the-box compatibility with heavily customized core files or third-party checkout/theme modules, though we will do our best to assist you. [*][b]Refund Policy:[/b] We offer a 100% refund if the extension is completely non-functional on a standard OpenCart setup and our support team is unable to fix it. We do not issue refunds for "change of mind" or if you have already requested and received a domain license key. [*][b]Distribution:[/b] The code is open-source (no IonCube), meaning you can modify it for your own needs. However, you may not resell, redistribute, share, or publish this extension in any form. [/list] ============================================================================= 5. KEYWORDS & TAGS (BB CODE, NO EMOJIS) ============================================================================= [b]Module Keywords and Tags:[/b] [list] [*]catalog optimizer [*]hide empty categories [*]hide empty brands [*]out of stock [*]seo manager [*]sort order [*]database cleanup [*]db cleaner [*]remove unused attributes [*]remove unused options [*]fix 404 [*]broken links [*]bulk edit [*]stock status [*]automation [*]seo duplicate [*]ocfilter cleanup [*]downloads cleanup [/list]