close

Necessary update of your password on PrestaShop Addons

Hello,

You are currently the holder of an Addons account created from your Paypal account, which allows you to connect to our marketplace.

In order to increase security and simplicity, we are implementing a single authentication system. Therefore, signing in with PayPal won’t be possible on our marketplace, from April 2nd on. Read morearrow_right_alt

To continue to access your personal space on PrestaShop Addons, we simply invite you to reset your password as of now by clicking on the link below.

You will receive a new password allowing you to directly sign in to your Addons account, without using PayPal. Once logged in, you will be able to change this password in your personal space.

Your Addons account will not be affected in any way by this development.

I change my password Continue with PayPal
menu
close search

Needs

  • shopping_cart Increase average cart
  • next_week Migrate my store
  • mood Increase customer satisfaction
  • show_chart Optimize conversions
  • group_add Increase traffic
  • computer Make browsing easier
  • access_time Save time

Features

  • computerDesign & Navigation
  • searchTraffic & Marketplaces
  • loyaltyPromotions & Marketing
  • descriptionProduct Page
  • paymentPayment
  • peopleCustomers
  • assignmentAdministration
  • shareFacebook & Social Networks
  • local_shippingShipping & Logistics
  • gps_fixedSpecialized Platforms
View all modules chevron_right
Key Features for your Business Sector

Key Features for your Business Sector

Great deals

Great deals

Modules developed by

Modules developed by PrestaShop

Style

  • Minimalist
  • Clean
  • Neutral
  • Original
  • Baroque

Business Sector

  • pets Animals & Pets
  • brush Art & Culture
  • directions_car Automotive & Cars
  • local_drink Drink & Tobacco
  • computer Electronics & Computers
  • shopping_basket Fashion & Shoes
  • restaurant_menu Food & Restaurant
  • local_florist Gifts, Flowers & Celebrations
  • healing Health & Beauty
  • home Home & Garden
  • store Jewelry & Accessories
  • child_friendly Kids & Toys
  • whatshot Lingerie & Adult
  • directions_bike Sports, Activities & Travel
View all templates chevron_right
Premium Templates Premium Templates
Email templates Email Templates

Growth and Development

  • Banking & Funding Banking & Funding
  • Website audit and optimization Website audit and optimization
  • Hosting Hosting

Help

  • PrestaShop Training PrestaShop Training
  • PrestaShop Support PrestaShop Support

Resources

View all resources chevron_right
  • User Guide User Guide
  • e-Commerce Calendar E-commerce Guide
Customize your store tabs with a favicon trending_flat
PrestaShop Addons - The Official Marketplace
close

check_circle The product has been added to your cart

Continue shopping View my cart
lock 100% Secure payment
close
Your data will be transferred to the Partner when you download this module.
close

I confirm my contact details to continue

close

Yummy, your shop will love it! Your product has been successfully downloaded Need a hand to install it in your PrestaShop store? Follow our tutorial: How to install a paid or free module Addons

Sales by products and by customers report Module

Price
$71.49 $49.49
Home > PrestaShop Modules > Administration > Data Import & Export > Sales by products and by customers report
Sales by products and by customers report

Sales by products and by customers report Module

favorite_border
favorite
Developed by Community developer
Best seller
V1.6.0.4 - V1.7.7.8
From V1.6.0.4 to V1.7.7.8

Gallery

module - Data Import & Export - Sales by products and by customers report - 1
module - Data Import & Export - Sales by products and by customers report - 2
module - Data Import & Export - Sales by products and by customers report - 3
module - Data Import & Export - Sales by products and by customers report - 4
See all screenshots (4)
Demo Back Office arrow_drop_up

Overview

Generate report of total sales based on time intervals, order statuses and more, for products or customers. With just few clicks you can generate powerful reports that answer complex questions about your sales activity with export to CSV and PDF.

What this module does for you

event_available Analyze your store activity
Merchant can monitor and analyze sales for individual products or product categories or have the report for total amounts of sales of all products. Based on information from the report, merchant can decide to update product prices, add reductions or coupon codes to boost sales. By using edit links for selected products, time can be saved. Similar type of report is available for Sales by Customer reports. Merchant can quickly identify most loyal customers and generate report on customer activity based on date intervals, order statuses and more.

Installation

- extract the downloaded .zip archive of this module to the /modules folder of your PrestaShop site.
- In your PrestaShop back office, navigate to Modules and Services
- under List of modules, navigate to 'Administration'
- find module named 'Product sales report' and click install

After installation menu 'Orders' -> 'Product sales report'.
is added to your back office. Click on added menu to start using this module.
NOTE: In case new menu does not appear, refresh you web page.  

Translation:
=> Localization
    => Translations
         => MODIFY TRANSLATIONS
                              - Type of translation: Installed modules translations,
                              - Select your theme
               => Modify
                   -  Module 'Product sales report'

You have a question ?

This developer answers your questions in:
en
message   Contact the developer

Technical sheet

Latest update

05/17/2021

Available in

en

PrestaShop Compatibility

V1.6.0.4 - V1.7.7.8

Compatibility MultiShop 

Yes info

Module version

V 2.3.2

Number of downloads

129

Documentation

Included

Developer

Community developer

Developer languages

en

Category

Data Import & Export

Features

PRODUCT SALES SALES REPORT

LIST OF PRODUCTS

Product sales report of this module displays list of products with calculated total sales for every listed
product. Fields 'Paid tax included' and 'Paid tax excluded' display the total sales
for every listed products. If shop uses multiple currencies, these values are displayed in the shop's default currency. Conversion rate from the database table 'ORDERS' is used to do the calculation for products sold in other currencies.
Data fields displayed in the table of listed products:
- Product ID
- Product reference
- Product name (if options to display combinations is enabled, product name includes attributes)
- Parent category
- Paid tax included
- Paid tax excluded
- Quantity sold
- Current wholesale price per product
- Sum of wholesale price per products. Wholesale price from the time when product was ordered is used (original wholesale price). If option "Use current product wholesale price to calculate wholesale prices" is enabled, then current wholesale price is used to calculate this sum.
- Available quantity in stock per product (or per product if option "Display product combinations" is enabled

USING THIS MODULE in combination with Delivery Dates Wizard Pro Module

Using this module in combination with Delivery Dates Wizard Pro Module is a powerful tool to generate list of products that must be delivered at specific dates in the future. This option was added based on inquires by customers who bought Sales by products module and wanted to generate product reports filtered by delivery dates set by Delivery Dates Wizard Pro.
NOTE: Delivery Dates Wizard Pro module is a module developed by another community developer and must be bought separately. For more details, please see description of Delivery Dates Wizard Pro Module on PrestaShop addons market place.

DATE-FROM DATE-TO SELECTION

This form enables to you display products sold withing specified date range, based of date of orders or delivery date (see options bellow). Filter is set by selecting values from date picker form to input values for fields 'Ordered from:' and 'Ordered to': (or 'Delivered from: ' and 'Delivered to: ' see options bellow).
Selected values are saved by clicking the button 'Filter by date' and used for further reports. To delete saved date filter, simply click to 'Orders from:' or 'Orders to' text field, delete the value and click 'Filter by date'.

ORDER STATUSES SELECTION

Order status filter selection enables you to display product sales with the selected order statuses.
For example, if you want to generate the report for all product sales that match predefined criteria: 'Waiting for Bank Wire payment', 'Waiting for PayPal payment', 'Waiting for Cash on delivery', you have to check these three statuses in the form 'Order State' and click 'Save'. Now, only products whose orders match checked statuses are listed. The report calculation is performed for the listed
product only.

SEARCH FILTERS

The list of products can be filtered to generate specific report. For example, you can generate report for all products from the specified parent category or generate report for individual products. It is possible to quickly search for individual products by entering partial or full text for product name or reference to text
fields in the header of the list.

REPORT

Bellow the list of products, total sales are displayed. This is the summed value for the total sales for all listed products. Summed values are displayed for:
- Total products (sum of all product sales for specified time interval, order statuses or other search filters if applied)
- Total products tax incl.
- Wholesale price total (sum of all wholesale prices for or listed product sales. Those are original wholesale prices as in the moment when product was ordered)
- Reductions (sum of all reductions for listed products)
- Reductions tax incl.
- Quantity discounts (sum of all quantity discounts for listed products)

DOWNLOAD PDF

By clicking “Download PDF” button, a complete document including the list of products and the report is generated. List of products saved to PDF can contain maximum of 50 products displayed as best selling products. (see options bellow.) Report of summed total sales is saved to PDF for all products applied by search filters (not just 50 best selling)

EXPORT

By clicking export button on the tool bar, the list of products is with the same details as in the browser list is exported to CSV file. The exported file can be opened and edited in Excel document or Google docs sheet.

OPTIONS

- Display the list of products separated by product combinations
- Display 50 top selling products in the PDF report
- Display product reference
- Display product parent categories
- Display total paid per product tax excluded
- Display total paid per product tax included
- Display total reductions per product tax excluded
- Display total reductions per product tax included
- Display wholesale prices
- Display quantity discounts
- Delivery Dates Wizard Pro (Filter by delivery date instead of order date)
- Display current wholesale price for listed products (product cost)
- Display available quantities for listed products (quantity in stock)
- Filter by delivery date (instead of Order date)
- Filter delivery date by Delivery Dates Wizard Pro Module (it requires module Delivery Dates Wizard Pro to be installed and option Filter by delivery date must be enabled)

CUSTOMER SALES SALES REPORT

LIST OF CUSTOMERS

Customer sales report of this module displays list of customers with calculated total sales for every listed customer. Fields 'Paid tax included' and 'Paid tax excluded' display the total sales
for every listed customer. If shop uses multiple currencies, these values are displayed in the shop's default currency. Conversion rate from the database table 'ORDERS' is used to do the calculation for orders made in other currencies.

Back office page 'Customer sales report' display list of customers with following columns:
- ID
- first name
- last name
- email
- default group
- newsletter (yes/no)
- opt-in (yes/no)
- group (default group customer is member of)
- newsletter (yes/no)
- opt-in (yes/no)
- total tax excluded (total value of all products bought by a customer for selected period of time, if date filter is set and for selected order statuses, if status filter is set. See more details bellow)
- total tax included
- orders (number of all orders customer made for selected period of time and with selected order statuses, if date and status filters are set)
- country code (if enabled in options)
- edit button (clicking the button opens edit page for selected customer)

DATE-FROM DATE-TO SELECTION

This form enables to you display customers that made orders within specified date range. Filter is set by selecting values from date picker form to input values for fields 'Orders from:' and 'Orders to':. Selected values are saved by clicking the button 'Filter by date' and used for further reports. To delete saved date
filter, simply click to 'Orders from:' or 'Orders to' text field, delete the value and click 'Filter by date'.

ORDER STATUSES SELECTION

Order status selection enables you to limit valid order statuses for the report. For example, if you want to generate the report for all customer sales that match predefined criteria: 'Waiting for Bank Wire payment', 'Waiting for PayPal payment', 'Waiting for Cash on delivery', you can check these three statuses in the form 'Order Status' and click 'Save'. Now, only customers having orders matching checked statuses are listed. If no status is selected, status filter is not applied. Thus, selecting no statuses has the same effect as selecting all statuses.

SEARCH FILTERS

The list of customers can be filtered to generate specific report. For example, you can generate report for all customers that assigned for newsletter and are members of specific group by selecting values in the header of the list of customers. It is also possible to quickly search for individual customers by entering text for customer’s firs name, second name or email to text fields in the header of the list.

REPORT

Bellow the list of customers, total sales are displayed. Those are summed values for total sales for all listed customers. Summed values are displayed separately in two columns for values with tax excluded
and tax included.
Total values displayed in report:
- Products (The sum of all values “total“ from the list of displayed customers)
- Shipping(Total sum of shipping costs for listed customers)
- Wrapping(Total sum of wrapping costs for listed customers. The display of
wrapping can be disabled, see options bellow)
- Discounts (The sum of all discounts for listed customers)
- Total (The sum of all products, shipping, wrapping and discounts)

DOWNLOAD PDF

By clicking “Download PDF” button, a complete document including the list of customers and the report is generated. List of customers saved to PDF can contain maximum of 50 customers displayed as top customers. (see options bellow.)

EXPORT

By clicking export button on the tool bar, the list of customers is exported to CSV file. The exported file can be opened and edited in Excel document or Google docs sheet. In addition to columns listed in the browser, total shipping and wrapping costs are exported to CSV.

OPTIONS

- Display country of the customer's address (shows country code of the customer's address)
- Display top customers in PDF report (shows 50 top customers sorted by total
values of sales in PDF report. To display the list of top customers in PDF the
same filters are applied as for the list of customer in the browser. Thus, showing
the same list as in the browser, but only the top 50 customers)
- Display wrapping costs (If enabled, wrapping costs are displayed in browser and
PDF report and exported to CSV)
See more
See less

Recommendation

This module runs on Prestashop versions 1.6 - 1.7
To display PDF documents generated by module, PDF reader software is needed.
To display reports exported to CSV, an application like Microsoft Excel or Open Office Excel is needed. Application must be configured to use "," as the column delimiter.

What's New in Version 2.3.2(05/17/2021)

  • Bug fixes

Support and updates

At the time of purchase, your Business Care subscription for your first year is automatically included, then tacitly renewed at the end of the period.

You can cancel your subscription at any time, before the end of the current period.

Services included in your subscription:

  • Security updates
  • Compatibility updates
  • Developments and upcoming features
  • Unlimited support

Want more details? Check out the most frequently asked questions about Business Care.


See more
See less

You have a question ?

This developer answers your questions in:
en
message   Contact the developer

About this developer

Listed products

2

Developer since

05/03/2015

Country

Slovenia

Support languages

en

Community developer

message Contact the developer

Frequently bought together

Total price:
$320.47
Add to cart
Price $71.49 $49.49
  • Official

    Official

    10,000 modules, graphic themes and services

  • 100% trusted

    100% trusted

    Your purchases and personal data are 100% secure

    100% trusted
  • 1-click installation

    1-click installation

    The modules you bought appear directly in your back-office

Explore

Learn

Discover us

Contact us

© 2007-2023 PrestaShop SA.
Legal notices Personal Data Protection Policy
Chat