Fenix provides multiple ways to consume the order and the fulfillment data from retailers. Fenix uses platform-specific webhooks to retrieve that information for retailers on platforms like Shopify, BigCommerce, etc.
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. 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.
Order data templates with key headers and attribute definitions:
Sample Order CSV data with Key headers:
Key Header:
ORDER_ID|ORDER_NUMBER|PLACED_DTTM|ITEM_QUANTITY|ORDER_SOURCE|ORDER_STATUS|FULFILLMENT_STATUS|CANCLLED_DTTM|CANCELLED_REASON|TOTAL_WEIGHT_VALUE|TOTAL_WEIGHT_UNITS|SHIPPING_LINE_SOURCE|SHIPPING_LINE_CODE|SHIPPING_LINE_SERVICE|SHIPCOST_VALUE|SHIPCOST_CURRENCY|BUYER_ADDRESS_ADDRESS_1|BUYER_ADDRESS_ADDRESS_2|BUYER_ADDRESS_CITY|BUYER_ADDRESS_PROVINCE|BUYER_ADDRESS_PROVINCE_CODE|BUYER_ADDRESS_COUNTRY|BUYER_ADDRESS_COUNTRY_CODE|BUYER_ADDRESS_ZIPCODE|LINE_ITEMS_SKU|LINE_ITEMS_QUANTITY|LINE_ITEMS_REQUIRES_SHIPPING|LINE_ITEMS_IMAGE_URL|LINE_ITEMS_ROUTING_URL|PREDICTION_EXPECTED_SHIPMENT_DTTM|PREDICTION_PROMISED_DELIVERY_DTTM
Sample Data:
5544645|S824514|2023-08-05T00:00:00-05:00|4|Amazon|OPEN|FILLED|||3|LBS|Fenix Shipping|Priority|Priority Mail|10|USD||P.O. Box 8050||Christiansted|Virgin Islands|VI|United States|US|00823|910544U^911441U^111319^101102|1^1^2^1|TRUE^TRUE^TRUE^FALSE|||2023-08-12T00:00:00-05:00|2023-08-12T00:00:00-05:00
Sample CSV File to download:
CSV data attribute definitions:
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 | NO | |
BUYER_ADDRESS.ADDRESS_2 | NO | |
BUYER_ADDRESS.CITY | YES | |
BUYER_ADDRESS.PROVINCE | YES | Required any one of these two fields |
BUYER_ADDRESS.PROVINCE_CODE | YES |
BUYER_ADDRESS.COUNTRY | YES | Required any one of these two fields |
BUYER_ADDRESS.COUNTRY_CODE | YES |
BUYER_ADDRESS.ZIPCODE | YES | |
LINE_ITEMS.SKU | NO Required only if want to fully utilize Fenix post-purchase platforms like Branded Tracking Page and Notifications to show purchased products. | List of items(SKUs) separated by allowed separators | ^ @ # , |
LINE_ITEMS.QUANTITY | SKU quantities separated by allowed separators | ^ @ # , |
LINE_ITEMS.REQUIRES_SHIPPING | 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 | Image URLs separated by allowed separators | ^ @ # , |
LINE_ITEMS.ROUTING_URL | 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 |
Fulfillment data template with key headers and attribute definitions:
CSV data with Key headers and values:
Key Header:
SHIPMENT_ID|ORDER_NUMBER|SHIPMENT_DTTM|TRACKING_NUMBER|CARRIER_NAME|CARRIER_SERVICE|ITEM_QUANTITY(`)|LABELCOST_VALUE(`)|LABELCOST_CURRENCY|SHIPMENT_STATUS(`)|SHIPPER_ADDRESS_1|SHIPPER_CITY|SHIPPER_ADDRESS_PROVINCE|SHIPPER_ADDRESS.PROVINCE_CODE|SHIPPER_COUNTRY|SHIPPER_ADDRESS.COUNTRY_CODE|SHIPPER_ZIPCODESKUS|QUANTITIES
Sample Data:
XGDYS1737S|S824514|2022-12-12T00:00:00-05:00|99981773237887|USPS|Priority Mail|2|10|USD|SHIPMENT_CONFIRMED|2000 Walnut Ave|Fremont|California|CA|United States|US|94538|911441U^111319|1^1
Sample CSV File to download:
CSV data attribute definitions:
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 | ^ @ #, |