Standalone financial export dashboard that compiles live OpenCart inventory and order
data into downloadable CSV spreadsheets. Each button generates a timestamped file under
/userfiles/files/inventory/ and presents a direct download link when
processing completes.
- Current Inventory — exports active in-stock products with MPN, quantity, unit price, extended price total, unit cost (custom_field key 3), and extended cost total. A summary total row is appended.
- Last 6 Month Sales by Product — aggregates units sold and profit per product/price from completed orders (
order_status_id = 3) with date_added older than six months. Includes a profit total row.
- Date Products Sold Out — lists active zero-quantity products with price, cost, and the date of the most recent completed sale after 2016-06-01.
- CSV formatting — all values are quote-escaped; monetary columns use two decimal places.