Per Unit or Per Item Shipping Help?

[Ajeh]

The Product information is stored in your database tables:
products
products_description

The master_categories_id is in the table:
products

You can test the contents of the Shopping Cart to see how many Products are in specific Categories based on the master_categories_id to determine what to do on Handling Charge, instead of using the built in Handling Charge ...

Is the Handling charge based on 1 $50.00 handling charge IF there is 1 or more firearms?

Or, is the Handling charge based on how many Products are in the shopping cart and charging $50.00 per item for the Handling charge?

[colortheworld]

The Product information is stored in your database tables:
products
products_description

The master_categories_id is in the table:
products

You can test the contents of the Shopping Cart to see how many Products are in specific Categories based on the master_categories_id to determine what to do on Handling Charge, instead of using the built in Handling Charge ...

Is the Handling charge based on 1 $50.00 handling charge IF there is 1 or more firearms?

Or, is the Handling charge based on how many Products are in the shopping cart and charging $50.00 per item for the Handling charge?

I'm not sure? I just have handling set as 50.00 on the USPS Module.

Now, I do know that when I go to look at the shopping cart there's always a number in parenthesis that says "(1 x "")" and in those quotes are the weight of the product...

[Ajeh]

I go to your site and buy a Rifle and a Gun ...

Do you want to charge me $50.00 for this order for the Handling Fee or do you want to charge me $100.00 for the Handling Fee?

NOTE: you can edit the USPS shipping module and turn off the quantity and weight of boxes:

USPS Options
Select from the following the USPS options.

Display weight
Display transit time

[colortheworld]

Actually I'm wrong...

Firearms get a $50.00 charge, Handguns get $35 -- these charges cover insurance and handling. Smaller items are flat rate priority mail box.

[Ajeh]

Okay so the basic idea is ...

Count how many Products are in the shopping cart and then add $50.00 on a per Quantity per Product basis to the shipping charge ...

So if there were 9 Products in the Cart, and 3 come from the Rifle category and 4 from the Gun category and 2 from non-firearm categories ...

Then I could just take the Rate Quote from USPS based on weight, and add to those:

3 x 50.00 = $150.00
4 x 50.00 = $200.00
= $350.00

and add that $350.00 to each quote from USPS that is listed and the amount would apply, correct?

Then, if an Order is made with none of these firearm categories Products ... just the normal shipping rates from USPS would apply, correct?

[colortheworld]

Okay so the basic idea is ...

Count how many Products are in the shopping cart and then add $50.00 on a per Quantity per Product basis to the shipping charge ...

So if there were 9 Products in the Cart, and 3 come from the Rifle category and 4 from the Gun category and 2 from non-firearm categories ...

Then I could just take the Rate Quote from USPS based on weight, and add to those:

3 x 50.00 = $150.00
4 x 50.00 = $200.00
= $350.00

and add that $350.00 to each quote from USPS that is listed and the amount would apply, correct?

Then, if an Order is made with none of these firearm categories Products ... just the normal shipping rates from USPS would apply, correct?

Not sure I catch you, but let me explain this a bit better, in terms of category

We have 3 categories on the site, the first is "Custom Rifles for Sale", the second is "Guns for Sale", and the third is "General Sales" (this is currently 2 guide books).

With 3 categories, we have a total of 13 products, all 6 in the "Custom Rifles" are Rifles. In "Guns for Sale" we have 4 rifles and 1 handgun (handguns are $35.00 shipping, in case you missed the edit I made on my last post), and "General Sales" is just 2 books.

I've added weight into the products, minus the books, and turned off the show weight and show transit boxes.

I don't see this "Per Quality / Per Product" in the Module, but I wonder if this means "Per Item / Per Unit". Is that the case?

Thanks for being so patient with me -- I'm a creature of retention. I can't just read something and totally get it all the time, but once I do it once (or twice), it's picked up.

[Ajeh]

"Per Product Per Item" is *me* asking *you* if the handling charge is based on the quantity ordered for each Product x $50.00 or just $50.00 if 1 or more are in the cart ...

This makes the calculation either the normal USPS shipping quote plus $50.00 or the normal USPS shipping quote plus $50.00 per Product x quantity ...

And then, if no firearms are in the cart, just the normal USPS shipping quote ...