Help with different shipping rates for first and additional items???

[BenhamCollectibles]

It is doing something wrong. It is showing 0.00 dollar as the best way for shipping. It has these lines on the shopping cart screen below the ;back to shopping' button:

CARDS: 0 = 1.05


HOTWHEELS: 0 = 1.56


SHOES: 0 = 11.56


CARDS: 0 = 1.05


HOTWHEELS: 0 = 1.56


SHOES: 0 = 11.56


Do I need to do something to the table rate or something else???? I have nothing in the table rate box because I don't know what to put in it. I am not sure what should be in place for this to work.

[BenhamCollectibles]

print screen button alone is not working, don't I need to push something else at the same time??

[Ajeh]

For now, this is fine ... we are just looking for counts ...

Now add 1 Hot Wheel ... 1 Card ... and 1 Shoes ...

Now test the amounts displayed by raising the Hot Wheels to 2, then 3, then 4, then 5 ... all the way to 20 ... are the rates right for the Hot Wheel?

Do the same on the Cards ...

I don't know if the shoes will work with this formula, as it sounds like you want a different formula for them ... but try it for fun ...

[BenhamCollectibles]

No, nothing is increasing when I add any amount of any item. The shipping still says 0.00. I have a screenshot now. How should I get it to you? I think if you see what it is doing, it will definitely help. I know what I am seeing is not right, but I need you to see it so you know what to do with it.

[BenhamCollectibles]

http://s188.photobucket.com/albums/z...reenshotBC.jpg


This should do the trick. Below the back to shopping button is what I know shouldn't be there.

[Ajeh]

I am afraid I cannot see anything from a screen shot ...

From what I can see you need to either be in the shipping estimator or the checkout_shipping with the Table Rates shipping module installed to see this work ...

But I cannot tell if you have this installed right or not ...

Without actually setting this up I am not sure how to help you further ...

This code:

global $cart;
  $cnt_cards = $_SESSION['cart']->in_cart_check('master_categories_id','9');
echo 'Cards: ' . $cnt_cards;

Should tell you how many Products are in the cart that have the master_categories_id 9 ...
$cnt_cards would display the value ...

[BenhamCollectibles]

Here is what mine say right now for just the cards:

global $cart;
$cnt_cards = $_SESSION['cart']->in_cart_check('master_categories_id','9');
$card_ship = ceil($cnt_cards/4) * .17;
$card_ship = $card_ship+ 1.05;

I know it has been very difficult to work with not knowing what is happening on this end. I do appreciate you trying to help me. you are the only one that I got any help from. Not sure what to do now. Pretty sure all the other open source carts don't have the shipping feature that I need either. The only thing I can think of now is to set up 3 different stores for the three different categories, each in its own store. I had someone else do that for me once before, but it was really hard to manage and it was OSCommerce so it didn't have all the extras that this Zen has. When God wants me to have this, He will provide a way for me to get it to work. Thanks again for being patient with me, Ajeh.

Kristofer Benham

[Ajeh]

The problem you are having is that you are not using the Product's master_categories_id

I also changed the formula a bit to account for when 0 so that didn't need a lot of change, example for cards to work with 2 categories:

  $cnt_cards = $_SESSION['cart']->in_cart_check('master_categories_id','17'); // 2009 Allen & Ginter Base Cards
  $cnt_cards = $cnt_cards + $_SESSION['cart']->in_cart_check('master_categories_id','13'); // 2009 Topps Base Cards
  $card_ship = ceil($cnt_cards/4) * .17;
  $card_ship = ($card_ship == 0 ? 0.00 : $card_ship+ 1.05);

Based on your site, and that this is going to be a lot more categories than this method is easily used for, you may want to alter it somewhat ...

If you are not using the products_model then this field would be ideal to use:
cards
hotwheels
shoes

as the content of the products_models field ... then the checks can be done with:

$cnt_cards = $_SESSION['cart']->in_cart_check('products_model','cards');

  $cnt_hotwheels = $_SESSION['cart']->in_cart_check('products_model','hotwheels');

  $cnt_shoes = $_SESSION['cart']->in_cart_check('products_model','shoes');

Meanwhile, try the code as it is setup now with the changes I added to your site to see how this works ...

[BenhamCollectibles]

I follow some of what you said below. I will just try it out this way and see how it works at this moment. I will report any descrepancies or mistakes to you ASAP. And no, I do not like using the model number box. It make sme have to make up a model number for 150,000 cards alone, plus Hot Wheels and any shoes I may get. I hope that helps you in making this a little easier. Thank you for your help on this project.

Kristofer

[BenhamCollectibles]

Well, on the first test run, I see that the counters that are on the cart screen are actually counting the items as I increase them. But there is still no shipping total at the bottom of the screen (best way 0.00). Do I need to set up a table rate now or just leave it alone? I like the idea of the models box being used kinda like a categorizer for shipping purposes. Not sure what else to test without some input from you on what I should do now.

Kris