Tutorials & Solutions

How to fill out the inventory spreadsheet

Breno Barreto
Breno Barreto
Last updated
12/31/2019

Using the inventory spreadsheet you can bulk insert any number of SKUs for each inventory in your store.

Each spreadsheet line corresponds to an SKU inventory, which that even if the same SKU is present in more than one inventory, it would appear once for each inventory.

In addition, correctly filling out the spreadsheet depends on two rules, as follows:

  • Each spreadsheet column must either contain a number or a text;
  • Updating the quantity of SKUs must be done through the TotalQuantity column.
Notice: If these rules are not followed, the system will either not accept importing the spreadsheet altogether or the item quantity available for sale may be incorrectly displayed.

Please refer to each inventory spreadsheet field's meaning below.

  • SkuId (text): SKU ID.
  • TotalQuantity (number): quantity of SKU units.
  • ReservedQuantity (number): amount of this SKU being reserved.
  • AvailableQuantity (number): amount of this SKU available for sale.
  • WarehouseId (text): Inventory ID, as registered in the logistics module.
  • WarehouseName (text): inventory name, as registered in the logistics module.
  • RefId (text): SKU reference code.
  • IsActive (text): indicates whether the SKU is active (true) or inactive (false) in the catalog.
  • UnlimitedQuantity (text): indicates whether the SKU inventory has been defined as infinite (true) or not (false).
  • LockIds (text): Reservation identification code.
  • DispatchedReservations (number): Number of SKU items that have already moved past the Ready for Handling status, meaning that their reservations have already been cancelled.
Still got questions?
Ask the community
Find solutions and share ideas in VTEX's community.
Talk to our experts
Get in touch if you have something specific to ask about the platform.
  • PT
  • ES
VTEX website