File transfer

​

Overview

​

Introduction

Our platform supports multiple methods for data integration through file transfers. You can share your data files in two ways:

1. Direct upload via sFTP
2. Cloud storage integration (such as Azure Blob Storage)

Once your files are uploaded, our system automatically processes and synchronizes the data, making it readily available for analytics and insights on our platform.

​

Data Types

• Costs - Marketing costs data
• Indeliveries - Incoming products
• Inventory - Current stock levels and product attributes
• Orders - Customer transaction data

​

File name convention

We expect the file to be named the following:

{merchant}_{dataType}_{date}.{fileFormat}

where:

• merchant = Company name
• dataType = One of the values specified in Available Data Types
• date = last date of data (normally ‘yesterday’ as it’s the last day containing a full day of data looking at today)
• fileFormat = One of the values specified under Technical specification

​

Technical Specification

Category	Supported Options
File Formats	.csv, .xls, .xlsx, .parquet
Delimiters	Comma ,, Semicolon ;
Decimal sign	Dot .

​

Schemas & Examples

• Please note that if you want to import an example into eg. Google Sheets, you should uncheck “Convert text to numbers, dates and formulas” - if not, the numbers may be malformatted.

​

Costs

• Please reach out to commercial team for more info on the channel groups and channels.
• There is a possibility to map rows to different storefronts by country. In case you want that, we need information on how the mapping should look, see Merchant mappings.

Column name	Format	Data Type	Description	Optional	Example
date	ISO 8601	date	Date of the campaign data (YYYY-MM-DD according to ISO8601).	No	2025-02-20
campaign		string	Name of the campaign.	Yes	Summer Sale 2025
channel		string	Marketing channel used.	No	Facebook
channelGroup		string	Group classification of the channel.	No	Social paid
cost		number	Total cost associated with the campaign.	No	1500
country	ISO 3166	string	Targeted country (2 letters).	No	SE
currency	ISO 4217	string	Currency of the cost data (3 letters).	No	SEK

​

Indeliveries

	Column name	Format	Data Type	Description	Optional	Example
Product level	productId		string	Unique product identifier.	No	AK0898
Variant level	indeliveryDate	ISO 8601	date	Expected or actual date of delivery for the items to the warehouse.	No	2025-02-20
Variant level	quantity	Non-negative	number	Quantity of items in delivery.	No	1
Variant level	variantNo		string	Product variant number. Unique identifier of product variant (eg. style, color, size).	No	BUF036
Variant level	warehouse		string	Warehouse identifier.	Yes	warehouse-1

​

Inventory

	Column name	Format	Data Type	Description	Optional	Example
Product level	brand		string	Product brand.	Yes	brand-1
Product level	category		string	Product category.	Yes	Apparel
Product level	collection		string	Product collection.	Yes	Summer collection
Product level	currency	ISO 4217	string	Currency code for cost of goods sold.	No	SEK
Product level	customAttribute1		string	Custom attribute for product.	Yes	season-2024
Product level	customAttribute2		string	Additional custom attribute for product.	Yes	Kids
Product level	customAttribute3		string	Additional custom attribute for product.	Yes	sustainable
Product level	customAttribute4		string	Additional custom attribute for product.	Yes	limited-edition
Product level	customAttribute5		string	Additional custom attribute for product.	Yes	bestseller
Product level	gender		string	Gender targeting for the product.	Yes	Women
Product level	name		string	Product name.	No	Black Dress no. 1
Product level	productId		string	Unique product identifier. Same as in your datalayer on the website.	No	AK0898
Product level	subCategory		string	Product subcategory.	Yes	Dresses
Variant level	cogs	Non-negative	number	Cost of goods sold.	No	120
Variant level	color		string	Product color.	Yes	Black
Variant level	inventoryQuantity	Non-negative	number	Available inventory quantity.	No	124
Variant level	material		string	Material of product.	Yes	Polyester
Variant level	size		string	Product size.	No	M
Variant level	variantNo		string	Product variant number. Unique identifier of product variant (eg. style, color, size).	No	BUF036
Variant level	warehouse		string	Warehouse identifier.	No	warehouse-1

​

Orders

• Orders are matched on productId and variantId so we expect a unique combination of orderId-productId-variantId. If multiple items of the same variant were bought we expect them be aggregated with quantity: number of items bought.
• All prices should include tax.
• Order header level fields should be repeated for all items in the same order. If an item is returned or updated. we expect the original values for all columns except what has been updated (eg. the returned… fields or status line).
• If an order is updated, please fill out the updatedAt field and the fields that have been updated (eg. return details).
• If you want data mapped to a specific storefront, fill out externalStorefrontId and provide us with info about your existing storefronts, see Merchant mappings.

	Column name	Format	Data Type	Description	Optional	Example	Default
Order header	city		string	City for the order.	Yes	Stockholm
Order header	country	ISO 3166	string	Targeted country (2 letters).	No	SE
Order header	createdAt	ISO 8601 - UTC	date	Timestamp of when the order was created.	No	2025-01-13T11:36:45Z
Order header	currency	ISO 4217	string	Currency of the cost data (3 letters).	No	SEK
Order header	customerIdentifier		string	Identifier for the customer. Can be either customer id, email or a hashed email.	Yes	david@dema.ai	UNKNOWN
Order header	externalStorefrontId		string	Identifier for the storefront / location where item was sold.	Yes	CH-233
Order header	orderId		string	Unique identifier for the order.	No	D12345
Order header	paymentProvider		string	Payment method used.	Yes	Klarna
Order header	region		string	Geographic region for the order	Yes
Order header	shipping	Non-negative	number	Shipping fees paid by customer (including tax).	No	80
Order header	shippingProvider		string	Shipping provider.	Yes	UPS
Order header	status	Enum. One of [PENDING, IN_PROGRESS, COMPLETED, CANCELLED]	string	Status of the order.	Yes	PENDING	UNKNOWN
Order header	taxTotal	Non-negative	number	Total tax amount (including shipping tax). Based on paid price.	No	200
Order header	total	Non-negative	number	Total order amount. What the customer paid after discounts, includes tax but excludes shipping costs.	No	3000
Order header	type		string	What type of order (online, retail etc.).	Yes	ONLINE	ONLINE
Order header	updatedAt	ISO 8601 - UTC	date	When the order was last updated.	Yes	2025-01-13T11:36:45Z
Order header	voucher		string	Voucher code used for an order. What was added by the customer.	Yes	BLACK_WEEK25
Order header	voucherDiscount		number	Discount amount applied by the voucher.	Yes	1000
Order header	voucherType		string	Type of voucher	Yes	DISCOUNT
Order header	zipCode	No space	string	Zip code of the order.	Yes	11613
Order line	cogs	Non-negative	number	Cost of goods sold, if not set COGS from inventory is used. Usually customers don't send this.	Yes	200
Order line	originalPrice	Non-negative	number	Original price per unit (before any discounts). Including tax, but excluding order level discounts.	No	1000
Order line	paidPrice	Non-negative	number	Final price per unit paid by the customer. Including tax, but excluding order level discounts.	No	900
Order line	productId		string	Unique product identifier. Same as in your datalayer on the website.	No	AK0898
Order line	promotionAmount		string	Promotion amount applied per unit.	Yes	100 SEK
Order line	promotionId		string	Identifier of the promotion rule applied to this item.	Yes	promotion-12345
Order line	promotionType	Enum. One of [FIXED, PERCENTAGE]	string	Type of promotion.	Yes	PERCENTAGE
Order line	quantityDecimal	Non-negative	number	Quantity sold.	No	2.5
Order line	returnedAt	ISO 8601 - UTC	date	Date of return.	Yes	2025-01-14T11:36:45Z
Order line	returnedQuantityDecimal	Non-negative	number	Quantity returned decimal.	Yes	1.5
Order line	returnedReason		string	Reason for the return.	Yes	TOO_SMALL
Order line	returnedShipmentStatus	Enum. One of [CREATED, SHIPPED, DELIVERED, CANCELLED]	string	Status of the return shipment.	Yes	DELIVERED
Order line	returnedShipmentId		string	Shipment ID for the return.	Yes	shipment-id
Order line	returnedShippingProvider		string	Shipping provider for the return.	Yes	UPS
Order line	returnedWarehouse		string	Warehouse for the return.	Yes	warehouse-1
Order line	shipmentId		string	ID of the shipment.	Yes	shipment-id
Order line	shipmentStatus	Enum. One of [CREATED, SHIPPED, DELIVERED, CANCELLED]	string	Status of the shipment.	Yes	CREATED
Order line	shippingProviderLine		string	Shipping provider for item.	Yes	UPS
Order line	statusLine	Enum. One of [PENDING, IN_PROGRESS, COMPLETED, CANCELLED]	string	Status of the order item. Overrides status.	Yes	PENDING	UNKNOWN
Order line	tax	Non-negative	number	Tax amount per unit, excluding order level discounts.	At least one of `tax` or `taxRate` must be set.	30
Order line	taxRate	Non-negative	number	Tax rate percentage for the item (e.g., 25 for 25% VAT).	&uarr,	25
Order line	variantNo		string	Product variant number. Unique identifier of product variant (eg. style, color, size).	No	BUF036
Order line	warehouse		string	Warehouse identifier.	No	warehouse-1

​

Troubleshooting and Support

For common issues and solutions, contact our support team directly for assistance.