Select Orders from Certain State / Tax Group

[mreigle]

Hi:

 

I have several thousand orders and I am trying to print all of the invoices from a certain state (Texas) so that I can easily do the state sales tax. Is there a module that does this?

 

If there are no modules, what would be the SQL type into phpAdmin to atleast get the order ID's of the orders from Texas?

 

select * from TABLE orders where ?? == "TX"

 

Any ideas?

[mreigle]

I answered my own question. To select all of the orders from a specific state with phpMyadmin, timply type:

 

select * from orders WHERE billing_state = "Texas";

 

(instead of texas, whatever state you're looking for)