Bulk importing shipping rates from a spreadsheet

GymJam
Shopify Partner
8 0 17

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

 

Replies 79 (79)

GymJam
Shopify Partner
8 0 17

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

Anzimaty
Shopify Expert
13 0 1
Can you please send me the program for importing shipping rates. Please send it iman@katergi.com
xa3point10
Visitor
1 0 0

Hi GymJam,

 

By any chance could you share that with me as well please 🙂 

xa3point10(at)gmail

 

Thanks a bunch!

george__ms
Visitor
2 0 0

Hi GymJam,

 

Is it possible for you to share the program, it would help us save a lot of time. thank you!

george__ms
Visitor
2 0 0

George__ms [at] Hotmail [dot] com

samyzeze
Visitor
1 0 0

Hi GymJam,

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

Thanks in advance!

Samy

epsylontech
Visitor
2 0 0

Could you please share your program with me or email to ectindia.info@gmail.com

krumholz
Shopify Partner
6 0 1

Hey @GymJam, would you mind sharing this program with me, nick.krumholz@gmail.com

itspriyanka
Shopify Partner
39 0 5

Hi GymJam,

 

Can you mail me the code on priyanka@learnwise.in?

 

Thanks,

Priyanka

NBA2
Visitor
1 0 0

Hi GymJam,

 

could you please provide this program to us?

 

That would would be awsome!

 

nbaeck [at] gmail.com

 

Thank you!

Jamvies
Visitor
1 0 0
Hi GymJam,

I would be grateful if you could send the program please. Been looking for a solution to this for a while!

jamvies [at] gmail [dot] com
Arron_VZ
Visitor
1 0 0

Hi,

 

Would it be possible to get this program as well? arronvz @ gmail.com

 

Many thanks!

Eco8direct
Visitor
1 0 0
I’d love to get that program if you don’t mind sending it? My email is info@eco8direct
jupitorONmars
Visitor
3 0 0

Hi! Can you kindly send me the program to mo@dingbats-notebooks.com?

 

Would really appreciate it

Gerbs89
Visitor
1 0 0

Would you be able to pass on that script my way as well? 

 

davidrent89<<at>>gmail.com

 

Appreciate it greatly!! 

itspriyanka
Shopify Partner
39 0 5
Hi @Gerbs89,

I never really got that script myself!

-Priyanka
SarahJ22
Visitor
2 0 0

Hi GymJam

I've just found your post following a Google search as I have been wondering whether I can add shipping costs  by uploading a csv file from the many shipping spreadsheets I have created.  I have designed a silicone keyboard with sunken keys for people with cerebral palsy like myself, Parkinson's, etc or who have a visual impairment.

 

It is taking me an age to enter shipping costs and I find myself wishing that I could download what I have already entered, as a csv file, paste my prices in, and upload it.  Wouldn't that be so simple!  

 

If you could e-mail me your program, I would be extremely grateful.  

 

Thanks, Sarah 

website (at) lime-at (dot) com

 


@GymJam wrote:

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


0

rushi137
Tourist
4 0 1

Yes, I would like this program too.  please email me rushinarasimha137 @ gmail.com

Uros_Cadez
Visitor
1 0 0

Hello,

 

I also need that program. Could you please send it to me, that would be great! papesuzana <> gmail.com

 

Thank you!!

ShellyD
Visitor
1 0 0

Hello GymJam

Can I please have this program also?

Please send to: shelly@manufactoryapparel.com

Thank you!!!

Anyware_Web_Mar
Shopify Partner
5 0 3

Hi GymJam,

 

Not sure if you're watching this thread still but if you are I'd love to have a copy too please - over 600 rates to load. Please send to info <at> anyware.co.nz

Does it exist in a form that could be posted in this forum so you don't need to send it all the time?

 

Thanks so much,

Phil

Ecommerce Website Design | Wellington, New Zealand | https://anyware.co.nz/
Brynoss
Visitor
2 0 1

Hi I also need this if you could send me a copy to bryn at peatys.co.uk

 

Would be a good one to upload into the App marketplace for sure!

 

Thanks

KimJay
Visitor
1 0 1

Hello, are you able to send the program to kjeysman@gmail.com. I would really appreciate it!

RAEWebTeam
Visitor
1 0 1

Hi,

I've just looked through the forums for exactly this and have found nothing so far, would be great if you could send this to me at chris<<at>>ropeaccessequip<<dot>>com. If you can or if not then any help would be much appreciated.

 

Chris

AL_07
Visitor
1 0 0

Hello,

 

Also interested in this program as well. Can you please email to al AT theautolamps DOT com, thanks in advance!

ECLO
Visitor
1 0 0

Hello,

 

It looks like you have received many requests for this program, and I was wondering whether we might also be able to receive a copy? The email address is david.parra@eclo-store.com.au. That would be greatly appreciated!

 

Best regards,

David

Supremegamer
Visitor
1 0 0

Hello, are you able to send the program to calvin.supremefactory@gmail.com I would really appreciate it!

Casc1
Visitor
1 0 0

Hi GymJam,

It would be greatly appreciated if you could also share the script with me (simon@cascadic.com)

Agree with the comments that it would make a great app, I'm amazed Shopify doesn't have an inbuilt solution for this

Regards

Simon

mrice09
Visitor
1 0 0

Hello, are you able to send the program to ice@ever-pretty.ca I would really appreciate it!

thepacha
Tourist
8 0 2

did anybody ever got that script ?

WezTackville
Visitor
1 0 0

Hi

Hope your well?

You mention that you have created a program to bulk import shipping rates in to shopify.

Is there a chance that you can also send this to me.

My email is awais@tackville.co.uk

I look forward to receiving this if you still have it.

Thanks
Wez

Meshaal
Excursionist
21 0 3

Hello,

Could you please send the program for bulk import shipping rates to Fun.Cons@mssandp.com

YOUDA
Visitor
1 0 0

Hi Gym

Appreciate if you can share the program for importing the shipping rates with me youda.world@gmail.com

Thanks in advance

premiumapparell
Tourist
9 0 1

Hi Gym Jam!

Looks like your extremely popular! Should turn it into an app?

Anyway, are you able to email me as well? cam@premiumapparel.co.nz

Thanks mate!

Cam

Meshaal
Excursionist
21 0 3

Hi, 

Did you receive the program by email? If received, could you please forward it to me too at Fun.Cons@mssandp.com

gregmanic
Visitor
1 0 0

This could be a huge help...  could you send this program to me as well

 

My email is greg@manicmerch.com 

 

 

Thanks!

PascalR
Shopify Partner
39 0 6

Hi GymJam,

I would really appreciate if you could send this to me as well. My email is     pas.renaglia@gmail.com

Thanks so much!

Kind regards,

Pascal

Alaabi
Visitor
1 0 0

hi 

mikem31
Shopify Partner
10 0 9

has anyone received the program to import the shipping data in bulk from GymJam?

If yes, is anyone able to share it via DM?

That would be greatly appreciated.

thepacha
Tourist
8 0 2
Seems to me it never existed . This thread is going on for years . Best
PascalR
Shopify Partner
39 0 6
Hello never received anything
Regards
Brynoss
Visitor
2 0 1
No, as far as I can tell it was very early stages and there was no program
to do it. I signed up for it but the guy got in touch and expected me to
design his spreadsheet for him,
Gadi_Rosales
Shopify Partner
3 0 0

i would like to see it please

edutify
Visitor
3 0 0

Hi gymjam,
I came across this post just like many others who are looking for a solution to import shipping rates via csv. Appreciate if you could send a copy of your program to support@edutify.co ?
Thanks

ShahzadSalim
Visitor
1 0 0

Hello,

Can anyone send this program on shahzad.salim@gesolucions.com.   

Faith126_
Visitor
1 0 0

Hi GymJam,

 

Kindly, could you share that with me as well.

 

My email is faithkemboi126@gmail.com

 

Thanks a bunch!

defang_yang
Shopify Partner
1 0 0

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
Visitor
1 0 0

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

thank you!!

covpolo10
Tourist
13 0 1

Hi

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

many thanks