Custom Sales Report

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Just wondering if there was a simple way to add/edit some of the feild we can choose when exporting our orders for accounting purposes.

Rght now product cart can tell us the shipped date, order details, total tax, , payment type and tax details.

But to find the data it just does a search by date of process, shipped or etc but we want to be able to get a report on categories.  So to be precise, we want to be able to search and get reports done on specific categories.

That way we can search our espresso machines category between to dates, and get the details on the products in that category that were ordered.  So when we do our report between date X and date Y, we can see all of the items in that category that were sold, and the details (payment type, tax details etc.)

Does anyone have a solution to this?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Espressotec Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2007 Location: Canada Status: Offline Points: 0	Post Options Post Reply Quote Espressotec Report Post Thanks(0) Quote Reply Topic: Custom Sales Report Posted: 28-June-2008 at 2:41pm
	Just wondering if there was a simple way to add/edit some of the feild we can choose when exporting our orders for accounting purposes. Rght now product cart can tell us the shipped date, order details, total tax, , payment type and tax details. But to find the data it just does a search by date of process, shipped or etc but we want to be able to get a report on categories. So to be precise, we want to be able to search and get reports done on specific categories. That way we can search our espresso machines category between to dates, and get the details on the products in that category that were ordered. So when we do our report between date X and date Y, we can see all of the items in that category that were sold, and the details (payment type, tax details etc.) Does anyone have a solution to this?
	Espressotec Sales and Services

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 11-July-2008 at 7:32am
	Hi, Have you tried the Custom Data Export & selecting the data you want - you can then download the data, load it into Excel or a DB and manipulate / filter it to your hearts content from there. I've not checked to see if it downloads the data you are after, but it's a pretty comprehensive selection list.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code