Table Rate Error

[John Cisco]

I installed the Table Rate for shipping and set all my values accordingly.

25:6.95,50:8.95,75:10.95,100:12.95,150:14.95,200:16.95,300:19.95,400:22.95,10000 0:26.95

I also set the method to price.
No matter how much I purchase it always comes back saying the shipping is 6.95 (the first value in the table). If I change that first value to something else, it comes back with that value each time.

What am I missing here?

Thanks

edit: I'm not sure why there is a space on 16.95 listed above, there is no such space when I edit this post and there is no space where I can update the table in Zen Cart either

[Ajeh]

Have you an URL that we can peek at?

What version of Zen Cart are you using?

Is this a clean install or an upgrade?

[John Cisco]

It was a clean install....
version 1.2.6

If you want to take a look go to
http://www.kcwow.com/cart/ although I'm not sure what good that will do

I started this site a while back and the owner went on a hiatus for a few months and just dropped back in so I'm trying to finish it up.

thanks

[Ajeh]

Note: v1.2.6 is very old and has quite a few bugs and security issues plus lacks in many features ...

You might wish to upgrade at least to v1.2.7 if you cannot upgrade to v1.3.0.2 at this time ...

I am not seeing anything obvious in regard to this particular issue ... but I would recommend that you copy all of the settings currently in the tables.php to NotePad or something so you can easily reconfigure it ...

Then, remove and reinstall it ... then put back your settings ... does this change anything for you?

[John Cisco]

Hmmm....
I guess I'll try to upgrade tomorrow then.

I haven't done an upgrade with Zen....I guess I'll have to backup every file that I've made code changes to? I'll look for a FAQ section regarding upgrades.

[kobra]

I assume that your table rate is weight based and if you look at the item below you have no weight entered into your product description. So no matter how much is added to the cart it will always default to the first ship rate.

Total Items: 1 Weight: 0lbs Amount: $10.95

I know that you stated that you set it to price but I would check that this is the case.

[Ajeh]

Always a good idea to backup the whole site and the database ... then do a test upgrade in a test directory with a test database of the Live database ...

There are several writeups on how to do this ...

[John Cisco]

I found a place in the file...
/includes/modules/shipping/table.php

// shipping adjustment
if (MODULE_SHIPPING_TABLE_MODE == 'price') {
$order_total = $_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices() ;
} else {
$order_total = $shipping_weight;
}

and I changed this to

// shipping adjustment
if (MODULE_SHIPPING_TABLE_MODE == 'price') {
$order_total = $_SESSION['cart']->show_total();
} else {
$order_total = $shipping_weight;
}

And it works just fine. Looks like the prob was for some reason it was taking the total price in the cart, and subtracting the free shipping prices (which nothing was designated as free shipping and that shipping option isn't even installed). It for some reason was substracting the total price from itself and giving me the lowest shipping option.
When I would echo the results the $order_total would come out as 0 and it would give me the first shipping price. If that all makes sense.

Just in case someone else has the same problem and wants to just go in and edit the code.

[Ajeh]

Actually the issue is a bit more than that when shipping is based on Total and you have:

Always Free Shipping

Downloads

Virtual Products

etc. etc.

I am working on a new and better method to catch all of these so that when using a Shipping Module based on Price, anything that would ship for free is not used in the Total for the Shipping calculation ...

Weight and Item count seem to be working happily ... just those Shipping based on Total ...

[MrForce]

Ajeh,

I've noticed this issue show up in several threads, but considering I'm new to Zen Cart I just wanted to be sure I understand correctly.

I'm using "Table Rate" shipping based on price. I did not intend to enter weights for any of the products in my catalog. However, I've found that I cannot proceed past step 1 of checkout until I enter a [non-zero] weight for the item in the shopping cart.

Am I correct to assume I must enter some non-zero value for weight on all my products (aside from those defined as free shipping) even if I am using the aforementioned shipping method?

Thanks in advance...