Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?



Find us on Facebook

Follow us on Twitter

View our YouTube channel


 All Forums
 Technical
 PHP (Unix / Linux / Apache) versions
 Sorting products
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author  Topic 
Page: of 2

Terry Paulhus
Advanced Member

Canada
474 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
8727 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
Advanced Member

Canada
474 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
7115 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
Advanced Member

Canada
474 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
7115 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
8727 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
Advanced Member

Canada
474 Posts

Posted - 09/24/2020 :  07:16:42  
Nope... not using that at all....

Terry (Redsei)

dbdave
ECT Moderator

USA
8727 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
Advanced Member

Canada
474 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
8727 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

39256 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

39256 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
Advanced Member

Canada
474 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

39256 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
Advanced Member

Canada
474 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
8727 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
Advanced Member

Canada
474 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
8727 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
Advanced Member

Canada
474 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
8727 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   
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2019 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000