Stock Reserve & Reorder for OpenCart — physical stock, reserved orders and a reorder point

Stock Reserve & Reorder for OpenCart is a module for shops that keep goods in their own stockroom. OpenCart stores one number per product, Quantity, and takes an order off it as soon as the order enters a processing status, long before the parcel leaves the shelf. After a few days of sales the number in the admin no longer matches the shelf, and every stock count starts with the question “where did those 7 units go?”.

The module reads the orders and shows three figures for every product and every option value: physical stock (what is on the shelf), reserved (sold but not shipped yet, with the list of orders) and available (what you can still sell). A receipt adds +N on top of the stock instead of overwriting it; write-offs and stock counts are logged and can be cancelled. The reorder point comes from your sales speed, lead time and safety days.

There is a separate version for WooCommerce: Stock Reserve & Reorder for WooCommerce.

What the customer sees

Customers do not see the module: nothing changes in the storefront or the checkout, the module adds no scripts or requests to shop pages, and OpenCart keeps selling from the same Quantity field. Customers only notice the result: the product was reordered in time, not after the last unit had been sold twice.

What the admin gets

A Catalog → Stock & reorder menu item and the Stock, Reorder, Stock documents and Settings pages.

• Tiles: how many units are reserved and in how many lines, how many are physically on the shelf, how many lines need reordering and how many are oversold.
• Table for every product and option value that OpenCart subtracts from stock: OpenCart quantity, physical, reserved, available, sold in the period, reorder point and state: OK, Reorder, Oversold, Nothing available, Not tracked.
• A click on the reserve opens the orders that hold it: number, date, status, customer, quantity and whether OpenCart has already deducted the goods.
• Filters: search by name, model, SKU or #ID, category, with a reserve, reorder + oversold, nothing available, option values, disabled products; sorting by reserve, available stock, days of stock or urgency.
• Stock change from the row: receipt +N, write-off −N or stock count, where the counted shelf quantity becomes the physical stock. Every change is a document in the log with the counter before and after, and it can be cancelled.
• Product form line: Physical · reserved · available under the Quantity field, with a link to the stock page.

Reorder

• Reorder point = units sold per day × (lead time + safety days). A line goes to Reorder when the available stock is at or below this point, and to Oversold when more is reserved than physically on the shelf.
• Stock lasts: how many days of sales the available stock covers at the current speed.
• Pro: lead time, safety days, minimum stock, pack size and supplier for one product or option value; an Order column with the suggested quantity; CSV purchase list and Receipt from suggestions buttons.

Pro: stock documents, CSV and the daily digest

• Multi-line documents: a receipt, write-off or stock count with a number, supplier and note. Lines are pasted straight from a spreadsheet: SKU, model, #product_id or #product_id/option_value_id and a quantity. Check the lines shows the stock before and after; an unknown code, an ambiguous model or a zero quantity blocks the whole document until the line is fixed.
• CSV of the stock, the purchase list and every stock change: UTF-8 with BOM, semicolon separator, and names starting with = are not run as formulas in Excel.

• Daily digest: lines at or below the reorder point with the suggested quantity and, optionally, oversold lines. When nothing is due, nothing is sent.
• Channels: up to 5 e-mail addresses through the store mail settings, and Telegram (bot token and chat ID). In OpenCart 4 the OpenCart scheduler runs the digest, in 3 and 2.3 a URL with a secret key for the hosting cron.

How it works, step by step

1. The module takes the orders in the reserving statuses. By default these are the processing statuses of your store minus the complete ones, i.e. sold but not shipped.
2. For every product and option value it counts how much of those orders OpenCart has already taken off Quantity, with the same rule as the core (OpenCart 4.1 joins the processing and complete status lists, an OpenCart 4 variant also deducts its master product).
3. Physical = OpenCart quantity + the already deducted goods of reserving orders. Reserved = all goods of reserving orders. Available = physical − reserved.
4. Units sold per day = sold in the period (30 days by default) ÷ days. Reorder point = units per day × (lead time + safety days); in Pro never below the minimum stock.
5. A receipt, write-off or stock count changes Quantity with one atomic quantity + N query, so a sale arriving in the same second is not lost. Every change is logged and cancelling puts it back.

Under the hood

• No core edits. No OCMOD patches; the menu item and the product form line are added with OpenCart events. One class library is the same in all three builds, the code is PHP 7.0 compatible.
• Own tables oc_cc_stockres_doc (documents), oc_cc_stockres_move (change lines with the counter before and after), oc_cc_stockres_item (product parameters). Core tables are not changed.
• Calculated on the fly, once per request in a temporary table; no cache, so the figures are always fresh.
• Cron URL index.php?route=extension/cc_stockres/cron.cron&key=… (on 3.x and 2.3 extension/module/cc_stockres_cron/cron): without the key it answers 403, the digest goes out at most once a day and is retried if sending fails.
• The licence lives in its own settings group: Save never touches it.
• Uninstall removes the events and (OpenCart 4) the cron task and keeps the documents and product parameters, so a reinstall sees them. OpenCart deletes the module settings on uninstall; the licence in its own group stays. For full removal drop the oc_cc_stockres_* tables by hand.

Installation

1. OpenCart 4: Extensions → Installer → upload cc_stockres.ocmod.zip (keep the archive name) and press Install. OpenCart 3: Extensions → Installer → cc_stockres-oc3.ocmod.zip, then Extensions → Modifications → Refresh. OpenCart 2.3: upload the contents of the upload/ folder from cc_stockres-oc2.ocmod.zip to the shop root (FTP or the hosting file manager); the 2.3 Installer does not copy files without FTP set up.
2. Extensions → Extensions → Modules → CatCode Stock Reserve & Reorder → Install. The module is on right away.
3. Catalog → Stock & reorder. In Settings check the reserving statuses, the sales window, lead time and safety days.
4. For Pro: paste the licence key from the e-mail you get after payment, or press Try Pro for 7 days on the Licence tab.