StoreFeeder Get Product Content

Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)

API Call: GET /products?ExcludeTaxRateCountries=true&IncludeImages=true&IncludeBarcodes=true&IncludeVariants=true&IncludeCategories=true

We want to exclude tax rate countries in our call, as the response returns tax rates for every single country which is causing huge payload. At the same time, we want to include some params in order to get as much information as possible for the product, so the teams can use it when optimizing products.

API Docs: GET products

We do not want to store any product data directly in Hemi as it needs to be optimized and made for our standards. So this is why the purpose of this call is to be able to get all the product details information from Storefeeder in a .csv file from where we can pick the data optimize it and manually import it in Hemi.

The CSV delimiter will be comma (,) and we need to place all the enclosing (“) and escaping end line characters (\r\n) . The file name structure should be : StoreFeederProductsExport{YYYY}{MM}{DD}{HH}{MI}{SS}.csv

Get Products example response

{
    "TotalItems": 18550,
    "PagingInfo": {
        "PageSize": 100,
        "Page": 1
    },
    "TotalPages": 186,
    "Data": [
        {
            "ProductID": 4326405,
            "SKU": "DEX-8-BS",
            "Name": "8 Bamboo Drinking Straws",
            "ProductGUID": "1002c5e6-a82e-4449-b9e8-6b4b63986ad1",
            "ProductType": "SimpleProduct",
            "GlobalTradeIdentifiers": {
                "EAN": "5056225403169",
                "UPC": "",
                "AdditionalBarcodes": [
                    "X000TXD5ZD"
                ]
            },
            "WarehouseInformation": {
                "Warehouse": {
                    "WarehouseName": "FF STORES WAREHOUSES",
                    "WarehouseGuid": "47b69f20-ca67-48ad-b347-fa6d5b023a0e",
                    "WarehouseID": 213
                },
                "ContainsHazardousMaterials": false,
                "IsFragile": false,
                "UnitOfMeasure": "Unit",
                "Weight": 0.74,
                "Packaging": {
                    "PackagingID": 505,
                    "PackagingName": "Parcel"
                },
                "PackagingQuantity": 100,
                "PackagingQuantityDecimal": 100.0000,
                "ProductTypeDescription": "8 Bamboo Drinking Straws",
                "DetailedProductTypeDescription": "",
                "ProductComposition": "",
                "ProductHarmonizedCode": "",
                "RecordSerialNumberOnBarcodeDespatch": false
            },
            "PricingInformation": {
                "TaxClass": {
                    "TaxClassID": 1,
                    "TaxClassGuid": "84bd98c3-a6de-439a-9354-1f3a4867b955",
                    "CreatedOn": "2007-03-25T19:27:35.74",
                    "IsGlobal": true,
                    "Name": "20",
                    "TaxRate": 20.0000
                },
                "Price": 9.9900,
                "Margin": 0.0000,
                "AverageCost": 2.72,
                "AverageCostExVat": 2.72,
                "PriceIncludesVat": true,
                "LastCostPrice": 2.2142,
                "LastCostPriceExVat": 2.2142
            },
            "InventoryInformation": {
                "Inventory": 0,
                "Allocated": 0,
                "OnBackOrder": 0,
                "OnPurchaseOrder": 0,
                "ManualReorderLevel": 1000,
                "CalculatedReorderLevel": 0,
                "SoldLast30Days": 0,
                "SoldLast90Days": 0,
                "SoldLast120Days": 0,
                "LastOrderedDate": "2022-04-03T08:38:55"
            },
            "Brand": "DECO EXPRESS",
            "Description": "<ul>\r\n<li><span class=\"a-list-item\">100% NATURAL AND ENVIRONMENTALLY-FRIENDLY: Bambooz straws are a great alternative to disposable straws as they are made from 100% natural, organic, and biodegradable bamboo. They are tasteless and odourless so there is no risk of missing out on flavour when drinking your favourite drinks.</span></li>\r\n<li><span class=\"a-list-item\">REUSABLE: Bambooz straws can be used infinite times, are durable, recyclable, resistant and will help you contributing to fight environmental pollution</span></li>\r\n<li><span class=\"a-list-item\">SAFE: Bambooz straws are washable, non-toxic, have not been treated with any colorants or coating and can even be used by children.</span></li>\r\n<li><span class=\"a-list-item\">MULTI USE: You can use Bambooz to drink tea, coffee, smoothies, juices, or whatever other drink you have in mind</span></li>\r\n<li><span class=\"a-list-item\">UNIQUE: Each Bambooz straw is unique in size and colour being made from 100% natural bamboo</span></li>\r\n</ul>",
            "Archived": true,
            "IsAkit": false,
            "ProductImages": [
                {
                    "ProductImageID": 2889244,
                    "ImageURL": "https://storefeederimages.blob.core.windows.net/ffstoresltd/Products/1002c5e6-a82e-4449-b9e8-6b4b63986ad1/Full/dkeuuoesr5z.jpg",
                    "Order": 1,
                    "Height": 688,
                    "Width": 688
                }
            ],
            "ManufacturerPartNumber": "100",
            "CreatedOnDate": "2019-09-16T06:28:39.573",
            "LastModifiedDate": "2021-11-12T17:38:31.347",
            "ProductSpecialAttribute": ""
        }
    ]
}

Mapping: Please note N/A means we exclude it from saving it in the CSV.

If “true” we put Yes in the csv. If “false” we put No in the csv. | | ProductImages | | | | N/A | | | | | ProductImageID | | | N/A | | The ProductImageID will have assigned ProductImageURL to it. | | | ImageURL | | | Image | 12 | <v1.1> We want to have 6 hardcoded image headers - image1, image2 etc. and fill them subsequently. So if we have a product with 3 images we will fill only up until image3, but if we have product with 6 images we will fill up to image6.</v1.1> | | | Order | | | N/A | | | | | Height | | | N/A | | | | | Width | | | N/A | | | | ManufacturerPartNumber | | | | N/A | | | | CreatedOnDate | | | | N/A | | | | LastModifiedDate | | | | N/A | | | | ProductSpecialAttribute | | | | N/A | | |

The ultimate goal is for whoever will need such a file to be able to get the file on their own without the need/help of the support team. We have similar generation of csv file for Shopify and the file needs to be generated by the suppor team. For Storefeeder we will have a tickbox field which is named “Export products from Storefeeder” and upon checking the tickbox, it will generate and download a csv file (on FTP) with the above information and then send a link to the file on the email.