order products by value

  • Posts: 23
  • Thank you received: 2
11 years 6 months ago #102632

Hi

Web server crashed, so I have to setup everything again (yes, should have made a backup).

How can I by default show products in order of ascending value?

Cheers

Please Log in or Create an account to join the conversation.

  • Posts: 26151
  • Thank you received: 4027
  • MODERATOR
11 years 6 months ago #102654

Hi,

Where do you want to change the order ?
In the front-end, back-end ? In a menu ? A module ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
11 years 6 months ago #102661

Hi Jerome

I'm wanting to change in the front-end.

I had it on my previous installation - I think I may have modified some code - but can't remember what I did.

Cheers

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 6 months ago #102665

Hi,

Depending on which value ?

In the menu/module configuration, you can set the order via the option "Ordering direction" and the value on which you want to order via "Ordering field".

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
11 years 5 months ago #103535

Hi Xavier

I want to order my products within a category in ascending order using the field price_value

I cannot find an this option as the ordering field in the parameters.

Please Log in or Create an account to join the conversation.

  • Posts: 26151
  • Thank you received: 4027
  • MODERATOR
11 years 5 months ago #103548

Hi,

Ordering on the price is not possible and it has never been.
Between currencies, discounts, ACL, quantities... There are too variables to make a good and faster ordering.
But you can fill the "msrp price" and sort on this field.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
11 years 5 months ago #103592

Well it is possible, because I had it working on my site for nearly a year.


Ok, let's take a different approach.

I can create a filter on price.

How can I automatically apply this filter? That is, by default the filter is in ascending order -- the user doesn't have to select ascending from the drop down list.

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
11 years 5 months ago #103603

Hi,

There was never such option in HikaShop. Filters cannot be applied by default to a listing and the price_value cannot be used as an ordering value in a listing.
However, if you enter the retail price in your products, you can order them by retail price by selecting the product_msrp column in the "ordering column" option of your product listing menus/modules.

It is potentially possible to modify the product listing main MySQL with a hikashop plugin and add a left join to the hikashop_price table and order by the price_value if you want. The trigger to use is this one:
www.hikashop.com/en/support/documentatio...reProductListingLoad
That however requires to know programing so you might need the help of a developer.

The following user(s) said Thank You: elucidbusiness

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
11 years 5 months ago #104106

ok, so I've added a trigger to mysql to update the product_msrp field when the price_value field changes. This works well.

However, I now have common price showing on my website for the product view:

Common price: 49,70 € ($58.68)
Our price: $64.55 each


How do I hide the common price?

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 2
11 years 5 months ago #104110

Don't worry, fixed it.

The following user(s) said Thank You: Jerome

Please Log in or Create an account to join the conversation.

Time to create page: 0.100 seconds
Powered by Kunena Forum