Page 1 of 1

Custom Report Builder

Posted: Mon May 14, 2012 11:53 am
by Jojordan
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?

Re: Custom Report Builder

Posted: Mon May 14, 2012 2:58 pm
by david-ebt
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?

Re: Custom Report Builder

Posted: Mon May 14, 2012 4:36 pm
by jmestep
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

Re: Custom Report Builder

Posted: Tue May 15, 2012 8:28 am
by Jojordan
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.