Sales Dynamics

This section displays statistics on sales for the specified period. You can get a graphic presentation of information about the summarized cost of products purchased during this period, the quantity of items purchased and the number of orders placed in this period with “Processed” or “Complete” status. You can get statistics on sales within a specific category, a group of categories or all the categories in the store, and even trace the dynamics of how a specific product was sold.

The application performs a search based on the parameters specified in the form and produces a graph which can be used for quick evaluation of the store sales dynamics. The necessary degree of accuracy of the graph can be set by selecting the step (day, week, month, quarter, year). The search results can also be exported to MS Excel where a more accurate graph can be built. Export to MS Excel gives you the advantage of being able to choose the form of the graphical presentation of your data.

To get the application to produce a graphical presentation of sales dynamics in the ‘Sales dynamics’ section, do the following:

1. Select the period.

2. Select the step you want to use to break down the results: day, month, week, quarter, year.

3. Select the categories you want to include into the search results.

'Sales dynamics' search filters

4. Click 'Select product' and use the standard product search forum to choose the necessary one. When you have selected a product, you can click 'Clear' to remove it from search parameters.

5. Select which data you want to see: the total for all the sold items of the product; the quantity or the number of orders.

6. Click 'Search' to show the results or 'Export to MS Excel' to view or save an .xls file containing the sales dynamics.

Click 'Clear form' to delete all the search parameters.

Example.

You want to trace the dynamics of the number of orders placed at your store in the period April 1, 2006 – April 16, 2007 which are now processed / completed. Take the following steps:

1. Specify the beginning of the period: April - 1 - 2006.

2. Specify the end of the period: April - 16 - 2007.

3. Select the step for your graph (For example, Day)

4. As you are interested in all the sales made at your store, click on the ‘select all’ link to select all the categories. Do not use the 'Select product' button.

5. In the ‘Show’ line select the radio button next to 'Number of orders'.

6. Click 'Search'.

The results displayed to you will look like this:

'Sales dynamics' report results

Exporting the search results data to MS Excel, you get a file with a list of dates and the indication of the number of orders placed each day:

Export to MS Excel