Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

State Based Region Shipping Rates


billythekid

Recommended Posts

I am using the regions based mod for European counties.

I have disabled and enabled it a few times so I could change/test the number of

countries and the rates.

 

I am now unable to disable it, the remove button does not appear anymore and I cannot reload any changes i have made in the file.

 

does anyone know how to fix?

Link to comment
Share on other sites

I am using the regions based mod for European counties.

I have disabled and enabled it a few times so I could change/test the number of

countries and the rates.

 

I am now unable to disable it, the remove button does not appear anymore and I cannot reload any changes i have made in the file.

 

does anyone know how to fix?

 

hmmm, I would love to help you, but you are giving too little to go by. Are you getting any error or strange screens? Maybe you can post a screenshop here. Thanks!!!

Link to comment
Share on other sites

  • 2 weeks later...

I installed your contribution to the my Oscommerce instalation and I set up

7 regions and this was ok.

 

But when I make an order the Region Base Rate is not calculated in the

checkout_shipping.php and it say "The Shipping Rate can not be calculated at

 

this time" may you guide me about it?

 

by the way do you know if there is a City Base Rate contribution? or may you

 

guide me how change your php files to transform region base rate to city

base rate.

 

I appreciate any help. Muchas Gracias por la ayuda.

 

This is how I configured try to simulate a City Base Rate with your Region

Base Rate contribution:

 

Rates Based on Regions (group of States and/or Countries)

 

Enable US Regions Method

1

 

Sort Order

0

 

Handling Fee

0.00

 

Mode

weight

 

Tax Class

IVA

 

Region 1 States/Countries

Monclova,Monterrey,Nuevo Laredo,Reynosa,Saltillo

 

Region 1 Shipping Table

5:68,5.5:69.4,6:70.8,6.5:72.2,7:73.6,7.5:75,8:76.4,8.5:77.8,9:79.2,9.5:806,

10:82,10.5:83.4,11:84.8,11.5:86.2,12:87.6,12.5:89,13:90.4,13.5:91.8,14:932,

14.5:94.6,15:96,15.5:97.4,16:98.8,16.5:100.2,17:101.6,17.5:103,18:104.4,18.5

:105.8,19:107.2,19.5:108.6,

 

 

Region 2 States/Countries

Cd. Victoria,Matamoros,Piedras Negras,Torre?n

 

Region 2 Shipping Table

5:68,5.5:69.65,6:71.3,6.5:72.95,7:74.6,7.5:76.25,8:77.9,8.5:79.55,9:81.2,9.5

:82.85,10:84.5,10.5:86.15,11:87.8,11.5:89.45,12:91.1,12.5:92.75,13:94.4,13.5

:96.05,14:97.7,14.5:99.35,15:101,15.5:102.65,16:104.3,16.5:105.95,17:107.6,1

7.5:109.25,18:110.9,18.5:11

 

 

Region 3 States/Countries

Aguascalientes,Cd. Guzm?n,Cd.

Valles,Celaya,Chihuahua,Colima,Durango,Guadalajara,Irapuato,Le?n,Los

Mochis,Mazatl?n,M?xico

D.F,Morelia,Pachuca,Qu?retaro,Tampico,Tepatitl?n,Zacatecas,Zamora

 

Region 3 Shipping Table

5:68,5.5:70.45,6:72.9,6.5:75.35,7:77.8,7.5:80.25,8:82.7,8.5:85.15,9:87.6,9.5

:90.05,10:92.5,10.5:94.95,11:97.4,11.5:99.85,12:102.3,12.5:104.75,13:107.2,1

3.5:109.65,14:112.1,14.5:114.55,15:117,15.5:119.45,16:121.9,16.5:124.35,17:1

26.8,17.5:129.25,18:131.7,1

 

 

Region 4 States/Countries

Acapulco,Cd. Ju?rez,Cd.

Obreg?n,Chilpancingo,Coatzacoalcos,C?rdoba,Cuernavaca,Culiac?n,Jalapa,Manzan

illo,Oaxaca,Poza

Rica,Puebla,Puerto

Vallarta,Tehuac?n,Tepic,Tlaxcala,Toluca,Uruapan,Veracruz,Villahermosa

 

Region 4 Shipping Table

5:68,5.5:70.75,6:73.5,6.5:76.25,7:79,7.5:81.75,8:84.5,8.5:87.25,9:90,9.5:92.

75,10:95.5,10.5:98.25,11:101,11.5:103.75,12:106.5,12.5:109.25,13:112,13.5:11

4.75,14:117.5,14.5:120.25,15:123,15.5:125.75,16:128.5,16.5:131.25,17:134,17.

5:136.75,18:139.5,18.5:142.

 

 

Region 5 States/Countries

Campeche,Cd. Del Carmen,Hermosillo,M?rida,Mexicali,Tapachula,Tuxtla

Guti?rrez

 

Region 5 Shipping Table

5:68,5.5:71,6:74,6.5:77,7:80,7.5:83,8:86,8.5:89,9:92,9.5:95,10:98,10.5:101,1

1:104,11.5:107,12:110,12.5:113,13:116,13.5:119,14:122,14.5:125,15:128,15.5:1

31,16:134,16.5:137,17:140,17.5:143,18:146,18.5:149,19:152,19.5:155,20:158,20

5:161,21:164,21.5:167,22:1

 

 

Region 6 States/Countries

Canc?n,Chetumal,Ensenada,Tijuana

 

Region 6 Shipping Table

5:68,5.5:71.3,6:74.6,6.5:77.9,7:81.2,7.5:84.5,8:87.8,8.5:91.1,9:94.4,9.5:97.

7,10:101,10.5:104.3,11:107.6,11.5:110.9,12:114.2,12.5:117.5,13:120.8,13.5:12

4.1,14:127.4,14.5:130.7,15:134,15.5:137.3,16:140.6,16.5:143.9,17:147.2,175:

150.5,18:153.8,18.5:157.1,1

 

 

Region 7 States/Countries

La Paz

 

Region 7 Shipping Table

5:68,5.5:71.6,6:75.2,6.5:78.8,7:82.4,7.5:86,8:89.6,8.5:93.2,9:96.8,9.5:100.4

,10:104,10.5:107.6,11:111.2,11.5:114.8,12:118.4,12.5:122,13:125.6,13.5:129.2

,14:132.8,14.5:136.4,15:140,15.5:143.6,16:147.2,16.5:150.8,17:154.4,17.5:158

,18:161.6,18.5:165.2,19:168

Link to comment
Share on other sites

I installed your contribution to the my Oscommerce instalation and I set up

7 regions and this was ok.

 

But when I make an order the Region Base Rate is not calculated in the

checkout_shipping.php and it say "The Shipping Rate can not be calculated at

 

this time" may you guide me about it?

 

 

This is seems like you have another module misconfigured. This error is not being displayed but my Regions Based Rates shipping module. Maybe you have a UPS module installed and misconfigured.

 

I also see that your are entering city names in the zone fields. Because cities are not defined in the zones base, cities cannot be supported. You have to entere States and/or Countries.

Link to comment
Share on other sites

even though I input this cities in the Zones Table.

 

I don?t install any other shipping rate just the State Base Rateh

 

If you are familiar with the zone defining in the zone base, i don't see why it should not work. However, eveyhing must be done right.

 

As far as the "The Shipping Rate can not be calculated at this time" message. I really seems that you have another module enabled, but not configured. That error is not an output of the module, so either you have a misconfigured module or you have some corrution with your oscommerce installation.

Link to comment
Share on other sites

Hi I have a problem with Stated based rates, works fine for me for each region i have 8 regions. HOwever when i put more than 2 prices breaks by weight it doesn't work..

 

ALso if you put the first price break under 30 every item is billed under that weight.

 

For example i want to have

 

30:8.18,1000:20,5000:0

 

Doesn't seem to work.

 

Any ideas? The products that i sell have three weights thats it. First set at 1 are priced always at $9

 

Second set are 1000 weight and are dependant on the state. hence the reason for your contribution.

 

Third weight is $0 no free..

 

I dont care about the weights i just use them to disguish the three diffrent shipping types.

Link to comment
Share on other sites

Hi I have a problem with Stated based rates, works fine for me for each region i have 8 regions. HOwever when i put more than 2 prices breaks by weight it doesn't work..

 

ALso if you put the first price break under 30 every item is billed under that weight.

 

For example i want to have

 

30:8.18,1000:20,5000:0

 

Doesn't seem to work.

 

Any ideas? The products that i sell have three weights thats it. First set at 1 are priced always at $9

 

Second set are 1000 weight and are dependant on the state. hence the reason for your contribution.

 

Third weight is $0 no free..

 

I dont care about the weights i just use them to disguish the three diffrent shipping types.

 

I have a similar problem. If I set an item to 0 and the shipping set as follows 0:0.00 it allows me to have an auto download. If I have an item set 1 and the shipping as follows 1:10.00 it seem to get doubled to $20.00 and so on. If I set the item to 0.5 I get the correct shipping price. Could someone explain how the calculations work. I've looked everywhere for an explanation.

Thankyou

 

Trev

Edited by trevb54
Link to comment
Share on other sites

Make sure that everything is set correctly under "configuration/Shipping & Packaging/" make sure the following are set correctly:

Enter the Maximum Package Weight you will ship.....

Package Tare weight.....

Larger packages - percentage increase.....

 

It sounds like you have values entered here or at least the wrong values.

 

 

Also, i will no longer provide forum support for this or any of my contributions under this user name "billythekid", I will close this accout and strickly use my "nezah.net" account. I will still provide support and answer questions as best and often as i can, but only under username "nezah.net"

 

Jorge Suarez

Edited by billythekid
Link to comment
Share on other sites

This is seems like you have another module misconfigured.  This error is not being displayed but my Regions Based Rates shipping module.  Maybe you have a UPS module installed and misconfigured.

 

I also see that  your are entering city names in the zone fields.  Because cities are not defined in the zones base, cities cannot be supported.  You have to entere States and/or Countries.

Link to comment
Share on other sites

I change all the Zones to Mexican States but it still give me this message in the checkout_shipping.php. I desactivate all Shipping Method and I only leave the Region Based Rate Methods.

 

----------------------info display in the chechout_shipping.php-----

Shipping Method

This is currently the only shipping method available to use on this order.

 

Region Based Rates

The shipping rate cannot be determined at this time $0.00

 

---------------------------------------------------------------------------

 

My new configurations base on states is:

 

Rates Based on Regions (group of States and/or Countries)

 

Enable US Regions Method

1

 

Sort Order

0

 

Handling Fee

0.00

 

Mode

weight

 

Tax Class

IVA

 

Region 1 States/Countries

Nuevo Leon

 

Region 1 Shipping Table

5:68,5.5:69.4,6:70.8,6.5:72.2,7:73.6,7.5:75,8:76.4,8.5:77.8,9:79.2,9.5:80.6,10:8

2,10.5:83.4,11:84.8,11.5:86.2,12:87.6,12.5:89,13:90.4,13.5:91.8,14:93.2,14.5:94.6

,15:96,15.5:97.4,16:98.8,16.5:100.2,17:101.6,17.5:103,18:104.4,18.5:105.8,19:107.

2,19.5:108.6,

 

Region 2 States/Countries

Cohauila

 

Region 2 Shipping Table

5:68,5.5:69.65,6:71.3,6.5:72.95,7:74.6,7.5:76.25,8:77.9,8.5:79.55,9:81.2,9.5:82.

85,10:84.5,10.5:86.15,11:87.8,11.5:89.45,12:91.1,12.5:92.75,13:94.4,13.5:96.05,14

:97.7,14.5:99.35,15:101,15.5:102.65,16:104.3,16.5:105.95,17:107.6,17.5:109.25,18:

110.9,18.5:11

 

Region 3 States/Countries

Aguascalientes,Durango,Guanajuato,Hidalgo,M?xico D.F,Quer?taro,San Luis Potosi,Tamaulipas,Zacatecas

 

Region 3 Shipping Table

5:68,5.5:70.45,6:72.9,6.5:75.35,7:77.8,7.5:80.25,8:82.7,8.5:85.15,9:87.6,9.5:90.

05,10:92.5,10.5:94.95,11:97.4,11.5:99.85,12:102.3,12.5:104.75,13:107.2,13.5:109.6

5,14:112.1,14.5:114.55,15:117,15.5:119.45,16:121.9,16.5:124.35,17:126.8,17.5:129.

25,18:131.7,1

 

Region 4 States/Countries

Chihuahua,Colima,Estado de M?xico,Guerrero,Jalisco,Michoac?n,Morelos,Nayarit,Oaxaca,Puebla,Sinaloa,Sonora,T

abasco,Tlaxcala,Veracruz

 

Region 4 Shipping Table

5:68,5.5:70.75,6:73.5,6.5:76.25,7:79,7.5:81.75,8:84.5,8.5:87.25,9:90,9.5:92.75,1

0:95.5,10.5:98.25,11:101,11.5:103.75,12:106.5,12.5:109.25,13:112,13.5:114.75,14:1

17.5,14.5:120.25,15:123,15.5:125.75,16:128.5,16.5:131.25,17:134,17.5:136.75,18:13

9.5,18.5:142.

 

Region 5 States/Countries

Campeche,Chiapas,Sonora,Yucat?n

 

Region 5 Shipping Table

5:68,5.5:71,6:74,6.5:77,7:80,7.5:83,8:86,8.5:89,9:92,9.5:95,10:98,10.5:101,11:10

4,11.5:107,12:110,12.5:113,13:116,13.5:119,14:122,14.5:125,15:128,15.5:131,16:134

,16.5:137,17:140,17.5:143,18:146,18.5:149,19:152,19.5:155,20:158,20.5:161,21:164,

21.5:167,22:1

 

Region 6 States/Countries

Baja California Norte,Baja California Sur,Quintana Roo

 

Region 6 Shipping Table

5:68,5.5:71.3,6:74.6,6.5:77.9,7:81.2,7.5:84.5,8:87.8,8.5:91.1,9:94.4,9.5:97.7,10

:101,10.5:104.3,11:107.6,11.5:110.9,12:114.2,12.5:117.5,13:120.8,13.5:124.1,14:12

7.4,14.5:130.7,15:134,15.5:137.3,16:140.6,16.5:143.9,17:147.2,17.5:150.5,18:153.8

,18.5:157.1,1

 

Region 7 States/Countries

 

 

Region 7 Shipping Table

5:68,5.5:71.6,6:75.2,6.5:78.8,7:82.4,7.5:86,8:89.6,8.5:93.2,9:96.8,9.5:100.4,10:

104,10.5:107.6,11:111.2,11.5:114.8,12:118.4,12.5:122,13:125.6,13.5:129.2,14:132.8

,14.5:136.4,15:140,15.5:143.6,16:147.2,16.5:150.8,17:154.4,17.5:158,18:161.6,18.5

:165.2,19:168

 

 

Muchas Gracias

Link to comment
Share on other sites

I see you are adding cities and states combined. I also see that not all states are being entered correctly. You need to follow zone guidelines or your shopping cart will never work properly. I see right away that your first region shipping table has the city "Nuevo Leon" whic is a city, not a state. The state Guanajuato.

 

Remeber that you can only entered properly defined zones. Zones are defined in "Locations & Taxes/Zonez."

 

Have you even installed mexican zones to your shopping cart? If you haven't, absolutely nothing will work with shipping.

do a search for "medico zones" and install that.

 

Once you have that installed, you have to enter those Zones into the region shipping tables of the shipping module.

Link to comment
Share on other sites

I got and installed already the Mexico Zones that is on the Contibutions Comunity...

 

By the way, Nuevo Leon is a State. It is the State of Monterrey for example.

 

After I entered this Zones I went to the Shipping Module and I set up the Regios.

 

Do I need to configure the Tax Zones? Does it impact on this?

 

Do you have another idea what can happend?

 

Regards,

Link to comment
Share on other sites

Thanks for fixing my problem it was the settings in configuration/Shipping & Packaging/

 

However now when it has 0 for a $ amount. It says The shipping rate cannot be determined at this time Is it ok to change this message in the coding? When else does this message get used?

Link to comment
Share on other sites

I got and installed already the Mexico Zones that is on the Contibutions Comunity...

 

By the way, Nuevo Leon is a State. It is the State of Monterrey for example.

 

After I entered this Zones I went to the Shipping Module and I set up the Regios.

 

Do I need to configure the Tax Zones? Does it impact on this?

 

Do you have another idea what can happend?

 

Regards,

 

 

Sorry, i confused Nuevo Leon with Leon, which is in the state of Guanajuato.

 

Are you running MS2?

 

No, tax zones should not affect the shipping calculations.

 

Since you are basing rates on weight, do you have wight entered into the products details? If so, I think this problem is beyond the shipping module. There is a problem with your oscommerce installation.

Link to comment
Share on other sites

Yes, I?m running MS2.

 

I made some testing to tried to find the problem and sometimes it worked but another time didn?t.

 

I reinstall to 3 regions again because I set up to 7 regions.

 

I set a product weight to 25 pounds.

 

I erased the Region 1 Shipping Table and I made 5 test cases: I set "25:124" then I set "26:124" then I set "27:124" and they didn?t work until I set "30:124" then "40:124" and they worked. So 3 cases didn?t work and 2 cases work. I don?t know why.

 

Does the module support weight below the 30 pounds?

 

Regards,

Link to comment
Share on other sites

Yes, I?m running MS2.

 

I made some testing to tried to find the problem and sometimes it worked but another time didn?t.

 

I reinstall to 3 regions again because I set up to 7 regions.

 

I set a product weight to 25 pounds.

 

I erased the Region 1 Shipping Table and I made 5 test cases: I set "25:124" then I set "26:124" then I set "27:124" and they didn?t work until I set "30:124" then "40:124" and they worked. So 3 cases didn?t work and 2 cases work. I don?t know why.

 

Does the module support weight below the 30 pounds?

 

Regards,

 

Oh ok, the you have a misconfiguration in the shipping and packaging settings. Actually I answered this earlier.

 

Make sure that everything is set correctly under "configuration/Shipping & Packaging/" make sure the following are set correctly:

Enter the Maximum Package Weight you will ship.....

Package Tare weight.....

Larger packages - percentage increase.....

 

It sounds like you have values entered here or at least the wrong values.

 

Jorge Suarez

Link to comment
Share on other sites

I set the values on blank

 

And now always take the first value, what ever I set the system take the first one (example $50 in this case 24:50,24.5:55,25:60,26:70 even though the product weigth is 25)

 

Addicional in the top of the window now this message appear after I set the values on blank

 

 

Warning: Division by zero in /home/computer/www/www/catalog/includes/classes/shipping.php on line 61

 

Warning: Division by zero in /home/computer/www/www/catalog/includes/classes/shipping.php on line 62

 

Do you know why it is happening?

 

Regards,

Link to comment
Share on other sites

Hi.

Firstly thanks for this great contribution - works like a dream.

 

Have a few small issues:

1. How to change the display of weight rate in Kg instead of Pounds ( I am in the UK)

2. How to add a UK State ie Jersey into Zone 2 Rates?

3. why the conversion of KG into Pounds has a formuly of KG * 4 = pounds? (It should be KG*2.2=pounds)

 

Hope some one can help me on this and guide me a little.

Thanks!!

 

Kunal :thumbsup:

Can anyone help on this!

Kunal

Link to comment
Share on other sites

Can anyone help on this!

Kunal

 

 

There is few things you need to check. The items on your list are not controlled by the shipping module, but let me try to point you in the right directions.

 

Make sure that your "country or origin" is configured properly under "configuration/shipping & packaging"

 

Download and install the uk zones into your zonebase and make sure they list under "Locations & taxes/Zones"

 

Properly configure the "Localizations" section. And you might have to modify your language file a bit.

Link to comment
Share on other sites

It seems that there are a number of people requesting city based, or postcode based shipping.

 

Is there a way of having the customer make a selection themselves, rather than relying on existing fields? And have the shipping module base costs on their selection?

 

ie.

 

1. Set up an additional field titled "Shipping Zones", to which I could add "NSW Metro, NSW Regional, VIC Metro, VIC Regional" etc.

 

2. The customer when filling in their address or shipping opions, select the "Shipping Zone" from the list

 

3. In the admin, I would have built the relationship by using the module....

 

Region 1 States/Countries = NSW Metro

Region 1 Shipping Table = 600:8, 9999:0

 

Region 2 States/Countries = VIC Metro

Region 2 Shipping Table = 600:12, 9999:0

 

Region 3 States/Countries = NSW Regional, VIC Regional

Region 3 Shipping Table = 600:15, 9999:0

 

This way, anyone could easily modify it to their own needs, whether its states, postcodes, methods etc. It would also mean that spelling mistakes would be eliminated...

 

 

I've got no idea how to programme this myself... any ideas - or other contributions that do this?

 

Thanks! Tim

Link to comment
Share on other sites

It seems that there are a number of people requesting city based, or postcode based shipping.

 

Is there a way of having the customer make a selection themselves, rather than relying on existing fields? And have the shipping module base costs on their selection?

 

ie. 

 

1. Set up an additional field titled "Shipping Zones", to which I could add "NSW Metro, NSW Regional, VIC Metro, VIC Regional" etc.

 

2. The customer when filling in their address or shipping opions, select the "Shipping Zone" from the list

 

3. In the admin, I would have built the relationship by using the module....

 

Region 1 States/Countries = NSW Metro

Region 1 Shipping Table = 600:8, 9999:0

 

Region 2 States/Countries = VIC Metro

Region 2 Shipping Table = 600:12, 9999:0

 

Region 3 States/Countries = NSW Regional, VIC Regional

Region 3 Shipping Table = 600:15, 9999:0

 

This way, anyone could easily modify it to their own needs, whether its states, postcodes, methods etc.  It would also mean that spelling mistakes would be eliminated...

I've got no idea how to programme this myself...  any ideas - or other contributions that do this?

 

Thanks!  Tim

 

I have been tempted to do this, but i think i will wait till ms3 comes out. If i were to do this now, the contribution will be useless once ms3 comes out. So, lets wait. I will also add other capabilites such the ability to chose different methods (eg, air, ground, and so on).

 

Jorge Suarez

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...