Hi Scott,
How do I "Query the data from the smith_storeorders table using sql mgmt studio query analyzer"? I export my orders a few times a week as CSV files already. I need a breakdown of what was sales tax and what was product. There should be a way to do this without using a third party. Our old cart would allow me to create a report and it would look like this:
- Total Product Sales $X
- Tax $X
- Shipping Fees $X
This way I would not have to go through each individual order to see who was charged tax. Since this is an online store, we only charge sales tax in Texas. Please help!