Configure Counterpoint lot tracking for online expiry dates

Perishable inventory creates a different challenge from ordinary stock counting. A shelf may be full while saleable quantity is falling, and a batch can become unsuitable before its physical quantity reaches zero. For an Australian retailer selling groceries, cosmetics, temperature-sensitive products or packaged food online, lot number tracking gives each batch a traceable identity, while expiry dates determine whether it can be promised, picked, dispatched or returned. That discipline supports traceable customer service when staff must explain exactly which batch left the warehouse.

Counterpoint can hold the operational record for those batches, but the online catalogue needs an equally clear view of what is available. Because NCR Retail Online has been discontinued, retailers moving to Magento or WooCommerce through NCR Counterpoint partners must define which platform owns each field and which system authorises a sale. Comparing inventory sync options is useful at this stage because a controlled stock feed is more valuable than a high-frequency feed that cannot explain a lot discrepancy.

Establish lot tracking at item level

Begin with the item master, not the web page. In the Counterpoint administration area, enable lot control for each relevant SKU or product group; field labels differ between Counterpoint releases, so confirm the configuration with an implementation partner. Make the rule explicit: ordinary stock can be sold by quantity, whereas controlled stock must resolve to a lot before it is committed. A category such as the site’s cookware product catalogue provides a useful control example because cookware normally needs quantity and variant tracking rather than expiry control.

At minimum, capture a unique lot identifier, supplier lot reference, receipt date, expiry date, quantity, purchase cost, location and stock status. Keep the internal lot identity separate from the consumer-facing SKU. A product should not receive a new SKU merely because its expiry date changes, as that creates unnecessary catalogue duplication and makes stock reconciliation harder. If the same batch can sit in several warehouses, treat the lot and location as separate dimensions while retaining one common batch history.

Build lot recording into goods receipt rather than adding it after delivery. The purchase-order receipt should prompt for lot, expiry and quantity, and stock without a valid expiry date should enter a hold state. Quarantine, damaged and expired batches need statuses that cannot be allocated to customer orders. Counterpoint user permissions should restrict manual status changes and batch overrides, while an audit trail records who received, moved, released or rejected each lot.

Define expiry and allocation rules

Store machine-readable dates consistently, preferably in ISO YYYY-MM-DD format, even when staff and customers in Australia see the familiar day/month/year presentation. A date-only expiry is usually sufficient for packaged products, but temperature-controlled or shelf-life calculations may require a time and timestamp. Clearly distinguish a product’s expiry date from its manufacture date, best-before date, received date and promotional end date so that a general stock rule does not accidentally apply the wrong deadline.

Use a defined allocation sequence across eligible lots. First Expiry, First Out is appropriate when older batches should leave inventory first, with receipt date acting as a tie-breaker where expiry dates match. Partial allocations must remain attached to the original lot, and an online reservation should hold the exact quantity until the order is confirmed or the reservation expires. Counterpoint should reject allocation of expired, quarantined or damaged lots unless an authorised user records a formal override and reason.

Expiry flags support operational decisions but do not replace a legal assessment. Australian food labelling commonly distinguishes “use by” dates, where safety is relevant, from “best before” dates, which primarily relate to quality. The Australian Competition and Consumer Commission and the Australian Consumer Law require accurate representations and prohibit selling food that is unsafe. Packaging and allergen disclosures must also meet the applicable Food Standards Code and Food Standards Australia New Zealand requirements, with relevant state and territory food laws applying to the seller.

Synchronise controlled stock with ecommerce

Map each online product to one controlled Counterpoint SKU. The quantity published to the storefront should be the sum of sellable lots, not a general stock figure that includes expired, quarantined or reserved units. Internal lot numbers can remain hidden unless the retailer intentionally offers batch-level traceability. If customers can choose a batch, expiry information must come from the same Counterpoint record used to authorise fulfilment.

For Magento or WooCommerce, define a compact integration contract covering SKU, sellable quantity, reserved quantity, lot identifier, expiry date, location and update time. Order creation should reserve stock in Counterpoint, while fulfilment confirmation should identify the lots actually shipped. Webhooks should be idempotent so a repeated event cannot deduct the same units twice, and reconciliation should compare the order ledger with the web platform after every cycle.

The mapping must preserve the difference between product attributes and inventory dimensions. The archived menswear product page illustrates how colour, size and fit can create many variants; those variations should map to the correct SKU without duplicating identical stock records. Australian stores should also keep catalogue prices in Australian dollars while the tax engine applies the 10% GST only where the product category is taxable, with most staple food generally treated as GST-free.

Test exceptions before going live

Test the complete lot lifecycle with more than a simple sale and return. Include several lots with the same expiry, partial receipts, a receipt with a missing date, an expired lot, a quarantined batch, a cancelled order and a return opened after dispatch. Attempt to oversell the last sellable unit from two customers at the same time and confirm that only one reservation succeeds. Each online order should reconcile to a Counterpoint sales transaction and the correct lot movement.

Physical picking must follow the allocation result rather than relying on a warehouse worker to remember which batch is oldest. Pick lists and labels should show the lot identifier where staff need it, while customer documents should use the approved Australian date format. Updates must account for Sydney and Melbourne daylight-saving changes; Brisbane remains in Eastern Time without daylight saving. Stores supplying customers across major cities should also account for transit time, since stock promised online may spend several days in transit between Melbourne, Brisbane, Sydney and regional distribution points.

Imported batches need their compliance status treated as part of availability. Keep customs entries, supplier documents and relevant biosecurity clearances associated with the lot, since Australian border controls can delay or hold food consignments. Rule documentation should be equally precise. The late surrender rule example demonstrates how a clearly defined condition can change an outcome; the same separation of trigger, approval and result is needed for rules covering expired stock, manual release and return-to-shelf decisions.

Build a controlled operational handover

Before moving an online store away from the discontinued NCR Retail Online service, export the item mapping, current lot balances and open-order status. Reconcile those records with the target Magento or WooCommerce environment, then run parallel stock checks for enough trading cycles to expose timing differences. The NCR Counterpoint partner should document responsibility for mapping, integration monitoring, expiry rules, customer support and release approval.

During cutover, keep old inventory feeds read-only or disconnect them cleanly to prevent duplicate deductions. Monitor reservation failures, negative available quantities, unmatched lots and orders awaiting expiry approval. Every override should produce a dated audit entry, and routine reconciliations should include quarantined stock that must never appear as immediately purchasable.

The practical takeaway is to make one reconciled Counterpoint lot record the authority for expiry status, then require every online sale, allocation and dispatch event to return to that record before stock is released.