Magento report
- or -
Post a project like this3086
$$
- Posted:
- Proposals: 3
- Remote
- #923362
- Awarded
Description
Experience Level: Intermediate
General information for the website: Sell clothing
Description of requirements/features: We require a bespoke report creating, with the following exact features.
A report that shows us the total number of sales for each and every product, broken down by size, revenue, and whether they were sold via trade or retail. The report also needs to be time specific, i.e. we can search the dates we want.
So for example, when viewing a Tyco BMW custom T – this report should be able to tell us:
1*) A breakdown of how many Smalls, Mediums, Larges, XL’s, XXL’s and 3XLS we sold from EXAMPLE 1st January 2015 to 1st February 2015
2*) A total of how many items were sold (plus total revenue)
3*) How many of these sales were trade vs retail (quantity and revenue)
4*) A further breakdown of the different customer groups within ‘trade’ and general’
I have included an example below of points 1 to 4 above.
Size Total Quantity Sold (2*) Total quantity sold (Trade)(3*) Total quantity sold (Retail) (3*) Total Revenue (2*) Total revenue (trade)(3*) Total Revenue (Retail)(3*)
Tyco BMW Custom T
Date – 1st January 2015 to 1st feb 2015 L 95 65 30 £1,500 £900 £600
Breakdown of Total Revenue (Trade) (4*) Breakdown of Total Revenue (General) (4*)
Customer Group Quantity of products Revenue same idea as trade breakdown
UK Traders 30 £300
NON EU Traders 10 £100
EU Traders with VAT NO 20 £100
EU Traders No VAT No 5 £400
Total 65 £900
Here is a list of all the customer groups we class as ‘retail’:
Not logged in
General
Retailer
Retail Excl Vat
Here is a list of all customer groups we class as ‘trade’:
UK Traders (wholesale excl vat)
Non EU traders (Wholesale Incl vat)
EU traders (with Vat no.)
EU traders (no vat no.)
Tyco Employee 40%
PBM sponsor 50% off
George Georghiou Tyco
Doris
Extra notes: Please note that we require a fixed fee price only. We do not have a budget for this work, please submit your best price.
Description of requirements/features: We require a bespoke report creating, with the following exact features.
A report that shows us the total number of sales for each and every product, broken down by size, revenue, and whether they were sold via trade or retail. The report also needs to be time specific, i.e. we can search the dates we want.
So for example, when viewing a Tyco BMW custom T – this report should be able to tell us:
1*) A breakdown of how many Smalls, Mediums, Larges, XL’s, XXL’s and 3XLS we sold from EXAMPLE 1st January 2015 to 1st February 2015
2*) A total of how many items were sold (plus total revenue)
3*) How many of these sales were trade vs retail (quantity and revenue)
4*) A further breakdown of the different customer groups within ‘trade’ and general’
I have included an example below of points 1 to 4 above.
Size Total Quantity Sold (2*) Total quantity sold (Trade)(3*) Total quantity sold (Retail) (3*) Total Revenue (2*) Total revenue (trade)(3*) Total Revenue (Retail)(3*)
Tyco BMW Custom T
Date – 1st January 2015 to 1st feb 2015 L 95 65 30 £1,500 £900 £600
Breakdown of Total Revenue (Trade) (4*) Breakdown of Total Revenue (General) (4*)
Customer Group Quantity of products Revenue same idea as trade breakdown
UK Traders 30 £300
NON EU Traders 10 £100
EU Traders with VAT NO 20 £100
EU Traders No VAT No 5 £400
Total 65 £900
Here is a list of all the customer groups we class as ‘retail’:
Not logged in
General
Retailer
Retail Excl Vat
Here is a list of all customer groups we class as ‘trade’:
UK Traders (wholesale excl vat)
Non EU traders (Wholesale Incl vat)
EU traders (with Vat no.)
EU traders (no vat no.)
Tyco Employee 40%
PBM sponsor 50% off
George Georghiou Tyco
Doris
Extra notes: Please note that we require a fixed fee price only. We do not have a budget for this work, please submit your best price.
Giles B.
100% (10)Projects Completed
18
Freelancers worked with
10
Projects awarded
43%
Last project
24 Apr 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies