Forums / Addon Shipping Modules / Canada Post module

Canada Post module

Views: 188,608

Results 121 to 140 of 481
29 Oct 2010, 7:34 PM
#121
wbroadway avatar

wbroadway

New Zenner

Join Date:
Aug 2010
Posts:
3
Plugin Contributions:
0

Canada Post module

Ajeh:

Usually, if you are seeing the dropdown and the input box for the State/Provence ... then you are missing those two from your stylesheet.css in your template ...

I only have that extra box problem when I choose the

2= Display as Listing on Shopping Cart Page

option instead of the popup (1). It looks and works fine in the popup version though.

29 Oct 2010, 7:48 PM
#122
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Canada Post module

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Nov 2010, 3:17 AM
#123
djlqd avatar

djlqd

New Zenner

Join Date:
Dec 2008
Posts:
55
Plugin Contributions:
0

Re: Canada Post module

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

11 Nov 2010, 12:19 PM
#124
djlqd avatar

djlqd

New Zenner

Join Date:
Dec 2008
Posts:
55
Plugin Contributions:
0

Re: Canada Post module

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

7 Dec 2010, 6:10 PM
#125
batman42ca avatar

batman42ca

New Zenner

Join Date:
May 2010
Posts:
32
Plugin Contributions:
0

Re: Canada Post module

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.

1 Mar 2011, 1:03 AM
#126
babyluxe avatar

babyluxe

New Zenner

Join Date:
Feb 2011
Posts:
3
Plugin Contributions:
0

Re: Canada Post module

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!

1 Mar 2011, 2:03 AM
#127
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Canada Post module

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!

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Mar 2011, 2:26 AM
#128
babyluxe avatar

babyluxe

New Zenner

Join Date:
Feb 2011
Posts:
3
Plugin Contributions:
0

Re: Canada Post module

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!

11 Mar 2011, 7:39 PM
#129
laurahowes avatar

laurahowes

New Zenner

Join Date:
Jan 2008
Posts:
64
Plugin Contributions:
0

Re: Canada Post module

What file is it that controls Zen Cart's 'Duplicate Product' function?
Is it admin/includes/modules/copy_to_confirm.php ? I checked the file I have server side with the file in the mod package and they are identical...

After installing this module this function appears not to be working.

This is the error message I get:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '// CANADA POST changes below: 'kgs', ' at line 20
in:
[insert into products (products_type, products_quantity, products_model, products_image, products_price, products_virtual, products_date_added, products_date_available, products_weight, products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_price_sorter, master_categories_id ) values ('1', '3', '', '', '38.9500', '0', now(), '0001-01-01 00:00:00', '0.9', // CANADA POST changes below: 'kgs', 'cm', '32.00', '20.00', '8.00', '0', '0', '1', '3', '1', '1', '0', '0', '0', '0', '0', '1', '0', '0', '38.9500', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

11 Mar 2011, 8:13 PM
#130
laurahowes avatar

laurahowes

New Zenner

Join Date:
Jan 2008
Posts:
64
Plugin Contributions:
0

Re: Canada Post module

Forgot to add: fresh install of 1.3.9h
Installed a few other mods, but nothing else touches this file...
(Stock by Attributes, Image Handler2, Excel Populate, Admin Blue Styles)

15 Mar 2011, 6:18 AM
#131
fiks avatar

fiks

New Zenner

Join Date:
Mar 2011
Location:
Canada
Posts:
1
Plugin Contributions:
0

Re: Canada Post module

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 :smile:

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.

23 Mar 2011, 3:26 PM
#132
janissaire avatar

janissaire

Zen Follower

Join Date:
Sep 2008
Location:
Toronto, Ontario, Canada
Posts:
474
Plugin Contributions:
0

Re: Canada Post module

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?

After looking at computer code for a while - I think I'm going crazy but the voice in my head assures me that I'm not! http://www.jecphotography.com/mystore

25 Mar 2011, 2:01 PM
#133
janissaire avatar

janissaire

Zen Follower

Join Date:
Sep 2008
Location:
Toronto, Ontario, Canada
Posts:
474
Plugin Contributions:
0

Re: Canada Post module

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?

After looking at computer code for a while - I think I'm going crazy but the voice in my head assures me that I'm not! http://www.jecphotography.com/mystore

28 Mar 2011, 2:22 PM
#134
janissaire avatar

janissaire

Zen Follower

Join Date:
Sep 2008
Location:
Toronto, Ontario, Canada
Posts:
474
Plugin Contributions:
0

Re: Canada Post module

Bump plz :smile:

Does anyone have the answer as to why the Cda Post module is resetting the length, height, width back to 12x12x12?

The check boxes also will reset.

I am starting to think of uninstalling Cda Post and go with UPSXML instead - but I don't seee size dimensions there.

After looking at computer code for a while - I think I'm going crazy but the voice in my head assures me that I'm not! http://www.jecphotography.com/mystore

30 Mar 2011, 12:55 AM
#135
highlander avatar

highlander

Zen Follower

Join Date:
May 2007
Posts:
125
Plugin Contributions:
0

Re: Canada Post module

Does anyone know what the canadapostbak.php file is for?

30 Mar 2011, 3:14 AM
#136
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Canada Post module

I would expect that's a backup file that should have been deleted. It most certainly should not have kept a ".php" extension. Same goes with any payment or shipping module.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Mar 2011, 6:24 PM
#137
janissaire avatar

janissaire

Zen Follower

Join Date:
Sep 2008
Location:
Toronto, Ontario, Canada
Posts:
474
Plugin Contributions:
0

Re: Canada Post module

Ok - since there doesn't seem to be any answers to my posts in this thread...re 12x12x12

How do I remove Canada Post info from my products in the Catalogue? I have uninstalled it from admin.

After looking at computer code for a while - I think I'm going crazy but the voice in my head assures me that I'm not! http://www.jecphotography.com/mystore

2 Apr 2011, 2:32 AM
#138
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: Canada Post module

where are you putting the dimensions mentioned above ? are you talking about the CPC module?
I have issues with this as well and am trying to perfect it.
and it concerns lettermail.
the module is calculating costs correctly based on our price check with shipping to same destination on Ebay using CPC. however I can't get lettermail to display. and it doesn't display on Ebay either. Funny thing is I have zone rate enabled in the shipping module and the CPC shipping estimator produces a flat rate cost that seems to be correct . the client wants it to say lettermail to give customer a comfort level.
I will keep posting my findings ....

2 Apr 2011, 12:04 PM
#139
royal avatar

royal

Zen Follower

Join Date:
Jun 2008
Location:
Canada
Posts:
261
Plugin Contributions:
0

Re: Canada Post module

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?

Hello janissaire,

I'm sorry that Canada Post Module is not working for you. I had same problem at first. Then a check the files and notice that I mix up the 2 canadapost.php files. I upload All Files in the correct location and Then I was ready for business.

Pre-Owned Books and Second Hand Stuff: http://www.onlineyardsale.ca

2 Apr 2011, 12:08 PM
#140
royal avatar

royal

Zen Follower

Join Date:
Jun 2008
Location:
Canada
Posts:
261
Plugin Contributions:
0

Re: Canada Post module

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?

Helo janissaire,

If the quality of products goes above the letter dimensions or size it will give you the package rate.

Pre-Owned Books and Second Hand Stuff: http://www.onlineyardsale.ca