Roggie Posted March 2, 2010 Share Posted March 2, 2010 I have a site that does very little business... but I do need to see how many people ordered from teh site in 2009 and how much they spent... is there anyway to do this? R Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted March 2, 2010 Share Posted March 2, 2010 I have a site that does very little business... but I do need to see how many people ordered from teh site in 2009 and how much they spent... is there anyway to do this? R Look in the Reports section of the add ons. I use a very basic Sales Report by date range that outputs only to the screen. Your requirements may vary and would require a different one. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
knifeman Posted March 2, 2010 Share Posted March 2, 2010 I have a site that does very little business... but I do need to see how many people ordered from teh site in 2009 and how much they spent... is there anyway to do this? R I don't think that is possible in a stock shop. The website sends you an e-mail for every sale. Did you save them? Simply count them up. When you print the invoice to ship with your order, did you print a copy for your records? Enter the totals into a speadsheet or accounting program. Tim Link to comment Share on other sites More sharing options...
Guest Posted March 3, 2010 Share Posted March 3, 2010 This contribution summarizes daily, monthly and yearly sales including gross sales, taxes, shipping and other fee's http://addons.oscommerce.com/info/5961 Chris Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted March 3, 2010 Share Posted March 3, 2010 if it is just a one off,and you are familiar with mysql, you could run a basic query and export the output to excel for further manipulation. select * from orders, orders_products where orders.orders_id = orders_products.orders_id HTH KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.