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.





