The Custom Export connector can both send your stock to a partner and receive a partner's stock as CSV or Excel files. You define the column layout in a template, so the file matches whatever shape the partner expects.
Before you start
- An active Custom Export connector with a delivery target configured (FTP, SFTP, webhook, or email).
- Your brand uses the modern inventory engine (reservations v4). Contact support if you are unsure.
- Every inventory location you intend to share has a unique Location code.
Set a code on every inventory location
- Go to Settings → Inventory Locations in the left menu.
- Open the location you want to share.
- In the Location code field, enter a short identifier that will appear in your CSV/Excel rows (e.g.
WH-MAIN,DK-CPH-1). - Click Save location.
Important: Location codes must be unique within the brand. The same code is used to match rows on both export and import.
Create the inventory report template
The template defines the columns of the file you will exchange with the partner.
- Go to Settings → Connectors and open the Custom Export connector.
- Scroll to Templates and click Add template.
- From Document type, select Inventory Reports.
- Choose a Format: CSV or Excel.
- Add columns matching the partner's spec. See the column reference below.
- Click Save.
Tip: The same template is used for both export and import. To support both directions, the template must include a variant identifier (SKU or EAN) and a quantity column (Available quantity, Quantity, or Quantity in stock).
Column reference
| Column | Description | Used by |
|---|---|---|
| Inventory location code | The location's Location code. On import this matches the row to a TRAEDE location. | Export & Import |
| Inventory location ID | The location's TRAEDE id. Informational only. | Export |
| Inventory location GLN | The location address GLN, if set. | Export |
| SKU | Variant SKU. One of SKU or EAN is required for import. | Export & Import |
| EAN | Variant barcode. | Export & Import |
| Item number | Product item number. | Export |
| Full variant name | Product name including color and size. | Export |
| Color / Color code / Size | Variant attributes. | Export |
| Available quantity | Disposable stock (in stock minus allocated). Required on import. | Export & Import |
| Quantity in stock | Underlying physical stock level. Accepted as a fallback on import. | Export & Import |
| Allocated quantity | How much of the in-stock quantity is reserved. | Export |
| Next incoming date / Next incoming quantity | The earliest future PO arrival, if Include incoming inventory in export is on. | Export |
Configure the connector
- On the same connector page, scroll to Inventory report settings.
- Pick the locations to share in Inventory locations.
- Pick a Default inventory location (for imports). This is used when an inbound row does not include an inventory location code.
- Configure the remaining options (see field reference below).
- Click Save.
| Field | Description | Required |
|---|---|---|
| Inventory locations | The locations whose stock is exported and that imports may write to. | Yes |
| Default inventory location (for imports) | Fallback target when an inbound row has no location code. | No |
| Include incoming inventory in export | When on, the next-incoming columns are populated. | No |
| Emit one export file per inventory location | On (default): one file per location. Off: all locations are merged into a single file. | No |
| Export interval (minutes) | How often an automatic export runs. Leave blank to use the default of 60 minutes. | No |
Set up the customer connection
- On the connector page, find the customer in the connections table and click Edit. (Or edit the customer profile and add the Custom Export connection there.)
- Under Export documents, tick Inventory Reports to enable outbound exports.
- Under Import documents, tick Inventory Reports to enable inbound imports.
- If imports are enabled, scroll down to Import Routing and tell TRAEDE how to recognise inbound inventory files. Pick one of:
- All files — if this connection only ever receives inventory reports.
- Folder — e.g.
/inventoryon the FTP server. - Filename pattern — e.g.
INV_*.csv.
- Optionally fill in Inventory report export interval (minutes) to override the connector's interval for just this customer.
- Click Save connection.
How export works
TRAEDE automatically queues an export for each customer connection where the export interval has elapsed. The default schedule runs every 5 minutes and dispatches the export only when the interval has elapsed for the connection.
Each scheduled run renders the template into one or more files (depending on Emit one export file per inventory location) and delivers them via the connector's configured target. Each row in the file represents one (location, variant) pair. Stock with zero available quantity is omitted.
How import works
Inbound files arrive via the delivery target you have configured (FTP/SFTP scan or webhook ingestion). For each row:
- The Inventory location code column is matched to a TRAEDE inventory location with the same code.
- If the row has no code, the connector's Default inventory location is used.
- If the code is not in the connector's allowed locations, the file fails with a validation error.
- The SKU or EAN column resolves the variant. Rows with neither are skipped.
- The Available quantity (or Quantity / Quantity in stock) is treated as the partner's available stock for that variant.
- TRAEDE sets the location's in-stock quantity to available + currently allocated, so the available quantity in TRAEDE matches the file.
Verifying
Open the connector and find the connection in the list. Each connection shows a Last exported at timestamp, updated after every successful export.
For deeper inspection, go to Document exchange in the left menu and filter by document type:
inventory_report_push— outbound CSV/Excel exports.connector_import— inbound files. The connector decides per file whether it is an inventory report based on the connection's Import Routing rules.
Limitations
- Requires the modern inventory engine. Brands still on the legacy engine cannot use inventory reports yet.
- Sell-ahead and future-dated stock cannot be imported — only the current available quantity is honored.
- Bundles are included in the export but are not specially handled on import (they are treated as regular variants).
- One template per document type per connector. To send and receive different layouts, configure two separate connectors.