...
Below is a standard folder structure of either of the above two locations.
...
...
Inbound order & fulfillment data sample CSV templates and attributes:
...
...
| Expand |
|---|
| title | Order Summary Data Attributes: |
|---|
|
Attribute | Required | Allowed Fields & formats |
|---|
ORDER_ID | YES | Unique Id of the order, if order number is unique, then pass order number as order id | ORDER_NUMBER | YES | | PLACED_DTTM | YES | 2022-11-06T19:21:29-05:00 | ITEM_QUANTITY | YES | | ORDER_SOURCE | NO | Source channel from where order placed. Websire Subscription APPs Amazon Etc…
| ORDER_STATUS | NO | | FULFILLMENT_STATUS | NO | NOT_FILLED PARTIALLY_FILLED FILLED
| CANCLLED_DTTM | YES | Provide only if the order cancelled | CANCELLED_REASON | YES | Provide only if the order cancelled | TOTAL_WEIGHT.VALUE | NO | | TOTAL_WEIGHT.UNITS | NO | | SHIPPING_LINE.SOURCE | NO | Shipping provider names like Fenix Shipping Shopify Subscription
| SHIPPING_LINE.CODE | YES | | SHIPPING_LINE.SERVICE | YES | | SHIPCOST.VALUE | YES | | SHIPCOST.CURRENCY | NO | | BUYER_ADDRESS.ADDRESS_1 | YES | | BUYER_ADDRESS.ADDRESS_2 | | | BUYER_ADDRESS.CITY | YES | | BUYER_ADDRESS.PROVINCE | YES | | BUYER_ADDRESS.PROVINCE_CODE | | | BUYER_ADDRESS.COUNTRY | YES | | BUYER_ADDRESS.COUNTRY_CODE | YES | | BUYER_ADDRESS.ZIPCODE | YES | | LINE_ITEMS.SKU | YES | List of items(SKUs) separated by allowed separators | ^ @ # , | LINE_ITEMS.QUANTITY | YES | SKU quantities separated by allowed separators | ^ @ # , | LINE_ITEMS.REQUIRES_SHIPPING | YES | Boolean values (True\False) separated by allowed separators | ^ @ # , to define whether the item is shippable item or Gift or Insurance or etc… | LINE_ITEMS.IMAGE_URL | YES | Image URLs separated by allowed separators | ^ @ # , | LINE_ITEMS.ROUTING_URL | NO | Routing URLs separated by allowed separators | ^ @ # , Routing URL : It’s website routing url of Product details page to route website | PREDICTION.EXPECTED_SHIPMENT_DTTM | YES | Mandatory only if you business have the calculated predictions | PREDICTION.PROMISED_DELIVERY_DTTM | YES | Mandatory only if you business have the calculated predictions |
|
| View file |
|---|
| name | Inbound Shipment Data.csv |
|---|
|
| Expand |
|---|
| title | Shipment Summary Data Attributes: |
|---|
|
Attribute | Required | Allowed Fields & Formats |
|---|
SHIPMENT_ID | YES | | ORDER_NUMBER | YES | | SHIPMENT_DTTM | YES | 2022-11-06T19:21:29-05:00 | CARRIER_NAME | YES | | SERVICE_NAME | YES | | TRACKING_NUMBER | YES | | ITEM_QUANTITY | NO | | LABELCOST.VALUE | NO | | LABELCOST.CURRENCY | NO | | SHIPMENT_STATUS | NO | SHIPMENT_CONFIRMED READY_SHIP PICKED_BY_CARRIER INTRANSIT SHIPMENT_EXCEPTION OUT_FOR_DELIVERED DELIVERY_EXCEPTION RETURN_TO_SENDER RETURNED_TO_SENDER DELIVERED
| SHIPPER_ADDRESS.ADDRESS_1 | YES | | SHIPPER_ADDRESS.ADDRESS_2 | | | SHIPPER_ADDRESS.CITY | YES | | SHIPPER_ADDRESS.PROVINCE | YES | | SHIPPER_ADDRESS.PROVINCE_CODE | | | SHIPPER_ADDRESS.COUNTRY | YES | | SHIPPER_ADDRESS.COUNTRY_CODE | YES | | SHIPPER_ADDRESS.ZIPCODE | YES | | LINE_ITEMS.SKU | YES | List of items(SKUs) separated by allowed separators | ^ @ # , | LINE_ITEMS.QUANTITY | YES | SKU quantities separated by allowed separators | ^ @ # , |
|