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 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, 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.
...
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 YES | 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 YES | 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 | 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 | 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.SKUSKUS | YES | List of items(SKUs) separated by allowed separators | ^ @ # , | LINE_ITEMS.QUANTITYQUANTITIES | YES | SKU quantities separated by allowed separators | ^ @ #, |
|