surfgatinho Posted July 25, 2006 Share Posted July 25, 2006 Anybody found a fix for this yet. I can't get anything except "Sorry, this shipping option is not available for this order" even after following the instructions above Quote Link to comment Share on other sites More sharing options...
daz_75 Posted July 26, 2006 Share Posted July 26, 2006 A fix for what, if you do it correctly it works  Anyone any ideas on how the new "size" pricing is going to work? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 26, 2006 Share Posted July 26, 2006 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 Quote Link to comment Share on other sites More sharing options...
surfgatinho Posted July 26, 2006 Share Posted July 26, 2006 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 KingdomSet 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 Quote Link to comment Share on other sites More sharing options...
surfgatinho Posted July 26, 2006 Share Posted July 26, 2006 OK, answered my own question. I needed to update the weights string thing Quote Link to comment Share on other sites More sharing options...
Guest Posted August 16, 2006 Share Posted August 16, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.