Order and Fulfillment <> Bulk Data CSV Processor

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:

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 OPEN CLOSED 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 Preferred UPS Standard Duties & Taxes Included 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:

CSV data attribute definitions:

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 UPS FEDEX USPS 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 | ^ @ #,