IMPORTANT:
The columns names & order must NOT be changed
Supported item status: new
CSV Column |
Type |
Required |
Definition |
What does it refer to? |
Shop Code |
Text |
Optional |
Default - single store / first store |
Your store code which the order belongs to. If not specified, the order will be associated with your team's first store |
Retail Order ID |
Text |
Optional |
Default - Retail Item ID |
Order ID at your store. If not specified, the Retail Item ID will apply |
Retail Order Line Item ID |
Text |
Mandatory |
Unique ID (among all team orders: item ID + order ID + team ID) |
order line Item ID within the order at your store. It is a unique identified across all your team's orders. |
Quantity |
Number |
Optional |
Default - 1 |
Quantity of the item to order. If not specified, it is set for 1. |
Net Retail Revenue |
Decimal |
Mandatory |
Net revenue you received for this order. This data is important to ensure your margin protection and avoid losses. |
|
Source Name |
Text |
Optional |
Default: Amazon.com |
The source (marketplace) to purchase the item from. If not specified, it is set to Amazon.com |
Source Item ID |
Text |
Mandatory |
The item ID at your source (e.g. ASIN in Amazon.com) |
|
Fulfillment Min Margin Percentage |
Percentage |
Optional |
Default: fulfillment settings |
Order fulfilled only if source price meets this minimum margin Retail Revenue * (1- Fulfillment Min Marin Percentage) - Fulfillment Min Marin Amount > Source Price |
Fulfillment Min Margin Amount |
Decimal |
Optional |
Default: fulfillment settings |
Order fulfilled only if source price meets this minimum margin
Retail Revenue * (1- Fulfillment Min Marin Percentage) - Fulfillment Min Marin Amount > Source Price |
Buyer Name |
Text |
Mandatory |
Your buyer's name |
|
Buyer ID |
Text |
Optional |
Your buyer's user ID, as it is identified at your shop. This detail is optional for your own convenience |
|
Buyer Address 1 |
Text |
Mandatory |
Your buyer's ship-to address (house, street, etc.) |
|
Buyer Address 2 |
Text |
Optional |
Your buyer's ship-to address line 2. This detail is optional for your own convenience |
|
Buyer City |
Text |
Mandatory |
Your buyer's ship-to city |
|
Buyer State |
Text |
Mandatory |
Your buyer's ship-to state (e.g. New York, or NY) Mandatory only for US, else optional. |
|
Buyer Country |
Text |
US - Mandatory |
Your buyer's ship-to country (e.g. United States, or US) |
|
Buyer ZipCode |
Text |
Mandatory |
Your buyer's ship-to zip code(e.g. United States, or US) |
|
Buyer Phone |
Text |
Optional |
Sweept to fill in default number in case it's not available |
Your buyer's phone number. It's better to provide this detail as some source suppliers (marketplaces) require it for ordering. |