Handling Fee as Percentage?

There is a Handling fee on USPS ... what version of Zen Cart are you using? :unsure:

Regarding the solution in #17, is this percentage added to the order total or calculated shipping cost of order based on weight? Am needing to do similar and want to confirm it is based on the shipping amount vs the entire order. Thank you for any info.

Thank you for posting your solution, it works nicely. For info my question about what the percent is calculated on, it appears to be order total.

Hello:

I hate to keep this thread going, but based on the title, I think it applies to my dilemma. I am using the latest version of Zen Cart, and I am looking to apply a percentage-based handling fee to my shipping. I am using a priced-based table rate and would like to add a 5% handling fee based on total cost after taxes. I know from reading the other posts as well as other threads where to find the module's php, but am confused on how I would be able to change the formula to multiply by the handling fee instead of adding the fee.

Please help! Thanks!

Donanater:

Well I figured it out:clap:

The finished result was two fold. For our Free Shipping we added a 3% charge for PayPal transactions and $2.75 handling charge to cover shipping overhead. For our USPS module (priority, express, international shipping and PayPal charges we added a 5% charge plus $1.70.

No need to have an additional "Handling Fee" on the Shipping Module, this formula by-passes that.

USPS Shipping:
/public_html/includes/modules/shipping/usps.php

insert " +($order->info['subtotal'] * .05 + 1.70) into Line 298
where ($order->info['subtotal'] is your subtotal price * percent + overhead shipping cost.

Orginal:
'cost' => ($cost * $shipping_num_boxes) + (MODULE_SHIPPING_USPS_HANDLING_METHOD == 'Box' ? MODULE_SHIPPING_USPS_HANDLING * $shipping_num_boxes : MODULE_SHIPPING_USPS_HANDLING) );

Updated:
'cost' => ($cost * $shipping_num_boxes) + ($order->info['subtotal'] * .05 + 1.70) + (MODULE_SHIPPING_USPS_HANDLING_METHOD == 'Box' ? MODULE_SHIPPING_USPS_HANDLING * $shipping_num_boxes : MODULE_SHIPPING_USPS_HANDLING) );

Free Shipping:
/public_html/includes/modules/shipping/freeoptions.php

insert "($order->info['subtotal'] * .03 + 2.75) +"
where ($order->info['subtotal'] is your subtotal price * percent + overhead shipping cost.

Orginal:
'cost' => MODULE_SHIPPING_FREEOPTIONS_COST + MODULE_SHIPPING_FREEOPTIONS_HANDLING)));

Updated:
'cost' => MODULE_SHIPPING_FREEOPTIONS_COST + ($order->info['subtotal'] * .03 + 2.75) + MODULE_SHIPPING_FREEOPTIONS_HANDLING)));

Hope this helps anyone else out there.

Ok, this worked on the old version, but it doesn't seem to work on the January 2012 update. Anyone know what I might need to do different or what I'm doing wrong? I'm using .03 + 1.75 for the USPS module.

website: http://earthscauldron.com/store/

Add this line in RED to the code and see what is being calculated:

          $cost = preg_replace('/[^0-9.]/', '',  $cost);

// add $this->usps_countries to title to test actual country
echo 'I See USPS Cost: ' . $cost . ' Extra: ' . ($order->info['subtotal'] * .03 + 1.75) . ' = ' . (($order->info['subtotal'] * .03 + 1.75) + $cost) . '<br>';

ya, shows it's only adding 1.75 and not the 3%

Could you paste what you see from the echo?

I See USPS Cost: 31.25 Extra: 1.75 = 33
I See USPS Cost: 5.65 Extra: 1.75 = 7.4
I See USPS Cost: 5.55 Extra: 1.75 = 7.3

Estimate Shipping Costs
Total Items: 1 Amount: $140.00
Country: Please Choose Your Country United States Australia Canada United Kingdom United States Minor Outlying Islands
State/Province: Please select ...AlabamaAlaskaAllAmerican SamoaArizonaArkansasArmed Forces AfricaArmed Forces AmericasArmed Forces CanadaArmed Forces EuropeArmed Forces Middle EastArmed Forces PacificCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFederated States Of MicronesiaFloridaGeorgiaGuamHawaiiIdahoIllinoisIndianaInternationalIowaKansasKentuckyLouisianaMaineMarshall IslandsMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaNorthern Mariana IslandsOhioOklahomaOregonPennsylvaniaPuerto RicoRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirgin IslandsVirginiaWashingtonWest VirginiaWisconsinWyoming

Post/Zip Code:

Shipping quotes are based on the address information you selected:
Maine 04101 United States
Available Shipping Methods Rates
Store Pickup (Walk In) $0.00
United States Postal Service (Parcel Post (4 - 7 days)) $7.30
United States Postal Service (Priority Mail (2 - 3 days)) $7.40
United States Postal Service (Express Mail (1 - 2 days)) $33.00
United Parcel Service (1.00lbs) (Ground) $12.92

[ Close Window ]

And you are using:

          $methods[] = array('id' => $type,
                             'title' => $title,
                             'cost' => ($cost * $shipping_num_boxes) + ($order->info['subtotal'] * .03 + 1.75) + (MODULE_SHIPPING_USPS_HANDLING_METHOD == 'Box' ? $usps_handling_fee * $shipping_num_boxes : $usps_handling_fee) );

Ya, this:

$methods[] = array('id' => $type,
'title' => $title,
'cost' => ($cost * $shipping_num_boxes)+($order->info['subtotal'] * .03 + 1.75) + (MODULE_SHIPPING_USPS_HANDLING_METHOD == 'Box' ? $usps_handling_fee * $shipping_num_boxes : $usps_handling_fee) );

Could you go to your Admin and look in Modules ... Order Total ... and click on Subtotal ot_subtotal and make sure it is installed ...

Also change your echo in the USPS shipping module to:

echo 'I See USPS type: ' . $type . ' order subtotal: ' . $order->info['subtotal'] . ' Cost: ' . $cost . ' Extra: ' . ($order->info['subtotal'] * .03 + 1.75) . ' = ' . (($order->info['subtotal'] * .03 + 1.75) + $cost) . '<br>';

what comes up?

Ya installed:

Order Sub-Total

This module is installed
true

Sort Order
100

Ok changed echo:

I See USPS type: EXPRESS order subtotal: Cost: 31.25 Extra: 1.75 = 33
I See USPS type: PRIORITY order subtotal: Cost: 5.65 Extra: 1.75 = 7.4
I See USPS type: PARCEL order subtotal: Cost: 5.55 Extra: 1.75 = 7.3

Estimate Shipping Costs
Total Items: 1 Amount: $140.00
Country: Please Choose Your Country United States Australia Canada United Kingdom United States Minor Outlying Islands
State/Province: Please select ...AlabamaAlaskaAllAmerican SamoaArizonaArkansasArmed Forces AfricaArmed Forces AmericasArmed Forces CanadaArmed Forces EuropeArmed Forces Middle EastArmed Forces PacificCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFederated States Of MicronesiaFloridaGeorgiaGuamHawaiiIdahoIllinoisIndianaInternationalIowaKansasKentuckyLouisianaMaineMarshall IslandsMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaNorthern Mariana IslandsOhioOklahomaOregonPennsylvaniaPuerto RicoRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirgin IslandsVirginiaWashingtonWest VirginiaWisconsinWyoming

Post/Zip Code:

Shipping quotes are based on the address information you selected:
Maine 04101 United States
Available Shipping Methods Rates
Store Pickup (Walk In) $0.00
United States Postal Service (Parcel Post (4 - 7 days)) $7.30
United States Postal Service (Priority Mail (2 - 3 days)) $7.40
United States Postal Service (Express Mail (1 - 2 days)) $33.00
United Parcel Service (1.00lbs) (Ground) $12.92

[ Close Window ]

It does not make a lot of sense ...

What version of Zen Cart are you using?

Clean install or an upgrade?

If you switch to the Classic template does it work in the shipping estimator?

Ok, this is weird, if I log in with my testing customer info two different ids both in FL and NY it shows the 1.75 plus 3%, if I'm not logged in it only shows the 1.75....wha??

I'm using version 1.3.9h clean install, I'm using the classic template, I've just tweeked it to what I want.

Well this makes it harder to debug ...

I have tried this code in my v1.3.9h and it works in both the shipping estimator whether I am logged in or not and the checkout ...

For giggles and grins, go to the Modules ... Shipping ... and click on USPS and EDIT it and save the settings to NotePad ... then, do a REMOVE, INSTALL and reconfigure it ...

Ok, removed, re-installed, no change....

Could something here be the problem:

Enable USPS Shipping
True

Enter the USPS Web Tools User ID

Which server to use
production

Quote Sort Order
Price

Handling Fee - US
0

Handling Fee - International
0

Handling Per Order or Per Box
Order

Decimal Settings
3

Tax Class
--none--

Tax Basis
Shipping

Shipping Zone
--none--

Sort Order
1

All Packages are Machinable
True

USPS Options
Display transit time

Domestic Shipping Methods
EXPRESS, PRIORITY, FIRST CLASS, PARCEL

International Shipping Methods
Global Express, Priority Mail International, First Class Mail Int Parcel

Debug Mode
Off

So far nothing is indicating the problem ...

If you look at the usps.php file, and find the line that starts as:

  function quote($method = '') {

what are the next 2 lines?

function quote($method = '') {
    // BOF: UPS USPS
    global $order, $shipping_weight, $shipping_num_boxes, $transittime;

I am not finding a reason for this issue ...

Without going through your site and checking all of the files, I am not sure what the reason is ...

You can hide the problem by turning off the shipping estimator or you can see if you can find someone to pursue this further and try to hunt down the problem ...