This script will only read from the mysql database. No mysql data will be changed. The scipt will create a report of all sales within the specified time period + total sales within taxable states. 1) Identify date range. Start Date = End Date = 2) Identify States which are taxable. There may be multiple states. States will be identified using their 2 letter abreviation. (example New York = NY) 3) Identify email address that report will be sent to. 4) Look in table "tracking" under field tracking_status. If tracking_status = "NS", "W", "PS", or "C" then include it below. (anything else can be skipped) Pending Shipment:NS Warehouse Processing:W Partially Shipped:PS Completed:C 5) Create a CSV report listing each order as documented in "[url removed, login to view]" (use date formation Month-Day-Year for title of file) tracking_date = copy from mySQL tracking_id = copy from mySQL tracking_stateprovtax = copy from mySQL tracking_total = copy from mySQL TOTAL_TAXABLE = SUM of all rows with tracking_stateprovtax = "State identified in Step 3)" * tracking_total TOTAL_SALES = SUM of all tracking_total 6) Email CSV to specified email address + save a copy on the server.