Skip to main content

How to import/create a PO from Excel?

Learn how to easily import and create purchase orders from Excel.

Written by Youri Moskovic

You can upload POs from Excel using the import function on the Purchase Order page

STEP 1: Go to the Purchase Orders page

STEP 2: Click Import, select "Import Purchase Order," and download the Prediko PO import template
​

STEP 3: Complete the Excel template, filling in all the relevant info.

NOTE: If you have Combined Locations, make sure to use the Combined Location Name.

Identifying your products: the SKU column can contain the SKU (variant name), the product's barcode (EAN/UPC), or your supplier's own reference for the product. Prediko matches each line to the right product. Barcodes that lost their leading zeros in Excel still match. If a barcode or reference belongs to more than one product, Prediko won't guess: that row is flagged so you can fix it.

STEP 4: Upload the file into the pop-up.

STEP 5: "Select header row": this will be the column name that we are grabbing for upload

Note: if you are using the template, we will auto-select the header row

STEP 6: "Match column": match which column has data. The SKU field is labelled "SKU or barcode". If your file has no SKU column, a column headed Barcode, UPC, EAN or GTIN is matched to it automatically. If the file has both, the SKU column is used; if it has several barcode columns, choose the right one yourself.

STEP 7: "Validate data": see the data that we are planning to import

STEP 8: "Confirm": Upload the data

IF you have any errors, you can correct the data upon receiving the error.

STEP 9: Done 🥳

Read more about Purchase Order Statuses here.


​

Did this answer your question?