Using Pickware, you can add line items to a new or existing purchase order via CSV import. This allows you to transfer purchase orders from external demand planning tools into Pickware, and then continue with the classic Pickware purchasing process.

For the CSV import of line items, a purchase order must already exist.

If you haven't created a purchase order yet, you can find out here how to create a purchase order. For importing line items, the purchase order doesn't need to have any line items beforehand. You just need to select the corresponding supplier.

Once the purchase order has been saved, you can proceed with the import.

For the line items in the CSV file to be correctly matched to the products in the shop, the column Product number or Supplier product number is required. If both are specified, the product number takes precedence. If multiple products from a supplier have the same supplier product number, all products are added to the purchase order. If a product isn't yet assigned to the supplier, a new product-supplier assignment is created.

If the product is already included in the purchase order but is nevertheless added via the CSV, the product details are adjusted. If a product is listed in the CSV file with an order quantity of 0, it's removed from the purchase order.

The columns for importing or exporting the purchase order can be configured flexibly. To do this, go to the purchase order and click on List settings under Order line items. Here you can set the order of the columns. You can also configure which columns should be displayed during export or in the order overview.

For a correct import, the columns Product number or Supplier product number and Order quantity are mandatory.

The purchase price can be specified via the net purchase price for a single product or the (net) total of the line items. If only the net total is specified, small deviations may occur when calculating the individual line items.

If neither the individual price nor the total is specified, the purchase price is determined as follows:

By importing the CSV file for purchase orders, you can overwrite the details of the product-supplier assignment, provided the data in the CSV file differs from the existing values. To do this, activate the toggle Apply new values to the product-supplier assignment and the product under Import.

The following fields will be updated as a result:

Please note that the following values have no effect and are not applied as new values: