Custom Report Builder

A forum where issues related to the DataPort utility can be discussed.
Post Reply
Jojordan
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Mon May 14, 2012 11:23 am

Custom Report Builder

Post by Jojordan » Mon May 14, 2012 11:53 am

I'm wondering if I'm capable of building a custom report on all the products
in my store. I want to be able to include all the item descriptions, sku
numbers, and each month how much quantity there was for each item. Is there
any way to build a custom report like this?

User avatar
david-ebt
Captain (CAPT)
Captain (CAPT)
Posts: 253
Joined: Fri Dec 31, 2010 10:12 am

Re: Custom Report Builder

Post by david-ebt » Mon May 14, 2012 2:58 pm

How would your report differ from the "Reports >> Products >> Sales by Product" report or the "Reports >> Products >> Product Sales Breakdown" report? Are you wanting to report on a time period greater than a single month as see each month's sales in a new column?
David
http://www.ecombuildertoday.com
Enhanced Reporting for AbleCommerce
Image

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Custom Report Builder

Post by jmestep » Mon May 14, 2012 4:36 pm

You can do it with our report and export wizard. If you can come up with a SQL query, the plugin will handle it. We have one client who has 90 queries saved in his site.
http://www.web2market.com/Report-Export-Wizard-P96.aspx
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Jojordan
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Mon May 14, 2012 11:23 am

Re: Custom Report Builder

Post by Jojordan » Tue May 15, 2012 8:28 am

It seems as if in the Reports >> Product >> Product Sales Breakdown report that it only pulls data that had any activity that month. I'm looking for an organized report that pulls every product we have on our store and the quantity breakdown for each month. Even if the month reports zero data for a specific product I would like to be able to see that there is zero quantity for that product. I was wondering if there was any organized report that would simply pull every product and indicate each month how much quantity there was for it.

Thanks for all the help.

Post Reply