Forums / Built-in Shipping and Payment Modules / chosen shipping stored in db

chosen shipping stored in db

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

18 Jun 2006, 10:05 PM

jclegg

New Zenner

Join Date:: May 2006
Posts:: 13
Plugin Contributions:: 0

chosen shipping stored in db

I working on writing a sql statement to create a file that I need to send to my shipping/warehousing company so they can process my orders. In the file I need to specify in 2 different fields the shipping agent (ie UPS, FEDEX etc) and in another field the shipping type (Ground, 2nd Day Air etc). When looking in the orders table it is storing the shipping info like this:

United Parcel Service (1 pkg x 6.00 lbs total) (UPS Ground, <acronym title='Estimated Time of Arival'>ETA</acronym>: June 23, 20

I am not sure why it is storing all this info that I don't really care about. Any ideas on how best to extract the data I need or change how this is getting stored.

Thanks

19 Jun 2006, 12:05 AM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: chosen shipping stored in db

In the orders table there are two fields:

shipping_module_code ups

shipping_method United Parcel Service (1 x 10.00lbs) (Next Day Air Early AM)