how do i attach a different shipping rate table to each category?

[paulFromWales]

hi

i got a site but all the categories have different shipping prices, so i was thinking if each category had its own shipping rate table assigned to it i could sort it out easy but i have no idea how to do it and i have looked through forum but i just seem a bit confused about it all, can anybody point to in right direction please

paul

[Kim]

... and what if I buy a product for category A and one from category B?

[paulFromWales]

hi

there would be a shipping price for the one product working off the one table and a different price working from a different table for the othr and they would be added together to produce a total shipping charge for the packages

you can do it with zones cant you do it with categories some how?



paul

[Kim]

I would suggest you look at using the Per Weight Unit module in your case.

[paulFromWales]

hi

heres what i got to try and sort out:

cat A - shipping for these products is - £1.50
Additional shipping per product is £1.00 per product there after

cat B - shipping for these products is - £2.99
Additional shipping per product is £1.00 per product there after

cat C - shipping for these products is - £4.50
Additional shipping per product is £3.50 per product there after

cat D - shipping for these products is - £3.50
Additional shipping per product is £1.50 per product there after

cat E - shipping for these products is - £2.50
Additional shipping per product is £1.00 per product there after

cat F - shipping for these products is - £1.50
Additional shipping per product is £1.00 per product there after

cat G - shipping for these products is - £4.50
Additional shipping per product is £1.50per product there after



and there are another copule all different, its the additional product price and that they are all different prices that is confusing me, not sure if weigth is any good here.

any thoughts??

paul

[Ajeh]

You are going to need to customize a shipping module for this ...

Either you can base this on the categories_id or on the products_id ...

In your particular case, you break the easy method that Kim suggested of using the Per Unit perweightunit shipping module as you want the shipping to be:
fixed shipping cost of $XX.XX for 1st item then add $1.00 for each additional quantity of that item ...

Per Unit perweightunit takes the total products_weight * quantity * unit price ...

But all of that is nicely calculated in the shipping class ...

You don't want to do it the simple way ... but rather have a per product charge for shipping quantity 1 plus the $1.00 for each additional product ... and to complicate it one more step, you want this not on a given products_id but rather on a categories_id ...

Now, do you use Linked Products? The real question being, are all Products setup with a proper master_categories_id where the master_categories_id properly matches the Category that the Product would be charged for on shipping?

[paulFromWales]

hi

thanks for response, nice to hear that there is a way around this although i havent got a clue how to do what you just said, think i need some of your wisedom and guidance

Now, do you use Linked Products? The real question being, are all Products setup with a proper master_categories_id where the master_categories_id properly matches the Category that the Product would be charged for on shipping?

not sure, all the cateogies got an id but how do i know to check for what you just said?

paul

[Ajeh]

You can check if all products have a master_categories_id in phpMyAdmin which should be available in the Control Panel that came with your domain from your hosting provider ...

phpMyAdmin allows you to see the database and all of the tables and then look at the data in each row ...

You want to check the products table for the field master_categories_id to make sure none are set to 0 ...