What's new in Customer Journeys?

Connect and learn more! ×
VB Excel add-in - Batch Upload Slow Performance issue with high volume order lines — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VB Excel add-in - Batch Upload Slow Performance issue with high volume order lines

Received Response
136
Views
9
Comments

Summary:

Slow performance using VB Excel bulk load lines for Order using FA order Lines API.

The requirement is to bulk create 500+ lines per Order. Only 1 order is allowed to be entered at a time with Form based layout.

The FA API in question is /salesOrdersForOrderHub/{salesOrdeNo}/child/lines

It is observed the add-in is unable to scale after a certain point (first 200+ lines created in 90 secs) and the performance starts to degrade to a slow crawl. The next 100+ records could take beyond 10 ,15 or more minutes.

Again this is well short of our 500 lines target. We have not been able to do 500 lines yet.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!