Canada Post mod and dimensions, please help

[pcpowercan]

Greetings fellows,

 

I installed the new version of CP mod and I figured that it doesn't support product's dimension. I have looked at the OSC forum, speciffically the one at:

 

http://www.oscommerce.com/forums/viewtopic.php...p?p=81847#81847

 

and did excatly as written , but my entire CP mod kept crashing after the changes, and right now I'm having the error message:

 

"An error occured with the canadapost shipping calculations.

If you prefer to use canadapost as your shipping method, please contact the store owner."

 

Although, I updated my database using the code :

 

ALTER TABLE products ADD products_dim_type ENUM('cm','in') NOT NULL,

ADD products_length DECIMAL(6,2) DEFAULT '30' NOT NULL,

ADD products_width DECIMAL(6,2) DEFAULT '30' NOT NULL,

ADD products_height DECIMAL(6,2) DEFAULT '30' NOT NULL;

 

The mod was working fine before the changes, but I need to get accurate results from CP server by adding the product's dimension (not only weight).

 

I have contacted CP sell online help desk, and they responded to me as follows:

 

"I have looked over different possibilities and it not feasible not to enter

the dimensions and receive an accurate shipping cost. Another

possibility is to set up the option to ship items as is and not package them in

predefined boxes."

 

Since some of you are familiar with CP mod, could you please tell me what to do? I spent an entire week to figure this issue. I modified the admin part to accept dimensions, pass them to the shopping cart (plus weight), update CP mod to retreive dimension from products table in the database, but nothing works so far.

 

Thanks in advance.

[pcpowercan]

This might not be relevant, but thought you might have an idea:

 

I modified the weight of one product from 1 KG till 30 KG, and this is what I got at Canada Post server ( no dimensions yet):

 

1 KG --> 13 KG at Canada Post

10 KG --> 13 KG at Canada Post

20 KG --> 23 KG at Canada Post

25 KG --> 28 KG at Canada Post

27 KG --> 30 KG at Canada Post

.

.

30 KG --> error at Canada Post

 

As you can see, product's weight get incremented due to CP server calculations for the best fit pracel box (implies extra weight).

That's why CP sell on-line insists on having product's dimension parameters get passed through the shipping calculation.

Without fixing this bug customers will be over charged.

Anyone can help.... :!: