To begin, please upload an Excel file containing the following sheets and columns:
Sheet Name | Columns (* indicates required) |
---|---|
Purchase Orders | Order NumberCustomerWarehouseDate ReceivedRequested Delivery DateDelivery MethodOI %Order Total FallbackNotesDate ConfirmedDate Revision RequestedRevision Request NotesDate Shipment CreatedEstimated Ship DateActual Ship DateDelivery DateTracking NumberShipment Notes |
Purchase Order SKUs | Order NumberProduct LineSKUCasesPrice per Case |
Note on updating existing properties: Values must be specified for all rows of the columns provided and blank cells will be treated as empty; updating the corresponding value to be blank. If you want to update only certain properties while leaving others untouched, be sure to exclude the column(s) you want to leave untouched entirely from the uploaded file.