Fenix provides multiple ways to consume the order and the fulfillment data from retailers. For retailers on platforms like Shopify, BigCommerce, etc., Fenix uses platform-specific webhooks to retrieve that information.
For retailers not on such platforms, Fenix provides a feed upload service where the retailer can upload the necessary data, order, fulfillment, etc., to an agreed-upon cloud location, and Fenix can consume that data every 30min of the upload.
Folder structure and description
Fenix provides two ways to upload the order and fulfillment feed.
SFTP
AWS S3
Below is a standard folder structure of either of the above two locations.
CSV Sample Templates
| 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 |
|
| 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 | ^ @ # , |
|