osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

EMS Shipping covering all weights

This is a discussion on EMS Shipping covering all weights within the Zone Rates forums, part of the Shipping Modules category; Hi, I know there have been numerous threads about shipping and weights (particularly in oscommerce) but trying to find a ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Features Discussion > Shipping Modules > Zone Rates

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 07-17-2008, 04:50 AM
osCMax Testing Team
 
Join Date: Jul 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
ridexbuilder is on a distinguished road
Default EMS Shipping covering all weights

Hi,
I know there have been numerous threads about shipping and weights (particularly in oscommerce) but trying to find a specific answer has been elusive.
Time is of the essence for me, so getting something resolved quickly will be extremely useful.
EMS (Japan) has a vast range of weights/prices in their shipping rates, which are all required from 300g, all the way to 30Kg.
From what I've been able to find out so far, oscommerce (and derivatives) are unable to handle weights of less than 1 unit, for example 0.3, 0.5 etc. Weights under 1 are rounded up to a value of 1.
However working in grams (from 300g to 30,000g) makes the definition of the zones table too large (probably an excess of characters), filling the field.
My questions is:
What is the preferred/recommended option to overcome this? Should I just modify the zones database table to accommodate a larger field?

Thanks upfront for any insight.
EJ
__________________
Server OS: Linux 2.6.24-19-generic
Database: MySQL 5.0.51a-3ubuntu5.1
HTTP Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with Suhosin-Patch
PHP Version: 5.2.4-2ubuntu5.2 (Zend: 2.2.0)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 07-17-2008, 08:43 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,331
Thanks: 68
Thanked 323 Times in 306 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: EMS Shipping covering all weights

Yes, that sounds like it would be the simplest method to resolve your issue. Check to see what the current field size is and then increase it accordingly.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to michael_s For This Useful Post:
ridexbuilder (07-17-2008)
  #3  
Old 07-17-2008, 05:10 PM
osCMax Testing Team
 
Join Date: Jul 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
ridexbuilder is on a distinguished road
Default Re: EMS Shipping covering all weights

Sorry, silly question (again):
What table in the database are the weight values held in? There isn't one called shipping (too obvious, I guess).
Have looked in zones, geo_zones and zones_to_geozones with no luck.
The expression "Can't see the wood for the trees" springs to mind.
EJ
__________________
Server OS: Linux 2.6.24-19-generic
Database: MySQL 5.0.51a-3ubuntu5.1
HTTP Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with Suhosin-Patch
PHP Version: 5.2.4-2ubuntu5.2 (Zend: 2.2.0)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 07-17-2008, 06:13 PM
osCMax Testing Team
 
Join Date: Jul 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
ridexbuilder is on a distinguished road
Default Re: EMS Shipping covering all weights

Fortunately, with a lot of head scratching, I can now answer my own question.
The shipping table values are stored at the far end of the configuration table (along with stacks of other stuff) and is currently set as varchar(255). After consulting an online SQL definition of varchar, it's possible to raise this field to a max. value well in excess of what is required A semi-educated guess suggests that 640 characters should be sufficient to hold the EMS table but I'll update this post if more is needed (for the benefit of others).

EJ
__________________
Server OS: Linux 2.6.24-19-generic
Database: MySQL 5.0.51a-3ubuntu5.1
HTTP Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with Suhosin-Patch
PHP Version: 5.2.4-2ubuntu5.2 (Zend: 2.2.0)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 07-18-2008, 06:11 AM
osCMax Testing Team
 
Join Date: Jul 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
ridexbuilder is on a distinguished road
Default Re: EMS Shipping covering all weights

It seems as though varchar is restricted to 255 in MySQL (unlike others)
Switching the field to TEXT has resolved the field size issue and shipping weights are matched correctly to prices However, now the product weight maxes out at 999.99 - great! It's a shame the shipping zone doesn't see those two decimal places, and so, the saga continues...
__________________
Server OS: Linux 2.6.24-19-generic
Database: MySQL 5.0.51a-3ubuntu5.1
HTTP Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with Suhosin-Patch
PHP Version: 5.2.4-2ubuntu5.2 (Zend: 2.2.0)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 07-18-2008, 06:29 PM
osCMax Testing Team
 
Join Date: Jul 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 0
ridexbuilder is on a distinguished road
Default Re: EMS Shipping covering all weights

OK I had it with this train of thought - the modification of yet more fields smacks of using a sledgehammer to crack a nut!
This should be resolved MUCH easier by just removing the stupid rounding up of the weights. Trying to find a straight answer on this issue is however nigh on impossible. The zones table even suggests removing rounding in shipping.php, where there is no apparent code relating to rounding. 2 hours worth of web searching and still no further forward
I can see why people become frustrated....
__________________
Server OS: Linux 2.6.24-19-generic
Database: MySQL 5.0.51a-3ubuntu5.1
HTTP Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.2 with Suhosin-Patch
PHP Version: 5.2.4-2ubuntu5.2 (Zend: 2.2.0)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
ems shipping weights

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Confused and really need help with weights chrisbarbers Zone Rates 0 09-10-2007 03:44 AM
CttExpresso Internacional (EMS) michael_s New osCommerce Contributions 0 09-05-2007 10:13 AM
Common Carrier Shipping - Multiple Zones and Weights winerack osCMax v2 Features Discussion 2 06-29-2007 03:47 AM
Shipping weights KindsvaterFlat osCMax v1.7 Discussion 0 02-08-2005 05:09 PM
USPS shipping weights pahalik osCMax v1.7 General Mods Discussion 4 01-07-2005 01:39 PM


All times are GMT -8. The time now is 10:09 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax