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_SKUS|LINE_ITEMS_QUANTITY|LINE_ITEMS_REQUIRES_SHIPPING|LINE_ITEMS_IMAGE_URL|LINE_ITEMS_ROUTING_URL|PREDICTION_EXPECTED_SHIPMENT_DTTM|PREDICTION_PROMISED_DELIVERY_DTTM|BUYER_EMAIL_ID|SUBSCRIBED_FOR_EMAIL|BUYER_PHONE_NUMBER|SUBSCRIBED_FOR_SMS|BUYER_FIRST_NAME|BUYER_LAST_NAME
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 |xyz@gmail.com|TRUE|+4312354145|FALSE|John|smit
Sample CSV File to download:
| View file |
|---|
| name | Inbound Order Data.csv |
|---|
|
CSV data attribute definitions:
| 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 Zonos Shipping Rates
| SHIPPING_LINE.CODE | YES | Shipping option codes like GROUND_HOME_DELIVERY UPS_STANDARD_DDP
| SHIPPING_LINE.SERVICE | YES | Shipping option services like | SHIPCOST.VALUE | YES | 100 | SHIPCOST.CURRENCY | NO | USD | BUYER_ADDRESS.ADDRESS_1 | NO | 1238 w 59th Pl | BUYER_ADDRESS.ADDRESS_2 | NO | | BUYER_ADDRESS.CITY | YES | Los Angeles | BUYER_ADDRESS.PROVINCE | YES | Required any one of these two fields California CA | BUYER_ADDRESS.PROVINCE_CODE | YES | BUYER_ADDRESS.COUNTRY | YES | Required any one of these two fields United States US | BUYER_ADDRESS.COUNTRY_CODE | YES | BUYER_ADDRESS.ZIPCODE | YES | 90044 | 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 | BUYER_EMAIL_ID | YES(required for notifications) | xyz@gmai.com | SUBSCRIBED_FOR_EMAIL | shopper subscribed for email or not | TRUE | BUYER_PHONE_NUMBER | YES(required for notifications) | +13264012379 | SUBSCRIBED_FOR_SMS | shopper subscribed for SMS or not | FALSE | BUYER_FIRST_NAME | YES(for Notifications) | Buyer first name | BUYER_FIRST_NAME | No | Buyer last name |
|
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_ZIPCODE|LINE_ITEMS_SKUS|LINE_ITEMS_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:
| View file |
|---|
| name | Inbound Shipment Data.csv |
|---|
|
CSV data attribute definitions:
| Expand |
|---|
| title | Shipment Summary Data Attributes: |
|---|
|
Attribute | Required | Allowed Fields & Formats |
|---|
SHIPMENT_ID | YES | Unique Id of the Shipment, if shipment number is unique, then pass shipment number as shipment id | ORDER_NUMBER | YES | shipment ssociated order number | SHIPMENT_DTTM | YES | 2022-11-06T19:21:29-05:00 | CARRIER_NAME | YES | which carrier processes shipments like | SERVICE_NAME | YES | Which service carrier use to ship package like surepost fedex ground parcel select
| TRACKING_NUMBER | YES | 253427896831 | ITEM_QUANTITY | NO | 3 | LABELCOST.VALUE | NO | 100 | LABELCOST.CURRENCY | NO | USD | 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 | 1001 Mustang Drive | SHIPPER_ADDRESS.ADDRESS_2 | | | SHIPPER_ADDRESS.CITY | YES | GRAPEVINE | SHIPPER_ADDRESS.PROVINCE | YES | | SHIPPER_ADDRESS.PROVINCE_CODE | YES | TX | SHIPPER_ADDRESS.COUNTRY | YES | UNITED STATES | SHIPPER_ADDRESS.COUNTRY_CODE | YES | US | SHIPPER_ADDRESS.ZIPCODE | YES | 76051 | LINE_ITEMS.SKUS | YES | List of items(SKUs) separated by allowed separators | ^ @ # , | LINE_ITEMS.QUANTITIES | YES | SKU quantities separated by allowed separators | ^ @ #, |
|