Thread: Reports Wishlist

We are looking to add some additional reports to the admin site in a future release, so I thought I would check with the folks actually running the reports to see what kind of functionality you would like to see.

Let us know what you would like, and perhaps it will make it into an upcoming build

Thanks,

Dan

It will be usefull to get a report of all orders that have a specific product and a variant in them. We do not show orders as shipped till each and every item has been shipped and have to go back and look at each and every order manually one by one to see who ordered the item we got back in stock.
I am guessing it will be useful for others too.

It would be very useful to have a report which shows the contents of abandoned carts.

About this :
For multi-variant products, the inventory level for the default variant is used to determine if a product is shown. If the default variant has less than N, the product won’t be shown, even if other variants have inventory > N

Why hide all variants if some can still be sold ?
>> In product.VariantsInDropDown.xml.config, there should only be variants that have still inventory > 0.

Thanks

Xavier

I'd like to see a GROUP BY affiliate on the Orders page. We use affiliates to track our ads and it would be cool to be able to see the breakdown by affiliate/ad by day, month, year, etc.

Reports do not show Colors or sizes .. would be nice to have ...

Originally Posted by Roxannemm

It would be very useful to have a report which shows the contents of abandoned carts.

I second this request. No one has been able to tell me how to even find out how many abandoned carts there have been. Any help?

i was just looking at the admin dashboard page, you can change the stats shown by week / month etc, but how about by a specific date range?
also by last 30/60/90 days?

thanks!

Referrers by order.

Really easy ones:
1. add "cost" row to orders report
2. add "average order amount" to orders report

Tough one:
A report to help retailers know which items to re-order from their vendors. So, this would basically be a suped up best sellers report. This would give us huge advantage over competition. Report could tell us best sellers in last 7, 30, 60 days. Remaining Inventory. On-pace to sell out by xx/xx/xxxx. etc

Referrers by order.

i second this one.

Search stats:
I'd love to know what people are searching for on my site.

Keep them coming We are still watching this thread just so everyone is aware.

Report of users who do or don't wish to receive emails.

you have "orders by category" but not "orders by manufacturer".

also, the "order by category" report would be cool if we could see month over month sales for all categories. this would tell us best categories so we know which categories should be highlighted. if we see a category is trending up, we can feature that category or invest more in it.

Originally Posted by SRT

Report of users who do or don't wish to receive emails.

I second this one too.

Also: Referrer by order - absolutely!

Finally, it would be very useful to have the "Reports" link display on the navigation bar along side of: Misc Orders Taxes Shipping - instead of having to drill down a menu for the "Reports" drop down menu. I would think most store owners use the "reports" section multiple times a day. Having the "Reports" much easier to access on the navigation bar would be a great improvement over the constant drilling down to get to it.

Have the option to export reports in xls, txt or csv formats in addition to XML. This also includes the main "Manage Customers" section of the admin module.

Originally Posted by toofast

you have "orders by category" but not "orders by manufacturer".

also, the "order by category" report would be cool if we could see month over month sales for all categories. this would tell us best categories so we know which categories should be highlighted. if we see a category is trending up, we can feature that category or invest more in it.

We second this, would be great to show orders by manufacturer, by product.

Also, we'd like to see a report that shows the top customers by value and by number of orders over a date period.

I just got asked for a report that breaks down sales by credit card type / PO based on a date range.

Was also asked why there isn't a "Print Report" button. I know they can just print the page, however, they would like to print a report that doesn't include the stuff at the top of the page.

Originally Posted by SRT

Have the option to export reports in xls, txt or csv formats in addition to XML. This also includes the main "Manage Customers" section of the admin module.

I second this one!!

Originally Posted by SRT

Have the option to export reports in xls, txt or csv formats in addition to XML. This also includes the main "Manage Customers" section of the admin module.

I second this request.

I would like a report of all orders and the products in them that have yet to be fulfilled/shipped. That way we could just print off the report and head out into the warehouse to start packing the packages.

Please refer to this article about custom reports. IT works very well.

https://support.aspdotnetstorefront....barticleid=212

Just a thought!

In the Orders Bulk Printing Report i would like to see under the Ship to address column also the email address and what type of transactions it it like CC or purchase order etc.

thank you

Andrew

How about monthly statements... that's a kind of report..
Would be great to have for does using the system for BTB and Wholesale business.

Thank you

Another for an Inventory Report, with sizes, to filter by manufacturer based on a selectable quantity for the purposes of reordering.

Also for Orders, the ability to filter by Country, and also product on the order.

Thanks.

A customisable despatch note would be a great idea. I run a site where items are sometimes out of stock, with a lead time of a week or so. If a customer orders 2 items & 1 is out of stock, it would be nie to amend the despatch note to show that the other item will follow on.

I think reports does not show any colors or sizes. A report can be create which can be helpful for retailers when they want to go for re-order from the vendors. It would provide a competitive edge on competitors. This report would indicate the sellers performance of last XX days.

we export our orders into our accounting system and would love to be able to allocate coupon-ing to different departments. so.. what i would love is a order report for all orders with an additional column for coupon code used (if applicable) and if so coupon description (where we add allocated budget) and be able to export all of this to excel.

My shop has many sales outlets, so if the user chooses In-Store Pickup as shipping method, I'd like him to choose a pickup point from a list.

I'm trying to do it myself, we talk about it here
http://forums.aspdotnetstorefront.co....php?p=76039#5

I'm posting FYI, maybe it could be an interesting feature..

Originally Posted by SRT

Have the option to export reports in xls, txt or csv formats in addition to XML. This also includes the main "Manage Customers" section of the admin module.

I second this.

Be nice to know what products a product is a related or upsell product. If you take a product off-line you want to know what products are affected.

I'd like a report that shows the sales of particular products or categories by date to see how a promotion or new product works or how seasonality affects sales.

A report of all products that were giftwrapped. Of course, you will have added gift wrapping to your product!!!!!!!!

Nice to see what products were purchased as part of a kit or pack.

For reports on Failed Transaction, having more detailed information such as the order SKU # or Product name would help allow the staff to quickly follow up on declined transactions and help convert over more sales.

I think the Search stats would also be huge.

It would be nice to have price displayed in all the dynamic product pages (bestsellers, recently viewed products, related products, etc.)

Add Wire Transfer as a payment method.

Add ability to specify payment methods for given customer level.

For example:

Retail customers - credit cards
Wholesale customers - credit cards, checks
Export customers - Wire Transfer

That would be very helpful.

I would like to be able to specify minimum order amount per customer level. For example:

Retail Customer - no minimum

Wholesale Customer - $500 minimum

Export Customer - $2000 minimum

Right now under "Pricing and Promotion" we have only quantity discounts. It would be nice to have also discounts based on $ amount. For example, purchase $500 worth of products, get 10% discount, buy $1000 worth of products, get 15% discount.

Also, it would be nice to be able to assign discounts to customer levels, i.e. Retail only, etc.

For me knowing which manufacturers that have no products would be nice so I can unpublish them if nessasary.

The ability to have an AJAX address finder/filler would be nice.
I see it as a config where you could set your requests and map the responses.

Especially on the multiship pages. I've written one in 8 and it's a pain to rewrite it in 9 now.

Seems like report wishes can be never ending. I like the custom report, but would like to be able to export the results to excel,pdf, and xml

Sharona,

Compunix has a nice addon that while not really a report it can be used as a report tool. Essentially it allows you to write sql and execute it from within the admin. The result then can be exported to excel. The top (I think 10) sql statements are stored for you so you can rerun this same report without having to rewrite it.

I personally use this tool daily .. initially I had them write it as I was on a shared server and didnt have access to sql server management studio to run inventory reports ... im now on dedicated and have access but I love this tool so much I keep using it.

Yes, I've got clients who love the Compunix addon too. Jan, if you're reading this - make sure that we put it on the Extensions Marketplace, will you please? Please feel free to post a link here, too .... I have snarked at a few people for "blatant marketing" on this forum, but I want the message to be clear - if there is a member on this forum actively seeking help and someone else is actively marketing the solution, then for the seller to use the forum to point at a solution is absolutely fine. Encouraged, actually.

Thank you all so much guys! We very much appreciate your kind words here [blushing]. The link to the Get SQL Data report is here: http://www.ecommercecartmods.com/p-5...torefront.aspx

Don't blush Jan - it's deserved - this is indeed an awesome tool - I too use it daily & wouldn't be without it.


TTFN

BFG

I guess for me, a report on customers would be helpful. I know you can pull them up in the customers.aspx page, but a custom report that actually displays your customers and not just counts them. Or just grant the ability to export the customer list from customers.aspx.

I would think most store owners use the "reports" section multiple times a day. Having the "Reports" much easier to access on the navigation bar would be a great improvement over the constant drilling down to get to it.

It would be very useful to have a report which shows the contents of abandoned carts.

Hello, you mean like this one http://www.ecommercecartmods.com/p-1...torefront.aspx ? :-)

Here's a FREE report! Put it into your CustomReport section.

Code:

select 
	c.CustomerID, 
	c.email, 
	productid, 
	variantid, 
	productsku, 
	quantity, 
	productprice, 
	(quantity * productprice) as [Value], 
	sc.createdon, 
	c.firstname, 
	c.lastname 
from shoppingcart as sc (nolock) 
join customer as c (nolock) on c.customerid=sc.customerid 
join address as a (nolock) on c.billingaddressid=a.addressid 
where isregistered=1 
order by c.customerid desc, sc.createdon

Importantly this reports only the registered customers, as opposed to abandoned baskets of window-shoppers.

I'd love to see a REAL sales report

CATEGORY A
product A1 with quantity sold and extended prices
product A2 with quantity sold and extended prices
TOTAL CATEGORY A

CATEGORY B
product B1 with quantity sold and extended prices
product B2 with quantity sold and extended prices
TOTAL CATEGORY B

TOTAL DISCOUNTS
TOTAL SALES TAX
TOTAL SHIPPING

GRAND TOTAL

I'd like to be able to see a breakout between online and mobile sales.

I'd like to see a low inventory report.

Let us designate the threshold. If below that threshold, it shows up on report.

I'd like to see an Hourly Sales Report. Every good cash register has one, why not ASPDNSF?

if my newsletter goes out at 3pm, I'd love to see if that affected sales, without having to log in at 3pm and see what my total was prior to the email going out.

It would be good to have a report that shows Products/Variants and the image name associated with the product/variant and/or if it is Null. We have a lot of customers ask for this type of report on the various sites we have built.

Hmm, it sounds like you are after a missing images report for products? We have one for that: http://www.ecommercecartmods.com/p-1...torefront.aspx

I'd like to see a GROUP BY affiliate on the Orders page. We use affiliates to track our ads and it would be cool to be able to see the breakdown by affiliate/ad by day, month, year, etc.

Guys, you might be interested in this report which does the grouping and ordering information like that (on top of showing ordered items etc): http://www.ecommercecartmods.com/p-2...torefront.aspx