---
schema_version: "1"
id: 4c98f8d7a49c575878655eff54ba81482020faa66b5e38ccca50e62d05b47c60
title: File Format Guidelines for Modifying SKUs with Omnichannel Inventory
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/commerce/264-0-0/inv_import_bulk_guidelines.md
canonical_url: https://help.salesforce.com/s/articleView?id=commerce.inv_import_bulk_guidelines.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 185799f2843193fdff9e0be9669fb411ffd99c9552ddba05a245cdff561ae0fe
description: Use a CSV or JSON file to import, update, or delete SKUs. When you construct the inventory file, specify column headings that correspond to location, SKU, quantity, and availability information. If other fields are included, they’re ignored. We recommend that you use the provided sample CSV filei.
products:
  - Commerce
  - Omnichannel Inventory
release: "264"
---
# File Format Guidelines for Modifying SKUs with Omnichannel Inventory

Use a CSV or JSON file to import, update, or delete SKUs. When you construct the inventory file, specify column headings that correspond to location, SKU, quantity, and availability information. If other fields are included, they’re ignored. We recommend that you use the provided sample CSV filei.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><a href="https://help.salesforce.com/s/articleView?id=commerce.inv_editions.htm&amp;language=en_US" target="_blank">View supported editions</a>.</td></tr></tbody></table>

Each row in the file represents a product and its quantities. The column headings are case-insensitive, and the columns can be in any order.

The file can be up to 3.5 MB. The upload time depends on your file size and internet connection.

 
| Column heading | column value |
| --- | --- |
| Location ID | ID of the location containing the item. |
| SKU | Unique code that’s assigned to each product in your inventory to track availability and movement. |
| Quantity On Hand | Physical inventory available. |
| Safety Stock | Inventory that’s intentionally held in reserve that isn’t included in available to fulfill (ATF) and available to order (ATO). |
| Effective Date | Date and time the on-hand inventory data is available. ISO 8601 format required. |
| Future Date 1 | Date the specified quantity for a SKU will be available to order. ISO 8601 format required. |
| Future Quantity 1 | Inventory available for pre-order or backorder or that’s expected in the future. Must be greater than 0. |
| Future Date 2 | Date the specified quantity for a SKU will be available to order. ISO 8601 format required. |
| Future Quantity 2 | An additional group of inventory available for pre-order or backorder or that’s expected in the future. Must be greater than 0. |
| Group Eligibility Exclusion | Excludes the group from aggregating the location or SKU. |

#### See Also

- [Import or Delete Inventory with a CSV or JSON File](https://help.salesforce.com/s/articleView?id=commerce.inv_import_bulk_csv.htm&release=264.0.0&type=5 "Use the Omnichannel Inventory app to add, update, or delete inventory in bulk. You can use either a CSV or JSON file that contains the inventory SKUs.")
- [Omnichannel Inventory Impex API Endpoints](https://developer.salesforce.com/docs/commerce/commerce-api/references/impex?meta=Summary)
- [Omnichannel Inventory App](https://help.salesforce.com/s/articleView?id=commerce.inv_omnichannel_inventory_app.htm&release=264.0.0&type=5 "Use the Omnichannel Inventory app to view, add, and edit inventory SKU counts and manage locations, location groups, and location group assignments.")