VirtueMart Forum

VirtueMart 2.0
Joomla 1.7

I am in the process of implementing virtuemart - I want to include in the advanced search functionality price search ie if a client want search for items price range xx - yy.
Pls assist on what i need to adjust in the any other file. I have tried adjusting as per below and its not working.

$db =& JFactory::getDBO();

$query ='SELECT pr.virtuemart_product_id ,PE.product_name ,PE.product_s_desc ,pr.product_price FROM #__virtuemart_product_prices AS pr ';
$query.='LEFT JOIN  #__virtuemart_products_en_gb as PE on pr.`virtuemart_product_id` = PE.`virtuemart_product_id` ';
$query .='WHERE pr.product_price <50 ';
$query .= 'ORDER BY PE.product_name ';
//var_dump($query);

   
$db->setQuery($query);
$rows = $db->loadObjectList();
         
var_dump($rows);
die;
how to fetch values for product price i.e xx-yy , i think we have to used <form>

Thanks
rupesh

any body idea !!

i'm attaching the extended price range module for J1.5 and vm less than 2.0 ! so what i want is same module for VM2 and joomla 1.7 :'(?


thanks
rupesh.

[attachment cleanup by admin]

after working on it finally i have devloped price range module for vm2 ! but still thinks that any thing is missing!
Please help if i'm missing anything!
Thanks,
rupesh

[attachment cleanup by admin]

hi sir, i'm devloping a module for price range so i want to track a final price of the products but when i saw into the database table jos_virtuemart_product_prices "
It is storing actual "cost price" instead of final price! So where does the final price for the product is stored in vm2 database?  :o

[attachment cleanup by admin]

somewhere else i see the statement that the final price is NOT stored. Instead it is calculated "on demand".
afik this does not work out of the box and needs some caching mechanism to work.

Yes the final price is calculated taking into consideration taxes, discounts and any other rule applied for a price, so the query need to be much more complex than just a between.

We will integrate the price filtering in the custom filters extension but it needs some time to finish and be stable

Thanks for your reply sir!
But " where final price is  stored?" so that we can devlop a Price range module based on Final Price of the products!
and write queries taking consideration into Final Price of the products!
Thanking You,
rupesh

If you want it only for your own use, you can write a query with some "OR" taking into consideration the price rules applied in your site.
e.g. When the user writes 50 you can subtract the 20% VAT and search for the base price.

If you intent to develop that for general use, you have to take into consideration every single thing that can define the final price, so the query becomes more complex and with much more "ORs"

Thanks balai sir  for your reply !
I wrote this query which based on the product price :

$query ='SELECT pr.virtuemart_product_id ,PE.product_name ,PE.product_s_desc ,pr.product_price ,pm.virtuemart_media_id ,vm.file_url_thumb FROM #__virtuemart_product_prices AS pr ';
$query.='LEFT JOIN  #__virtuemart_products_en_gb as PE on pr.`virtuemart_product_id` = PE.`virtuemart_product_id` ';
$query.='LEFT JOIN  #__virtuemart_product_medias as pm on pr.`virtuemart_product_id` = pm.`virtuemart_media_id` ';
$query.='LEFT JOIN  #__virtuemart_medias as vm on pm.`virtuemart_media_id` = vm.`virtuemart_media_id` ';
$query .='WHERE pr.product_price > '.$_REQUEST['price_start'].' AND '.'pr.product_price < '.$_REQUEST['price_end'];

Can you plz modify this query so that it can consider Tax calculation ??
So the product is search based on price range including Tax and other rules also?

Thanks once again for your consideration!
Rupesh

Hi all. it's possible (or not) to call the Product Final Price.. ??

I am trying to find a way to add the very important Product Final Price in the Product List Column .. -> Administration page..
http://forum.virtuemart.net/index.php?topic=102281.0

Can someone help here, please ?!

Thanks!!

i think that at the start you have to take each product seperately and check which are the calculation rules applied to it. Getting the calculation rules for each product you can calculate the final price.

:S

rupesh: did you include the Products Price in Joomla advanced Search (com_search) ?!

Quote from: lipes on May 10, 2012, 03:55:03 AM
rupesh: did you include the Products Price in Joomla advanced Search (com_search) ?!

hey lipes,
untill now i tried to developed a price range module but without considerations of  tax and calculations rule!
see this
http://flyingcollections.com/index.php/price-range

but i'm trying to modify it by taking into consideration tax and calculation rules in future
i'm attaching my module here !
see attachment

[attachment cleanup by admin]

After install your module my page become blank other that ur input fields but not even search any result  :-[

hello sir,

Actually you have to load that module into article and then in the code ther is form action, so in form action You have to add article id !

Thts it!

If you have any problem then i will do it for you please PM me your joomla credentials!


Thank you
rupesh

or see price rANGE:www.flyingcollections.com

Hi. I am using in the VM2 and J2.5 the Rok Ajax Search:
Demo and download here: http://demo.rockettheme.com/extensions/?extension=rokajaxsearch

There are some problems that i am trying to solve / deal with ..
1 - with this fast and usefull Rokajax free module we cant see the User Joomla Search statistics ...
and 2 - I cant discover a way to insert any kind of php code of the Product price next the Product Name or Product Sku...
like i've find in this paid module: JoomNB VM Ajax Search Pro Module Demo: http://joomlamodule.net/index.php/vm-ajax-search-pro-module
or: http://demo.mooj.eu/index.php/virtuemart-pro-search-demo.html

I think that a website with this 2 things will get a powerfull search engine to know better what people need and search...

Quote from: lipes on September 01, 2012, 15:00:01 PM
Hi. I am using in the VM2 and J2.5 the Rok Ajax Search:
Demo and download here: http://demo.rockettheme.com/extensions/?extension=rokajaxsearch

There are some problems that i am trying to solve / deal with ..
1 - with this fast and usefull Rokajax free module we cant see the User Joomla Search statistics ...
and 2 - I cant discover a way to insert any kind of php code of the Product price next the Product Name or Product Sku...
like i've find in this paid module: JoomNB VM Ajax Search Pro Module Demo: http://joomlamodule.net/index.php/vm-ajax-search-pro-module
or: http://demo.mooj.eu/index.php/virtuemart-pro-search-demo.html

I think that a website with this 2 things will get a powerfull search engine to know better what people need and search...

hey lipes,

you are always hero member of virtuemart team, whenever anybody wants help you are ther!!

thanks for sharing  this features of joomla! Search opion is definately powerful feature and i will study the code of Rokajax  module!!


Thank you
rupesh

If you like check also the Custom Filters.

AFAIK is the only one which takes into account the shop's tax ,the price overrides  and the prices in multiple currencies trying to calculate as accurately as possible the final price.
http://breakdesigns.net/extensions/custom-filters

http://joomquery.com/d4j-virtuemart-price-searching-products-joomla-extensions/
D4J Virtuemart Price Searching Products is products filter using Price and Catergory very simple fast and and clearly configurable.
Deverloped by D4J – http://designforjoomla.com
++++ FEATURES++++

    No hacks to Joomla or Virtuemart core files or templates.
    Loading very fast, use Joomla and Virtuemart MVC, havent any extra Javascripts or Css files
    Special support for SEO (Search Engine Optimize) and SEF (Search Engine Friendly)
    Fully compatible all Browsers IE7+, Firefox 2+, Flock 0.7+, Netscape, Safari, Opera 9.5
    Using existing Layouts from Virtuemart by VmView class
    Options allow you easy to configuration, documentation detailed with screenshots
    Support for Joomla 2.5.x and Virtuemart 2.0.x
    100% FREE and Direct Download link



++++Screenshots++
(http://joomquery.com/wp-content/uploads/2014/03/d4j-virtuemart-search-for-price-range.jpg)

I understand your desire to promote your product .
But posting replies with no much relevance with the topic after 2 years, is not very helpful for this forum. Don't u think?

Also you did not wrote a word whether your price filter takes into account the calc rules which is the main issue on the topic