Knowledge Base

Neto By Maropost

Import Order Lines into a Purchase Order

Import Order Lines

To speed up creating a purchase order, you can import the order lines, their quantity, purchase price and more. This is especially useful if you create orders in your supplier’s portal, and then need to replicate the information in Maropost Commerce. To import order lines:

Add a purchase order by following these steps, up to the point where you add order lines.
Click the Import/Export CSV button and then click Import lines from CSV.
Click in the pop-up window to select your CSV file, or drag and drop it into the window.

Tip: Download an example CSV file with the import format here.
Choose a field mapping template:
- Select an existing template that you’ve already created.
- Create a new template to import the same file format again in the future. Enter a name for your template if you select this option.
- Import the order lines using a one-off field mapping. The mapping you create won’t be saved.
Click the Next button. If you’re creating a new template, or doing a one off import you’ll be taken to the field mapping, otherwise skip to step 8.

Select a unique identifier to match the order lines in your Datasource (CSV file) to products in Maropost Commerce.

Field	Description
Product SKU	Unique identifier for the product.
Product ID	The ID of the product assigned by Maropost Commerce automatically.
Product Supplier SKU	Supplier SKU field entered on the product.
Product Barcode/UPC	All UPC/EAN fields entered on the product.

Match the Maropost Commerce order line fields to fields in your CSV file, to populate the order lines in your purchase order:

Field	Description	Field Type
Supplier SKU	Can be populated from the product.	String (text)
Order line QTY	Amount of inventory being ordered. Can be populated from the product Reorder QTY field or 1 if reorder qty is empty.	Integer (whole number)
Order line supply price	Price per unit ordered. Can be populated from the product Default Purchase Price field.	Numeric up to 4 decimal places.
Order line tax rate	Tax percentage for the order lines. Can be populated from the supplier and product. If your product is tax free or your supplier is from a different country to you it will be 0%, otherwise it will be your default tax rate. Must be 0 or your store tax rate.	Numeric
Order line tax inclusive	Select if the order line supply price does or doesn’t include tax.	Boolean (yes or no)
Order line discount %	Percentage discount of the order line. If set, will automatically calculate the order line discount amount, and order line total.	Numeric
Order line unit discount amount	Discount amount for the order line. If set, will automatically calculate the order line discount %, and order line total.	Numeric up to 4 decimal places.
Order line total	Total cost for the qty ordered of this order line. If set, will automatically calculate the order line discount %, and order line discount amount.	Numeric up to 4 decimal places

Tip: Click the Save button if you’re creating a template that you will use again.

Click the Next button, and your file will be validated. Any errors with the data will appear here, refer to our troubleshooting section for information on how to resolve them.
Click the Confirm and import button.

Your file will be processed and the order lines added to the purchase order.

Tip: Click the Edit button to add more order lines, or adjust the existing order lines in the purchase order before you approve it.

Troubleshoot Import Errors

Most errors with your file will give you directions on how it needs to be fixed. This includes the Maropost Commerce field, your datasource field it's mapped to, and the lines in the file where the error occurred.

Error	Cause	Solution
The file selected has more rows then the maximum allowed (2000).	Purchase orders can’t contain more than 2000 order lines, total.	Split the CSV file into 2 or more files that have 2000 or less rows.
The CSV file does not contain any data.	The CSV file doesn’t contain any order lines.	Open your CSV file and check that it has order lines.
Multiple product matches found for the column ‘xxxx’, mapped to xxxx. To import, your Product UPC must be unique on each product in Maropost Commerce.	When trying to match order lines to your Maropost Commerce products multiple matches were found.	Check the lines identified as duplicates, and either update these products to have a unique identifier, or use a different field to match products to your file.