Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Saving an order's shipping method


darkflounder

Recommended Posts

I've only seen a few posts with this question, and never an answer.

 

Does OSC store the shipping method for an order somewhere? I've been through almost every DB table, and can't seem to find any location where it's stored.

 

I'd like to have the selection stored, then have the shipping method displayed in the order list for processing, as well as on the packing slip / invoice.

 

I'm ready to just figure this out myself and make a contribution for it. But if it's already been figured out and done by someone else, no sense in duplicating the effort.

Link to comment
Share on other sites

I've only seen a few posts with this question, and never an answer.

 

Does OSC store the shipping method for an order somewhere? I've been through almost every DB table, and can't seem to find any location where it's stored.

 

I'd like to have the selection stored, then have the shipping method displayed in the order list for processing, as well as on the packing slip / invoice.

 

I'm ready to just figure this out myself and make a contribution for it. But if it's already been figured out and done by someone else, no sense in duplicating the effort.

Did you make a test order and see what the results are?

Link to comment
Share on other sites

Yes, it is stored somewhere...export_orders_to_csv_v22 module withdraws it and places it into a csv. I think this is the code from the module that withdraws it.

 

// -------------------- QUERIES 5 ------------------------------------//

//Orders_Shipping

$orders_shipping = tep_db_query("select title, value from orders_total

where class = 'ot_shipping' and orders_id = " . $Orders_id);

//$row_orders_shipping = tep_db_fetch_array($orders_shipping);

while($row_orders_shipping = mysql_fetch_array($orders_shipping)) {

// end //

$Order_Shipping_Total = $row_orders_shipping["value"];

$Shipping_Method = filter_text($row_orders_shipping["title"]); // Shipping method from query 5

}

Link to comment
Share on other sites

OK, turns out this is no longer an issue. An older version of OSC I'm using on a heavily modified site didn't have that, while the latest version of OSC does have it.

 

And for the benefit of those also looking for this info, it's stored in the orders_total table.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...