StoreFeeder Get Stock

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)

Version	Date	Created / Updated	Notes
v1.0	14/06/2023	Hristiyan Georgiev	First publish

API Call: GET warehouses/{warehouseID}/inventory-report?PageSize={PageSize}&Page={Page}

Api Docs : https://rest.storefeeder.com/Help/Api/GET-warehouses

Basically we want to map the warehouseID that has been selected in the Storefeeder Connector Locations and make the call so we can get the stock. We want to do internal validation and ONLY keep quantity for products that are already created in Hemi. This validation can be on SKU level. So basically if there is a SKU match between the response of the Storefeeeder inventory report and Product > SKU, we then create/update records in Location Quantities in Hemi.

Example response :

{
    "TotalItems": 14949,
    "PagingInfo": {
        "PageSize": 1,
        "Page": 1
    },
    "TotalPages": 14949,
    "Data": [
        {
            "Product": {
                "ProductID": 4326518,
                "SKU": "LG-ROT-A167"
            },
            "TotalInventory": 0,
            "OnBackOrder": 0,
            "IsAkit": false,
            "Allocated": 0,
            "StockLocations": [
                {
                    "StockLocation": {
                        "StockLocationID": 27099,
                        "StockLocationReference": "Unspecified Location"
                    },
                    "Inventory": 0,
                    "Allocated": 0,
                    "PhysicalStock": 0,
                    "PendingOut": 0
                }
            ]
        }
    ]
}

Mapping: Please note N/A means we exclude it

StoreFeeder field		Hemi Mapping
`Product`
	`ProductID`	N/A
	`SKU`	Location Quantities > Product Identifier
`TotalInventory`		Location Quantities > Quantity
`OnBackOrder`		N/A
`IsAkit`		N/A
`Allocated`		N/A
`StockLocations`		N/A
	`StockLocation`	N/A
	`StockLocationID`	N/A
	`StockLocationReference`	N/A
	`Inventory`	N/A
	`Allocated`	N/A
	`PhysicalStock`	N/A
	`PendingOut`	N/A

If the there are SKU which do not match any of our Product > SKU we skip them.

History need to be incorporated and keep track of all stock changes in Item Location Quantity.

Hemi Connectors / Storefeeder Technical Scope / StoreFeeder Product Management / StoreFeeder Get Stock

StoreFeeder Get Stock