Does anyone have any input on how to default the n...
# manufacturing
v
Does anyone have any input on how to default the nearest location based on the Ship To address zip code ? We would also like to check inventory availability for the defaulting location
m
We had to do a custom solution for this. We took the first 3 digits of the zip code and weighted them by close, mid, far warehouses (we have 3). Then we did a custom script to find the closest one to route to. I think there's a NS solution for this, but it's a pay as you go based on volume/use. But it's been a few years, so I'm not sure.
v
Thanks Mark C, yeah they are still charging
@Mark C Curious to know how you all handle orders when the full inventory isn’t available at a single location. How do you default to multiple locations—possibly splitting the order between the two nearest ones—and how is this handled in the case of drop-ship items? Apologies if this scenario doesn’t apply to your business
m
We don't split orders automatically. We try very hard to keep inventory in all three warehouses, to avoid issues. The system looks for the closest warehouse that can fulfill the whole thing. If there isn't one, then it routes to an exception location where the warehouse teams can determine what to do manually. They can split orders that way.
l
@Mark C when splitting orders, do you literally create separate orders? Or just fulfill the same order in different locations?
m
The latter. We do location assignments at the line level on SO and then fulfill manually.
But it is a manual process, that fortunately doesn't happen that often.
s
Have you tried auto allocation? That’s standard NetSuite, I think it comes with advanced inventory
m
I do very similar things as Mark for multiple warehouses/stores. One issue is if one location cannot fulfill all. We don't want multiple lines for various reasons, and in that case I set to a default location. This is all done via suitescript. Not that difficult to write but the most annoying part was adding that ability for Kit items as well as some Location Priority logic.