During busy season, we are receiving 10k/hour thro...
# generals
Simon
02/12/2021, 4:54 PMDuring busy season, we are receiving 10k/hour through EDI. EDI send Netsuite the orders. Unfortunately Netsuite is not fast enough to create the orders. I decided to use Map Reduced, but still, too slow. Is there's a "trick" we don't know ? Celigo ?
k
KevinJ of Kansas
02/12/2021, 4:56 PMI'm sorry - receiving 10k what through edi?
KevinJ of Kansas
02/12/2021, 4:56 PMDollars? Lines? Qty? Orders?
s
Simon
02/12/2021, 4:57 PM10k orders a day, with an average of 5 lines per orders
Simon
02/12/2021, 4:57 PM10k orders an hour, with an average of 5 lines per order
k
KevinJ of Kansas
02/12/2021, 4:58 PMMan, I can't imagine any EDI keeping up with that.
KevinJ of Kansas
02/12/2021, 4:58 PMHave you looked at SuiteCloud + to give you more bandwidth on the scripting side?
s
Simon
02/12/2021, 4:58 PMNot yet
Simon
02/12/2021, 5:00 PMour edi is "dummy". it just receive the orders and the orders are send to SQL Server, which call a Json for each order... Of course we are changing that but our concern is in Netsuite, will it ever be possible to create 10k SO an hour ?
k
KevinJ of Kansas
02/12/2021, 5:00 PMAlso, I'd be concerned on whether NetSuite is a good fit at that kind of volume.
KevinJ of Kansas
02/12/2021, 5:01 PMSending it to your SQL server as a stage as opposed to using an EDI provider for the direct link is probably a saving grace there.
s
Simon
02/12/2021, 5:01 PMIt;s like that for 3 weeks. The rest of the year it's about 300/hr
k
KevinJ of Kansas
02/12/2021, 5:01 PMI'd look really hard at Celigo/Boomi for integrating to your SQL server.
KevinJ of Kansas
02/12/2021, 5:03 PM10k an hour is manageable with one of those - the problem with a lot of EDI tools is they are doing a whole bunch of malarkey to force the order to go in via script.
s
Simon
02/12/2021, 5:03 PMwe are phasing out SQL Server. EDI can create a json. It will send the json to Netsuite and we will save it. Then a map reduce is creating the order
b
battk
02/12/2021, 5:09 PMhave you determined how long it takes for your account to create a sales order on average?
c
creece
02/12/2021, 5:14 PMThats what I'd do Simon if it can't keep up. I've done it in the past in some other scenarios. I had a "to-process" folder and a "processed" and just pick up the files, process and move. The issue I ran into is if there's an error somewhere, you have to account for either keeping it it and just re-processing or some error folder to look at later. The downside is you don't get immmediate feedback when creating all of the orders in the service. You'd just get back a "yep we got the text" or "no there's an error saving the text".
s
scottvonduhn
02/12/2021, 5:20 PMat 10k per hour, i’d also recommend at least a few SC+ licenses. Worth inquiring about to your account rep for a quote.
m
matt.graney
02/12/2021, 11:28 PMHey @Simon, I’m with Celigo and concur with @scottvonduhnand @KevinJ of Kansas. We should be able to handle it as fast as NetSuite can ingest it, and will queue it up if needed to allow NetSuite time to catch up, which is a middleware-based version of what @creecedescribed.. The key will be NS concurrency, and hence SC+ licenses. FWIW, we have customers doing similar volumes over the holidays.
3 Views