Developer forum

Forum » Integration » Live integration performance issue - huge number of variants

Live integration performance issue - huge number of variants

Ricardo Pereira
Reply

Hi,

We are having an issue related to live integration when using combined products with a huge number of variants.
Basically on the product list we only show master products (no variants), however the live integration is getting the live data of all variants and this is causing performance issues. We have 20-30 variants per product and 12 products per page, so you can imagine how big is the request.
We can't disable the following option because we need that on the product page:


Does anyone know if it's possible to disable Live Integration only on the product list? Or maybe other solution for this issue?
We don't need to have live data on the product list because we're not showing prices or stock there.

Live Integration version: 6.0.11

BR,
Ricardo P.


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
Hi Ricardo, You can disable the Enable live prices checkbox for that. BR, Dmitrij
 
Ricardo Pereira
Reply

Hi Dmitriy,

Thank you for the quick answer.
I need live prices and live stock on the product detail page. If I disable the "Enable Live Prices" checkbox, won't that affect this?

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Hi Ricardo,

 

Then what you need it to:

  • "Enable Live Prices" = checked
  • "Lazy Load Product Info" = checked

 

Then in the product detail page you need to do an ajax call to either a feed page (or something that has a very small response size) with &getproductinfo=true and then update the product detail page.

 

The concept is that the request will not be going to the ERP until there is that additional parameter in the request. That way you can navigate the entire website without the overhead of the ERP connection.

 

That said, I know that Dmitriy just recently fixed a bug related to that, so you'll need the latest NuGet package for Live Integration, but until then you can develop the HTML and JS code for it.

 

Does that make sense?

Nuno

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Ricardo,
there are maybe a problem with updating a stock status too frequently for the variants from PIM, 
here is a draft Live integration version that is saving the variant stock only once, so you can try if it solves your issue.
BR, Dmitrij

 
Ricardo Pereira
Reply

Hi Nuno and Dmitriy,

Thank you for the help.

I updated the LI package to the latest version (to make sure all dependencies were updated as well) and then replaced the LI DLL with the one Dmitriy sent. But at the moment Live prices and stock are not being updated on the website. I can see the correct prices/stocks in the LI response (in the log file), but the website does not update the prices/stocks. This happens with and without the "Lazy Load Product Info".

Can you please advise?

 

BR,
Ricardo

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Hi Ricardo,

 

Do you have a URL I can take a look at?

 

You should be making an ajax request for the PDP with &getproductinfo=true. And then taking the response to update the PDP markup.

 

Best Regards,

Nuno

 
Ricardo Pereira
Reply

Hi Nuno,

Can you share an email so I can send you the URL and other information you need for testing?

BR,
Ricardo

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Hi Ricardo,

 

Sure,  send it to nag[at]dynamicwebusa.com

 
Ricardo Pereira
Reply

Hi,

Comparing the response of both LI versions (5.0.5 and 6.2.3), there are some differences.

LI 5.0.5

LI 6.2.3

Looks like variant ID is empty.

We are using the combined products - the Master product is created in DW and all variants come from BC integration.
That said, we checked the "Use product number in price calculation" so that we can match products/variants by product number.

It was working with LI 5.0.5, but with the new version, product price and stock are not being updated after the LI response.

Dmitriy, have you tested with combined products?

 

BR,
Ricardo

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Ricardo,
Yes, there was a bug with variants. Can you try with this version? If that doesn't help can you explain your steps of how have you created the master product and its variants with more details?
What products/variants were imported and then how they were combined? Maybe add some screens from Ecom/Pim and EcomProducts database table screen.
You can send those to me at: dbe@dynamicweb-cms.com
Thx
BR, Dmitrij

 
Ricardo Pereira
Reply

Hi,

Thank you Dmitriy.

Live prices are working well with this new version, however the "Lazy load product info" is not. Even though the "Lazy load product info" option is checked (and the &getproductinfo=true is not in the url), the LI is making the request and the price is updating.

I have both options checked:

 

BR,
Ricardo

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Ricardo,
sorry for that , the problem was that I sent you a wrong version from the local branch that didn't include the last changes for fixing the problem with getProductInfo=true that
were in the other brach.
Could you try with this version?
Thx
BR, Dmitrij

Votes for this answer: 1
 
Ricardo Pereira
Reply

Hi Dmitriy,

It's working like a charm :)
Thank you for all the help!

BR,
Ricardo

 

You must be logged in to post in the forum