Hi All, how would you manage having different grou...
# general
n
Hi All, how would you manage having different groups of customers with the same ship to (instead of copy/paste de ship to address in each customer)? We ship our goods to different pick-up points. Thanks.
b
Hi Nairolf, I'm pretty new to this but a custom field (a check-box) indicating you the order is to be shipped to a pick-up point could be the criterion for entering a workflow, which then updates all the ship-to fields to your pick up point. If you set it to run only on record create (as opposed to view, edit) then it would still give you the option of manually changing it if the customer asked for another shipping address.
n
Hey @Brad Wentworth, sorry I forgot to mention, we have different pick-up points. I also thought about transfer orders to the pick up point and then the sales order from the pick up point, but it sounds heavy to manage ๐Ÿ˜ฎ
d
Are you trying to ship from multiple origins but to a single destination? Or multiple origins to multiple destinations?
And is this all one SO?
n
Hey @dps, I ship from one origin on different SO to different pick-up points which are regrouping different customers/end-users
b
Is there a logic to the pick-up points? I've used saved searches and workflows for some pretty complex if-here-use-this-ship method, if-there-use-that-ship-method, &c., down to the zip code level
d
Hmmm so are you shipping to a consolidator of some sorts and do you need to track final mile?
b
The easiest way to do that would probably be to have several separate saved searches and workflows that evaluate each sales order, and then changes the shipping address according to whatever criteria you have. If it's on the state or zip-code level it would be pretty easy. If there are other dynamics, like item size, cost, or seasonality, that gets harder
d
There are ways to ship a single SO from multiple origins to a single location (line item shipping), but it sounds like thatโ€™s not what youโ€™re looking to solve
n
@Brad Wentworth, I believe it would be a solution in that essence ๐Ÿ˜‰
@dps indeed, I would like to have the opposite ๐Ÿ™‚ No consolidator, just a pick-up point ๐Ÿ™‚
d
Are you shipping to a freight forwarder?
n
Nope @dps just a pick-up point ๐Ÿ™‚
Imagine that Amazon is sending all the goods for your first 3 digit zip codes to the local convenience store instead of sending to you directly. The convenience store does not do anything instead stocking. He believes than doing that you'll buy something from his place in the same time. (But you bought from Amazon, so you don't care about local businesses ๐Ÿ˜‰ Just kidding !)
d
Haha
Maybe Iโ€™m over simplifying but would that just be a classic b2b shipment as if you were a distributor l shipping to a retailer?
n
Hum not really because I am billing the final customer.
d
Oh I see. Not really sure man, I will follow this thread to see how you solve this.
๐Ÿ‘ 1
b
@Nairolf Here's the condition I have in a workflow for a similar issue: (State/Province = MB Or State/Province = NB Or State/Province = Manitoba Or State/Province = New Brunswick Or Zip contains P3E Or Zip contains P3C Or Zip contains J9B Or Zip contains P0H Or Zip contains L0R Or Country = United States) And (Payment Method != Credit Card Or Country = United States) And (Department (Main) = Operations Or Department (Main) Is Empty Or Country = United States) The Action on the workflow is to set shipvia field value to FedEx Ground, but in principle it could set the shipping address too. You can see I have a complex web of different provinces and postal codes (our Canadian equivalent to States and Zip Codes) and even payment methods. My experience is that once you are comfortable with the and/or logic (especially if you're OK with nested logic statements) it's doable.
n
Thx a lot @Brad Wentworth ๐Ÿ˜‰