Creating new inventory batches by bulk importing using CSV files

To create new batches using a bulk import CSV file, you will need to generate a sample CSV file.

Once you have the sample CSV file, you can remove and only keep the products/variants you want to upload inventory batches for. If you would like to import multiple batches for a specific product, please duplicate the row and add the appropriate details.

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

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

To retrieve the 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.

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 dialogue 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.