Product and Inventory feed upload

Owned by Rahul Kumar Sahukar
Last updated: May 09, 2024
3 min read

Fenix provides multiple ways to consume the product and the inventory data from retailers. For retailers on platforms like Shopify, BigCommerce, etc., Fenix uses platform-specific webhooks to retrieve that information.

For retailers who are not on such platforms, Fenix provides a feed upload service where the retailer can upload the necessary data, product, inventory, order, etc., to an agreed-upon cloud location, and Fenix can consume that data within 5 minutes of the upload. In addition, the retailers who are on Shopify or BigCommerce but maintain a consolidated inventory in Shopify can also use this cloud upload feature.

Folder structure and description

Fenix provides two ways to upload the product and inventory feed.

  1. SFTP

  2. AWS S3

Below is a common folder structure of either of the above two locations.

image-20240509-153000.png

The description of each folder is as below.

  1. inventory

If the retailer wants to upload a complete snapshot of their inventory, they can upload the feed into this folder. Existing inventory will be discarded and will be overwritten with the new one.

2. delta

If the retailer wants to upload a delta inventory, they can upload the feed into this folder. This feed is basically the changes to their inventory since their last inventory/delta upload. Only the SKUs present in this feed will be modified. Others will not be touched.

3. product

If the retailer wants to upload a complete snapshot of their product catalog, they can upload the feed into this folder. Existing product data will be discarded and overwritten with the new one.

4. product-delta

If the retailer wants to upload a delta product feed, they can upload it into this folder. This feed is basically the changes to their product since their last product/product-delta upload. This feed can contain any new SKUs added or changes to the existing products. Only the SKUs present in this feed will be modified. Others will not be touched.

  1. bundles

If the retailers is maintaining virtual skus, they can upload the mapping data in this folder. The mapping contains the virtual SKU name and the physical SKUs with the respective quantities contained in it.

Data processing time

Usually, any feed uploaded into the above folders will be processed within 5 minutes.

Data feed formats

Below are sample product, inventory and the bundle SKU feed formats.

Note: If the retailer is given their own template, please use that.

  1. Product Feed Format

SKU,CATEGORY_ID,CATEGORY_NAME,PRODUCT_ID,PRODUCT_NAME,HEIGHT,WIDTH,LENGTH,GIRTH,DIM_UNITS,WEIGHT,WEIGHT_UNITS 212149,,,,,8,4,4,1,IN,3,LB 312323,,,,,6,6,11,1,IN,0.54895038,LB 4432232,,,,,1,20,20,1,IN,0.70106916,LB 5CHW43,,,,,3,11,21,1,IN,6.49921976,LB

2. Inventory Feed Format

SKU,LOCATION_ID,AVAILABLE_QTY 212149,528,612 312149,600,300 424149,810,876

 

  1. Bundle SKU Feed Format

VIRTUAL SKU,PHYSICAL SKU, QUANTITY Bundle 1,SKU1,3 Bundle 1,SKU2,2 Bundle 2,SKU1,10

Data Feed upload automation

The retailer tech team must automate uploading the feed to the Fenix-provided SFTP/S3 location.

Data Feed Location Access

Once the customer gives us their preference (SFTP or S3), these details will be provided.