Import Excel

Choose the customer and data type, then upload the Excel file from the customer.

Customer *

Data type *

PO (Schedule) Not available yet Receiving Not available yet Delivery Not available yet

PO month

Only PO rows for this month are imported, even if the file contains several months.

File Excel *

Format .xlsx / .xls, max. 20 MB.

No data type can be imported for this customer yet.

PO: one import = one month. All of this customer's PO in that month is replaced by the file (cancelled dates are removed too). For duplicate rows (same part + date) only the first row is used; the rest are ignored and recorded as warnings.
Receiving & Delivery: all dates in the file are imported. This customer's data from the first to the last date in the file is replaced by the file (re-uploading does not duplicate data). Columns outside the customer format are ignored.
Parts that are not registered yet are created automatically and flagged for review.
The file is processed right after upload; the result is shown on the detail page and in Import History.