Import inventory changes from Excel

  • Updated

Introduction

TRADE’s inventory importer allows you to quickly update inventory levels for product variants across multiple locations. This guide walks you through formatting your file, uploading it, and applying inventory changes — either by setting specific quantities or making adjustments.

 

 

Step 1: Format your CSV file

  1. Each row should represent a product variant.

  2. Match variants using either:

    • SKU

    • EAN
      You only need one of them, not both.

  3. Add a column for each inventory location you want to update (e.g. In stock, Remotely in stock).

  4. Save the file as a CSV. You can use either comma (,) or semicolon (;) as delimiters.

Example spreadsheet format:

SKUIn stockRemotely in stock
12345-BLK105
12345-GREY84

Step 2: Access the inventory importer

  1. Go to:
    traede.com/inventory/import
    (or type /inventory/import after your TRAEDE domain)

  2. Upload your CSV file.

  3. If your data looks incorrect, check the delimiter setting in the top-right corner:

    • Switch between comma and semicolon until your columns align correctly.


Step 3: Match columns to TRAEDE

  1. Match your identifier column to SKU or EAN.

  2. For each inventory column:

    • Select either:

      • Quantity: Overwrites the current stock level

      • Adjustment: Adds to/subtracts from the current stock level

    • Then choose the correct location from the dropdown.

💡 To subtract inventory, use negative values in the spreadsheet (e.g. -5).

  1. Check the Ignore first row option if your first row contains headers.


Step 4: Submit and verify

  1. Click Submit to start the import.

  2. The import runs immediately and updates your inventory across the selected locations.

  3. You can verify the update by searching for a product and checking its inventory levels.


Using the inventory importer is the fastest way to bulk update stock across your warehouse(s) or external stock locations. Choose “Quantity” for full updates or “Adjustment” for daily changes and syncing with external systems.

 
 
 
 
 

Was this article helpful?

0 out of 0 found this helpful