How to synchronize suppliers
The inventory planner allow import/export suppliers. Navigate to Stores -> Inventory Planner -> Suppliers and click Import/Export suppliers button to start.
Import suppliers
1. Prepare a CSV file with the following fields:
- supplier_id: supplier identifier.
- name: supplier name.
- lead_time: average days from order to receipt.
- min_order_qty: minimum purchasable units per order.
- product_skus: comma-separated list of SKUs supplied by this vendor.
CSV file example:
supplier_id,name,lead_time,min_order_qty,product_skus
1,Supplier-180,180,100,"24-MB04,24-WB07,24-WB04,24-UG01,24-WG01"
2,Supplier-90,90,100,"24-MB03,24-WB05,24-WB03"
3,Supplier-60,60,100,"MH01-XS-Gray,MH01-XS-Orange,MH01-L-Black"
2. Upload the CSV file
Click Select file and choose your CSV. Then click Import suppliers to import the data.
Export suppliers
To export existing suppliers click on Export suppliers button. CSV file will be generated and saved.
CSV file example:
| supplier_id | name | lead_time | min_order_qty | product_skus |
|---|---|---|---|---|
| 1 | Supplier-180 | 180 | 100 | 24-MB04,24-WB07,24-WB04,24-UG01,24-WG01 |
| 2 | Supplier-90 | 90 | 100 | 24-MB03,24-WB05,24-WB03 |
| 3 | Supplier-60 | 60 | 100 | MH01-XS-Gray,MH01-XS-Orange,MH01-L-Black |