Product Sales Excel Report
Product Sales Excel Report
Geminate comes with an amazing feature of 'Product Sales Excel Report', where you can get two types of report as follows:
1. Itemised Report : It pulls all the item(s) of your sale order(s) which are already finished from selected date range based on two options:
1. By SKU : Whatever SKU code has passed, all matched product(s) with SKU will be pulled with their total qty, their sale price and cost price which derives gross profit. that helps to analyze the overall selling of that individual SKU each day.
2. By Product Category : Whatever Product Category has passed, all matched product(s) under that category will be pulled with their total qty, their sale price and cost price which derives gross profit. that helps to analyze the overall selling of that individual product category each day.
2. Summarised Report: 1. By SKU : Whatever SKU code passed, all matched product(s) with SKU will be pulled with their total qty, their sale price and cost price which derives gross profit in background and provides a final computed summary in total for that date range. that helps to analyze the overall selling of that individual SKU with various burn rates like 3 days, 5 days or overall selected date range for report run.
2. By Product Category : Whatever Product Category passed, all matched product(s) under that category will be pulled with their total qty, their sale price and cost price which derives gross profit in background and provides a final computed summary in total for that date range. that helps to analyze the overall selling of that individual product category belonging to products with various burn rates like 3 days, 5 days or overall selected date range for report run.
Watch Video Tutorial
Exciting Features
Supports SKU based Itemised Report.
Supports Product Category based Itemised Report.
Supports SKU based Summarised Report.
Supports SKU Category based Summarised Report.
Easy to analyze overall gross profit of SKU and Product Category.
Easy to analyze burn rates of SKU and Product Category.
Helpful for strategic planning and decision making.
User friendly and Handy to Use.
Note: Extensively Tested on Odoo Vanilla with Ubuntu OS
-
Go to 'Home Menu'.
-
Go to 'Sales'.-->'Reporting'.--> 'Product Sales Report'.
-
If you select 'From Date' greater 'To Date' then raised Warning.
-
Select 'Product By' and 'Type' and put the SKU.
-
Select 'Product By' and 'Type' and select the 'Category'.
-
Select 'Product By' and 'Type' and select the 'Category'.
It pulls all the item(s) of your sale order(s) which are already finished from selected date range.
all matched product(s) with SKU will be pulled with their total qty, their sale price and cost price which derives gross profit.
all matched product(s) under that category will be pulled with their total qty, their sale price and cost price which derives gross profit
It saves your precious time for their gross profit in background and provides a final computed summary in total for that date range.
Easy to use and quick to apply.
GeminateCS Odoo Services
GeminateCS Suggested Apps
Contact / Support
