Is anyone interested in helping me tweak the Monthly Sales and Tax Report? I can send you $50 USD using Paypal?
I am using version 2.3.1 found here:
http://www.oscommerce.com/community/contributions,539/category,all/search,monthly+sales
Here's what I would like to do:
Modify Nontaxed Sales Column:
1.) Change a column from "Nontaxed Sales" to "Cost Price"
2.) I would like this column to be similar to the "Product Sales" column but instead of getting the information from the "products.products_price" I would like it to grab the price from a newly created column called "products.products_cost" for the corresponding order ID.
Modify Taxed Sales Column:
1.) Change a column from "Taxed Sales" to "Taxes Paid"
2.) I would like the "Taxes Paid" column to calculate the taxes I paid on the cost of the items. This calculation is "Taxes Paid" amount multiplied by 0.13. Therefore, if the cost of an item was $100 I would like the Taxes Paid column to show $13.00.
Modify the Tax on Shipping column
1.) Change a column from "Tax on shipping" to "Total Profits"
2.) I would like this column to calculate the following for each month:
"Cost Price" minus "Shipping & Handling" equals "Total Profits"