Om OilInventory & Purchase Orders

Upload & Generate

Upload a point-of-sale export and we compute the suggested order against the saved Master List (items matched by scan code, over a 14-day sales window).

File requirements

One .xlsx workbook with two sheets, named exactly:

InventoryData
  • Scan Code (or UPC)
  • Date
  • Current Qty (or In Stock / Current Inventory)
SalesHistory
  • Scan Code (or UPC)
  • Date
  • Sold Qty (or Qty Sold / Total Qty / # Sold)

Column names are case-sensitive. Extra columns are ignored. Dates may be Excel dates or YYYY-MM-DD / M/D/YYYY.