1. General Reports
fmReports - General Reports Section
This section contains standard Shopping Cart Reports, such as Best Viewed Products, Best Purchased ones and Best Customers Orders (total).
At report page, which is opened after you select the report, this report can be viewed, saved, printed or edited. From this page you can export current report, let's say to Excel. There's also Edit page option that allows to edit report data and its layout (Text font, size, color, alignment, etc.,framing options can be selected). In case you'd like to change some field contents, doubleclick on it to get the Memo screen. Please note, that any of these changes made to a specific report will not be saved as a template change.
To edit one of report templates you have to run Report Tool and open an appropriate file. Download User's Manual to learn how to edit report templates. Remember that every report needs some data (as well as its template) in order to be displayed. To customize data for a report you have to modify its .sql files. SQL files are stored in Reports\SQL sub-folder Report can use one or more .sql files whereas one .sql file may be used in one or more reports. As for example all General reports are very similar and they use the same queries to retrieve data. To figure out which .sql is used in a report open this report using Report Tool and see fields.
Entire report field enclosed in square brackets . First part (before dot symbol) (1) is .sql file name where "SQL" is a part of the name replaced with "DBDataSet". Second part (2) (after dot symbol) is field name quoted with "".
To access list of General Reports, select Reports -> General Reports using Main Menu or left-side bar. Report page allows you to view, save or print each report. You can export current report, let's say to Excel. There's also Edit report option that allows to edit report data and their layout (Text font, size, color, alignment, etc., framing options can be selected).
You can choose to generate any of the following General Reports:
- Best Viewed Products
- Best Sellers
- Best Customer Orders - Total
Best Viewed Products Report
Best Viewed Products report shows you the rank of the best viewed products. If products have similar gradation, they'll be shown in alphabetical order. Best Viewed Products report shows you the list of Product names, their quantity in your store, number of viewing (overviews) and the total of products ever viewed.
Best Sellers Report
Best Sellers report is very similar to the Best Viewed Products report. The difference is that it shows you the list of products which are the most popular among your customers not visitors. If products have similar gradation, they'll be shown in alphabetical order. You'll see the list of your product names, quantity of items that are purchased and the total of products listed in the report.
Best Customer Orders Report
Like other general reports, this report shows you the list of customers, their order totals and the amount of unique customers listed in the report. If customers have similar order totals, they'll be shown in alphabetical order.