To assign products to a supplier, Pickware gives you two options. You can either assign products manually one by one, or edit the products in a CSV file and then import it into your Shopware Admin. Starting with Pickware Advanced, you can also assign a product to multiple suppliers.
What information can I store?
Under Purchasing → Supplier assignment or via the CSV import, you can maintain the following information per assignment:
Product number
Product name
GTIN/EAN
Manufacturer
Manufacturer number
Supplier
Supplier number
Default supplier
Supplier product number
Minimum order quantity
Order quantity interval
Purchase price (net)
In the product details, you can maintain the following information per assignment:
Supplier
Supplier number
Supplier product number
Minimum order quantity
Order quantity interval
Purchase price (gross/net)
Minimum order quantity and order quantity interval
The minimum order quantity represents the minimum order quantity of the product for the respective supplier. The order quantity 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 fields are optional, for example if your supplier does not 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 Products tab. Using the search field, you can select all 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 Default supplier column.
Via the product details
In the product details, on the Suppliers tab, you can select a supplier from the drop-down menu. All suppliers that the product is assigned to appear 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 first supplier you select is automatically set as the default supplier. You can change this assignment by clicking Set supplier as default supplier in the context menu of the desired row.
If you're using Pickware Starter, you can only assign the product to one supplier. In this case, the Supplier tab looks like this:
Via the product-supplier assignment
Under Purchasing → Supplier assignment, you'll find an overview of all products and their respectively assigned suppliers.
For all products that already have suppliers assigned, you'll find one list entry per 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 display only the default suppliers if needed.
For all products without a supplier assignment, you'll find one list entry each.
On the right, in the filter settings, you'll find the option 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 the corresponding column and select from the list of all available suppliers, i.e. those suppliers that the product has not yet been assigned to.
For products that haven't been assigned to a supplier yet, you can only maintain one supplier at this point, which is then automatically marked as the default supplier. If you want to add multiple suppliers, you can do so in the product properties or via CSV import.
Assignment via CSV import
First, configure the view under Purchasing → Supplier assignment to your liking. For example, you can use the List settings in the top right to hide unnecessary table columns, or use the filter settings to filter products so that, for example, only products that haven't been assigned to a supplier yet are displayed. Then click 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 using the Import button. For the import to work, you only need the Product number and Supplier number columns.
You can find the supplier number either directly next to the respective supplier or in your supplier's settings under Number.
To import into Shopware, the CSV file must be UTF-8 encoded and use semicolons as separators. You can find more details on this, and where to find the corresponding configuration option in your spreadsheet program, here.
Assigning variant products
If you assign a product with multiple variants to a supplier, change the properties of the assignment, or remove the assignment again, you'll be asked each 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 per variant.
Deleting an assignment
You can also delete existing product-supplier assignments in several places. Besides deleting via the supplier properties (in the Products tab) or product properties (in the Suppliers tab), you can also delete the assignment individually under Purchasing → Supplier assignment using the three dots on the far right next to the product, or delete multiple assignments at once. To do this, select the desired entries in the list and then click the Delete product-supplier assignments button that appears at the top of the list.
Alternatively, you can delete assignments via CSV import as well.
Every exported CSV file contains a Delete assignment column for this purpose.
Enter Yes in this column for the desired entries, save the file, and then import it back into your Shopware Admin. The corresponding assignments will then be removed automatically.
If you delete an assignment where the supplier was set as the default supplier, the same logic as with manual deletion automatically applies – meaning that, if available, a subsequent default supplier will be set.
