Updating Inventory when CatalogEntry is set to 'Ready To Publish.

Paul McGann (Netcel)

Vote:

Hi,

We are currently investigating an issue with the state 'Ready To Publish' upon a catalog entry item.

We have an api that updates the inventory for the catalog entry however it appears to not be doing this when the item is set to 'Ready to Publish'.

Does anyone know if that behaviour is correct?

Thanks

#288408

Sep 30, 2022 12:03

Surjit Bharath

Vote:

Hi Paul,

I don't believe that is standard behaviour. Try inspecting the [InventoryService] table. Maybe you're not providing one of the mandatory fields?

#288460

Oct 01, 2022 20:42

Paul McGann (Netcel) - Oct 03, 2022 8:06

Thanks I will take a look and see.

Quan Mai

Vote:

inventory system is fairly independent from the catalog, it only needs the entry with the code exists. what error message are you seeing?

#288495

Oct 02, 2022 10:20

Paul McGann (Netcel) - Oct 03, 2022 8:16

We don't have an error message related. This is visually we can see we are sending the data however, we then see the data is not updating.

Quan Mai

Vote:

@Paul - how do you send the data and how do you check to see if it's updated ? sounds like a cache somewhere

does it work if you update inventories for published content?

#288542

Oct 03, 2022 10:21

Paul McGann (Netcel) - Oct 03, 2022 10:51

Hi Quan,

Hopefully I can explain this so it makes sense, please note stock is coming from a third part erp system.

1. We have an API endpoint /api/InventoryUpdate, to this api we send a list of type 'EPiServer.ServiceApi.Commerce.Models.Catalog.WarehouseInventory'.
2. We then use the 'IInventoryService' to retrieve the 'Mediachase.Commerce.InventoryService.InventoryRecord'.
3. We then create a writeable clone of the inventory record and update the stock level.
4. Finally we call the IInventoryService.Update method.

To check the stock is updated we do this manually in the system. Generally this is our client that will do this as they are adding products and stock and will raise issues with us when they don't go to plan.

If the state is set to draft or published it is working correctly, just anything in between.

I don't think this is a cache issue as this has been happening the past week and the cache should have been updated.

Thanks

Paul

Paul McGann (Netcel) - Oct 03, 2022 10:54

Just as a thought, is it possible to use the 'ICatalogSystem' to update the inventory levels?

Quan Mai - Oct 03, 2022 10:55

So I assume by checking you go to Catalog UI and check the Inventory tab? Is it possible to show code that update the inventories? I'm sure they are fine, just want to make sure no stone left untuned

Quan Mai - Oct 03, 2022 10:58

No, ICatalogSystem can't even handle the inventories. the inventories were separated long, long ago

Quan Mai

Vote:

if (!_catalogRepository.EntryExists(warehouseInventory.CatalogEntryCode))

this catches my eyes. can you check if this does not check for publish status?

Unless you are sure that each run will only update inventories of each sku in one warehouse, you can speed up quite a lot by updating all inventories of same sku in one go

#288551

Oct 03, 2022 11:31

Paul McGann (Netcel) - Oct 03, 2022 11:51

That code is just a wrapper around the 'ReferenceConverter.GetContentLink' method which I believe does not do any checks on publish status.

Paul McGann (Netcel) - Oct 03, 2022 11:51

That code is just a wrapper around the 'ReferenceConverter.GetContentLink' method which I believe does not do any checks on publish status.

Quan Mai - Oct 03, 2022 11:52

Can you check if the data is updated in the database or not?

Quan Mai

Vote:

Something is wrong somewhere else. if you are using the Catalog UI to update inventory in a Ready to Publish content, does it persist? because your code is essentially what Catalog UI does under the hood

#288560

Oct 03, 2022 12:51

Quan Mai

Vote:

#288561

Oct 03, 2022 12:51

Paul McGann (Netcel) - Oct 03, 2022 13:02

I am going to do some more investigation into this.