Help Desk

Custom Reports are a great way to extract some information from your store's database.

Get to know Custom Reports here:

http://help.aspdotnetstorefront.com/manual/1000/default.aspx?pageid=custom_reports&SearchHighlight=Custom%20Reports&condition=exactphrase

Following the instructions on that page, you can build your own custom reports. The sample query on that page lists out a test report that will provide the email address, and billing zip code associated with every order taken on your store.

See below for a few more custom reports you might find useful.

Here's a custom report that will list out all customer addresses: 

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Addresses', 'All Addresses in Database', 'SELECT AddressID,CustomerID,FirstName,LastName,Company,Address1,Address2,Suite,City,State,Zip,Country,Phone FROM Address')

This one will give you a report of all categories in your store: 

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Categories', 'Categories currently in the store', 'SELECT CategoryID,Name,ParentCategoryID,Published,Deleted FROM Category')

Export a list of all products that don't have a SKU: 

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Products Without SKU', 'Products currently without a SKU value', 'SELECT Name,ProductID,SKU FROM Product WHERE SKU IS NULL OR SKU = ''''')

Looks like this was posted forever ago and I missed it. 

Has anyone else tried to make any custom reports in SQL? I'm curious if you've made any that were life-changing. I'll make sure to share my own once I get it working!