- Welcome to VirtueMart Forum.
VirtueMart Community Forum
News:
You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification
Recent posts
#21
General Questions / Re: OMNIBUS directive in Virtu...
Last post by hazael - March 23, 2025, 10:40:59 AMif you are using the Yootheme template to display a dynamic product page, you can implement this last code as a regular Joomla module.
In the modules folder, create a mod_lowestprice folder. And add 2 files: mod_lowestprice.php and mod_lowestprice.xml
in mod_lowestprice.php:
in mod_lowestprice.xml
In the modules folder, create a mod_lowestprice folder. And add 2 files: mod_lowestprice.php and mod_lowestprice.xml
in mod_lowestprice.php:
Code Select
<?php
defined('_JEXEC') or die;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Factory;
if (!class_exists('VmConfig')) {
require(JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php');
}
VmConfig::loadConfig();
if (!class_exists('VmModel')) {
require(JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php');
}
$productId = Factory::getApplication()->input->getInt('virtuemart_product_id', 0);
if ($productId > 0) {
$db = Factory::getDbo();
$timezone = Factory::getConfig()->get('offset');
$date = new DateTime('now', new DateTimeZone($timezone));
$today = $date->format('Y-m-d');
$query = $db->getQuery(true)
->select('price, date')
->from($db->qn('#__virtuemart_product_price_history'))
->where('virtuemart_product_id = ' . (int)$productId)
->where('date >= DATE_SUB(' . $db->quote($today) . ', INTERVAL 30 DAY)')
->where('date < ' . $db->quote($today)) // tylko ceny sprzed dzisiaj
->order('price ASC, date ASC')
->setLimit(1);
$db->setQuery($query);
$lowestPriceData = $db->loadAssoc();
$productModel = VmModel::getModel('product');
$product = $productModel->getProduct($productId, true, false, false, true);
$prices = $productModel->getPrice($product, [], 1);
if (!empty($prices['discountAmount']) && $prices['discountAmount'] != 0 && !empty($lowestPriceData) && $lowestPriceData['price'] > 0) {
$currency = CurrencyDisplay::getInstance();
$convertedLowestPrice = $currency->priceDisplay($lowestPriceData['price']);
$lowestPriceDate = date('d.m.Y', strtotime($lowestPriceData['date']));
echo '<div class="uk-text-small uk-margin-small-top"><span>'. Text::_('LOWEST_PRICE').':</span> <span>' . $convertedLowestPrice . '</span></div>';
echo '<div class="uk-text-small"><span>'. Text::_('LOWEST_DATE').':</span> <span>' . $lowestPriceDate . '</span></div>';
}
}in mod_lowestprice.xml
Code Select
<?xml version="1.0" encoding="utf-8"?>
<extension type="module" version="4.0" client="site" method="upgrade">
<name>mod_lowestprice</name>
<author>666</author>
<version>1.0.0</version>
<description>Module for displaying the lowest price in the last 30 days on VirtueMart product page</description>
<files>
<filename module="mod_lowestprice">mod_lowestprice.php</filename>
</files>
</extension>
You cannot view this attachment. #22
General Questions / OMNIBUS directive in Virtuemar...
Last post by hazael - March 22, 2025, 00:47:30 AMThere has been a lot of discussion here regarding the requirement to display the lowest price within the last 30 days according to the EU directive, but no one has offered a concrete solution.
I have created a very simple script that handles this task perfectly. It would be great if Max — who is not present here at the moment (perhaps currently on the front line, fighting for a free Ukraine 🙂) — could consider implementing this feature natively in VirtueMart once he returns.
In the meantime, here is a simple solution:
In the database (phpMyAdmin) we create a new table
--------------------------------------------------------
Now we create a php script of any name, which we put in any hidden place in the joomla folder:
The above script generates an up-to-date copy of the prices for each product. Prices older than 30 days are automatically removed from the database. The script overwrites or adds a new price entry for a given product only if its current price is lower than any previously recorded price within the last 30 days.
According to the EU Omnibus directive, only the lowest price from the last 30 days is relevant. This approach prevents generating unnecessary data and helps keep the database clean and efficient.
The script executes very fast, even in stores with a large product database.
It is recommended to schedule this PHP file via a CRON job to run once per day.
------------------------------------------
Now all we need to do is add a simple PHP code in our product template in the:
/com_virtuemart/productdetails/default.php
The above script will always display the lowest price within 30 days for the currently displayed product. The price will be automatically converted to the currently displayed currency ( unfortunately with the current exchange rate, but it's better than nothing ;-)).
The historical price will only display if the selected product has a price discount and the lowest historical price is more than 1 day old.
As a bonus - the lowest price will be displayed with the real date - i.e. the day on which the promotional action was in effect. This ensures that these prices will never be considered fictitious.
I have created a very simple script that handles this task perfectly. It would be great if Max — who is not present here at the moment (perhaps currently on the front line, fighting for a free Ukraine 🙂) — could consider implementing this feature natively in VirtueMart once he returns.
In the meantime, here is a simple solution:
In the database (phpMyAdmin) we create a new table
Code Select
CREATE TABLE IF NOT EXISTS `#__virtuemart_product_price_history` (
`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`virtuemart_product_id` INT UNSIGNED NOT NULL,
`price` DECIMAL(15,5) NOT NULL DEFAULT 0,
`date` DATE NOT NULL,
UNIQUE KEY `unique_product_date` (`virtuemart_product_id`, `date`),
INDEX (`virtuemart_product_id`),
INDEX (`date`)
);
--------------------------------------------------------
Now we create a php script of any name, which we put in any hidden place in the joomla folder:
Code Select
<?php
define('JPATH_BASE', realpath(__DIR__ . '/..'));
define('_JEXEC', 1);
require_once JPATH_BASE . '/includes/app.php';
use Joomla\CMS\Factory;
$app = Factory::getApplication('site');
if (!class_exists('VmConfig')) {
require(JPATH_BASE . '/administrator/components/com_virtuemart/helpers/config.php');
}
VmConfig::loadConfig();
if (!class_exists('VmModel')) {
require(JPATH_BASE . '/administrator/components/com_virtuemart/helpers/vmmodel.php');
}
$db = JFactory::getDbo();
$query = $db->getQuery(true)
->select('virtuemart_product_id')
->from('#__virtuemart_products');
$db->setQuery($query);
$products = $db->loadColumn();
$productModel = VmModel::getModel('product');
$date = date('Y-m-d');
foreach ($products as $product_id) {
$product = $productModel->getProduct($product_id, true, false, false, true);
$prices = $productModel->getPrice($product, [], 1);
$finalPrice = isset($prices['salesPrice']) ? $prices['salesPrice'] : 0;
// Pobierz ostatnio zapisaną cenę dla tego produktu
$query = $db->getQuery(true)
->select('price')
->from('#__virtuemart_product_price_history')
->where('virtuemart_product_id = ' . (int)$product_id)
->order('date DESC')
->setLimit(1);
$db->setQuery($query);
$lastSavedPrice = $db->loadResult();
if (is_null($lastSavedPrice) || (float)$finalPrice < (float)$lastSavedPrice) {
$queryInsert = "
INSERT INTO #__virtuemart_product_price_history (virtuemart_product_id, price, date)
VALUES (" . (int)$product_id . ", " . (float)$finalPrice . ", " . $db->quote($date) . ")
ON DUPLICATE KEY UPDATE price = VALUES(price)
";
$db->setQuery($queryInsert);
$db->execute();
}
}
$queryDelete = $db->getQuery(true)
->delete('#__virtuemart_product_price_history')
->where('date < DATE_SUB(CURDATE(), INTERVAL 30 DAY)');
$db->setQuery($queryDelete);
$db->execute();
echo '<script>window.location.href = "/";</script>';
echo '<noscript><meta http-equiv="refresh" content="0; url=/" /></noscript>';
exit;
The above script generates an up-to-date copy of the prices for each product. Prices older than 30 days are automatically removed from the database. The script overwrites or adds a new price entry for a given product only if its current price is lower than any previously recorded price within the last 30 days.
According to the EU Omnibus directive, only the lowest price from the last 30 days is relevant. This approach prevents generating unnecessary data and helps keep the database clean and efficient.
The script executes very fast, even in stores with a large product database.
It is recommended to schedule this PHP file via a CRON job to run once per day.
------------------------------------------
Now all we need to do is add a simple PHP code in our product template in the:
/com_virtuemart/productdetails/default.php
Code Select
<?php
$db = JFactory::getDbo();
$today = date('Y-m-d');
$query = $db->getQuery(true)
->select('price, date')
->from('#__virtuemart_product_price_history')
->where('virtuemart_product_id = ' . (int)$product->virtuemart_product_id)
->where('date >= DATE_SUB(' . $db->quote($today) . ', INTERVAL 30 DAY)')
->where('date < ' . $db->quote($today))
->order('price ASC, date ASC')
->setLimit(1);
$db->setQuery($query);
$lowestPriceData = $db->loadAssoc();
if ($product->prices['discountAmount'] != 0 && !empty($lowestPriceData) && $lowestPriceData['price'] > 0):
$currency = CurrencyDisplay::getInstance();
$convertedLowestPrice = $currency->priceDisplay($lowestPriceData['price']);
$lowestPriceDate = date('d.m.Y', strtotime($lowestPriceData['date']));
?>
<div class="ominibus">
The lowest price in the last 30 days before the promotion:
<strong><?php echo $convertedLowestPrice; ?></strong><br>
The day was in force: <strong><?php echo $lowestPriceDate; ?></strong>
</div>
<?php endif; ?>The above script will always display the lowest price within 30 days for the currently displayed product. The price will be automatically converted to the currently displayed currency ( unfortunately with the current exchange rate, but it's better than nothing ;-)).
The historical price will only display if the selected product has a price discount and the lowest historical price is more than 1 day old.
As a bonus - the lowest price will be displayed with the real date - i.e. the day on which the promotional action was in effect. This ensures that these prices will never be considered fictitious.
#23
Virtuemart Development and bug reports / Re: Sort by price bug
Last post by hazael - March 21, 2025, 15:22:02 PMI wrote a very simple script that will allow you to get around this problem 100% and Works only in Joomla 5
In the database in the table virtuemart_product_prices Add the column final_price:
In
administrator/components/com_virtuemart/models/product.php
change
to:
Create a PHP file of any name that you need to place (preferably) in the main Joomla 5 directory:
At the end, run this file on your website. It works 100%
You can also automatically run this file using the CRON command. Then the prices will always be as it should be.
This solution can also be used to display promotional prices or those with the lowest price from the last 30 days - what is required on many websites on which discounts are used. Here is an example of this solution:
https://forum.virtuemart.net/index.php?topic=152315.0
You cannot view this attachment.
In the database in the table virtuemart_product_prices Add the column final_price:
Code Select
ALTER TABLE `#__virtuemart_product_prices`
ADD COLUMN `final_price` decimal(15,5) NOT NULL DEFAULT 0 AFTER `product_override_price`;In
administrator/components/com_virtuemart/models/product.php
change
Code Select
case 'product_price':
(...)
break;
to:
Code Select
case 'product_price':
$ff_select_price = ' , IF(pp.override, pp.product_override_price, pp.product_price) as product_price, pp.final_price ';
$orderBy = ' ORDER BY pp.`final_price` ' . $filterOrderDir . ', p.`virtuemart_product_id` ' . $filterOrderDir;
$joinPrice = TRUE;
break;Create a PHP file of any name that you need to place (preferably) in the main Joomla 5 directory:
Code Select
<?php
define('_JEXEC', 1);
require_once __DIR__ . '/includes/app.php';
$app = Joomla\CMS\Factory::getApplication('site');
if (!class_exists('VmConfig')) {
require(JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php');
}
VmConfig::loadConfig();
if (!class_exists('VmModel')) {
require(JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php');
}
$db = JFactory::getDbo();
$query = $db->getQuery(true)
->select('virtuemart_product_id')
->from('#__virtuemart_products');
$db->setQuery($query);
$products = $db->loadColumn();
$productModel = VmModel::getModel('product');
foreach ($products as $product_id) {
$product = $productModel->getProduct($product_id, true, true, true);
$prices = $productModel->getPrice($product, [], 1);
$finalPrice = isset($prices['salesPrice']) ? $prices['salesPrice'] : 0;
$queryUpdate = $db->getQuery(true)
->update('#__virtuemart_product_prices')
->set('final_price = ' . (float)$finalPrice)
->where('virtuemart_product_id = ' . (int)$product_id);
$db->setQuery($queryUpdate);
$db->execute();
}At the end, run this file on your website. It works 100%
You can also automatically run this file using the CRON command. Then the prices will always be as it should be.
This solution can also be used to display promotional prices or those with the lowest price from the last 30 days - what is required on many websites on which discounts are used. Here is an example of this solution:
https://forum.virtuemart.net/index.php?topic=152315.0
You cannot view this attachment.
#24
Virtuemart Development and bug reports / Re: Sort by price bug
Last post by hazael - March 21, 2025, 12:40:03 PMadministrator/components/com_virtuemart/models/product.php
Maybe in 748
change to
It will work when the price is overwritten
However, if you mean sorting by rules for prices, which are located in the admin panel:
/administrator/index.php?option=com_virtuemart&view=calc
Sorting this is impossible, because these prices are generated directly in your template - as an end result.
Maybe in 748
Code Select
case 'product_price':
(...)
break;change to
Code Select
case 'product_price':
$orderBy = ' ORDER BY IF(pp.product_override_price > 0 AND pp.override = 1, pp.product_override_price, pp.product_price) ' . $filterOrderDir . ', p.`virtuemart_product_id` ' . $filterOrderDir;
$ff_select_price = ' , IF(pp.override = 1 AND pp.product_override_price > 0, pp.product_override_price, pp.product_price) as product_price ';
$joinPrice = TRUE;
break;It will work when the price is overwritten
However, if you mean sorting by rules for prices, which are located in the admin panel:
/administrator/index.php?option=com_virtuemart&view=calc
Sorting this is impossible, because these prices are generated directly in your template - as an end result.
#25
Virtuemart Development and bug reports / Sort by price bug
Last post by niosme - March 20, 2025, 16:47:44 PMProduct sort by price when price overrides exist and also child products exist, throws wrong sorting results.
How to fix that?
Latest version of virtuemart in VirtueMart 4.2.2 10908 with Joomla! 3.10.12
How to fix that?
Latest version of virtuemart in VirtueMart 4.2.2 10908 with Joomla! 3.10.12
#26
General Questions / Re: Download links
Last post by Jumbo! - March 19, 2025, 10:48:11 AMYou can consider using this plugin: https://extensions.virtuemart.net/product/products/shipment-for-virtual-products-detail.
#27
General Questions / Download links
Last post by artonweb - March 19, 2025, 08:12:20 AMHello.
Is there a way to sell products such as ebooks (in .pdf format)?
When a customer buys an ebook, Virtuemart sends him a download link for the purchased ebook.
Also, I would like to offer limited times (e.g. three times) to download the file.
Thank you in advance.
Is there a way to sell products such as ebooks (in .pdf format)?
When a customer buys an ebook, Virtuemart sends him a download link for the purchased ebook.
Also, I would like to offer limited times (e.g. three times) to download the file.
Thank you in advance.
#28
Plugins: Payment, Shipment and others / Re: Smart search in Virtuemart...
Last post by Eholov - March 18, 2025, 12:02:18 PMQuote from: Dud3 on January 20, 2025, 06:38:14 AMI've overhauled the complete data receiving part - the Virtuemart Models are now used.
Customfields are now indexed if they have the search parameter enabled.
Breakdesign CustomFilter customfields are supported too.
Added a new plugin to allow you (or show you) how to access the indexing part and customize it to your needs.
More or less all Virtuemart product/category/manufacturer variables are there available.
https://github.com/Dudebaker/Virtuemart-Finder
Thank you for integrating Virtuemart product search into Joomla Smart Search (Finder). Product search works for me, but it gives results in the form of articles, not Virtuemart products. Tell me, do your plugins have settings to change the type of search results or do I have to edit the components\com_search\tmpl\search\default_results.php and components\com_search\tmpl\search\default_result.php files myself?
#29
Virtuemart Development and bug reports / Building frontend URLs from ba...
Last post by Ghost - March 18, 2025, 07:59:31 AMBuilding frontend SEF URLs using Joomla\CMS\Router\Route::link() doesn't work. This check in vmrouterHelper::buildRoute() prevents it from working:
Code Select
if (!VmConfig::isSite()) return $segments; #30
Virtuemart Development and bug reports / Re: Pagination generate bad UR...
Last post by vdweb.cz - March 15, 2025, 21:48:36 PMStill its bug, that must be fixed...