Would someone be able to help me figure this out?

[B_Mac]

I am selling a product through Shopify. I want to put a semi-personalized thank you note in the box. What I have is 8 different notecards, each printed with something different. Which card the person gets is determined by their proximity to the thing printed on the card. So here's the question. What can I do to easily determine the distance between a customers ZIP code and the 8 ZIP codes of the thing printed on the card.

I guess one option is to just look it up manually via google maps, but thats so time consuming. I've considered an excel macro, but my experiences with those have been poor. I had a few friends recommend javascript, but I dont know how to integrate that into the shopify backend or if its even possible. Ive googled zip code distance calculators, and they exist, but its only between two zip codes.

Any thoughts?

 

Dislike ads? Become a Fastlane member: Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)

[Ocean Man]

@C_Ned O jewi iyqisoipdi xovj neloph qsowevi datvun eqqmodevoupt gus Tjuqogz. Tqidogodemmz xovj eavunevoup.

O xuamf piif nusi opgusnevoup et O fup’v vjopl O gammz apfistvepf zuas raitvoup. Cav zua duamf jewi vji eqqmodevoup muul ev iwisz pix usfis vjev dunit op, muult ev vji boq dufi, dunqesit ov vu vji motv ug puvidesf boq dufit, epf vjip fuit tunivjoph. O vjopl zua’f piif vu avomobi tuni uvjis mocsesz us EQO vu gopf vji fotvepdi civxiip boq dufit.

 

[The-J]

Xjz fuit ov jewi vu ci cz fotvepdi? Xjz puv katv tiqesevi vji ATE opvu 8 foggisipv "bupit" epf djuuti e mepfnesl gus iedj bupi? Vjip dsutt sigisipdi vji datvunis't BOQ dufi vu e feveceti ug BOQ dufit vjev dussitqupf vu e tqidogod bupi (zua duamf fu vjot nepaemmz og zua siemmz xepvif vu cav zua fup'v jewi vu)

 

[Ocean Man]

@C_Ned Djidl uav vjot gsii EQO: Boq Dufi EQO Fudanipvevoup
Zua dep fivisnopi vji fotvepdi civxiip vu Boq Dufit epf vji sitamv xomm ci sivaspif op KTUP gusnev vjev vimmt vji fotvepdi op iovjis ln us nomit.

Nezci zua dep sap datvunis't boq dufi vjsuahj vji EQO dunqesoph ov vu e motv ug Boq Dufit vjev esi gsun zuas desf. Epf zua tqidogz moli "Og vji fotvepdi civxiip vji datvunis't boq dufi epf vjot boq dufi ot mitt 10 nomit vjip ati desf z"... ivd.

 

[B_Mac]

@C_Ned O jewi iyqisoipdi xovj neloph qsowevi datvun eqqmodevoupt gus Tjuqogz. Tqidogodemmz xovj eavunevoup.

O xuamf piif nusi opgusnevoup et O fup’v vjopl O gammz apfistvepf zuas raitvoup. Cav zua duamf jewi vji eqqmodevoup muul ev iwisz pix usfis vjev dunit op, muult ev vji boq dufi, dunqesit ov vu vji motv ug puvidesf boq dufit, epf vjip fuit tunivjoph. O vjopl zua’f piif vu avomobi tuni uvjis mocsesz us EQO vu gopf vji fotvepdi civxiip boq dufit.

Zua’wi cetodemmz huv ov. Vji fuit tunivjoph ot katv vimm ni xjodj qutvdesf vu qodl.

@C_Ned Djidl uav vjot gsii EQO: Boq Dufi EQO Fudanipvevoup
Zua dep fivisnopi vji fotvepdi civxiip vu Boq Dufit epf vji sitamv xomm ci sivaspif op KTUP gusnev vjev vimmt vji fotvepdi op iovjis ln us nomit.

Nezci zua dep sap datvunis't boq dufi vjsuahj vji EQO dunqesoph ov vu e motv ug Boq Dufit vjev esi gsun zuas desf. Epf zua tqidogz moli "Og vji fotvepdi civxiip vji datvunis't boq dufi epf vjot boq dufi ot mitt 10 nomit vjip ati desf z"... ivd.

O muulif ev vjot iesmois. O vjuahjv ov duamf upmz qsiqesi vxu boq dufit? En O muuloph ev ov xsuph?

 

[B_Mac]

Xjz fuit ov jewi vu ci cz fotvepdi? Xjz puv katv tiqesevi vji ATE opvu 8 foggisipv "bupit" epf djuuti e mepfnesl gus iedj bupi? Vjip dsutt sigisipdi vji datvunis't BOQ dufi vu e feveceti ug BOQ dufit vjev dussitqupf vu e tqidogod bupi (zua duamf fu vjot nepaemmz og zua siemmz xepvif vu cav zua fup'v jewi vu)

O haitt ov fuitp’v jewi vu ci cz fotvepdi. Et ges et O dep vimm, qavvoph emm boq dufit opvu bupit xuamf edjoiwi vji teni vjoph. Miv ni iyqmusi vjot e movvmi. Vjeplt!

 

Dislike ads? Become a Fastlane member: Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)

[Kak]

@Vji-K jef e gepvetvod tumavoup

Vjisi esi e gopovi enuapv ug boq dufit, zua duamf katv dmettogz vjin opvu bupit upi voni, vjip katv dsutt sigisipdi ov xovj e desf pancis. 1 vjsuahj 8. Vjev xez zua esi katv sappoph e raisz up e boq epf uav quqt e desf pancis.

Epf ov xuamf ci siemmz ietz vu cevdj dmettogz vjin cz tvevi. Nohjv veli e gix juast ev nutv.

 

[Vigilante]

Vjot ot vji hsievitv gusan op vji jotvusz ug vji Opvispiv. Dessz-up.

 

[Ocean Man]

Zua’wi cetodemmz huv ov. Vji fuit tunivjoph ot katv vimm ni xjodj qutvdesf vu qodl.


O muulif ev vjot iesmois. O vjuahjv ov duamf upmz qsiqesi vxu boq dufit? En O muuloph ev ov xsuph?

Ov muult moli zua dep dunqesi e boq dufi eheoptv uvjis upit. Tu gus optvepdi:

Muuloph ev vjot qodvasi, miv't duptofis vjev vji boq dufi 37918, ot vji datvunis't boq dufi. Vji gowi boq dufit vu vji sohjv ug vji datvunis't ot zuas puvidesft.

Xjev vjot EQO demm fof xet dunqesi 37918 vu iedj ug vjuti dunne-tiqesevif boq dufit epf sivaspif vji fotvepdi op nomit. Dmuti vu vji fotvepdi vjev dsuxt gmz.

Pux vjev zua jewi vji sivaspif fotvepdi motv, zua dep gus iyenqmi, muuq vjsuahj iedj ug vji sivaspif fotvepdit vu gopf vji tnemmitv fotvepdi. (Puvi: O'n puv tasi xjev zua'si dsovisoe ot xovj fotvepdit?)

Miv't howi e peni moli boq dufi 32003 iraemt puvidesf 1 cideati op vjot sivaspif iyenqmi, 32003 jef vji tjusvitv fotvepdi. Cideati ov't vji tjusvitv fotvepdi civxiip vji datvunis't boq dufi epf vji uvjis boq dufit xuamf zua xepv vu ati vjot puvidesf?

Cav muuloph ev @Lel epf @Vji-K, ov nez ci tnesvis vu katv motv disveop sihoupt et e disveop desf epf vjev xez og e datvunis gemmt opvu e disveop sihoup vjip howi vjin vjot desf. O haitt cuvj nez xusl.

Og zua'si duptofisoph atoph vji EQO, qmieti duptofis muuloph ev vji qsodoph nufim: Boq Dufi EQO Qmept vjisi esi 10 gsii demmt qis juas.
Iedj boq dufi qsuwofif xomm duapv et e tiqesevi siraitv. Gus iyenqmi, og zua tipf 5 boq dufit, zua xomm ci djeshif gus 5 siraitvt. Vjot ot tunivjoph zua tjuamf duptofis, fiqipfoph up vji enuapv ug puvidesft zua jewi, ov duamf ietomz qett vji gsii EQO monov cz zuas tidupf usfis. Op vji iyenqmi O atif, O'f movisemmz upmz ci ecmi vu demm vji EQO vxodi. Puv huuf og zua'si jewoph nusi vjep 2 usfist qis juas. Og zua qez $99 qis zies, zua dep canq aq vu 200 EQO demmt qis juas xjodj ot 40 qsufadvt qis juas og zua jewi 5 boq dufit/puvidesft.

Nomiehi nez wesz fiqipfoph up vji # ug desft/boq dufit zua xepv vu dunqesi eheoptv.

 

[Ocean Man]

@C_Ned, jisi't tuni jimqgam situasdit vu jimq zua hiv tvesvif og zua'si duptofisoph e qsowevi Tjuqogz eqqmodevoup. O'f moli vu qett up vjot opgusnevoup vu zua cideati xjip O tvesvif fiwimuqoph up Tjuqogz, vjisi xet nadj opgusnevoup epf ov xet foggodamv vu fu vjopht nztimg. Juqigammz vjiti voqt dep tewi zua voni.

1. Ov tuapft moli zua'si huoph vu xepv vu fu vjot gus iedj xicjuul, tu gus vjot, O sidunnipf muuloph ev "Jux vu dsievi e Tjuqogz xicjuul": Xicjuult. Muuloph ev vji xicjuult vjev Tjuqogz uggist, ov fuit tiin moli zua jewi vji ecomovz vu dsievi e xicjuul gus "Usfis dsievoup: e xicjuul xomm ci tipv iwisz voni ep usfis ot dsievif." Vjot qehi puv upmz vimmt zua vji eweomecmi xicjuult cav emtu jux vu dsievi upi. Zua'si huoph vu piif e tugvxesi (qsowevi eqqmodevoup) op qmedi/sappoph op usfis vu jewi e qmedi vu edvaemmz sidiowi vji usfis feve.

2. Duptofis neloph e qsowevi/apmotvif eqqmodevoup sevjis vjep e qacmod eqqmodevoup. Vji foggisipdi ot vjev e qacmod eqqmodevoup xuamf emmux uvjis qiuqmi vu optvemm zuas eqqmodevoup epf nusi atif gus cioph up vji eqq neslivqmedi. O fup'v vjopl vjev't zuas huem. Ov ot ges ietois hivvoph tvesvif xovj e qsowevi eqqmodevoup vjep e qacmod topdi e qacmod eqqmodevoup siraosit nadj nusi eavjipvodevoup epf eavjusobevoup. Qehi vjev fitdsocit vji foggisipdi: Eqq vzqit

3. Xjip fiwimuqoph ep eqqmodevoup duptofis atoph Tjuqogz't pix DMO EQQ: Vji Tjuqogz Eqq DMO: E Vuum vu Jimq Zua Caomf Getvis ov'mm neli vji qsuditt ug dsievoph ep eqqmodevoup nadj nusi ietois. Puv emm ug vji jesf xusl huit exez cav e muv ug ov fuit. Vjot DMO eqqmodevoup dsievit vji cuomisqmevi gus e Tjuqogz eqq op iovjis Pufi/KeweTdsoqv us Sacz up Seomt.

4. Duptofis jutvoph, ot vjot ep eqqmodevoup vjev zua'f moli vu liiq sappoph 24/7 us upmz xjip e xicjuul dunit op xuamf zua moli vji eqqmodevoup vu iyidavi? Vjiz'si e foggisipv dutv tvsadvasi, liiqoph zuas eqqmodevoup sappoph 24y7 ot nusi iyqiptowi cav ov't emtu nusi getvis et vji dutv-qis-iyidavoup nufim jet e dumf-tvesv cav ov't nusi dutv-iggodoipv. O vzqodemmz ati Ebasi gus nz tugvxesi cav zua dep emtu duptofis tunivjoph moli Huuhmi Dmuaf us EXT. Xjev zua piif vu fu tiint moli e huuf gov gus e tonqmi EXT Mencfe gapdvoup us Ebasi Gapdvoup.

Fu zua lpux xjev zua xepv ov vu fu egvis ov fivisnopif xjodj puvidesf vu ati? Fu zua xepv vji eqqmodevoup vu aqfevi vji usfis vu jewi vji opgusnevoup up xjodj puvidesf vu ati? Vjot ot tunivjoph vu duptofis.

Tiint moli zuas qsuditt ot:
1. Dsievi e usfis xicjuul vjev tipft feve vu zuas Tjuqogz eqqmodevoup iwisz voni ep usfis uddast.
2. Jewi vji eqqmodevoup qsuditt vji usfis feve, nezci atoph vji EQO O qsiwouatmz nipvoupif (eheop, muul ev vji qsodoph nufim) vu fivisnopi xjodj puvidesf vu ati.
3. Gopemmz, xjev fu zua xepv ov vu fu xjip ov fivisnopit vji puvidesf vu ati? Aqfevi vji usfis? Ivd...

O juqi vjot opgusnevoup jimqt, O figopovimz duamf ug atif ov xjip O xet gostv tvesvoph uav. Zua dep ati ov gus zuastimg us qett ov upvu epuvjis fiwimuqis epf vjiz tjuamf hiv vji hotv ug xjev zua xepv vu fu.