If you are using Google Checkout when you export your orders you will not be able to use this and see your order amount totals. Google checkout stores these values in another table (google_orders) not the default table (orders).
While this probably will not affect many people a company that I work for is using php scripts to automate shipping ( converting to xml, and using dazzle and worldship software ). Because of the possiblitiy of need to manual overrides we are using this mod to pull orders into a format viewable by excel, change the ship type variable if needed and run through the xml converter to print postage automatically. Seems more complicated than what it is, and it allows us to print postage for 300 orders very quickly.
At any rate the point is that they base their shipping methods in part on the the order totals. If orders are over $100 they go by UPS, not USPS, and if orders are $150 or more they are nsured.....
Since this mod doesn't take into account the order totals from Google Checkout, I had to modify it a bit. I added the following code to pull the order totals from the google checkout table into the order table:
$query = 'update orders,google_orders set orders.order_total=google_orders.order_amount where orders.orders_id=google_orders.orders_id';
If you need to see order totals and you are using Google Checkout you can place this code in the export file: Admin->shipping_export.php and it will solve the issue. Place the code near the top right after the includes.
Might be worthwile to include something like this or a conditional statment to grab the google info in future releases.
Thanks for the export btw, works great, and it saved me a lot of coding time! :-)
**DirtyGrrrl Lingerie** - Because inside every woman there's a DirtyGrrrl!
<> Lingerie <> Clubwear <> Swimsuits <> Costumes <> Accessories <> & More
