Mixed category shipping calculation

[Ajeh]

I wrote this based on Postcards where there was a Parent cat with subcats that had the Products ...

But, as you have some of these Categories that hold subcategories with Products, and some of these Categories where the Category itself holds the Products, I rewrote this to do the calculations for each group for Postcards, Books and Prints to identify based on the Category you identify for $chk_cat to know how to calculate for either condition.

See if this new attachment works better for you ...

[lot49]

I wrote this based on Postcards where there was a Parent cat with subcats that had the Products ...

But, as you have some of these Categories that hold subcategories with Products, and some of these Categories where the Category itself holds the Products, I rewrote this to do the calculations for each group for Postcards, Books and Prints to identify based on the Category you identify for $chk_cat to know how to calculate for either condition.

See if this new attachment works better for you ...

Hi Ajeh, works great!
Thank you.
For adding different zones, do I clone this categoriesitem for each zone?

[Ajeh]

Yes, if you need different Zones then clone this shipping module ...

[lot49]

Yes, if you need different Zones then clone this shipping module ...

Hi Ajeh,
Seems to be going so far but have another question.
I'm wanting to add another book in the book master category "1" which would use the default shipping metheod as it's of a different size and weight as the others. Using the master category id #'s to calculate shipping, is there a way to have 2 different shipping calculations within one master category?
Or, can you turn a sub category into a master category for shipping purposes, and have it still be in a sub category? Eg: is it possible to have a master category "books", and within this category have the category "deluxe books" which calculates by one master category id, and "regular books" which calculates with the default shipping method?

thx

[Ajeh]

While the master_categories_id is a categories_id, the Categories that hold subcategories are never master_categories_id as only a Category with Products can be a master_categories_id ...

So let's step through this slowly and pretend I know nothing about your Categories and Products as if it were your store and not mine ...

You want to add a Product, what is its products_id? to a Category, what is the categories_id? what is its master_categories_id? and you want it do use the default shipping, what is the default shipping?

Currently, I am aware that you have the CategoriesItem2.zip that I made for you to manage Books, Prints and Prostcards ...

For this new Product that you say is a Book with different shipping, what makes it different? We might be able to identify it by its products_id and adjust the shipping charges based on that, but you need to provide more detail and take baby steps in doing so as I do not know your shop and your shipping like you do ...

[lot49]

While the master_categories_id is a categories_id, the Categories that hold subcategories are never master_categories_id as only a Category with Products can be a master_categories_id ...

So let's step through this slowly and pretend I know nothing about your Categories and Products as if it were your store and not mine ...

You want to add a Product, what is its products_id? to a Category, what is the categories_id? what is its master_categories_id? and you want it do use the default shipping, what is the default shipping?

Currently, I am aware that you have the CategoriesItem2.zip that I made for you to manage Books, Prints and Prostcards ...

For this new Product that you say is a Book with different shipping, what makes it different? We might be able to identify it by its products_id and adjust the shipping charges based on that, but you need to provide more detail and take baby steps in doing so as I do not know your shop and your shipping like you do ...

Hi Ajeh,
Yes, I received the zip and it works great. Thank you.

In the books category I hope to have regular books of a standard size, limited edition books of the same standard size, and Deluxe edition books which are larger, and need the unique shipping in the books category
of the CategoriesItem. The Deluxe books are the unique ones. All the other books are small and can be put in a standard envelope:
$5.60 shipping and handling for one with an additional .75 for each additional book.

I would like them to be side by side in the books category rather than creating separate categories for each as some are the same book offered as regular or deluxe.

Ideally the default shipping I would set at $5.60 each then .75 for each additional. This would cover most items, then use the specific shipping calculations you set up for the books, postcards and prints for the other unique items.

Hope this makes sense, Thx

[Ajeh]

Any reason you cannot make a Category for:
Books Small (or some other useful name)

then Link these books to the Books Category?

Then a new calculation can be made for the shipping of these Products that would use the master_categories_id for the Books Small category as the trigger ...

[lot49]

Any reason you cannot make a Category for:
Books Small (or some other useful name)

then Link these books to the Books Category?

Then a new calculation can be made for the shipping of these Products that would use the master_categories_id for the Books Small category as the trigger ...

Do you mean if someone then goes into the books category they will then have a choice of Books Small, and other books?
The snag is some regular books and the deluxe limited edition books are just different versions of the same book. I'd prefer to have them side by side rather than in different categories so someone can see them together and chose one or the other.

With what you're suggesting could I have, for example, an All Books Category, and a Deluxe books Category, and then link the Deluxe books in the All Books Category so people could see everything together under All Books?
Can you make a Category for, as per your example, Books Small, for shipping purposes, have them linked to the Books Category but not have the the separate Books Small Category visible on it's own as a choice, only have the items visible linked in the Books Category?

[Ajeh]

You can do it that way, which is similar to your Post Cards category ... The Products are in their own Category, but then Linked to the All category ...

Just make sure that the correct master_categories_id is set ...

Once the books are arranged correctly, then the code can be adapted for the different shipping charge ...

[lot49]

You can do it that way, which is similar to your Post Cards category ... The Products are in their own Category, but then Linked to the All category ...

Just make sure that the correct master_categories_id is set ...

Once the books are arranged correctly, then the code can be adapted for the different shipping charge ...

Okay, I think I've got it, just one more question hopefully.
For adapting the code for a new master_category_id, I'm guessing I can go in the categoriesitem.php
and copy one of the other specific charges you set up (such as books below), and modify it for the new category?


// bof: calculate books shipping cost
$chk_cat = '75'; // parent or main categories_id for books
$chk_cart = 0;
if (!zen_has_category_subcategories($chk_cat)) {
// if $chk_cat has no subcategories and has products
$chk_cat_products = zen_get_categories_products_list($chk_cat, false, false);
$chk_cat_products_id_list += zen_get_categories_products_list($chk_cat);
$chk_cart += $_SESSION['cart']->in_cart_check('master_categories_id', $chk_cat);
} else {
// if $chk_cat has subcategories and has products
$subcategories_array = array();
zen_get_subcategories($subcategories_array, $chk_cat);
for ($i=0, $n=sizeof($subcategories_array); $i<$n; $i++ ) {
$chk_cat_products_id_list += zen_get_categories_products_list($subcategories_array[$i]);
$chk_cart += $_SESSION['cart']->in_cart_check('master_categories_id', $subcategories_array[$i]);
}
}
//1 = 17.50, 2 = 17.50 + .75, 3 = 17.50 + 1.50, 4 = 17.50 + 2.25
//17.50 per book + .75 for each book over 1
$ship_books = ($chk_cart > 0 ? 17.50 + (($chk_cart-1) * 0.75) : 0);
//echo 'Books in Cart: ' . $chk_cart . ' shipping: ' . $ship_books . '<br>';
// eof: calculate books shipping cost