Zen Cart Logo

Table Rate Question

Locked

Views: 1,763

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
16 Nov 2009, 6:11 AM
#1
cameo avatar

cameo

Zen Follower

Join Date:
Nov 2009
Location:
Ohio
Posts:
100
Plugin Contributions:
0

Table Rate Question

Hello again!

If I wanted to use the below Table Rate for:

United States Shipping Rates
$0.00 to $24.99 ---> $8.50
$25.00 to $49.99 ---> $14.50
$50.00 to $99.99 ---> $19.50
$100.00 and above ---> $25.00

Canada Shipping Rates
$0.00 to $24.99 ---> $13.50
$25.00 to $49.99 ---> $19.50
$50.00 to $99.99 ---> $24.50
$100.00 and above ---> $29.00

Worldwide Shipping Rates
$0.00 to $24.99 ---> $18.50
$25.00 to $49.99 ---> $24.50
$50.00 to $99.99 ---> $29.50
$100.00 and above ---> $35.00

How would I set the Shipping Table up? Would it go something like the below for United States Shipping Rates:

24.99:8.50,49.99:14.50,99.99:19.50,100:25.00

But then where would I enter the Canada & Worldwide Shipping Rates at?

Thanks,
cameo

16 Nov 2009, 3:06 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

Instead, use the Zone Rate zones shipping module and set the first zone for the US and the second zone for CA and the third Zone for 00 (that is two zeros) to mean everyone else not otherwise defined ...

17 Nov 2009, 4:05 AM
#3
cameo avatar

cameo

Zen Follower

Join Date:
Nov 2009
Location:
Ohio
Posts:
100
Plugin Contributions:
0

Re: Table Rate Question

Ajeh:

Instead, use the Zone Rate zones shipping module and set the first zone for the US and the second zone for CA and the third Zone for 00 (that is two zeros) to mean everyone else not otherwise defined ...

Hi Linda,

Thank you very much for your reply! Ok, I did what you said above, and the below is how I entered it in the zone rate shipping module. Did I do it right?

Zone 1 Countries
US

Zone 1 Shipping Table
24.99:8.50,49.99:14.50,99.99:19.50,100:25.00

Zone 2 Countries
CA

Zone 2 Shipping Table
24.99:13.50,49.99:19.50,99.99:24.50,100:29.00

Zone 3 Countries
00

Zone 3 Shipping Table
24.99:18.50,49.99:24.50,99.99:29.50,100:35.00

Thanks!
cameo

17 Nov 2009, 5:21 AM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

End them in
10000:25.00

etc. etc. so that they do not go to 0.00 when beyond 100.00 ...

Then, test them out to check that they are working as you expect them too ...

18 Nov 2009, 3:36 AM
#5
cameo avatar

cameo

Zen Follower

Join Date:
Nov 2009
Location:
Ohio
Posts:
100
Plugin Contributions:
0

Re: Table Rate Question

Ajeh:

End them in
10000:25.00

etc. etc. so that they do not go to 0.00 when beyond 100.00 ...

Then, test them out to check that they are working as you expect them too ...

Hi Linda,

Ok, I did what you said above then I tested them and they work!!!

Thank you very much!!

cameo

18 Nov 2009, 4:19 AM
#6
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

Thanks for the update that you now have everything working ... :smile:

25 Nov 2009, 8:57 PM
#7
gbks avatar

gbks

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Re: Table Rate Question

Ajeh:

End them in
10000:25.00

etc. etc. so that they do not go to 0.00 when beyond 100.00 ...

Then, test them out to check that they are working as you expect them too ...

Ajeh,

how can I set a maximum rate in the Table? 5:7.50.

I want to set a price for anything up to 5 lbs and everything over 5 lbs use the UPS rates.

Thanks, sorry for the hijack

25 Nov 2009, 11:51 PM
#8
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

You would need to customize both the UPS and Table Rate shipping modules to check the weight and enable or disable them based on weight ...

For example, the Table Rate table shipping module:
/includes/modules/shipping/table.php

    if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_TABLE_STATUS == 'True') ? true : false);
    }

// do NOT show if weight is > 5.00
      if (!IS_ADMIN_FLAG) {
        global $cart;
        if ($_SESSION['cart']->show_weight() > 5.00) {
          $this->enabled = false;
        }
      }

    if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_TABLE_ZONE > 0) ) {

Then reverse the logic for the UPS shipping module:
/includes/modules/shipping/ups.php

26 Nov 2009, 1:51 AM
#9
gbks avatar

gbks

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Re: Table Rate Question

Linda,

Thanks for the info. Let me ask some remedial questions. How do I access the code? Someone from another post mentioned through FTP or file manager. Where is that located? Any help you can give is greatly appreciated.

Michael

26 Nov 2009, 2:37 AM
#10
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

All of the code is on the server for your domain ...

What you want is to have a copy of your whole site on your computer ... for example:
c:\my_internet\my_website

And you have in there the full "mirror" image of the files on your site, example:
c:\my_internet\my_website

would have a full copy of everything that is on the server ...
c:\my_internet\my_website\admin
c:\my_internet\my_website\cache
c:\my_internet\my_website\download
c:\my_internet\my_website\editors
c:\my_internet\my_website\email
c:\my_internet\my_website\extras
etc. etc.

The "mirror" copy of your site is both a way to "work" on the files and be a backup of your site ...

This means, I could sneak into your site and delete the whole thing ... :eek:

But then, you could just reload all of the files and you are back in business ... :cool:

The magic happens by having a few tools to do this with:

1 a good Text Editor - you could use NotePad, but would be frustrated and break most of your files in about ... 5 minutes ... so you want a good Text Editor such as UltraEdit or NoteTab Pro

The Text Editor allows you to customize the code as you need it to be, without damaging the files

You do not want to change your files via the Control Panel of your site as you will run into problems and you will break files, as well as that is very inefficient ...

You do not want to use programs such as MSWord or WordPad as these are not TEXT Editors they are wordprocessing programs and would put all kinds of "garbage" in your files ...

2 a good FTP program - The FTP is a File Transfer Protocol program to "transfer" your files back and forth between your computer and your domain site on the server ... something like FlashFXP or WSFTP or a host of other software packages ...

FTP programs can give you a list of files on the Left Panel of the screen (your computer) and on the Right Panel of the screen (your server) and allow you to transfer the files back and forth ...

Now, you can work with the code and make changes as needed to the files that are running your site ...

Your hosting provider can help you with login information, if you are not sure what to use to access your site with FTP ...

3 Dec 2009, 7:31 PM
#11
timdwyer42 avatar

timdwyer42

Zen Follower

Join Date:
Apr 2009
Posts:
149
Plugin Contributions:
0

Re: Table Rate Question

Ajeh:

You would need to customize both the UPS and Table Rate shipping modules to check the weight and enable or disable them based on weight ...

For example, the Table Rate table shipping module:
/includes/modules/shipping/table.php

if (zen_get_shipping_enabled($this->code)) {
  $this->enabled = ((MODULE_SHIPPING_TABLE_STATUS == 'True') ? true : false);
}

// do NOT show if weight is > 5.00
if (!IS_ADMIN_FLAG) {
global $cart;
if ($_SESSION['cart']->show_weight() > 5.00) {
$this->enabled = false;
}
}

if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_TABLE_ZONE > 0) ) {

> 
> Then reverse the logic for the UPS shipping module:
> /includes/modules/shipping/ups.php

Hi. Do you know how I would do this for the zones module? I tried putting the code in red under " ```
   if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_TABLE_STATUS == 'True') ? true : false);
    }
```" in the file and it's giving a blank page.
4 Dec 2009, 3:08 PM
#12
ajeh avatar

ajeh

Oba-san

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

Re: Table Rate Question

You are asking about the Zone Rate zones shipping module but showing the Table Rate table shipping module ...

If you just reversed that ... the code should be the same ...

If you are getting a blank page, check if you have blank space(s) or blank line(s) after the closing php bracket ?> at the bottom of the page ...

You can also get from the Free Software Downloads the Debug Tool to help identify the problem ...