Assign supplier per product
To assign products to a supplier, there are three options:
- Manually via the supplier mapping: Under Purchasing → Supplier Mapping you will find a list with all products or product variants. By double-clicking in the corresponding column, you can enter the manufacturer, supplier, supplier product number, minimum purchase, purchase steps and the net purchase price. You can filter the list according to product, supplier and manufacturer or according to products without supplier allocation in order to be able to add or edit missing suppliers more quickly.
- By CSV import via the supplier mapping: First click on Export in the supplier mapping to get a current list of all products as a CSV file. In the file you can now enter the desired supplier for all products and upload the file again via the Import button. The exported CSV file contains all columns that are visible in the administration at the time of the export. Therefore, hide or show all (not) required columns. In order for the import to work, you only need the columns product number and supplier number.
- Via the supplier details: Open the desired supplier and switch to the Products tab. Use the search field to select all products you want to assign to the supplier.
- Via the product details: In the tab Suppliers you also have the possibility to select a supplier.
A product can only be assigned to one supplier at a time. If a product with several variants is assigned to a supplier, you can use the prompt when saving to decide whether the assignment should be made for all variants.
Maintain further supplier-specific information on a product
With the help of the supplier mapping, you also have the option of entering the supplier product number, net purchase price, minimum purchase quantity or the purchase interval. By double-clicking in the corresponding column, you can make the entry manually or, as described above, upload all changes collectively as a CSV file via Import. Alternatively, you can also maintain this information in the Supplier tab in the product details. If it is a variant article, the information is also optionally saved here for all variants.