Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Questions
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 31st, 2012, 07:38 AM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default sorting and pricefilter - salesprice

Store ID: 1727z9pgtyc2oba4
Website URL: billigjumpsuit.dk
URL to page in question:

How do i set up the sorting mechanism to sort by salesprice if it exists otherwise take the ordinary price. Also how do i set up the prcefilter do sort by sale price, if any, or else sort by price?
  #2  
Old December 31st, 2012, 09:46 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

Currently, you can only set it up to sort by price or saleprice, but doing a conditional sort is not possible.

Eric
  #3  
Old December 31st, 2012, 10:00 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

Sorry, I'm wrong about that.

You have access to the sprice value which is what you need.

For example, in the sorting template you have this:
PHP Code:
       "price"   => "Price (low to high)",
        
"-price"   => "Price (high to low)"
If you change that to:
PHP Code:
       "sprice"   => "Price (low to high)",
        
"-sprice"   => "Price (high to low)"
Then products will be returned sorted low to high (or high to low) based on their "real" price (ie. the lowest price available for that product whether it be the regular price or sale price).

Eric
  #4  
Old December 31st, 2012, 10:05 AM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Smile

fantastic happy newyear !
  #5  
Old December 31st, 2012, 10:08 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Happy New Year to you, too!
  #6  
Old December 31st, 2012, 10:28 AM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default

Thanks!, it works perfectly on the soritng high to low, but unfortunately not on the "sorting widget", when i change from price to sprice nothing happens here, is there anyway to fix this?
  #7  
Old December 31st, 2012, 11:08 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

You need to change this:
HTML Code:
<ul>
  <li><a href="[server.url type='fullpage' query='price=-300']">Under 300 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=300-600']">300 Kr. ~ 600 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=600-900']">600 Kr. ~ 900 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=900-1200']">900 Kr. ~ 1200 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=1200-']">Over 1200 Kr.</a></li>
<ul>
To this:
HTML Code:
<ul>
  <li><a href="[server.url type='fullpage' query='sprice=-300']">Under 300 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=300-600']">300 Kr. ~ 600 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=600-900']">600 Kr. ~ 900 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=900-1200']">900 Kr. ~ 1200 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=1200-']">Over 1200 Kr.</a></li>
<ul>
Eric
  #8  
Old January 1st, 2013, 12:10 PM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default

Quote:
Originally Posted by Eric View Post
Hi,

You need to change this:
HTML Code:
<ul>
  <li><a href="[server.url type='fullpage' query='price=-300']">Under 300 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=300-600']">300 Kr. ~ 600 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=600-900']">600 Kr. ~ 900 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=900-1200']">900 Kr. ~ 1200 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='price=1200-']">Over 1200 Kr.</a></li>
<ul>
To this:
HTML Code:
<ul>
  <li><a href="[server.url type='fullpage' query='sprice=-300']">Under 300 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=300-600']">300 Kr. ~ 600 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=600-900']">600 Kr. ~ 900 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=900-1200']">900 Kr. ~ 1200 Kr.</a></li>
  <li><a href="[server.url type='fullpage' query='sprice=1200-']">Over 1200 Kr.</a></li>
<ul>
Eric
Hello Eric, i tried that, but i get this message "There are no products in this category" no matter which price category i choose
  #9  
Old January 2nd, 2013, 12:02 PM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default

Is there a way to solve the widget problem??
  #10  
Old January 2nd, 2013, 12:03 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

I haven't forgot about you. Still looking into this. I will update this thread as soon as I know more.

Eric
  #11  
Old January 2nd, 2013, 12:28 PM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default

thanks mate
  #12  
Old January 2nd, 2013, 02:05 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

Upgrading your Datafeedr plugin to the newest version should fix the issue.

Eric
  #13  
Old January 2nd, 2013, 03:38 PM
thk1976 thk1976 is offline
 
Join Date: May 2012
Posts: 232
Default

Thankyou very much
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
regarding sorting officialwatch Questions 1 October 26th, 2012 08:29 AM
about sorting officialwatch Questions 1 October 5th, 2012 09:10 AM
Sorting Feature feeriejade Questions 6 August 15th, 2012 07:58 PM
Sorting by Age lpimco Questions 2 October 4th, 2011 02:05 PM


All times are GMT -5. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.