How to synchronize product groups
The inventory planner allow import/export product groups. Navigate to Stores -> Inventory Planner -> Product group and click Import/Export product groups button to start.
Import product groups
1. Prepare a CSV file with the following fields:
- group_id: product group identifier.
- name: group name.
- cover_time: target stock cover in days for the group.
- overstock_time: overstock threshold in days (used with sales velocity).
- overstock_threshold_qty: overstock threshold in units.
- product_skus: comma-separated list of SKUs included in the group.
CSV file example:
group_id,name,cover_time,overstock_time,overstock_threshold_qty,product_skus
1,"Group 1",90,10,5,"24-MB01,24-MB04,24-MB03"
2,"Group 2",60,15,2,"WSH11-29-Orange,WSH11-29-Red,WSH11,WSH12-28-Green"
2. Upload the CSV file
Click Select file and choose your CSV. Then click Import product groups to import the data.
Export product groups
To export existing product groups click on Export product groups button. CSV file will be generated and saved.
CSV file example:
| group_id | name | cover_time | overstock_time | overstock_threshold_qty | product_skus |
|---|---|---|---|---|---|
| 1 | Group 1 | 90 | 10 | 5 | 24-MB01,24-MB04,24-MB03 |
| 2 | Group 2 | 60 | 15 | 2 | WSH11-29-Orange,WSH11-29-Red,WSH11,WSH12-28-Green |