VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: marvays on November 08, 2022, 10:53:03 AM

Title: Saving the price over time
Post by: marvays 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?
Title: Re: Saving the price over time
Post by: sirius 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
Title: Re: Saving the price over time
Post by: StefanSTS 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
Title: Re: Saving the price over time
Post by: jjk on November 09, 2022, 12:10:15 PM
Quote from: marvays 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.

Do you mean this one?
https://eur-lex.europa.eu/legal-content/DE/TXT/?uri=CELEX%3A32019L2161 (https://eur-lex.europa.eu/legal-content/DE/TXT/?uri=CELEX%3A32019L2161)
Title: Re: Saving the price over time
Post by: Jörgen on November 09, 2022, 12:30:05 PM
Quote from: jjk on November 09, 2022, 12:10:15 PM
Quote from: marvays 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.

Do you mean this one?
https://eur-lex.europa.eu/legal-content/DE/TXT/?uri=CELEX%3A32019L2161 (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
Title: Re: Saving the price over time
Post by: sirius on November 09, 2022, 12:35:28 PM
yes jjk,

for example in my country France
QuoteLes 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
QuoteProfessionals 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
Title: Re: Saving the price over time
Post by: StefanSTS on November 09, 2022, 12:42:17 PM
Quote from: Jörgen on November 09, 2022, 12:30:05 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
Title: Re: Saving the price over time
Post by: Milbo on November 09, 2022, 16:19:32 PM
We show the old prices already, just crossed
Title: Re: Saving the price over time
Post by: Jörgen on November 10, 2022, 08:02:12 AM
Quote from: Milbo on November 09, 2022, 16:19:32 PM
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
Title: Re: Saving the price over time
Post by: StefanSTS on November 14, 2022, 19:45:07 PM
Quote from: Jörgen on November 10, 2022, 08:02:12 AM
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
Title: Re: Saving the price over time
Post by: pinochico on March 13, 2023, 16:25:59 PM
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 :)
Title: Re: Saving the price over time
Post by: I love Silver on June 12, 2023, 21:36:45 PM
Quote from: pinochico on March 13, 2023, 16:25:59 PM
We prepared plugin nit remover OTC 2023 (https://www.outlookindia.com/outlook-spotlight/nit%20remover-over-the-counter-6-most-effective-otc-supplements-2023--news-291578) 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 :)

I think it's a good try. :)
Title: Re: Saving the price over time
Post by: pinochico on June 14, 2023, 06:14:59 AM
yes:
https://www.minijoomla.org/extensions/virtuemart-extensions/price-history-for-virtuemart
Title: Re: Saving the price over time
Post by: Jörgen on June 14, 2023, 09:15:45 AM
The demo sais:
QuoteDeprecated: Array and string offset access syntax with curly braces is deprecated in

Jörgen
Title: Re: Saving the price over time
Post by: pinochico on June 14, 2023, 09:46:46 AM
ach :(

It is developing domain too and now we are working on other app.

Ok I install on different domain on the week end
Title: Re: Saving the price over time
Post by: Ideastyle15 on April 18, 2024, 23:08:36 PM
Hello,

I would like to buy this plugin, but I can't find it on your website. I have already written emails, but I have not received an answer.