Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    220
    Plugin Contributions
    0

    Default Expected date products - change date for all.

    Hi everyone

    Say you have 100 products you expect to have in december. And you you want to change the expecting date for all these 100. IS there a way to select all those products which this considers and then select a date and click update? Istead of having to do it manually 1 and 1 product.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Expected date products - change date for all.

    If the date you want to change is for December 22, 2010 ... and you want to set it to December 25, 2010 then you could use:
    Code:
    UPDATE products SET products_date_available = '2010-12-25' WHERE products_date_available >= '2010-12-22' and products_date_available < '2010-12-23';
    Before doing this, you want to make a backup of your database first ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Sep 2008
    Posts
    220
    Plugin Contributions
    0

    Default Re: Expected date products - change date for all.

    Quote Originally Posted by Ajeh View Post
    If the date you want to change is for December 22, 2010 ... and you want to set it to December 25, 2010 then you could use:
    Code:
    UPDATE products SET products_date_available = '2010-12-25' WHERE products_date_available >= '2010-12-22' and products_date_available < '2010-12-23';
    Before doing this, you want to make a backup of your database first ...
    Great idea. Thanks :)

 

 

Similar Threads

  1. Date Format for products expected
    By irishshopper in forum Basic Configuration
    Replies: 1
    Last Post: 13 May 2011, 02:01 PM
  2. Products Expected adds 2034 expected date
    By RobertG in forum General Questions
    Replies: 1
    Last Post: 6 Feb 2011, 01:00 AM
  3. How to Change Date Expected in All Products At Once?
    By dzkidz in forum Customization from the Admin
    Replies: 0
    Last Post: 30 Jul 2010, 08:05 PM
  4. Quick Question: Date Expected vs Date Added
    By ymbd in forum Setting Up Categories, Products, Attributes
    Replies: 14
    Last Post: 16 Aug 2008, 05:00 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