{"section":"tutorials","requestedLocale":"en","requestedSlug":"importing-and-exporting-an-inventory-spreadsheet","locale":"en","slug":"importing-and-exporting-an-inventory-spreadsheet","path":"docs/en/tutorials/shipping/shipping-strategy/importing-and-exporting-an-inventory-spreadsheet.md","branch":"main","content":"Before importing an inventory, you must export a spreadsheet. Even without an existing inventory, the correct spreadsheet model used for import is obtained by first downloading/exporting a spreadsheet. By following the steps below, you will receive by email a file with the exported spreadsheet.  \n\n## How to export an inventory\n\n1. In the VTEX Admin, go to **Shipping > Shipping Strategy**, or type *Shipping Strategy* in the search bar at the top of the page.  \n3. Click on the **Warehouses** tab.  \n4. Click on the `:` button next to *Create warehouse*.  \n5. Click on the **Export items** option.  \n6. An email will be sent with the exported file.\n\nIf you have more than one existing inventory, this same action also allows you to concomitantly export a spreadsheet containing items from all store inventories. If your inventory is very extensive, this file will be split into more than one spreadsheet. You will also receive an email with the corresponding link to each spreadsheet.\n\n## How to import an inventory\n\n1. In the VTEX Admin, go to **Shipping > Shipping Strategy**, or type *Shipping Strategy* in the search bar at the top of the page.\n2. Click on **Warehouses** tab.  \n3. Click on `:` button next to *Create warehouse*.  \n4. Click on the **Import items** option.  \n5. Choose a file from your computer and drag it into the box.  \n6. Click on **Import**. \n\n> ⚠️ If these indicators are not respected, the system may not accept the spreadsheet import or the number of available items may be incorrect.\n> Importing the inventory will overwrite the current values on your existing one. Import only if you want to replace the SKU data present in the Admin.\n\nUsing an inventory spreadsheet, you can bulk insert the number of SKUs for each of your store's inventories. Importing an inventory spreadsheet is the easiest way to bulk add the SKUs to your store.\n\nEach spreadsheet row therefore applies to a SKU per inventory, which means that if a single SKU is present in more than one inventory, it will appear once in each one of those. The spreadsheet contains all inventory product variations added to your store.\n\nThis import is done using an .xls format spreadsheet, in which the format is the same as the exported one. In case your file is over 4.5 MB, you need to use a .zip compressed file. \n\nIn addition, for the spreadsheet to be correctly filled out, two following rules must be adhered to:  \n\n- Each spreadsheet row must contain a number or text.  \n- Updating SKU quantities must only be done in the TotalQuantity column.  \n\n## Inventory spreadsheet fields  \n\nCheck the meaning of each of the inventory spreadsheet fields.\n\n- **SkuId** (text): SKU ID.  \n- **TotalQuantity** (number): quantity of SKU units.  \n- **ReservedQuantity** (number): automatically filled in when exporting a spreadsheet. It takes the number of reserved SKUs into account.   \n- **AvailableQuantity** (number):automatically filled in when exporting a spreadsheet. Displays the quantity of SKU available for purchase. Is calculated by subtracting the reserved quantity from the total amount.  \n- **WarehouseId** (text): inventory ID as added to the Shipping Strategy module.  \n- **WarehouseName** (text): inventory name as added to the Shipping Strategy module.   \n- **RefId** (text): SKU reference code.  \n- **IsActive** (text): shows whether the SKU is active (`true`) or inactive (`false`) in the catalog.  \n- **UnlimitedQuantity** (text): shows if the SKU inventory was defined as unlimited (`true`) or not (`false`).  \n- **LockIds** (text): Booking identification code.  \n- **DispatchedReservations** (number): number of SKU items that have already moved beyond the `Item received for processing` status and whose booking is no longer valid. \n- \n> ℹ️ To include an item with Unlimited inventory, you must fill in the **TotalQuantity** field with the value `1000000` and change the **UnlimitedQuantity** field to `True`."}