Updating existing inventory batches with bulk import CSV file

Updating existing inventory batches with bulk import CSV file — Watch Video

To create new batches using a bulk import CSV file, you will first need to generate an export for the inventory batches in Freshly.

Once you have have the export CSV file, you can remove and only the keep the products/variants you want to update inventory batch details/fields for. If you would like to also create multiple batches for a specific product, please duplicate the row and add the appropriate details without the inventory_batch_id.

Please make sure the following fields are present and valid before importing into the Freshly:

variant_id (should be pre-populated from Shopify)
location_id (should be pre-populated but can also be retrieved from the import modal)
inventory_batch_id (should be pre-populated from Freshly)
inventory_batch_quantity (any integer greater than 0 e.g. 14, 56, 2948)
expiry_date (Format: YYYY-MM-DD, e.g. 2026-03-24)

If you want to update the location or transfer the inventory batch, you can retrieve the new location_id for a specific location for your store, please refer to the import modal, where a list of all your active Shopify locations with their Shopify location_id will be listed (shown below):

📝 If using Microsoft Excel to edit the CSV file, please ensure that the id fields (variant_id, location_id, etc.) are in a number format to avoid being truncated with trailing zeros.

Optionally, you can set enable_shopify_sync to FALSE to not update inventory in Shopify when batches are created or updated. By default, this value will always be set to TRUE even if the column isn't present.

Once you have added the required and optional fields, you can upload the file by clicking on Choose file or dragging and dropping the file into the field.

Once you are ready, click on Import batches. Before importing, you will get a confirmation summarizing how many batches you will be creating and how many you will be updating. Confirm the dialog by clicking on Start import.

You should get a notification telling you that your final CSV will be emailed to you directly.

A CSV file with your inventory batches will get emailed to you with the status of your import. If any of your fields were missing or invalid, these will be shown in the import_status column.

You can now go into Freshly and view these inventory batches. These batches will only be shown in the history if the quantity was changed. Other changes will not be listed in the inventory batch history.