SyncifyPro
Install
← All tutorials

Tutorial · 4 min

Update inventory across locations

Set stock levels from a supplier file, per location, without touching anything else.

Inventory lives per location, so an inventory file needs three things: which variant, which location, and the quantity.

  1. Export Inventory. The file lists each variant with a column per location.
  2. Match your supplier's SKUs against the SKU column — VLOOKUP or XLOOKUP works well here.
  3. Write the new quantities into the location column you're updating.
  4. Delete the location columns you are not changing, then import.

Leaving a location out of the file leaves that location's stock untouched. That is usually what you want when only one warehouse is being counted.

Doing it every night

If the supplier posts a file to FTP on a schedule, set up a scheduled import against that server instead of doing this by hand. See the scheduling guide.

Next

Change prices in bulk

Raise, cut or recalculate prices across a vendor, a collection or the whole catalog.

Add, remove or replace tags

Tags drive collections, filters and automations — and they are replaced wholesale on import.

Try it on your store

Install SyncifyPro