Re: [1.2.7] Changing sort order of products
There isn't anywhere that you can enter a page full of sort orders at a time (at least not in the cart admin).
The best way to approach this is to build an sql query that updates them all at the same time - if you know how to make Excel output a concatenated string, its very simple.
If you don't, then just grab the zip file I attached to this post - it contains an Excel file with two worksheets: the first one is simply a listing of product_id in the first column and sort order in the second. Populate those columns with your own data.
Then switch to the 2nd worksheet: you'll see 20 rows or so of sql queries that have been automatically created from the data in the on the first sheet.
Autofill those rows down the page so you have the same number of rows as you do on the first sheet.
Now copy the whole column, and paste it into a text editor like Notepad.
Save it to your hard drive as a .txt or .sql file.
Make a backup of your database before the next step!
Go to Admin > Tools > Install SQL Patches, use the browse button to locate that file, and upload it. Your update is done.
Last edited by bunyip; 8 Mar 2009 at 10:54 PM.
Neville
An assumption is what you arrive at when you get tired of thinking...
Bookmarks