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!!

[mc12345678]

Ok that got me on the right track, I had to modify it to the below for it to work:

            if ($rateReply->Service->Code == 03) {
            $_SESSION['shipping_rate_ups'] = $cost;
            }
            if ($rateReply->Service->Code == 92 || $rateReply->Service->Code ==  93) {
            $_SESSION['shipping_rate_ups_surepost'] = $cost;
            } 

Thank you for your help!

Glad that it helped, but I notice that the tests that Ajeh included in her below code were not incorporated: ie if current session value is 0 or if current estimate is greater than the current session value. I don't know the impact of the absence of that test, and it is that aspect that I encouraged doing your own testing to validate that the proper data is captured as expected, needed, or desired.

If incorporated I would suggest placing it within each of the above if statements, around the session assignments.

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