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:
CSV data attribute definitions:
Order Summary Data Attributes:
ORDER_ID
Unique Id of the order, if order number is unique, then pass order number as order id
ORDER_NUMBER
Â
PLACED_DTTM
2022-11-06T19:21:29-05:00
ITEM_QUANTITY
Â
ORDER_SOURCE
Source channel from where order placed.
Websire
Subscription APPs
Amazon
Etc…
ORDER_STATUS
FULFILLMENT_STATUS
NOT_FILLED
PARTIALLY_FILLED
FILLED
CANCLLED_DTTM
Provide only if the order cancelled
CANCELLED_REASON
Provide only if the order cancelled
TOTAL_WEIGHT.VALUE
Â
TOTAL_WEIGHT.UNITS
Â
SHIPPING_LINE.SOURCE
Shipping provider names like
Fenix Shipping
Shopify
Subscription
Zonos Shipping Rates
SHIPPING_LINE.CODE
Shipping option codes like
GROUND_HOME_DELIVERY
UPS_STANDARD_DDP
SHIPPING_LINE.SERVICE
Shipping option services like
Â
SHIPCOST.VALUE
100
SHIPCOST.CURRENCY
USD
BUYER_ADDRESS.ADDRESS_1
1238 w 59th Pl
BUYER_ADDRESS.ADDRESS_2
NO
Â
BUYER_ADDRESS.CITY
Los Angeles
BUYER_ADDRESS.PROVINCE
Required any one of these two fields
California
CA
BUYER_ADDRESS.PROVINCE_CODE
BUYER_ADDRESS.COUNTRY
Required any one of these two fields
United States
US
BUYER_ADDRESS.COUNTRY_CODE
BUYER_ADDRESS.ZIPCODE
90044
LINE_ITEMS.SKU
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
Mandatory only if you business have the calculated predictions
PREDICTION.PROMISED_DELIVERY_DTTM
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:
CSV data attribute definitions:
Shipment Summary Data Attributes:
SHIPMENT_ID
Unique Id of the Shipment, if shipment number is unique, then pass shipment number as shipment id
ORDER_NUMBER
shipment ssociated order number
SHIPMENT_DTTM
2022-11-06T19:21:29-05:00
CARRIER_NAME
which carrier processes shipments like
SERVICE_NAME
Which service carrier use to ship package like
surepost
fedex ground
parcel select
TRACKING_NUMBER
253427896831
ITEM_QUANTITY
3
LABELCOST.VALUE
100
LABELCOST.CURRENCY
USD
SHIPMENT_STATUS
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
1001 Mustang Drive
SHIPPER_ADDRESS.ADDRESS_2
Â
Â
SHIPPER_ADDRESS.CITY
GRAPEVINE
SHIPPER_ADDRESS.PROVINCE
Â
SHIPPER_ADDRESS.PROVINCE_CODE
YES
TX
SHIPPER_ADDRESS.COUNTRY
UNITED STATES
SHIPPER_ADDRESS.COUNTRY_CODE
US
SHIPPER_ADDRESS.ZIPCODE
76051
LINE_ITEMS.SKUS
List of items(SKUs) separated by allowed separators | ^ @ # ,
LINE_ITEMS.QUANTITIES
SKU quantities separated by allowed separators | ^ @ #,
