Skip to main content

How do I assign products to a supplier?

To assign products to a supplier, Pickware gives you two options. You can either make the assignment manually for each product individually or edit the products in a file via CSV import and then import them into your Pickware Admin. With Pickware Advanced or Professional, you can also assign a product to several suppliers.

What information can I store?

Under Einkauf → Lieferantenzuordnung (Purchasing → Supplier Assignment) or via the CSV import, you can maintain the following information for each assignment:

  • Product number

  • Product name

  • GTIN/EAN

  • Manufacturer

  • Manufacturer number

  • Supplier

  • Supplier number

  • Default supplier

  • Supplier product number

  • Minimum order quantity

  • Order interval

  • Purchase price (net)

In the product details, you can maintain the following information for each assignment:

  • Supplier

  • Supplier number

  • Supplier product number

  • Minimum order quantity

  • Order interval

  • Purchase price (gross / net)

Minimum order quantity and order interval

The minimum order quantity represents the minimum order amount for the product with the respective supplier. The order interval tells you in which quantity intervals you can order the respective product from your supplier. This information is then taken into account as an order suggestion when creating supplier orders. Both details are optional, for example if your supplier doesn't have any requirements in this regard.

Manual assignment

You can assign products to a supplier manually in several ways.

Via the supplier details

Open the desired supplier and switch to the Produkte (Products) tab. Using the search field, you can select all the products you want to assign to the supplier. If a product is the default supplier, you'll recognize this by the green checkmark in the Standardlieferant (Default supplier) column.

Via the product details

In the product details, in the Lieferanten (Suppliers) tab, you can select a supplier from the drop-down menu. You'll see all the suppliers the product is assigned to in the list below, where you can adjust the properties for each one. You'll recognize the default supplier by the star next to the name.

The supplier you select first is automatically set as the default supplier. You can change the assignment by clicking on Lieferant als Standard-Lieferant festlegen (Set supplier as default supplier) in the context menu of the desired row.

If you only use Pickware Starter, you can only assign the product to one supplier. In that case, the Lieferant (Supplier) tab looks like this:

Lieferanten_Produktdetails_ohne_ERP_Pro (1).jpg

Via the product-supplier assignment

Under Einkauf → Lieferantenzuordnung (Purchasing → Supplier Assignment), you'll find an overview of all products and their respective assigned suppliers.

For all products that are already assigned to suppliers, you'll find a list entry for each assignment. You'll recognize the default supplier by the green checkmark in the corresponding column. On the right, in the filter settings, you can also choose to display only the default suppliers if needed.

For all products without a supplier assignment, you'll find a list entry for each one.

On the right, in the filter settings, you'll find the option Zeige nur Produkte, die noch keinem Lieferanten zugeordnet sind (Show only products that are not yet assigned to a supplier). This lets you see the relevant products at a glance and assign them to a supplier.

To assign a product to a supplier, click on the corresponding column and select from the list of all available suppliers, i.e. the suppliers the product hasn't been assigned to yet.

For products that haven't been assigned to a supplier yet, you can only maintain one supplier at this point, which is then automatically noted as the default supplier. If you want to store several suppliers, you can do so in the product properties or via CSV import.

Assignment via CSV import

First, configure the view under Einkauf → Lieferantenzuordnung (Purchasing → Supplier Assignment) according to your preferences. For example, you can use the Listeneinstellungen (List settings) at the top right to hide table columns you don't need, or use the filter settings to filter products so that, for example, only those products that aren't yet assigned to a supplier are displayed. Then click on Export to get a CSV file with all displayed products/product assignments and columns.

In the CSV file, you can now enter the desired supplier for all products and upload the file again via the Import button. For the import to work, you only need the columns Produktnummer (Product number) and Lieferantennummer (Supplier number).

You'll find the supplier number either directly next to the respective supplier or in your supplier's settings under Nummer (Number).

Lieferdienstnummer.png

For the import into Pickware, the CSV file must be UTF-8 encoded and use semicolons as separators. You can find more details about this and where to find the corresponding configuration option in your spreadsheet program here.

Assigning variant products

If you assign a product with several variants to a supplier, change the properties of the assignment, or remove the assignment again, you'll be asked every time you save whether you want to apply the changes to all other variants as well. The only exception is the supplier product number, which can only be changed individually for each variant.

Deleting an assignment

You can also delete existing product-supplier assignments in several places. Besides deleting via the supplier properties (in the Produkte (Products) tab) or product properties (in the Lieferanten (Suppliers) tab), you can also delete the assignment individually under Einkauf → Lieferantenzuordnung (Purchasing → Supplier Assignment) using the three dots on the far right next to the product, or delete several assignments at once. To do this, select the desired entries in the list and then click the Produkt-Lieferanten-Zuordnungen löschen (Delete product-supplier assignments) button that appears at the top of the list.

PoLiZu 2.png

PoLiZu 1.png

Alternatively, you can also delete assignments via CSV import.
Every exported CSV file contains the Zuordnung löschen (Delete assignment) column for this purpose.
Enter Ja (Yes) in this column for the desired entries, save the file, and then import it back into your Pickware Admin. The corresponding assignments will then be automatically removed.

If you delete an assignment where the supplier was set as the default supplier, the same logic as with manual deletion automatically applies – meaning a subsequent default supplier will be set, if one exists.

Did this answer your question?