Skip to main content

Importing & Exporting Inventory

You can perform bulk stock updates with a CSV file. This tool only updates existing inventory records. It does not create products, warehouses or locations.

Each row represents one SKU at one Location, with a Building and a target Stock Level.

Before You Begin​

Make sure the product, inventory item, warehouse, and location already exist, and that the SKU is already stocked at that location. If any of those records are missing, the import fails. We recommend refreshing your inventory first to ensure you're working with the latest inventory data.

Columns​

Inventory import accepts a single CSV file with the following columns

  • SKU - This is a required field.
  • Warehouse ID - This is a required field. This is the Endless ID of the relevant building/warehouse
  • Stock Level - This is a required field. Enter the stock level
  • Location ID - This is an optional field. If you leave this field blank, inventory will be updated for the default available locatoin in the relevant building. If you want to specificy which location to update, enter the Endless ID of the relevant location.
  • Location Handle - This is an optional field. You can enter either available or unavailable . If the building you are updating has only the two default locations (available and unavailable), you can use Location Handle instead of Location ID to add inventory to the unavailable location. We do not recommend using both location ID and and location handle.

The easiest workflow is to export inventory from Endless, keep the rows you want to update and remove all columns except SKU, Warehouse ID, Location ID, and Stock Level, then import the file back after updating the stock values. Starting from an Endless export helps you preserve valid warehouse and location IDs.

You will see additional columns in an export, such as Name, UPC, Available, Physical, Warehouse Name, or Location Name, but they should be removed before import.

CSV Examples​

This is the smallest valid file:

SKU,Warehouse ID,Location ID,Stock Level
PROD-001,warehouse-uuid,location-uuid,25
PROD-002,warehouse-uuid,location-uuid,0

Validation & Behavior​

Stock Level is the target quantity for that SKU at that location. A value of 25 sets the stock level to 25, and 0 sets it to zero. Negative values are not allowed.

The SKU must already exist as an inventory item in the current company, the location must exist, the location must belong to the specified warehouse, and the SKU must already be stocked there.

Endless validates the full file before applying any updates. If any row fails, the import does not partially update inventory. Completely empty rows are ignored, but partially filled rows are treated as invalid.

Troubleshooting​

If the import fails, first confirm that the SKU, Warehouse ID, and Location ID are correct, that the location belongs to the warehouse, that the SKU is already associated with that location, and that Stock Level contains only non-negative numbers.

If you are unsure about the IDs, export inventory from Endless and use that file as your starting point.