Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

How to display only cheapest product?


Recommended Posts



I have a big question. I want to display in each category the cheaper product that have the same name. for example:


product_id: 1234 | products_name: AMD Duron 1.1Ghz | price: 25.00

product_id: 2456 | products_name: AMD Duron 1.1Ghz | price: 27.00


I want to select the cheapest. I want to do this cause i buy the pruducts with several dealers en some time one is cheaper than others. I want to display the cheaper automagicaly.


The only way to know if the products is the same is with the product name.


Anyone have done this.


If someone knows, I will apreciate the share of his(her) code.




Sergio R. de la Garza

Link to comment
Share on other sites

I put code to only show one product with a similar name here. You should be able to modify it to display the cheapest one instead of the newest one.

In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...