Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Import orders from a CSV

Summary: Choose an event, upload a CSV, let Event POS validate every row, then confirm to create the orders and attach them to the event.

Before you begin

  • Prepare your CSV using the Download template button on the Order Imports page. See The CSV file format for what each column expects.
  • Every SKU in the file must match an existing product in your store.

Steps

  1. Open Order Imports from the app navigation, or choose Import orders from an event card's actions menu on the Event Calendar to arrive with the event pre-selected.
  2. In the import flow, pick the Event the orders belong to.
  3. Set the Tax rate (%) if the prices in your file include tax. The rate applies to every row and prices are treated as tax-inclusive; leave it empty for no tax.
  4. Choose whether to Decrement inventory at the venue. When on, venue stock drops by the imported quantities (even below zero). Turn it off if that stock was already reconciled — see The inventory toggle below.
  5. Choose your CSV file (Click to browse your files). Event POS validates it immediately.
  6. Fix any errors. Validation is all-or-nothing: if any row is invalid, no orders are created and the flow lists the problems by Row, Column, and Problem. Correct the file and choose it again.
  7. When the file is clean, a Ready to import summary shows the Orders to create and the number of CSV rows. Review it, then choose Confirm import.
  8. An Import started message confirms. The import runs in the background and its row on the Order Imports page moves from Running to Completed (or Partially failed if some orders couldn't be created).

What gets validated

The file must be readable, non-empty, and have data rows. Each row is checked so that:

  • qty is a positive whole number.
  • unit_price is a number of zero or more.
  • payment_method is cash or card, and is the same for every row of an order.
  • sold_at, if present, is a valid date/time and falls within about a month of the event — a date far outside the event's window is treated as a typo and rejected.
  • sku matches an existing product or variant. Unknown SKUs are reported as errors.

The inventory toggle

Decrement inventory at the venue controls whether the import reduces stock:

  • On — venue stock drops by the imported quantities, even below zero. Use this when the imported sales haven't already been taken out of your counts.
  • Off — inventory is left untouched. Use this when the stock was already reconciled elsewhere.

Duplicate protection

If you upload the exact same file for the same event again, a warning appears: This exact file was already imported for this event. Importing it again will duplicate its orders. Choose Import anyway only if you genuinely mean to create the orders a second time.

Related articles