Question

Inventory Feed to Amazon/eCommerce Marketplaces

  • 23 April 2021
  • 6 replies
  • 88 views

I’m new to this forum so if this is the wrong board for this please point me in the right direction. 

We’re a pretty large company running Acumatica. We sell both wholesale and retail, both on our own websites as well as external marketplaces like Amazon, eBay, Walmart, Etc. We’re currently using Celigo to facilitate an API connection between Acumatica and these platforms to import orders, but we’re looking to export inventory from Acumatica to these platforms as well. 

Being that we currently have over 60,000 SKUs it’s impractical for us to export our entire inventory to these platforms, so we’re looking to set up a feed that only pulls inventory from items whose inventories have changed since the last update. We’ve hit a wall with Celigo because we can’t seem to access the LastModified field on StockItems>WarehouseDetails and Celigo can’t track changes without that timestamp. 

Has anyone set up such an inventory field for their businesses? We’re looking to set up inventory updates for changes every 15 minutes so our Amazon inventory can be as accurate as possible. 


6 replies

Userlevel 3
Badge

@ruchikasharma23 - Could you please check with Celigo why they can’t do it and if there are any possible workarounds.

@ruchikasharma23 - Could you please check with Celigo why they can’t do it and if there are any possible workarounds.

Sure, working on it.

@Igor.Leybe - their premade templates have the following OData filter which references the LastModified on the stock item: /StockItem?$filter=LastModified ge datetimeoffset'{{encodeURI lastExportDateTime}}' &$top=100

This only recognizes a change to the item listing itself, not to changes in inventory. We tested this by applying an inventory adjustment, running the flow, getting nothing, then changing the item description, running the flow, and getting a result. When we asked Celigo about it they suggested we contact Acumatica. We even attended their office hours and got the same answer. 

@Igor.Leybe - their premade templates have the following OData filter which references the LastModified on the stock item: /StockItem?$filter=LastModified ge datetimeoffset'{{encodeURI lastExportDateTime}}' &$top=100

This only recognizes a change to the item listing itself, not to changes in inventory. We tested this by applying an inventory adjustment, running the flow, getting nothing, then changing the item description, running the flow, and getting a result. When we asked Celigo about it they suggested we contact Acumatica. We even attended their office hours and got the same answer. 

Hi @ctechaplus 
We have proposed a solution to Celigo for this scenario and waiting for their reply. It includes retrieving the inventory records using a Generic Inquiry.
Please allow us some time to confirm the findings with Celigo and get back to you on this.

@Igor.Leybe to do this via GI would be more time consuming. Opening up the field on the item/warehouse table would be easier, and faster, much much faster.

Why can’t/won’t Acumatica do that?

Anshel

Currently, we have a field which is exposed to the API and calculates inventory based on the warehouse. This field is based on “INStatus.LastModifiedDateTime”. However, the question with Celigo is the aggregation of inventory items based on various locations. So, it should either be aggregated on the Celigo side or we can have a generic Inquiry which feeds this information to Celigo. For this reason, we have a GI in this case. Please find attached for your reference.
After importing the GI, you can perform a GET request:
{​sitename}​/OData/StorageSummary?$filter=SiteLastModifiedDate gt datetime'2021-04-22T00:00:00.000'

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved