Author Topic: Saving the price over time  (Read 609 times)

marvays

  • Jr. Member
  • **
  • Posts: 451
    • richta.cz
  • Skype Name: marvays
Saving the price over time
« on: November 08, 2022, 10:53:03 am »
From the new year, the EU directive regulating the legislation in the area of displaying discounts and prices in e-commerce will enter into force.
In the event of an inspection, it will also be necessary to be able to document a specific price at a given time, i.e. save prices over time.
I have no idea how it will be in other countries...

Will VM be able to solve it somehow?

sirius

  • Jr. Member
  • **
  • Posts: 187
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Saving the price over time
« Reply #1 on: November 09, 2022, 09:53:39 am »
mmm...sounds like a last modification date column for prices will be needed, like the one for products.
But they are already here in the table #_virtuemart_product_prices: created_on,created_by,modified_on,modified_by
So we could make this column appear on the product list with something like "Since: + modified_on date of the price".
And a parameter in backend could prevent the modification of the price if date() - modified_on !>= one month (particularly in case of discount)
...just a suggestion
J3.10.11 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

StefanSTS

  • Global Moderator
  • Full Member
  • *
  • Posts: 585
  • VirtueMart Version: VM 4.2 on Joomla 4.5
Re: Saving the price over time
« Reply #2 on: November 09, 2022, 11:23:45 am »
How about making daily/weekly/monthly backups of your database according to the frequency of price updates?

Is there a link to a publicly available source for that EU directive?
I doubt that there is need to keep all past prices available in the shop system itself.

Regards
Stefan
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3751
  • using Matomo instead of Google Analytics
Re: Saving the price over time
« Reply #3 on: November 09, 2022, 12:10:15 pm »
From the new year, the EU directive regulating the legislation in the area of displaying discounts and prices in e-commerce will enter into force.

Do you mean this one?
https://eur-lex.europa.eu/legal-content/DE/TXT/?uri=CELEX%3A32019L2161
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3933
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Saving the price over time
« Reply #4 on: November 09, 2022, 12:30:05 pm »
From the new year, the EU directive regulating the legislation in the area of displaying discounts and prices in e-commerce will enter into force.

Do you mean this one?
https://eur-lex.europa.eu/legal-content/DE/TXT/?uri=CELEX%3A32019L2161
Showing the inspector a backup will certainly not fix this issue. A rolling 30 day table for items using discounts will probably be necessary.
As far as I understand this is only applicable to discounted items.
Regards
Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

sirius

  • Jr. Member
  • **
  • Posts: 187
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Saving the price over time
« Reply #5 on: November 09, 2022, 12:35:28 pm »
yes jjk,

for example in my country France
Quote
Les professionnels qui annoncent des réductions de prix sous forme de rabais ou de promotions doivent afficher le prix le plus bas pratiqué au cours des 30 jours précédents cette offre.
https://www.economie.gouv.fr/dgccrf/Publications/Vie-pratique/Fiches-pratiques/Annonce-de-reduction-de-prix
Quote
Professionals who announce price reductions in the form of rebates or promotions must display the lowest price practiced during the 30 days preceding this offer.
https://www-economie-gouv-fr.translate.goog/dgccrf/Publications/Vie-pratique/Fiches-pratiques/Annonce-de-reduction-de-prix?_x_tr_sl=fr&_x_tr_tl=en&_x_tr_hl=fr&_x_tr_pto=wapp
J3.10.11 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

StefanSTS

  • Global Moderator
  • Full Member
  • *
  • Posts: 585
  • VirtueMart Version: VM 4.2 on Joomla 4.5
Re: Saving the price over time
« Reply #6 on: November 09, 2022, 12:42:17 pm »
Showing the inspector a backup will certainly not fix this issue. A rolling 30 day table for items using discounts will probably be necessary.

Seems there is more than one issue.

1. Showing the lowest 30 day price.
2. Keeping all past prices available for inspection.

To solve the second issue, database backups should suffice.
The first issue can be solved in different ways, from a simple manually added custom field up to a dedicated database table.

That could be part of VirtueMart Core or available via a plugin.

Stefan
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10531
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Saving the price over time
« Reply #7 on: November 09, 2022, 16:19:32 pm »
We show the old prices already, just crossed
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3933
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Saving the price over time
« Reply #8 on: November 10, 2022, 08:02:12 am »
We show the old prices already, just crossed

Sorry, but this is NOT always the lowest price since 30 days ago.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

StefanSTS

  • Global Moderator
  • Full Member
  • *
  • Posts: 585
  • VirtueMart Version: VM 4.2 on Joomla 4.5
Re: Saving the price over time
« Reply #9 on: November 14, 2022, 19:45:07 pm »
Sorry, but this is NOT always the lowest price since 30 days ago.

It might not, but it could be used with a different language variable to say it is the 30-day-lowest if someone needs to show old prices.
The logic behind it could come from an external source, or by the shop owners brains depending on the size of the shop and/or the owners brains.

STS
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.