Saving the price over time

[marvays]

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]

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

[StefanSTS]

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

[jjk]

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

[Jörgen]

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

[sirius]

yes jjk,

for example in my country France

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

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

[StefanSTS]

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

[Milbo]

We show the old prices already, just crossed

[Jörgen]

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

[StefanSTS]

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

[pinochico]

We prepared plugin vmpricehistory into VM, which store price long time (from setup) and show right info about sale on productdetail and show google graph.

In this time Im testing