Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SHIPPING RATE FOR DIFFERENT COUNTRIES BASED ON WEIGHT


smokemake

Recommended Posts

Posted

Hi,

 

 

 

I need to set up a shipping rate somehow that offers this structure

 

under 1Kg free shipping US and canada flat rate for rest of the world

 

1KG TO 2KG FREE USA shipping flat rate Canada, flat rate rest of the world

 

2kg to 10 kg free shipping US and canada flat rate for rest of the world

 

 

10 KG OR MORE flat rate US SHIPPING, FREE SHIPPING CANADA, FLAT RATE REST OF THE WORLD

 

 

how can this be done?

 

 

I have tried to set the zone shipping but it will only have Zone 1 shipping, I am thinking I need to add multiple zones but I am not sure how I can add multiple zones to shipping module

 

Zone Based Rates

Enable Zones Method

True

 

Tax Class

GST/HST ON SHIPPING

 

Sort Order

1

 

Zone 1 Countries

CA, us

 

Zone 1 Shipping Table

3:8.50,7:10.50,99:20.00

 

Zone 1 Handling Fee

0

Posted

The MultiGeoZone MultiTable Shipping addon will do what you want. Remember that shipping tables start with the minimum weight for that price, not the maximum.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

The MultiGeoZone MultiTable Shipping addon will do what you want. Remember that shipping tables start with the minimum weight for that price, not the maximum.

 

Regards

Jim

 

ok so you are saying I can not do 2kg to 10 kg Free shipping then over 10 KG and under 1 kg not free shipping?

 

can I also add expedited shipping and express shipping to each level?

 

I am trying to install multi zone shipping but I am not sure which one is the latest one

Posted

No, I didn't say that. I said that the value used in the table is a minimum, so a table string of 3:8.50,7:10.50,99:20.00 will charge 8.50 for orders from 3 to 7 Kg and will not allow orders weighing less than 3 Kg to be shipped. You should start your table at a weight of 0 if you want to allow all orders.

 

Yes, the MZMT addon will allow multiple tables in each zone, so you can offer ground, expedited, and express shipping to each zone. Or whatever combination that you want.

 

The latest version is here. Please report if you have any problems with that one; I need to have more people test it before I upload it to the addons section.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

Actually, I am having problems. For someone reason, the language file isn't being recognized.

 

I have unistalled, instaled the file, removed and instaled the module again, but the error remains: 808684368165f3a415e360d5d6464a80

 

Is somebody else with the same issue?

Posted

The language file should be in catalog/includes/languages/english/modules/shipping/. If you have another language installed, copy that file to the same directory under your other language. You will need to translate the defines for each additional language.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

Hey Jim.

 

Thanks for the reply, but the file already was in the right place: 28f03f8e49df6f862477bc96f47a21da

 

I will try to remove and upload the files again in couple of minutes.

Posted

Oops, that's actually a bug. Find this code in the module file:

 

  $language_file = DIR_FS_CATALOG . DIR_WS_LANGUAGES . $language . '/modules/shipping/usps_codes.php';

 

and replace it with

 

  $language_file = DIR_FS_CATALOG . DIR_WS_LANGUAGES . $language . '/modules/shipping/mzmt.php';

 

Thanks for reporting that. I'll fix the upload in a minute.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

Give a bump here when you upload it, please. :)

 

I can't even find this code in the modules that I have downloaded o:)

 

$language_file = DIR_FS_CATALOG . DIR_WS_LANGUAGES . $language . '/modules/shipping/usps_codes.php';

Posted

The patched distribution package is here. You only need to upload the module file; the others are not changed.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

I just uploaded another patch to the same location. Please try this one and let me know if it works for you.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

I just uploaded another patch to the same location. Please try this one and let me know if it works for you.

 

Regards

Jim

 

 

thanks for the upload, I have been very busy, but I will try the link above by this weekend for sure, hopefully I can get it right this time.

Posted

What you want can be done with the Zones module. Uninstall it (in admin), open /includes/modules/shipping/zones.php, edit the "number" (easy to find) to the number of zones you need. Back to admin, install it, you now have the number of zones you asked for ready to fill in with your weight/price ratios.

Posted

I just uploaded another patch to the same location. Please try this one and let me know if it works for you.

 

The message error finally disappeared. :)

 

I will try the other steps during the rest of the day.

 

What you want can be done with the Zones module. Uninstall it (in admin), open /includes/modules/shipping/zones.php, edit the "number" (easy to find) to the number of zones you need. Back to admin, install it, you now have the number of zones you asked for ready to fill in with your weight/price ratios.

 

I meant to ask you about that possibility since a couple of days ago. Any idea of what possibility should be more simple?

Posted

The Zones module will allow you to have one table per zone. If you want multiple tables, for example to add ground, expedited, and express to one or more zones, then you need the MZMT module.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

The Zones module will allow you to have one table per zone. If you want multiple tables, for example to add ground, expedited, and express to one or more zones, then you need the MZMT module.

 

Regards

Jim

 

I am almost finishing configuring the zone rates module, but I also can see the advantages of your module, Jim.

 

Could you please do a final favor: can you post a screenshot with an correct fulfilled geo zone in the admin painel and as it is seen by the users at the shop?

Posted

Maybe later -- working with a client right now.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

I tried installing it and now I am getting this error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' at line 1

 

select gz.geo_zone_id from geo_zones gz left join zones_to_geo_zones ztgz on (gz.geo_zone_id = ztgz.geo_zone_id) where ztgz.zone_country_id = '0' and ztgz.zone_id = '0' and LOWER(gz.geo_zone_name) like shp%

 

 

 

I am not sure how to uninstall it and reinstall it now since when I click on shipping module this will come up

Posted

Hey Jim.

 

I didn't understood what's the correct location for the SQL files. Where do I put them?

 

I hope that will help me how to know how to add country to the new taxes zones that I have created and I see no option how to do it. :rolleyes:

Posted

It appears that your version of MySQL is being fussy about that code. Try this version. No need to uninstall, just replace the module you have with the one from this file.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...