Amazon Shipping Method based on weight

Printer-friendly version    Send to friend    1 reply
Andrew Bent
User offline. Last seen 3 weeks 3 days ago.

Is there a way for us to adjust the shipping method for Amazon orders after orders are imported into ChannelAdvisor?  We have a lot of different item types right now, with various different shipping requirements, and it would be nice if there were some way for ChannelAdvisor to look at the weight of an item and change the shipping method automatically from Amazon Standard to USPS First Class, USPS Priority or FedEx Ground based on the weight.  Right now, every single order is coming into our label software the same way, as Amazon Standard, and we have to individually adjust the shipping method based on the weight of the item there, and it would be much more convenient if we could find a way to do it in advance in CA.

0
Your rating: None
Peter Kinnally
User offline. Last seen 2 hours 29 min ago.
RE: Amazon Shipping Method based on weight

Does you shipping software export the ship weight? If it does not right now, then can you make it (i.e. UPS WorldShip has the capability but we do not currently utilize that piece of data)? If so, you should be able to run some formulas in excel to alter the data and upload the correct information.

Currently, we use UPS WorldShip and Endicia's Dazzle for our shipping exports. We customized our UPS outputs to match the formats that we upload into CA. With the Dazzle (USPS) file, we cross reference the shipping class with what we have in a table to match what is needed for CA. I've set it up so that my shipping staff can run an excel macro to import, alter and extract all the info onto 1 sheet in excel. Then all they have to do is save it as a text tab delimited file.

I'm no programmer, so there is probably a cleaner and simpler way. But this way has worked for us for a couple years now (small tweaks now and then when there is a system change in excel or CA).

You may also be able to alter your Amazon feeds inventory-level shipping override options. The output for an order with the ship override options may or may not give you the output you're looking for. Honestly, it's probably a little riskier to do this.

Good Luck!!

Peter K