News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Saving the price over time

Started by marvays, November 08, 2022, 10:53:03 AM

Previous topic - Next topic

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

#1
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.12 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

StefanSTS

#2
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

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
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Jörgen

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
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

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
J3.10.12 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

StefanSTS

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
--
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

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

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

StefanSTS

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
--
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.

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 :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

I love Silver

#11
Quote from: pinochico on March 13, 2023, 16:25:59 PM
We prepared plugin nit remover OTC 2023 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. :)

pinochico

www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

Jörgen

The demo sais:
QuoteDeprecated: Array and string offset access syntax with curly braces is deprecated in

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

pinochico

ach :(

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

Ok I install on different domain on the week end
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products