DEVELOPER CENTER
Hi there,
I am trying to sync catalogs and their inventory values to an external system. The SimPRO account has >24,000 catalog items so we only want to sync products that have changed recently, or their inventory has changed recently.
I can easily get a list of modified catalog items using the If-Modified-Since header, however I can't find a way to get catalog items whose inventory has recently been updated.
I have run a couple of tests and it looks like adding inventory for a catalog item doesn't change the DateModified field.
I also tried to use the /api/v1.0/companies/{companyID}/storageDevices/{storageDeviceID}/stock/ endpoint, but that doesn't seem to support the If-Modified-Since header.
Is it possible to get a list of catalog items whose inventory have changed from a specific date?
Getting catalogs that have recent inventory changes
Forum rules
- Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
- No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
- Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
- Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
- Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
- Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
- Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
- Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
-
JarradFluent
- Posts: 3
- Joined: Tue Jun 07, 2022 6:45 am
-
robbertcha
- Posts: 416
- Joined: Thu Apr 15, 2021 10:07 pm
Re: Getting catalogs that have recent inventory changes
Hi,
You need to create a purchase order & receipt to update catalog items in inventory, so the stock itself will not be updated, but the quantity of the item in the inventory, and this endpoint is actually getting data from multiple tables, that is the reason why we didn't provide If-Modified-Since feature in this endpoint.
Thanks for your helpful suggestion, I'll move this topic to "Feature Requests" first and send you an update when we decide/start to implement this feature, thank you.
You need to create a purchase order & receipt to update catalog items in inventory, so the stock itself will not be updated, but the quantity of the item in the inventory, and this endpoint is actually getting data from multiple tables, that is the reason why we didn't provide If-Modified-Since feature in this endpoint.
Thanks for your helpful suggestion, I'll move this topic to "Feature Requests" first and send you an update when we decide/start to implement this feature, thank you.
Robbert
API Developer | simPRO Software Group
API Developer | simPRO Software Group