Write returned shipping quote vaules to order table

[marcopolo]

I'm trying to write the quoted returned values from the following carriers UPS, FedEx, and USPS.

I just need to write:

UPS ground
FedEx Ground
USPS Priority Mail

to the below tables I created in the orders database called:

shipping_rate_ups
shipping_rate_fedex
shipping_rate_usps

I updated the includes/classes/order.php and can write to the new tables using the following code:

'shipping_rate_ups' => $_SESSION['shipping']['cost'],
'shipping_rate_fedex' => $_SESSION['shipping']['cost'],
'shipping_rate_usps' => $_SESSION['shipping']['cost']);

I used the $_SESSION['shipping']['cost'] just to test the writing of the new tables which worked fine. Now I just need to grab the actual quoted returned values but I'm stuck and have no idea how to do it? Any help would be much appreciated!

[bislewl]

Ok...Can you clarify why you need to record the rates, they changes sometimes on a daily basis and there is virtually an infinite amount of combinations between zip-codes, weights, dimensions and services... Why not just use the live rates?

[marcopolo]

I'm going to start offering a flat rate (best way) shipping option which will loose me some money per shipment since it will be cheaper then the carriers actual rates. It will be offered alongside those options (UPS ground, Fedex Ground, USPS) by recording the real rates at the time of order I can then reference those rates and see which carrier was the cheapest and use them for that shipment. Doing it this way will guarantee I'm using the cheapest carrier to ship the package.

[marcopolo]

Just in case I was not clear in the below picture, I'm trying to log the following rates highlighted in yellow in the new tables I created in orders database.

[Ajeh]

You appear to want to save the lowest cost of each shipping module to your order ...

For USPS you could customize the code:
/includes/modules/shipping/usps.php

around line 380 to include the code in RED:

      // bof: save lowest cost to $_SESSION['shipping_rate_usps']
      $_SESSION['shipping_rate_usps'] == 0;
      // eof: save lowest cost to $_SESSION['shipping_rate_usps']

      for ($i=0; $i<$PackageSize; $i++) {

Then around line 566 include the code in RED:

        $cost += (MODULE_SHIPPING_USPS_HANDLING_METHOD == 'Box') ? $usps_handling_fee * $shipping_num_boxes : $usps_handling_fee;
        // bof: save lowest cost to $_SESSION['shipping_rate_usps']
        if ($_SESSION['shipping_rate_usps'] == 0 || $_SESSION['shipping_rate_usps'] > $cost) {
          $_SESSION['shipping_rate_usps'] = $cost;
        }
        // eof: save lowest cost to $_SESSION['shipping_rate_usps']
        // set the output title display name back to correct format
        $title = str_replace(array('RM', 'TM', '**'), array('®', '™', ''), $type_rebuilt);

Maybe this will help you on the other shipping modules ...

NOTE: I have not tested this code

[marcopolo]

Thank you so much I will test later today and report back!!

[marcopolo]

Ajeh It worked perfect, and I was able to use your code to modify the UPS and FedEx modules as well without issue! Thank you again!

[Ajeh]

You are most welcome ... thanks for the update that this worked for you ...

[marcopolo]

Ajeh,

This has been working great however I'm adding UPS Surepost and need to save that as well as the Ground rate, can the above code be modified to save two/three rates? UPS uses service codes which are:

Gound: 03
SurePost: 92 less than 1 lb
SurePost: 93 greater than 1 lb

There will on be either a 92 or 93 not both plus code 03

[marcopolo]

Sorry there is a typo in my post above I do not need to save the surepost as ground I need to save both surepost and ground rates separately.