Sorting products

Author	« Topic »	Page: of 2
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/22/2020 : 13:55:55 Is there a way to sort the products by pOrder DESC? I don't see that option in the Main settings? Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/22/2020 : 18:20:08 There should be up and down arrows in your admin and there is product order up and product order down there. Are you not seeing that? If not, please let us know what version you are on. Thanks, David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/23/2020 : 19:19:15 I'm on the latest version. In PRODUCT ADMIN, I'll sort by pOrder DESC and the results are not the same as Default Product Sort Order: Product Order. Even when I do by date... all the newest show up, but the order was wrong when compared to the rows that were entered when I imported the CSV. Terry (Redsei)
Phil ECT Moderator United Kingdom 7715 Posts	Posted - 09/24/2020 : 02:21:50 Hi Terry, I've just looked in the main settings of my admin and I see those sort options - click the link for a screenshot https://paste.pics/A7JBS * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/24/2020 : 05:16:11 I'm not saying that the options are missing... I'm saying that the results are different. For instance.... When I view within the product admin section I get... SourceSmack-colorful-purple-wave-refraction3 SourceSmack-murky-swirl1 SourceSmack-orange-frosted-scratch SourceSmack-dark-blue-swirl2 When I view how it shows online I get.... cropping-hair Double_linear-circle-alternatinggrid-12-0 Double_linear-circle-intersectinglines-12-0 The products order shown in the admin search is different than what shows online. Terry (Redsei)
Phil ECT Moderator United Kingdom 7715 Posts	Posted - 09/24/2020 : 05:18:51 Sorry Terry I misunderstood your question. That does seem strange so let's see if Vince can shed any light on that for you. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
dbdave ECT Moderator USA 10468 Posts	Posted - 09/24/2020 : 07:12:23 Is it possible you are using the product filter bar and you have selected a different sort on the front end of the website? That would override what's set in the admin. David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/24/2020 : 07:16:42 Nope... not using that at all.... Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/24/2020 : 09:28:21 Hi Terry, as a test, perhaps check the site with a browser you never use to be sure a cookie is not set in your primary browser that is forcing a different sort. Thanks, David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/24/2020 : 09:58:55 Way ahead of you on that... did all of that. One thing I didn't do was in the database utility, I didn't do was "Reorder images in database". Not sure what that would do... Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/24/2020 : 10:19:21 Ok Terry, sounds like you've taken some steps there, so as Phil suggests, we should let Vince investigate this one. I'm sure he'll be along shortly. Thanks, David
Vince Administrator 42874 Posts	Posted - 09/24/2020 : 10:34:15 I'm here . . . I'm here . . . Can you send FTP login details to my email (vince AT ecommercetemplates DOT com) and I'll have a look. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Vince Administrator 42874 Posts	Posted - 09/25/2020 : 02:55:59 quote: Nope... not using that at all.... You do seem to have the side filter and using that you can manually override the sort options. Have a look at the left of the products page and go down a bit to where it says "Sort Order". Can you try that to see if it solves the sort problem? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/25/2020 : 04:43:56 Sorry Vince my fault for not specifying. The issue is displayed on the index page. It’s set to show the newest images. That’s where the problem is. Terry (Redsei)
Vince Administrator 42874 Posts	Posted - 09/25/2020 : 04:57:11 Hi Terry After changing the sort in the filter bar a session value is written to remember the customer's preferred sort, which is kind of a feature normally. But if this is causing problems, just add this line before the include files in the index.php page... <?php $_SESSION['sortby']=''; ?> Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/26/2020 : 07:23:30 Thanks Vince... I tried this it has no effect. After looking at the display of images I have noticed that the images are indeed sorting from newest date. However, it then sorts alphabetically. Last attempt: Is there a way to sort by date and then NOT to sort alphabetically... but rather how it was entered in the CSV listing of rows? Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/26/2020 : 07:29:16 Hi Terry, have you entered any sort order in your products, a numerical value there? You should be able to force a sort that goes by those numbers. David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/26/2020 : 07:32:08 No unfortunately not.... they are all by name (which I'm not sure why I did... possibly SEO at the time). It may be a daunting task to go back and change all images and all zip files Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/26/2020 : 08:46:57 Hi Terry, I'm not sure we are talking about the same thing. This is the [red[Product Order:[/red] set on each product, in the product details of the admin, or on the quick entry menu in the admin. Once you set those, you can sort by that on the home page and that way you control the sort 100% David
Terry Paulhus Ecommerce Template Expert Canada 573 Posts	Posted - 09/26/2020 : 10:27:07 Your not confused David... I was.... my sort on the home page is sorted by newest images. I have now used date desc to show that. ( I was using prod order search... but that is something else) So using this sort, on the front page, it shows everything I uploaded yesterday (for instance). However, it's sorted by date and then by name. I just wanted the date and the order to which I had on the CSV file.... I have done another test, and uploaded 1 today and then uploaded 2 more today... all three show but not in the order I uploaded those. I don't think this can be done. I looked at doing your way and creating an order number for each item... but all in all I want it sorted by date. My mistake. Again I don't think it can be done that way—correct? Terry (Redsei)
dbdave ECT Moderator USA 10468 Posts	Posted - 09/26/2020 : 12:54:18 Hi Terry, if you want to force a sort by date, regardless of what a customer has selected to resort on your site, then you want my trick here - https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=108630 Just apply it to your home page instead of a custom "new-products" page like I use. Let me know if you have questions about that. David
Page: of 2	« Topic »