Is your Shopify CSV ready for a reorder check?
Start with current stock, then match the sales and availability records. You can ask for help even when some of that information is missing.
1. Start with an inventory export for one location
In Shopify admin, open Products → Inventory → Export. Choose the stock location you want to review and record when you exported the file. Shopify documents its formats in the inventory CSV guide.
Stockbela's preparation helper accepts Available and All states inventory exports. It uses sellable stock, not an on-hand total that includes committed or unavailable units. An orders export or a general product CSV is not a substitute.
Keep each size or color as a separate variant with a unique SKU. Shopify can export a blank SKU, but Stockbela needs a stable identifier to match records. Correct missing SKUs or names in your source data before preparing the worksheet.
2. Match three more records
- Units sold: use the same variant SKUs, location and recent/history windows as your stock and availability records. A money total cannot replace a unit count. Check how your sales source handles returns; do not turn a negative or unknown total into zero. Shopify describes its report fields in the sales report guide.
- Time in stock: use verified time each variant was available to buy during those windows. A current stock snapshot cannot prove what happened between past snapshots. Enter verified whole-day totals, or use the free availability helper with complete, verified intervals for partial days.
- Supplier lead time: confirm how many days it takes for a new order to become ready to sell. Leave an unknown value unresolved until you have evidence.
If you use the availability helper, follow its exact timestamp and sales-window notes. A rolling time window can differ from a calendar-month report. The helper blocks missing or overlapping time; it does not reconstruct lost sales.
3. Prepare a worksheet before scanning
- Open Prepare Shopify CSV, choose your inventory file and select one location.
- Resolve the errors shown. Use the worksheet it creates to add verified sales, availability and lead-time information.
- Read the input CSV guide, then scan the completed worksheet and check the snapshot date and assumptions.
- Review each alert before placing an order. Check incoming stock, minimum order quantities, pack sizes, promotions and supplier changes separately.
An incomplete worksheet is a preparation aid. It is not a finished scanner input or a file to import back into Shopify. The scanner may withhold estimates for short or insufficient history.
Download the one-page checklist · See a synthetic stockout example
Missing a record? Ask before paying.
Your first request needs only a store nickname, the number of SKUs and the question you want help with. The records section is optional; unknown answers stay “Not sure”. You review the draft and send it through your own email service.
The optional one-time Inventory Review is US$29 or THB 990 for up to 50 SKUs at one location. It includes a data-quality check, written priorities, CSV results and one clarification round within 7 days of delivery. We confirm useful analysis is possible, scope, delivery date and cancellation/refund terms before payment.
Keep customer data out of your inventory files
Free preparation and scans run in your browser. This page has no upload form, tracker or third-party video embed. For a paid manual review, agree the minimum SKU-level data and a private sharing method first. Do not send order-level customer records, passwords, admin access or payment-card information.
Stockbela estimates depend on the records you supply. It does not guarantee sales, savings or stockout prevention and does not order from your suppliers.