Results 1 to 3 of 3
  1. #1
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Bulk Weight Change?

    Is there is SQL I could put in to change all listings from weight: 1 to 0.5 ?

  2. #2
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Bulk Weight Change?

    For all active product:
    Code:
    UPDATE products SET products_weight = '0.5' WHERE products_weight = '1' AND products_status = 1;
    Backup the database before executing. Above is written to consider being used in admin->tools->Install SQL Patchesm

    If using phpmyadmin, consider the use of the DB_PREFIX with the table name of products found just after the word "UPDATE".
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Re: Bulk Weight Change?

    Beautiful, thank you... I scheduled a full backup with my host.

 

 

Similar Threads

  1. v151 Bulk Weight Changes and Shipping
    By Christian_Wagner in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 15 May 2013, 08:15 PM
  2. v151 Tare Weight / Maximum Package Weight Functionality Change Help
    By jbible in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 17 Jan 2013, 07:17 PM
  3. Change sideblocks in bulk
    By gffb in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 2 Feb 2011, 05:14 AM
  4. Creating products to be ordered in bulk (i.e. by weight)
    By grummbo in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 14 May 2009, 07:02 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