After: Stock - After: RenderUnits

Keerthy Sethupathy

Posted on 23/03/2021 13:11:36

Hi,

After upgrading a customer solution to 9.10.4, we are experiencing slow load time for productlists.

When doing a debug=true, i can see that After: Stock and After RenderUnits are being called multiple times for each product and they take 200ms to finish everytime.

What changes have been made regarding Stock and Units in 9.10?

Replies

Nicolai Pedersen

Posted on 23/03/2021 13:20:40

Sent to qa for verification. We will get back to you.

Keerthy Sethupathy

Posted on 23/03/2021 13:21:50

Thank you Nicolai

Oleg Rodionov

Posted on 24/03/2021 05:34:43

Hi,

I've checked product list/details using Rapido solution based on DW9.10.4 and was not able to catch the issue. It seems to be one related to your specific solution. Could you please share URL to yuor solution if possible or submit the case to support if relevant to have deep dig and fix.

BR, Oleg QA

Keerthy Sethupathy

Posted on 24/03/2021 06:32:17

Hi Oleg, Have you tested the case where the table EcomStockUnit is filled in the Database. The issue only appears when this table is filled with multiple rows. I could on the failing solution remove everything from EcomStockUnit and the issue would disappear

Oleg Rodionov

Posted on 24/03/2021 07:50:51

Hi Keerthy,

Thanks for the feedback. But could you please specify how many records were in your EcomStockUnit and EcomStockUnitDetail tables. I've tested with EcoStockUnit has 1000 records and not able to catch the issue anyway.

BR, Oleg QA

Keerthy Sethupathy

Posted on 24/03/2021 21:10:00

Hi Oleg,

I have 19419 rows in ecomstockunit.

Nothing in EcomStockUnitDetail

I am working on setting up a DW 9.10.4 Rapido, with filled EcomStockunit table for you.

I will reply when it is ready.

But you should already now see that Render Stock and Render unit takes 10 ms or more for every product, with no traffic on the site.

Keerthy Sethupathy

Posted on 25/03/2021 10:26:20

Hi Oleg,

You can test the issue here, wich is a Rapido 3.4.2 with ecomstockunit table filled with 19000 ++ rows.

http://rapido-342-full.websrv01.smartpage.dk/english/products?Search=&feed=true&DoNotShowVariantsAsSingleProducts=True&debug=true

Oleg Rodionov

Posted on 26/03/2021 22:37:05

Hi, thanks. We will take in accout your case during research. BR, Oleg

Oleg Rodionov

Posted on 29/03/2021 05:40:37

Hi,

The issue is now bugged by DevOps BUG 1478 submitted to research and fix it. Thanks.

BR, Oleg QA

Keerthy Sethupathy

Posted on 29/03/2021 08:41:07

Hi Oleg,

Do you know a date, when the issue will be looked at?

We are unable to upgrade our customers to 9.10, if they use the EcomStockUnit table, so they are pressing for a solution.

Oleg Rodionov

Posted on 29/03/2021 08:48:40

Hi,

I hope it will be done in upcoming DW release at least.

BR, Oleg QA

Keerthy Sethupathy

Posted on 29/03/2021 08:52:26

Hi Oleg,

Perfect thanks!

Vladimir Shushunov

Posted on 30/03/2021 10:11:00

Hi Keerthy,

Could you please check is the problem remains when the setting

/GLOBALSETTINGS/ECOM/PRODUCTLANGUAGECONTROL/VARIANT/PRODUCTDEFAULTUNITID

is True?

Best regards,

Vladimir

Keerthy Sethupathy

Posted on 30/03/2021 10:48:47

Hi Vladimir,

When setting the setting: /GLOBALSETTINGS/ECOM/PRODUCTLANGUAGECONTROL/VARIANT/PRODUCTDEFAULTUNITID = True

then the issue dissapears.

What exactly does that settting do?

Vladimir Shushunov

Posted on 31/03/2021 07:52:29

This post has been marked as an answer

Hi,
its the main purpose to allow to have different Default units in variants (see Settings\eCommerce\Advanced configuration\Fields)

But there is the additional handling for this parameter:
when it is "false" stock units rows are selected ignoring VariantId
which is caused additional calculations

Best regards,
Vladimir

Votes for this answer: 1

Keerthy Sethupathy

Posted on 07/04/2021 15:50:18

Hi Vladimir,

Okay thank you.

You must be logged in to post in the forum

Developer forum

After: Stock - After: RenderUnits

Replies