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

A purchase order must already exist before you can import line items via CSV.

If you haven't created a purchase order yet, you can find out how to do so here. The purchase order doesn't need to contain any line items before importing. 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 provided, the product number takes precedence. If multiple products from a supplier have the same supplier product number, all of these products will be added to the purchase order. If a product isn't yet linked to the supplier, a new product-supplier mapping will be created.

If the product is already included in the purchase order but is added again via the CSV, the order details will be adjusted accordingly. If a product has an order quantity of 0 in the CSV file, it will be removed from the purchase order.

You can customize the columns used for importing and exporting the purchase order. To do this, go to the purchase order and, under Bestellpositionen (Order Line Items), click Listeneinstellungen (List Settings). Here you can set the order of the columns. You can also configure which columns are shown when exporting or in the order overview.

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

The purchase price can be specified either via the net purchase price for an individual product or via the (net) total of the line items. If only the net total is provided, minor discrepancies may occur when calculating the individual line items.

If neither the unit price nor the total is provided, the purchase price is determined as follows:

By importing the CSV file for purchase orders, you can overwrite the details of the product-supplier mapping, provided the data in the CSV file differs from the existing values. To do this, go to Importieren (Import) and enable the toggle Neue Werte in die Produkt-Lieferanten-Zuordnung und das Produkt übernehmen (Apply new values to the product-supplier mapping and the product).

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: