How to check for inventory change using REST API

Question

I am working on an automated Integration that picks up the products based on the last date modified and updates those products in an e-Commerce platform. but whenever the inventory is updated, it's not affecting the last date modified of the products and I am not seeing those products in my response.

URL : https://<host_url>//Entity/<endpoint_name>/<endpoint_version>/StockItem?$filter=LastModified ge datetimeoffset'2022-01-19T05:17:43'
This the API and parameters I am using in order to fetch recently updated products (date will change based on the integration run time)
if a Qty of a product is updated (Qty added to a product, shipment completed with a product in order) it's not affecting this last date modified.

Is there a way to find the Inventory change of a product, any separate endpoint just to determine a change?

Thanks,

jinin · Accepted Answer

Hi@RanjithKumar,Stock item entity only updates the details available on the stock item screen. The Quantity will maintain on the warehouse level. The Qty updates are available on the InSiteStatus table.To get the qty updates through the endpoint, we need to create a GI with InventoryItem andInSiteStatus table. And also create a Custom endpoint to get the updates.I’ve created a sample package with GI and endpoint. Please review.You can adjust the GI and the filter based on your requirement.Endpoint url: …./entity/InventoryUpdate/20.200.001/GetInventoryUpdates?$expand=GetInventoryUpdatesDetailsMethod: PUTInput:{"FromDate":{"value":"2021-01-01"},"ToDate":{"value":"2022-12-29"}}

deebhane · Answer

hi @RanjithKumar,As Sales order, shipment and receipts updates of the productwill not updated the inventory last modified date.We need to create a GI that looks for INTran and Inventory Item last modified date and get records to GI based on datetime modified on any of these table.This GI screen has to be exposedto GI.we can also add date filters on the GI if required.

Sign up

Social Login

Login to the community

Social Login