Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Complete UK Shipping Module Mow Available


markafcb

Recommended Posts

  • Replies 55
  • Created
  • Last Reply

Top Posters In This Topic

In the database there is a table called products and within this table there is a field called products_weight which has length values set to 5,2 which means it will only allow 5 digit numbers with 2 decimal places. So for example if you entered 1000 it would round it down to 999.99 or if you set it to 0.045 it would round it up to 0.04. By changing this value to 8,3 it will allow you to enter weights as either grams e.g 1Kg would be 1000 grams or as Kilograms e.g 60 grams is 0.060 kg.

 

Just remember that whatever units you use as your product weight must be reflected in the shipping table.

 

I hope this makes sense.

 

 

ALTER TABLE `products` change products_weight products_weight decimal(8,3) NOT NULL

Link to comment
Share on other sites

A fix for what, if you do it correctly it works

 

Anyone any ideas on how the new "size" pricing is going to work?

OK, but could someone please give me a hint as to why I'm getting the "Sorry, this shipping option is not available for this order" message even though I have things set up as suggested:

Set Country of Origin to United Kingdom

Set Postal Code to your postal code

set Enter the Maximum Package Weight you will ship to the maximum weight you will send (I set mine to 50000 grams)

Set Package Tare weight. to your average packaging weight (This is the weight of the actual box or packaging you use to send your item. Therefore if your item weighs 100grams and the box you send it in weighs 100grams then it will automatically add the weight of the packaging onto your item weight.)

Set Larger packages - percentage increase. (I set this to 0 as I found out that with larger weights it was adding on a percentage)

 

Thanks

Link to comment
Share on other sites

  • 3 weeks later...

Does anyone know the coding to hide the shipping option, if you are not in that country or if the mx. amount is reached, rather than show "not available", all I want is it not to be displayed if unavailable, I know this can be done with item rates but can this be done with zone rates.

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...