Different shipping methods for different categories

[Ajeh]

What happens if you only have Products for categories_id 51 in the cart? And is the master_categories_id on each of these Products also 51?

What happens if you have a cart with Products from categories_id 51 and other Products from other Categories?

If the current Table Rate works for all Products, except when a Product from categories_id 51 is in the cart ... can you just add an additional charge to the current charge that is being calculated by the Table Rate?

Something like if 1 Product from categories_id 51 is in the cart add $XX.XX and if 2 Products from categories_id 51 is added to the cart, add something like XX.XX * 2 to the cost already calculated by the Table Rate?

What method is the Table Rate table shipping using? Item, Total or Weight?

[aly22]

current table rate is based on total price in cart; if cart totals over $75 she has a percentage of total price to calculate shipping.
I rather like the idea of your suggestion to just tack on a price IF an item (or 2, etc) were added from category 51 -- how would I do that?

Alternately, I'm considering just making items in categories_id 51 as "free shipping" -- and build the shipping cost into the item(s) themselves. If i do this, and items from other categories are in the cart as well, does it know not to add the value of the cat-51 items to the final shipping cost??

[Ajeh]

If the Table Rate table shipping module works right now for all Products, except these Products in categories_id 51 and you are basing your Table Rate on Price ...

Are you able to add just an additional charge to the current calculated shipping charge based on the fact that these Products have their Price in that Table Rate calculation or does that have to be backed out before the additional charge is applied for the categories_id 51 Products?

[aly22]

Let me see if I can explain this and answer you properly.
Ordering from categories_id 51 requires shipping 3, 6, 9 or 12 times (it is basic product but purchased at a monthly subscription price)

So according to my client, if someone orders the 12-month subscription she will lose $50 in shipping fees - based on the current table rate (based on price)
I don't do math at all well so this boggles my mind -- but based I am assuming that -- yes -- I could just add an additional charge to the current calculated shipping charged to cover the difference. The trick of course will be to determine how much (preferably a percentage?)

[Ajeh]

Is the customer ordering Quantity 3, 6, 9 or 12?

So if this was a $10 Product they would be charged:
$30, $60, $90 or $120

and that the Table Rate based on Price does not charge enough on the Price of these items against the Table Rate settings?

If that is the case, then how much needs to be charged on these Products?

If I order 3? 6? 9? or 12?

Do you use Free Shipping for anything or the setting 0 weight means Free Shipping in the Shipping/packaging?

I am trying to think through an idea here but need a few more facts on what to do with the Price of the Category 51 Products so they are not part of the Table Rate but then add in the "special" shipping charge for them ...

And, if that can be based on the Category 51 Product quantity * $XX.XX for their shipping charge ... to then add that to the Table Rate calculation ...

[aly22]

Is the customer ordering Quantity 3, 6, 9 or 12?

So if this was a $10 Product they would be charged:
$30, $60, $90 or $120

and that the Table Rate based on Price does not charge enough on the Price of these items against the Table Rate settings?

Correct.

If that is the case, then how much needs to be charged on these Products?

If I order 3? 6? 9? or 12?

The 3 month plan costs $66, shipping based on the table rate comes to $21.49 but needs to be $31.47

6 month costs $132, shipping based on the table rate over $75 is charged at 28% which (I think?) is $36.96 but needs to be $62.94

etc.

Do you use Free Shipping for anything or the setting 0 weight means Free Shipping in the Shipping/packaging?

No, I am not currently using Free Shipping at all.
Would it work to set up the categories_id 51 items for Free Shipping and just include the actual shipping charges into the product price itself (with a descriptive statement for the customer)

If I do this and other items from other categories are in the same cart will they calculate minus the purchase price of the categories_id 51 item(s)??

I truly appreciate your help ... and hope you know what an amazing person you are for all you do here :)

[Ajeh]

Let's say Product A is in categories_id 51 and has master_categories_id 51 and we want to charge $12.00 shipping ... so if 1 Product A is sold you get $12.00 shipping if 2 Product A then $24.00 etc.

Customize the Table Rate table shipping module by changing the code in:
/includes/modules/shipping/table.php


Near the top of the file change:

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

To read, so that the module is not disabled by Always Free Shipping:

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

// bof: give categories_id 51 a charge of $12.00 per quantity
global $cart;
$chk_cat_51 = $_SESSION['cart']->in_cart_check('master_categories_id','51');
$chk_cat_51_shipping = $chk_cat_51 * 12.00;

    $this->quotes = array('id' => $this->code,
    'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE . $show_box_weight,
    'methods' => array(array('id' => $this->code,
    'title' => MODULE_SHIPPING_TABLE_TEXT_WAY,
    'cost' => $chk_cat_51_shipping + $shipping + (MODULE_SHIPPING_TABLE_HANDLING_METHOD == 'Box' ? MODULE_SHIPPING_TABLE_HANDLING * $shipping_num_boxes : MODULE_SHIPPING_TABLE_HANDLING) ) ));
// eof: give categories_id 51 a charge of $12.00 per quantity

Now, just mark the Products in categories_id 51 to be Always Free Shipping and set the 12.00 to what ever amount you want to charge for shipping on Products in categories_id 51 ...

Also set on the Table Rate table shipping a 0:0; in front of the existing rates, example:

0:0; 25:1.00; 50:2.50; 75;3.75; 100:4.00, 500:10%

[aly22]

You are phenomenal! I will try this out ... and include a pot of coffee and donuts in my client billing this month!!

But is it possible to set the 12.00 to a percentage instead of a dollar amount?
Because product choices in categories_id 51 are not selected by quantity, but literally 4 different items based upon the length of subscription.
I suppose I could change that so each "item" is equal to a 3 month subscription (so a 12 month subscription would equate to 4 quantity)

[Ajeh]

Providing that you are not using Always Free Shipping for anything other than these special products ... you can use this for any Product even those outside of categories_id 51 as this new way captures all Products that are Free Shipping ...

NOTE: you must turn OFF the setting in Shipping/Packaging for 0 weight means Free Shipping as now those products without weight would get counted as Free Shipping if this were turned on, so set this to NO:

If there is no weight to the order, does the order have Free Shipping?
0= no
1= yes

Note: When using Free Shipping, Enable the Free Shipping Module this will only show when shipping is free.

And change the code to read:

// bof: give categories_id 51 a charge of $12.00 per quantity
global $cart;
//$chk_cat_51 = $_SESSION['cart']->in_cart_check('master_categories_id','51');
//$chk_cat_51_shipping = $chk_cat_51 * 12.00;

// comment out echo below to not see it
//echo 'I SEE FREE SHIPPING: items: ' . $_SESSION['cart']->free_shipping_items() . ' price: ' . $_SESSION['cart']->free_shipping_prices() . ' 7%: ' . $_SESSION['cart']->free_shipping_prices() * .07 . '<br>';

// charge 7% on ANY product marked as Always Free Shipping
$chk_cat_51_shipping = $_SESSION['cart']->free_shipping_prices() * .07;

    $this->quotes = array('id' => $this->code,
    'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE . $show_box_weight,
    'methods' => array(array('id' => $this->code,
    'title' => MODULE_SHIPPING_TABLE_TEXT_WAY,
    'cost' => $chk_cat_51_shipping + $shipping + (MODULE_SHIPPING_TABLE_HANDLING_METHOD == 'Box' ? MODULE_SHIPPING_TABLE_HANDLING * $shipping_num_boxes : MODULE_SHIPPING_TABLE_HANDLING) ) ));
// eof: give categories_id 51 a charge of $12.00 per quantity

I left in the old code, commented in case you need that later on ...

[aly22]

just realized that I neglected to say THANK YOU VERY MUCH!!!!