Author Topic: How to get products to show in a particular order  (Read 1014 times)

Offline cymru78

  • Newbie
  • *
  • Posts: 29
  • Karma: +2/-0
    • View Profile
How to get products to show in a particular order
« on: February 19, 2022, 02:21:07 PM »
Hi, I have my Abantecart site up and running and I'm adding products (160 out of over 620 in total!)

I have my home page listed using the 'Latest Products' block and I have the settings set to show 'Date New to Old' but it's not quite the way I want it.
I would like my products to display based on the date the I have entered in the 'Date Available' box.

For example, let's say that the Date Available was 12 December 2021. When I add this product, I don't want it show on my home page (or Latest Products as is the case) above something that has a date of 12 February 2022.

Is there a particular way for me to do this?

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: How to get products to show in a particular order
« Reply #1 on: February 19, 2022, 09:53:34 PM »
One option. You can edit date added on the product table directly with sql

Offline cymru78

  • Newbie
  • *
  • Posts: 29
  • Karma: +2/-0
    • View Profile
Re: How to get products to show in a particular order
« Reply #2 on: February 20, 2022, 03:42:56 AM »
Thanks for replying.
Would you be kind enough to give me the directions for doing that?
« Last Edit: February 20, 2022, 04:15:57 AM by cymru78 »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5358
  • Karma: +269/-2
    • View Profile
Re: How to get products to show in a particular order
« Reply #3 on: February 21, 2022, 12:03:44 AM »
Hello.
Disable the latest block in the Home page layout https://abantecart.atlassian.net/wiki/spaces/AD/pages/11763764/Pages+Layouts
Create the new Data Listing block and show products you want to display on home page https://abantecart.atlassian.net/wiki/spaces/AD/pages/12713994/Data+Listing+block

Offline cymru78

  • Newbie
  • *
  • Posts: 29
  • Karma: +2/-0
    • View Profile
Re: How to get products to show in a particular order
« Reply #4 on: February 21, 2022, 02:42:00 AM »
Thank you. I'll take a proper look at this as soon as I have some time.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5358
  • Karma: +269/-2
    • View Profile
Re: How to get products to show in a particular order
« Reply #5 on: February 21, 2022, 05:33:29 AM »
Thank you. I'll take a proper look at this as soon as I have some time.

Hello. Please see how easy it is

Offline cymru78

  • Newbie
  • *
  • Posts: 29
  • Karma: +2/-0
    • View Profile
Re: How to get products to show in a particular order
« Reply #6 on: February 21, 2022, 12:51:13 PM »
I have had a quick look at this and I don't think it's going to do what I need it to do.
This only seems to be good for the products that I choose. That's not what I'm looking for.

I want the latest products to display on the front page in the order of the date that they were added and for it to do it automatically. If I was to use it this way, I feel that I would manually have to add every single new product that I add and I don't have the time to do that.
Maybe I'm wrong.

I think that the option mentioned earlier by someone else would be a good option, but I'm can't figure out how to actually do that solution.

Offline ChristopherWel

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: How to get products to show in a particular order
« Reply #7 on: August 28, 2022, 04:27:57 PM »
The front page in the order of the date that
added and for it to do it automatically. If I was to use it this way, I feel that I would manually have to add every single new product that I add and I don't have the time to do that.
Maybe I'm wrong.

 

Powered by SMFPacks Social Login Mod