Skip to main content

Import a receipt from a file

When a warehouse or 3PL sends you a spreadsheet of what it counted, you can receive the purchase order (PO) from that file instead of typing each line into the Receive Items drawer. SKU.io matches each row to a PO line, shows you a preview, and records only the rows that pass as one receipt — the same receipt the drawer would record.

Before you begin​

  • You need the Receive purchase orders permission (purchase_orders.receive). Without it, Import receipt doesn't appear.
  • The PO must be Open with units still pending. Import receipt is hidden once every line is fully received.
  • The file must be a CSV or Excel file (.csv, .tsv, .txt, .xlsx, or .xls), with a header row and at most 5,000 rows. SKU.io reads the first sheet only.
  • Serialized products can't be imported. Receive them in the Receive Items drawer, which records a serial number per unit.

Steps​

  1. Open the purchase order from Orders → Purchase Orders.
  2. Open the More menu (⋮) and click Import receipt. The Import receipt dialog opens on the Upload step. If you already have the Receive Items drawer open, click Import from file in the drawer instead.
  3. To start from the right columns, click Download template. You get an Excel file with one row per line still pending, already filled in with each line's SKU, supplier SKU, barcode, and quantities.
  4. In the file, enter the units that arrived in the Quantity column, plus a Bin, Lot number, and Expiry date where you need them (see Template columns). Leave Quantity empty on any line that didn't arrive.
  5. Drag the file onto the dialog, or click the drop zone and choose it. SKU.io reads the file and moves to Preview & Validate.
  6. Check the Received date. It comes from the file's Received date column when every row agrees on one date, and otherwise defaults to today. One import records one receipt on one date, so if the file holds several dates, a warning asks you to pick one.
  7. Review the preview table. Each row shows its Status, the matched Product, and the line's Pending, Receiving, and After (received / ordered once this receipt is recorded) quantities. Use All, Ready, Errors, and Skipped to filter it. Rows marked Error explain why in the Message column and aren't received.
  8. Click Receive N lines (X units). SKU.io checks the file against the PO once more, then records the receipt.

What you'll see: the Done step confirms "Receipt recorded" with the line and unit count. A large receipt finishes in the background instead ("Receipt started"); follow it in the job tray, and the PO refreshes when it's done. The PO's Activity tab records the import as "Receipt imported from (file name) — N lines, X units."

To fix rows marked Error, correct them in the file and upload it again with Choose another file, or receive those lines in the Receive Items drawer.

Template columns​

The template and your own files use the same columns. Headers aren't case-sensitive, and SKU.io also recognizes common 3PL headers, such as Qty or Quantity received, Item, Vendor SKU, UPC or EAN, Location, Batch, and Exp date. A file needs at least one identifier column (SKU, Supplier SKU, Barcode, or Line) and a Quantity column.

ColumnIn the templateWhat to enter
LineFilled inThe PO line the row belongs to. When present, SKU.io matches by it first. Leave it as it is.
SKUFilled inYour SKU for the product.
Supplier SKUFilled inThe supplier's code for the product. Used when the SKU doesn't match.
BarcodeFilled inThe product's barcode (UPC, EAN, or GTIN). Used when neither SKU matches. Leading zeros are kept.
ProductFilled inThe product name, for reference. Not read on upload.
OrderedFilled inUnits ordered on the line, for reference.
ReceivedFilled inUnits already received, for reference.
PendingFilled inUnits still to receive, for reference.
QuantityEmptyThe units that arrived. Rows with no quantity, or a quantity of 0, are skipped.
BinEmptyOptional. The bin's code (or its name, when no other bin shares it) in a warehouse with locations turned on.
Lot numberEmptyRequired for lot-tracked products. Ignored, with a warning, for other products.
Expiry dateEmptyRequired for lot-tracked products.
Manufacture dateEmptyOptional, for lot-tracked products.
Received dateEmptyOptional. The date the stock arrived.

Dates can be Excel dates or text such as 2026-11-14, 11/14/2026, or 14-Nov-2026.

To receive one line into several bins, or as several lots, add a row per bin or lot with the same SKU and split the quantity between them.

How rows are matched and checked​

SKU.io matches each row to a PO line by the Line column, then by SKU, then Supplier SKU, then Barcode. A value in the SKU column is also tried as a supplier SKU and a barcode, because many 3PL reports put the supplier's code first. A supplier SKU only matches this PO's supplier. When the preview matches a row by something other than your SKU, it says so under the product, for example "matched by supplier SKU." When a product is on more than one line, the row goes to the first line that still has units pending.

These rows are errors and aren't received:

ProblemWhat the message says
The SKU, supplier SKU, or barcode isn't on the PO"(value) is not on this purchase order."
More units than the line has pending, including across several rows for the same line"Over-receipt: …" To receive extra units on purpose, use the Receive Items drawer — see Receive more than you ordered.
A bin that doesn't exist, is retired, or doesn't accept receipts"Bin (name) was not found in (warehouse)." or "Bin (name) does not accept receipts."
A lot-tracked product without a lot number or expiry date"This product is lot-tracked — add its lot number."
A serialized product"This product is serialized — receive it in the Receive drawer…"
A quantity that isn't a number"Quantity (value) must be a number of 0 or more."

Only the rows marked Ready are received. If the PO changes between the preview and Receive — for example, someone receives the same line in the drawer — the changed rows are highlighted with the reason and nothing is received until you click Receive again.

Import against an inbound shipment​

You can also import a receipt from an inbound shipment that's in transit. Open the shipment and click Import receipt, next to Receive Items. The template then lists only the lines still pending on that shipment, and the receipt is recorded against it. One import receives one PO. When the shipment carries several POs, Import receipt opens a list so you can pick the PO first.

When you import from the PO instead, rows for lines that are on an inbound shipment show the shipment number in the preview, and their units are recorded against that shipment.

Next steps​

Last verified: