Add purchase price of a product to see how much the shop has made in a specific time?

StartPrev 1 2 3 NextEnd
23.05.2025 14:03
#1
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Add purchase price of a product to see how much the shop has made in a specific time?

Hey
Maybe I am missing something, but wouldn't it be nice to see the revenue of a shop?
If we could add the price that we purchase our goods, this could be done easily?
revenue=selling price-purchase price multiplied by number of items sold.
And then a monthly/weekly statistic to see the revenue of the shop?
Or does this already exist?
EDIT:
https://www.webdesigner-profi.de/joomla-webdesign/shop/addons/income.html?lang=en
Would that do the trick? How does it know the purchase price?
Cheers
Rolf


Last change: 23.05.2025 14:05
 
23.05.2025 14:16
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

configuration / Shop functions
Purchase price : y

 
23.05.2025 14:22
#3
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Hey
Thanks!
So easy!
Will purchase later today!
And then I need to add purchase price and EAN to 200 products...maybe Export/Import or manually?

Cheers
Rolf


Last change: 23.05.2025 14:28
 
23.05.2025 14:44
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Addon Universal CSV Import
+
Addon Universal CSV Export

 
23.05.2025 22:26
#5
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Thanks
Bought and installed the addon "Income"

When I look at the last month, it says I had 16 orders, but I had 68.
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Aw: Add purchase price of a product to see how much the shop has made in a specific time?

What am I doing wrong?

Looks like certain order status are not counted. Delivered, for example...geliefert! in German.

Thanks
Rolf


Last change: 23.05.2025 22:32
 
24.05.2025 08:45
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Showing only paid orders.

see default_config.php or user_config.php
$config->payment_status_enable_download_sale_file = [5, 6, 7];

Status id 5,6,7

 
24.05.2025 09:27
#7
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Hey
Delivered orders were also paid and are part of the revenue? Waiting orders as well and sent orders, too.
What do I need to do to see all my revenue, no matter what the status is? Or all apart from open, since they are not paid?
Thanks
Rolf

 
24.05.2025 09:52
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

user_config.php
$config->payment_status_enable_download_sale_file = [5, 6, 7];

added status id

 
24.05.2025 11:09
#9
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Hey
Thanks, works!
If I add a purchase price now, I guess it is only for future sales, right?
And do I need to put it in user_config to make it update proof?
Cheers
Rolf

 
24.05.2025 12:34
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

- If I add a purchase price now, I guess it is only for future sales, right?
Yes

- And do I need to put it in user_config to make it update proof?
Yes. add to user_config

 
25.05.2025 17:18
#11
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Hmm
I have tried it now, but it takes the prices including VAT and subtracts the purchase price (without VAT).
It should always take the net prices without VAT on both cases, since the VAT may differ or there may be no VAT at all, depending on the country of the customer.
So it should be net selling price minus net purchase price. Everything else doesn’t make sense, we have customers around the world. Some of them buy without VAT, some of them with different rates within the EU.
VAT is never part of the income.

Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Both orders marked as red are the same product, my revenue per product is the same. One is going to Germany, the other to Denmark. One time 19% VAT, one time 25% VAT. Same profit, though, since I need to give the VAT to the German and Danish tax office :-)

Thanks
Rolf


Last change: 25.05.2025 18:45
 
26.05.2025 08:25
#12
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

There will be changes in the new version.

 
26.05.2025 08:46
#13
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Thank you

So that I can prepare: I will add the net purchase prices without VAT to all products, right?
Any ETA? Would be nice to start with it around the first of June.
Thanks a lot, very much appreciated!
Rolf

 
02.06.2025 08:20
#14
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Hey
Hope all is well. any news?
Thanks
Rolf

 
02.06.2025 08:27
#15
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Were busy with other extensions. Haven't started work yet.

 
03.06.2025 08:18
#16
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

hey
Okay, any idea how long it will take?
I can't use it right now, and paid for it.
But I understand if it takes some time.
Can I prepare stuff here? Like adding my net purchase price?
Thanks
Rolf

 
03.06.2025 11:38
#17
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

New version
Income 2.1.2

 
03.06.2025 12:08
#18
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Looks perfect!
Thanks a lot!!
Rolf

 
03.06.2025 14:29
#19
Dingens
User Dingens
Name: Rolf Wagels
28.03.2012
Posts: 957
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Will it start at zero after every update or is it just the case because it was a major update?
Thanks
Rolf

 
03.06.2025 15:02
#20
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28102
Quote
Aw: Add purchase price of a product to see how much the shop has made in a specific time?

Update added new filed in table Database (netto sell price)
Old orders do not have information about (netto sell price)

Not problem in update, problem in information "netto sell price" for old order.


Last change: 03.06.2025 15:02
 
StartPrev 1 2 3 NextEnd


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.