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?
Custom Report Builder
Re: Custom Report Builder
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?
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Custom Report Builder
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
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
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
Re: Custom Report Builder
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.
Thanks for all the help.