Bulk importing shipping rates from a spreadsheet

[GymJam]

Hi everyone,

I was wondering if I could kindly get some assitance on a problem I'm having.

I am working with a company who are going to deal with shipping and returns of our products worldwide, once we launch our website in the next couple of months.

They have provided us with an excel spreadsheet containing prices for every country. The prices are based on weights, so each 0.25kg step we have a price for each country. I will attach a screenshot of what we're working with below.

I would like to bulk import this into my Shopify website, so for each country on the spreadsheet, I would like to create a shipping zone and add both 'Standard - Tracked' and 'Standard - Untracked' options, with each of the weight-based prices. There's a lot of data.

Because we have quite a large amout of data, manually, would take weeks! I was hoping to use the admin/shipping_zones.json but they only support the GET request 😞

And because a range of couriers are being used, the Carrier-calculated shipping solution would not help us in this case.

Does anybody have any suggestions for this? 

Much appreciated

[GymJam]

I wrote a program which handled this for me. If you are in need of this please feel free to message me.

[defang_yang]

I have been looking for such program for many days.

I need this program. can you send email to yangdefang <<at>> gmail.com  ?

[Matias_Jara]

Hello 
I also need that program. If you could send it to me it would be great! matiasjara <<at>> gmail.com

thank you!!

[covpolo10]

Hi

I also need this, please could you send to sales<at>waterpoloshop.com

many thanks

[Scott_Yu]

Hi GymJam,

Could you also be so kind and share this program with me? My email is hello@cosmicbits.com.

Thanks!

[Jamie_D_]

I would highly suggest using the CarrierService API to return rates rather than importing rates from a CSV file.

https://help.shopify.com/api/reference/carrierservice

[Dekoera_Info]

Dear GymJam,

I have been looking around for a way to bulk import shipping rates. Could you please sent the program to my email? john<at>krisstech.com

Thank you very much in advance!

[Chris57]

Hi GymJam,

I've the exact same problem. Would very much appreciate if you could forward your program on to: chris [at] kinokostore [dot] com

Thanks in advance!

Chris

[Hot_Machiato]

Hi, 

I saw your posting and am also in need of the program. Pleas reply to carl AT gadener DOT net

Thanks,

Carl

[KENNETH_WAN]

May I try your program? as I have more than 500 entries for shipping method, thanks.

[John_Delk]

I have a spreadsheet to import as well. May I try this as well?

I'm shocked that one of the most complicated tasks to perform does not have a better solution within the Shopify standard options. adding rate one at a time just seems archaic.

Thanks

kledanhoj@gmail.com

[GymJam]

Apologies all, have only just seen this. Have emailed the above to follow up if you still require assistance with this. Cheers.

[Vicarious_Media]

Hey GymJam, if you would be able to send me the script that would help me out a bunch! Thanks! ask <<at>> vicariousbooks [dot] co [dot] uk

[Aaron_Tremblay]

@gymjam I'm looking for a program just like this, if you're still willing to share, please email aaron at magnetmod.com

Thank you!

[Friends_Fan_Sho]

Hi Gymjam,

I would love to get this from you as well! friendsfanshop@gmail.com

Thanks so much! 

[miloman18]

wow this is worth a try, would really like to try this program, send to me also please. Email address: me (at) samuelsabandar (dot) com

[AhsanKamal]

Hello GymJam,

Looks like this is exactly what I am looking for for my store. I have almost 500 shipping rules which I would love to bulk import by someway. It would take me ages to configure those rules individually. 

Would you be kind enough to share your program with me? My email is ahsan@s82s.com

Thanks.

[Leigh]

Hello GymJam,

With over 600 shipping rates to input, this is exactly what I have been looking for!  Could you please send your program to me - leigh@tdog-digital.co.uk

Thank you!

[Kah_Hwee_Tan]

Hi,

Can I have this program too as I have a few hundred entries to enter? My email is jia@snacksies.com Thanks!