We are still working on automation. Everything is just about complete and ready to go with a couple of exceptions. One of those items is shipping quotes.
Does anyone have any experience with getting shipping quotes to automatically populate on estimates (or sales orders) from their shipping provider? We do not have a lot of experience with scripts in NetSuite, so we were hoping somebody here could point us down the right path.
Here is what we were thinking. When a sales estimate is created, a workflow would trigger to run a script. The script would pull the destination address as well as the shipping option (ground, freight, etc.) from the estimate. The shipping origin would have to be a static address for our production warehouse.
The script would then take that information and send it to our shipping provider via an API call. The quote would then get returned and the scipt would write the shipping quote to the estimate in NetSuite.
This is how we think it would work. What we are not sure about it:
#1: How do we get the estimate number into the script? When the workflow triggers, does it in some way give the estimate number to the script so it knows where to pull the data from?
#2: How would we go about writing the script? We know this is a large ask. We are not looking for somebody to write a script for us. We were just hoping to get some information to start us down the right path to get this wrote ourselves.
This is just how we are thinking this would have to work. If there are other options we could take to make this happen, we are open to any option. We just need to get this shipping quote option automated. Right now, we are able to manually add a quote by pressing a button. We need this to be automated so the sales rep does not have to remember to manually do it.