Updating existing inventory batches with bulk import CSV file

To change many existing batches at once, export your batches from Freshly, edit the rows in a spreadsheet, and import the file from Inventory Batches > Import. Each row updates the batch with the matching inventory_batch_id . Importing and exporting are available on the paid Freshly plan.

Export your batches

1. In Freshly, go to Inventory Batches.
2. Click Export.
3. In Export inventory from, choose All locations or a single location.
4. Click Export batches.

Freshly emails the CSV to your notification email addresses. See Exporting batch tracked inventory.

Edit the file

1. Delete every row you don't want to change. This includes expired batches (check the status  column).
2. Edit the values you want to change. For each remaining row, make sure these are filled in: - inventory_batch_id : filled in by the export. Don't change it. - variant_id  and location_id : filled in by the export. - inventory_batch_quantity : a whole number, 0 or more. - expiry_date : format YYYY-MM-DD, for example 2027-03-24.
3. Optional: add an enable_shopify_sync  column. Leave it blank or set TRUE to update Shopify inventory when a quantity changes. Set FALSE to change Freshly only.

Every column in the row is saved. A blank cell clears that detail on the batch. A blank expiry_date  removes the expiry date, a blank received_date  resets it to today, and a blank quantity sets the batch to 0. Keep the values you don't want to change exactly as exported.

When a quantity changes and sync is on, Freshly adjusts the variant's available inventory in Shopify by the difference. This only happens if Preferences > Inventory > Batch quantities added or adjusted on Freshly are reflected in Shopify. is turned on.

Changing the location: if you change location_id , Freshly moves the batch to the new location but doesn't move the stock in Shopify. Adjust the quantities at both locations in Shopify yourself, or use a Shopify transfer. Location IDs are listed in the import modal.

If you use Microsoft Excel, format the ID columns (product_id , variant_id , location_id ) as Number with 0 decimal places, or as text, so Excel doesn't save them in scientific notation (like 4.4435E+12).

You can also add new batches in the same file. Add a row with no inventory_batch_id . See Creating new inventory batches with bulk import CSV file.

Import the file

1. In Freshly, go to Inventory Batches and click Import.
2. Under CSV file, click Select CSV or drop your file in.
3. Click Import batches.
4. Check the Ready to import summary. It shows how many batches will be added and how many updated.
5. Click Start import.

Freshly imports the file in the background and shows "Your import status will be delivered by email to:" with your email addresses.

Check the results

You'll get an email titled "Freshly inventory batch import results" with a CSV attached. Each row's result is in the import_status  column. "Completed" means the row was saved. Anything else is an error message. See Bulk importing inventory batches for what each error means.

Quantity changes appear in the inventory batch history. Other changes, such as a new expiry date or batch name, don't add a history entry.

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.