Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default Disable Product ID 3134 through to 3377 MYSQL Patch?

    When I go to a category in admin with these products, there's no way to set the sort order by Product ID. The drop down has 'Product Name' - 'Product Model'.. etc... but not Product ID. So, trying to disable a range of consecutive product ID's is a bit tedious. You can't just sort by ID and click the squares.

    Is there a MYSQL Patch that would disable a range of product IDs?

  2. #2
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default Re: Disable Product ID 3134 through to 3377 MYSQL Patch?

    Basically, I'm looking for the correct syntax to this:

    UPDATE products SET products_status = 0 WHERE products_ID '3134-3377';

  3. #3
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Disable Product ID 3134 through to 3377 MYSQL Patch?

    Quote Originally Posted by limelites View Post
    Basically, I'm looking for the correct syntax to this:

    UPDATE products SET products_status = 0 WHERE products_ID '3134-3377';
    How about
    UPDATE products SET products_status = 0 WHERE products_id > 3133 and products_id < 3378

    Cheers
    Rod

  4. #4
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default Re: Disable Product ID 3134 through to 3377 MYSQL Patch?

    Quote Originally Posted by RodG View Post
    How about
    UPDATE products SET products_status = 0 WHERE products_id > 3133 and products_id < 3378

    Cheers
    Rod

    perfect:

    UPDATE products SET products_status = 0 WHERE products_id > 3133 and products_id < 3378;

    Thank you, worked a treat.

 

 

Similar Threads

  1. Replies: 4
    Last Post: 13 Dec 2014, 04:48 AM
  2. v139h Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch ????
    By shags38 in forum Customization from the Admin
    Replies: 11
    Last Post: 20 Aug 2012, 04:19 AM
  3. Disable Products using Mysql patch?
    By smoke133 in forum General Questions
    Replies: 7
    Last Post: 10 Jun 2009, 06:16 AM
  4. MySQL patch question
    By isaiah36 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 24
    Last Post: 21 Jan 2007, 02:15 AM

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