Canada Post module

[Ajeh]

Do you have an URL to your site where we can actually see this?

[DJLQD]

I have downloaded zencart version 1.3.9h, and have installed Canada post shipping module 1.3.9f2.
I seem to have a problem. When I do an estimate for shipping it just gives me the store pickup option only.
Is there some extra configuring that needs to be done?

Any help would be greatly appreciated.

Thanks,
Les

[DJLQD]

And to be clear this is a new install, no other modules are in use.

[batman42ca]

Using Zen-cart 1.3.9h and Canada Post Shipping Module 1-3-9h lettermail, shipping rates did not work for me.

After reading all of the posts, trying everything suggested, staring at my product dimensions and configuration both in zen-cart and at Canada Post, I finally broke down and decided to debug the code. I had nowhere else to look.

I discovered this in includes/modules/shipping/canadapost.php:

    if ($this->lettermail_available && ($shipping_weight <= $this->lettermail_max_weight))
    {
      /* Select the correct rate table based on destination country */
      switch ($order->delivery['country']['iso_code_2'])
      {
        case 'CA':
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_CAN'));
            $lettermail_service = sprintf("Domestic Lettermail: estimated %d-%d business days", round($this->turnaround_time / 24 + 2), round($this->turnaround_time / 24 + 4)); //factor in turnaround time
            break;
          }
        case 'US':
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_USA'));
            $lettermail_service = "U.S.A Letter-post, up to 2 weeks";
            break;
          }
        default:
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_INTL')); //Use overseas rate if not Canada or US
            $lettermail_service = "INTL Letter-post, up to 2 weeks";
          }
      }

I don't think those preg_split calls will work properly unless they look like this:

    if ($this->lettermail_available && ($shipping_weight <= $this->lettermail_max_weight))
    {
      /* Select the correct rate table based on destination country */
      switch ($order->delivery['country']['iso_code_2'])
      {
        case 'CA':
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_CAN'));
            $lettermail_service = sprintf("Domestic Lettermail: estimated %d-%d business days", round($this->turnaround_time / 24 + 2), round($this->turnaround_time / 24 + 4)); //factor in turnaround time
            break;
          }
        case 'US':
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_USA'));
            $lettermail_service = "U.S.A Letter-post, up to 2 weeks";
            break;
          }
        default:
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_INTL')); //Use overseas rate if not Canada or US
            $lettermail_service = "INTL Letter-post, up to 2 weeks";
          }
      }

The regular expression "/"s are missing.

Or at least, that's what I had to change to finally get the
lettermail prices to work.

[Babyluxe]

Hello,

I'm using Zen Cart v1.3.9h and I installed the Canada Post Shipping Module. I've searched this forum for days and I've tried uninstalling and reinstalling but I still cannot get the module to update my product listings to allow me to input my product dimensions, which, of course, makes it extremely difficult to get an accurate quote. While I have seen that many people have encountered this error, I haven't yet found a solution. When I installed my SQLPatch, I got the following error message, which may have something to do with this issue:

Failed: 6
ERROR: Cannot ADD column products_weight_type because it already exists.
ERROR: Cannot ADD column products_dim_type because it already exists.
ERROR: Cannot ADD column products_length because it already exists.
ERROR: Cannot ADD column products_width because it already exists.
ERROR: Cannot ADD column products_height because it already exists.
ERROR: Cannot ADD column products_ready_to_ship because it already exists.
Note: 6 statements ignored. See "upgrade_exceptions" table for additional details.


Any help or tips to get in the right direction would be greatly appreciated!

Thank you!

[DrByte]

Hello,

I'm using Zen Cart v1.3.9h and I installed the Canada Post Shipping Module. I've searched this forum for days and I've tried uninstalling and reinstalling but I still cannot get the module to update my product listings to allow me to input my product dimensions, which, of course, makes it extremely difficult to get an accurate quote. While I have seen that many people have encountered this error, I haven't yet found a solution. When I installed my SQLPatch, I got the following error message, which may have something to do with this issue:

Failed: 6
ERROR: Cannot ADD column products_weight_type because it already exists.
ERROR: Cannot ADD column products_dim_type because it already exists.
ERROR: Cannot ADD column products_length because it already exists.
ERROR: Cannot ADD column products_width because it already exists.
ERROR: Cannot ADD column products_height because it already exists.
ERROR: Cannot ADD column products_ready_to_ship because it already exists.
Note: 6 statements ignored. See "upgrade_exceptions" table for additional details.


Any help or tips to get in the right direction would be greatly appreciated!

Thank you!

Those messages simply confirm that you've done the SQL updates step.
But if you're not seeing the fields for entering the dimensions in your admin, then that means you've not uploaded the updated PHP files to your server's admin folder structure according to the instructions.

[Babyluxe]

DrByte, thank you very much!

I uploaded the files in wrong folder, but now that I reinstalled them in the CORRECT folder, it gives me the option of entering dimensions.

Once again, thank you very much!

[Fiks]

wow batman, I just waisted HOURS trying to get the lettermail to work on a fresh install of both zencart and cp shipping module, after hours i removed everything and re-installed it to have the same result, and i spent so much time just changing the boxes in CP profil, then i red throught all of that thread to finally stumble on your post, made the change and everything is working great...

Thanks a lot

Using Zen-cart 1.3.9h and Canada Post Shipping Module 1-3-9h lettermail, shipping rates did not work for me.

After reading all of the posts, trying everything suggested, staring at my product dimensions and configuration both in zen-cart and at Canada Post, I finally broke down and decided to debug the code. I had nowhere else to look.

I discovered this in includes/modules/shipping/canadapost.php:

    if ($this->lettermail_available && ($shipping_weight <= $this->lettermail_max_weight))
    {
      /* Select the correct rate table based on destination country */
      switch ($order->delivery['country']['iso_code_2'])
      {
        case 'CA':
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_CAN'));
            $lettermail_service = sprintf("Domestic Lettermail: estimated %d-%d business days", round($this->turnaround_time / 24 + 2), round($this->turnaround_time / 24 + 4)); //factor in turnaround time
            break;
          }
        case 'US':
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_USA'));
            $lettermail_service = "U.S.A Letter-post, up to 2 weeks";
            break;
          }
        default:
          {
            $table_cost = preg_split("[:,]", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_INTL')); //Use overseas rate if not Canada or US
            $lettermail_service = "INTL Letter-post, up to 2 weeks";
          }
      }

I don't think those preg_split calls will work properly unless they look like this:

    if ($this->lettermail_available && ($shipping_weight <= $this->lettermail_max_weight))
    {
      /* Select the correct rate table based on destination country */
      switch ($order->delivery['country']['iso_code_2'])
      {
        case 'CA':
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_CAN'));
            $lettermail_service = sprintf("Domestic Lettermail: estimated %d-%d business days", round($this->turnaround_time / 24 + 2), round($this->turnaround_time / 24 + 4)); //factor in turnaround time
            break;
          }
        case 'US':
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_USA'));
            $lettermail_service = "U.S.A Letter-post, up to 2 weeks";
            break;
          }
        default:
          {
            $table_cost = preg_split("/[:,]/", constant('MODULE_SHIPPING_CANADAPOST_LETTERMAIL_INTL')); //Use overseas rate if not Canada or US
            $lettermail_service = "INTL Letter-post, up to 2 weeks";
          }
      }

The regular expression "/"s are missing.

Or at least, that's what I had to change to finally get the
lettermail prices to work.

[janissaire]

Ok - I put a post here because I wasn't sure If I was getting a conflict with ezPopulate:

http://www.zen-cart.com/forum/showthread.php?t=176918

but further research here shows that the issue might lie more with Cda Post shipping module than the EZpop one.

I read a couple of posts here (after the post above) but am unsure what the solution was here.

I have successfully mad my store using the EZpop and love it but I am being hit with the size dimension thing.

Product 1
Weight = 0.06 kgs
Length = 20 cm
Width = 16 cm
Height = 1 cm

Have tried checked and unchecked and hit save.

When I go back into it it says:
Product 1
Weight = 0.06 kgs
Length = 12 cm
Width = 12 cm
Height = 12 cm

Module is installed correctly and I have a Cda post ID as well.
Have set it to using their pricing.

Any ideas?

[janissaire]

I've currently got my module set to letter rates.

If the quality of products goes above the letter size does it then give me the package rate?