Managing Sales Statistics and Purchase Report: Difference between revisions

From osCommerce Wiki
Jump to navigation Jump to search
m (Changed protection level for "Managing Sales Statistics and Purchase Report" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading])
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''Note: This manual is for osCommerce v4.'''
After you accessed the admin area of your website, click on the '''Reports''' and '''Sales statistics''' tabs. You can choose the '''precision''' options from the drop down lists and the calendars, adding a month and year to compare, as well as check/uncheck the box next to '''products details'''.


After you accessed the admin area of your website click on '''Reports''' and '''Sales statistics''' tabs. You can choose the '''procision''' options from the drop down lists and the calendars as well as check/uncheck the box next to '''products details''', '''choose orders''' options from the drop down lists, '''show charts''' options by checking the boxes next to the required options, '''reset''' or '''update''' by clicking on the corresponding buttons. You can also '''save''' a certain sales statistics '''as filter''' by filling in its name and clicking on the corresponding button next to it so it will appear under '''sales statistics''' drop down list. Each sales statistics can be '''exported''' either as '''CSV''' or '''XLS''' by checking the radio buttons and clicking on the corresponding button.
It is also possible to '''choose orders''' options from the drop down lists, '''show charts''' options by checking the boxes next to the required options, '''reset''' or '''update''' by clicking on the corresponding buttons.  
[[File:Image 218.png|none|frame]]
 
If you scroll down this page you can see the corresponding charts according to the chosen chart options.
You can '''save''' certain sales statistics '''as a filter''' by filling in its name and clicking on the corresponding button next to it, so it will appear under the '''sales statistics''' drop down list.
[[File:Image 219.png|none|frame]]
 
Click on '''Puchase Report''' tabs. You can '''search by sales channel''' by checking the box(es) next to the required one(s), choose '''Date range''' from the drop down list, fill in '''Customer name''' or '''E-mail''' fields or choose the option from the '''Customer''' drop down list in the '''Customer''' section, fill in '''Model''' or '''Products Name''' fields or choose an option from '''Manufacturers''' drop down list in the '''Product''' section and fill in the fields or choose a '''country''' from the drop down list in the '''Shipping''' section. Then you can either '''reset''' or '''search''' by clicking on the corresponding buttons. The results of your search will be seen in the table below. You can also '''export''' the data by clicking on the corresponding button.
Each sales statistics can be '''exported''' either as '''CSV''' or '''XLS''' by checking the radio buttons and clicking on the corresponding button.
[[File:Image 220.png|none|frame]]
[[File:Sales Stat filter.jpg|alt=|none|thumb|801x801px]]
 
 
If you scroll down this page, you can see the '''corresponding charts''' according to the chosen chart options:
 
* '''''Sales Daily Statistics'''''
* '''''Orders'''''
* '''''Tax'''''  
* '''''Sub-Total, Total'''''
* '''''Shipping'''''
* '''''Amount Paid, Amount Due'''''  
[[File:Daily Stat.jpg|none|thumb|799x799px]]
[[File:Orders Stat.jpg|alt=|none|thumb|801x801px]]
[[File:Tax Stat.jpg|none|thumb|800x800px]]
[[File:Subtotal Stat.jpg|none|thumb|800x800px]]
[[File:Shipping Stat.jpg|none|thumb|800x800px]]
[[File:Amount paid Stat.jpg|none|thumb|802x802px]]

Latest revision as of 19:33, 25 September 2023

After you accessed the admin area of your website, click on the Reports and Sales statistics tabs. You can choose the precision options from the drop down lists and the calendars, adding a month and year to compare, as well as check/uncheck the box next to products details.

It is also possible to choose orders options from the drop down lists, show charts options by checking the boxes next to the required options, reset or update by clicking on the corresponding buttons.

You can save certain sales statistics as a filter by filling in its name and clicking on the corresponding button next to it, so it will appear under the sales statistics drop down list.

Each sales statistics can be exported either as CSV or XLS by checking the radio buttons and clicking on the corresponding button.


If you scroll down this page, you can see the corresponding charts according to the chosen chart options:

  • Sales Daily Statistics
  • Orders
  • Tax
  • Sub-Total, Total
  • Shipping
  • Amount Paid, Amount Due
Daily Stat.jpg
Tax Stat.jpg
Subtotal Stat.jpg
Shipping Stat.jpg
Amount paid Stat.jpg