Hello, curious — what is the maximum or recommende...
# suitecommerce
w
Hello, curious — what is the maximum or recommended number of items does a customer can put on their shopping cart? I understand there’s transaction line limitations, but it seems that the cart can only handle lesser than the Netsuite documented limitations? Currently, we have a B2B client with 177 cart items and returning a backend error: “Impossible to parse backend error - Response” . Any inputs is appreciated. Thank you all for taking time to read and answer.
s
There's no hard limit but there is a strong correlation between inability to checkout due to timeouts / performance problems once a customer exceeds 100 line items
w
Understood.. Is it worth while to file a support case to NetSuite to address this type of problem? These type of limits are sometimes hard to explain to clients especially when there are no documentation to support them. I got two of them now for B2B customer scenarios. 1. Shopping Cart Items (the issue above) 2. Loading 1K or 2K+ Invoices in My Account (List View) Thanks Steve (as always appreciate you)
s
We're well aware of the shopping cart size problem. I'm not sure what support will be able to tell you about that; general advice is to do things like turn off auto-apply promotions, reduce the number of fields in the relevant field sets and disable scriptable cart scripts -- but I'm not sure how viable that all is.
As for the invoice problem, that's a new one to me; I've not heard of that before. I would have imagined that the search function is limited to 1,000 results and it wouldn't return more results than that.
Can you give more details about that?
w
Basically, it's when a customer have like 2000+ open Invoice (that are valid), and they have to go to the Invoice List View at the My Account and with that # of open Invoices, it seems like NetSuite is having a hard time loading those transactions. Let me know if you need more details.
s
I'm just wondering if you can be more specific than "having a hard time". What actually happens?
w
I see.. sorry about that. 1. User logs in to their My Account. 2. Navigates to the Invoices. 3. This pages will display a blank page as it is loading ~2K+ Invoices, if I remember correctly after a while it will display the Chrome Kill alert cause the page is taking too long to respond with the request and user will not able to successfully load their Invoices.
s
So the page freezes. No timeout on the service call and no error message?
w
None, just freezes and chrome kill alert display and yes no alert/error message. We checked the Invoice at the backend and found that customer has that number of Invoices.
btw, I checked on this "Rreduce the number of fields in the relevant field sets and disable scriptable cart scripts". -- The client have the minimum cart fields on the field set. -- I don't think I can turn off the scriptable cart cause of Avalara, and just made sure other custom client scripts are not firing on Webtore context. -- We got another customer who have only ~120 shopping cart items and encountered the same cart problem.
s
Hmm, OK. Well I think they’ve hit a soft limit, I’m not sure what can be done. 2000 open invoices is a lot
w
From my experience with NetSuite SuiteCommerce clients (adapters) that have B2B offering, this number of Invoices is easily reached since Invoices are paid in Terms and are open for a while. .. and for the shopping cart issue as well, this other client sell shoes and they even only utilizes SCA for their B2B clients, and with one shoe model alone can have 10+ different sizes and widths and we installed the Grid Order Extension (by NetSuite) to add those shoes in the shopping cart.
s
I understand with the cart size limitations, but the invoicing one is new to me
w
Very common use case to be honest for B2B.. (Apologies for venting out here 😆). Hope with the availability of SuiteQL NetSuite can leverage this API to fix these volume issues, cause base from experience so far - using SuiteQL have a bit more performance boost that using the old-school reliable scripted saved search.
s
In the config record, what value do they have set for this?
w
let me check
for this shoe client it's 20 right now
curious, does this setting have an impact on the cart items on how NS pulls the data? Or this is more for the My Account List Views (ie. Orders, Invoices, Transactions?)
s
It has no effect on the cart
It is only used when the
suitescriptResultsPerPage
configuration property is queried
👍🏽 1
This is part of my confusion because I would expect paginated search results (such as transaction records) to not be slow regardless of their total number, as long as
suitescriptResultsPerPage
was a reasonably low number
w
I see.. yeah not sure... hope this is something at some point get a patch/lift. Thanks Steve for your time, much appreciated.
f
I recall this was fixed a couple of years ago, what SCA version is the customer using?
w
Which issue? Is it the Shopping Cart Items? 2021.2.3
f
no, sorry, the invoices one
w
We'll keep an eye then, since this is different client.. Thank you for your input.
f
shows up as fixed on 2020.2.4
❤️ 1
but the issue record shows as verified on february 2021
if they are on 21.2.3 they should have the fix
w
excellent. thank you! will keep an eye for customers with that number of Invoices. Appreciate it. Hopefully the Shopping Cart Items can be fixed soon! cheers!
👍🏻 1
s
Oh and btw, if you can't figure out the answer to this problem with the invoices, then please raise a case about it
👍🏽 1
w
thank you Flo & Steve for your help as always!