This article explains in what ways you can import order data to Omnia, to boost pricing performance and get more valuable insights.
To enhance pricing decisions with sales data, we ask you to regularly share your customer order data. There are 2 options: we have an API endpoint that can be used immediately or you can upload the data via file on an (S)FTP. Below you'll find what’s needed and how to deliver it.
To learn more about the benefits of order data, please read this article.
API
The API endpoint can be used immediately to import order data and the documentation of the endpoint can be found via: https://api-docs.omniaretail.dev/api/omnia/orders/postorders.
Upload files
How to Deliver Your Data
- Delivery Method: Secure upload via (S)FTP (we’ll provide credentials and folder structure).
- Cadence: Ideally daily, but we can import historically so frequency is flexible.
- Accepted Formats:
- CSV
- XML
- JSON
Don't worry about field names — as long as the necessary information is present, we’ll handle the mapping.
What Data We Need
Here's an overview of the data that is important to import order data via files.
Order-Level Information
|
Required info |
Description |
|
Order ID |
A unique identifier for each order in your system |
|
Order Date |
When the order was placed (preferably in UTC or with timezone info) |
|
Total Price |
The full price paid for the order (including taxes and shipping) |
|
Shipping Costs |
The amount charged for shipping |
|
Order Origin |
Where the order came from (e.g., online shop, POS system) |
Item-Level Information (per product in the order)
|
Required info |
Description |
|
Product ID |
Your internal product ID (used in your product catalog) |
|
Unit Price |
Price per item (including tax) |
|
Quantity |
How many units of the product were purchased |
Optional (but helpful)
|
Info |
Description |
|
Referrer |
Where the customer came from (e.g. Online + referrer (Google Shopping/Amazon etc.), Offline + (which shop) |
|
Currency |
ISO code (e.g., EUR, USD). If not provided, we’ll use a default based on the country of the portal. |
|
Tax Percentage |
VAT or sales tax rate. If not provided, we’ll use tax percentage from the product import. |
Example Structure (CSV)
|
orderId |
orderDate |
totalPrice |
shippingCosts |
origin |
itemId |
unitPrice |
quantity |
referrer |
|
ORDER123 |
2025-04-01T13:45:00Z |
64.97 |
4.99 |
webshop |
SKU001 |
29.99 |
2 |
Google Ads |
For orders with multiple items, use one row per item and repeat the order-level data.
Process:
- Reach out to your CSM or niels@omniaretail.com
- Provide the order file on a (S)FTP location.
- Our development team will handle the rest — including file parsing, product mapping, and data import into Omnia.
- We’ll confirm once the data is processed.
Questions?
Feel free to reach out to Niels (niels@omniaretail.com) if you need any help with file structure, delivery setup, or any questions about the data.