Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    Berkshire, UK
    Posts
    1,482
    Plugin Contributions
    1

    Default [1.2.7] Changing sort order of products

    I've got about 200 products which I need to push into a manual sort order, and I'm having trouble finding the option in admin - I know I can got into one product, if I have one product to do, but I don't see where to enter a page of sort orders at a time. Any subtle pointers would be appreciated!

  2. #2
    Join Date
    Sep 2004
    Location
    Western Massachusetts
    Posts
    2,945
    Plugin Contributions
    5

    Default 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...

 

 

Similar Threads

  1. v151 Product Sort within Category - having problems changing the default sort order
    By Don Wagner in forum Customization from the Admin
    Replies: 4
    Last Post: 21 Oct 2012, 03:03 AM
  2. Changing sort order of products in attributes controller
    By way10c in forum Setting Up Categories, Products, Attributes
    Replies: 9
    Last Post: 9 Nov 2011, 12:21 AM
  3. Changing the sort order for order status
    By heavenlynights in forum General Questions
    Replies: 8
    Last Post: 20 Dec 2009, 02:46 AM
  4. Changing the sort order of the Products on the super invoice + packing slip
    By DisgruntledGeorge in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 14 Nov 2007, 12:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR