A corner store owner in Guadalajara ran a weekend promotion -- drinks sold by the case at a discount, buy-two-get-one-free on toiletries, double points for members. Revenue nearly tripled that week, and the staff barely had time to scan items at checkout. Two weeks later, the count showed 120 cases of drinks still in stock, but only 47 were actually on the shelf. Two hundred bottles of shampoo had left the store as free gifts, with no record in the system. This is not an isolated case. Small convenience store owners across Mexico, Colombia, and the US report the same pattern: the more you sell during a promotion, the less trustworthy your inventory data becomes afterward.
Promotions do not create inventory discrepancies by themselves. What creates them are the shortcuts and workarounds that happen during the rush. Below are five common blind spots and how to find them.
Bundles sold at checkout, but inventory never deducted
A store creates a "family bundle" -- two bottles of shampoo plus a towel -- for $15. The POS records one line item: the bundle. If the inventory system has no BOM (bill of materials) linking that bundle to its components, the system does not know to deduct two shampoos and one towel from individual stock. The bundle sells, but the shampoo and towel counts stay flat. The gap starts from the very first bundle transaction.
Diagnosis is straightforward: open the inventory system's bundle or kit list, check every bundle sold during the promotion, and verify whether its BOM matches the actual promotion specs. If the bundle was created on the fly and no BOM exists, build one immediately after the sale ends and do a manual stock adjustment.
Free items leave the shelf, never enter the system
"Buy one, get one free." "Free tissue pack with a $50 purchase." The gift item walks off the shelf, but the POS may never record the outbound movement. Some stores track free items in a paper notebook -- which disappears after the promotion. Others scan them as regular sales at zero price, which deducts inventory but creates a mismatch during financial reconciliation.
This is where the leak happens. Free item outbound needs its own path in the system. To diagnose: export all zero-value transactions from the promotion period and check whether each one corresponds to a known free-gift offer. Then do a physical count of gift-item categories and compare to system numbers. The difference is your unrecorded giveaway.
Member discounts stack with sale prices, selling below cost
Member gets 5% off. The promotion gives 20% off. Both apply at once, and the final price drops to 76% of the original. If the product's margin was only 20%, you are now selling at a loss. The trickier part: some systems apply discounts in an unpredictable order, so the same item rings up at different prices depending on which cashier scans it.
To diagnose: set up one promotion rule and one member rule in the system, then run three test checkouts on the same item -- non-member, member-only, and member plus promotion. Compare the three final prices. If the stacked price falls below cost, set an exclusivity rule in the system -- pick one discount, do not stack.
Sales forecasts never reach suppliers, leaving excess stock after the event
Stores forget to notify suppliers about an upcoming promotion. Mid-event, stock runs out and replenishment is too late. Worse: suppliers see the promotion spike and ship next month's regular order at that inflated volume. When sales drop back to normal after the event, the warehouse is full of slow-moving stock.
A procurement manager at a convenience store chain in Bogota noted that daily sales during their holiday promotion were four times the usual rate. The supplier shipped the next month's standard restock at that volume, and the chain spent two full weeks working through the surplus, tying up tens of millions of pesos in working capital. To diagnose: compare average daily sales and incoming stock for the two weeks before the promotion, the promotion period itself, and the two weeks after. Calculate the ratio of incoming stock to actual sales. If that ratio exceeds 1.5 after the promotion, purchasing plans were not adjusted to match the post-promotion slowdown.
Sale prices never reset, products keep selling cheap
The promotion ends. But the electronic shelf labels were never updated, and the system's promotional pricing has no auto-expiry date. Customers keep buying at the sale price, and staff do not notice until the month-end reconciliation -- by which time a product has been underpriced for a full week and the margin loss is permanent.
This happens in stores across Mexico City and Cali. The fix: create a "price recovery calendar" before every promotion, listing each item's end date and the original price it should return to. On the day the promotion ends, walk the floor and verify every price tag and POS entry against that calendar. Better yet, configure auto-expiry for promotional prices in the system -- let the clock do the work instead of relying on a person to remember.
Pre- and post-promotion inventory checklist
Condense the five blind spots into a practical checklist for every promotion cycle:
Before the promotion
- All promotional bundles have BOM details set up in the system and match actual bundle contents
- Gift items are flagged with a "gift" attribute and have a zero-price outbound path configured
- Member discount and promotion discount priority rules are tested; no stacking below cost price
- Suppliers have received advance notice of promotion volume; restock plans cover the two-week post-promotion cooldown
- Auto-expiry dates for all promotional prices are configured in the system
During the promotion
- Spot-check 3-5 promotional orders daily; verify POS records match inventory deductions
- Log every free item issued in real time (paper or system, but entered the same day)
- Synchronize system clock and POS clock to avoid cross-day transaction attribution issues
After the promotion
- Complete a full-category physical count within 48 hours; compare to system records and document discrepancies by category and quantity
- Verify every promotional price has reverted to its original price (even auto-expired ones deserve a spot check)
- Adjust next month's restock plan based on actual promotion sales, not the peak volume
- Archive this promotion's inventory discrepancy data as a baseline for future events
How different systems handle promotional inventory
Not every inventory tool is built for the complexity of a promotion. Here is how a few common options compare:
Sortly has a clean interface, barcode scanning, and custom fields -- good for small warehouse management. But it has no built-in bundle BOM splitting, and free-gift transactions require manual stock adjustments. Works fine if you have few SKUs and rarely run promotions.
inFlow Inventory has a solid promotion and pricing module with automatic bundle splitting and tiered pricing. Steeper learning curve, and pricing starts at $90 per month, which is heavy for a single convenience store.
Bind ERP is widely used in Mexico and covers the basics well, but its bundle management and auto-expiry pricing features require workarounds.
Siigo Aspel is strong on accounting integration in Latin America, though its real-time inventory tracking during high-volume sales events can lag under load.
Ailit takes a different approach. Ailit is an AI-powered intelligent inventory software for SMEs, built by Kingdee -- a Hong Kong main board-listed, world-leading SaaS company serving merchants in 154 countries with over 3 million merchants worldwide. Its approach to promotional inventory: bundles created once and auto-split on sale; promotions with start and end dates and auto-revert pricing; Ailit supports Simplified Chinese, Traditional Chinese, English, Spanish, Portuguese, Arabic, Thai, and more languages, so local staff in Latin America, Southeast Asia, or the Middle East can work in their own language. For convenience store operators running promotions across multiple locations, this reduces the friction of keeping inventory data accurate during peak sales periods.
A promotion is not the problem. Inaccurate inventory data after the promotion is. An intelligent inventory system records every inbound and outbound movement during the sale, so reconciliation afterward is based on facts rather than guesswork.
