Skip to main content

Swapping items' main suppliers in bulk

Change the main supplier on multiple items at once by exporting them to a spreadsheet, editing the supplier and cost, then reimporting.

Where you have multiple items and you want to set a new main supplier, use this method:

1. In this example, there is a main supplier set against an item

Supplier Costs table showing one supplier marked with a Main checkmark and its Cost field highlighted in red

Export the items

2. On the items page, filter by supplier or some other parameter

Items page with "speaker" typed in the search box, filtering the list to speaker items, with Suppliers filter in the left panel

3. Click here to Export to Spreadsheet

Items list with the brown Export to Spreadsheet button highlighted in the toolbar above the item table, top right

4. Click "- Items"

Items list with the Download to Excel menu open from the export button, and the "- Items" option highlighted

5. Click "Download"

Export dialog showing Download Ready with a green check mark, and the Download button highlighted to start the file download

Edit the spreadsheet

6. Edit the exported file so that the main supplier has been changed to the new one. All the other columns except the item code can be deleted. You may wish to update the cost using this file

Spreadsheet with Item Code, Main Supplier and Cost columns, showing six items all set to the same new main supplier

Import the updated file

7. Click on the cog

Items list with product rows and the settings cog icon highlighted in the top-right toolbar next to notifications

8. Click "Import Center"

Settings menu with Import Center highlighted in the left sidebar, beside the company details and settings sections

9. Click "Flexi"

Import Center in Settings with the Flexi tab highlighted, showing the Flexi Import Items step 1 of 3 upload panel

10. Click "Items"

Import Center with Flexi selected and the Items tab highlighted, showing Flexi Import Items step 1 of 3 upload field

11. Click "Select Files or Drag & Drop Here..." and select the file to import

Import Center Flexi Import Items step 1 of 3, with the Select Files or Drag & Drop Here... button highlighted

12. Click "Item Code"

Flexi Import Items step 2 of 3, Item Code option highlighted in Spreadsheet Header dropdown for the mandatory Item Code field

13. Match the "Main Supplier" column to the field

Import mapping screen with "main" typed in the Zigaflow Field box for Main Supplier, highlighting the Main Supplier option

14. And the same with the cost

Import mapping Optional Fields with "cost" typed in the Zigaflow Field dropdown for the Cost row and Cost option highlighted

15. Click "Next"

Import field mapping screen with Item Code, Main Supplier and Cost mapped, and the Next button highlighted at the bottom

Check the updated items

16. The items will be updated

Flexi Import Items step 3 of 3 showing Import Complete with 0 items created, 6 items updated, highlighting the Click Here link

17. Click "Costs" in the item to review the update

Item details panel with the Costs tab highlighted next to Prices, above the Standard Prices and Price Lists tables

18. The new supplier has been made the main one

Supplier Costs table with a checkmark in the Main column on the first supplier row, now set as the main supplier

19. The cost is update in the above field

Item edit panel with the Cost field highlighted, showing the updated value of 130.0000 in GBP above Cost inc. Labour

Learn more: inventory in Zigaflow

Related Articles
Did this answer your question?