Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Transaction report


Roggie

Recommended Posts

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...