Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Extracting shipping information from database


David Hooker

Recommended Posts

I'm not sure if this is the right forum to be posting this, so if there's a better one please let me know.

 

I am trying to extract ordering information from the backend database, but I don't know where to extract the ID of the order's shipping method. I can get the text from orders_total, but there doesn't seem to be any record of the ID.

 

Also, if anyone could tell me about any guide to schema of the database, that would be great!

 

Thankyou.

Link to comment
Share on other sites

Hi David, the shipping method is in fact not tracked. You can add a new column for future orders to the orders table "shipping method" and fill in the method (or what info about shipping you need) during the checkout_process

 

I had the need for this for a client before, and this is a very straightforward approach to get this info.

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...