Results 1 to 2 of 2

Hybrid View

  1. 15 Jul 2012, 08:26 PM #1
    Terrill_Taylor
    Terrill_Taylor is offline New Zenner
    Join Date
    Aug 2006
    Posts
    94
    Plugin Contributions
    0

    Default How to bulk update the products last modified?

    Hello -

    I was hoping someone could point me in the right direction on what is really (I thnk) a MySQL question. I believe that an easy populate import created some bad dates in my products table (both data added and last modified. I am experiencing to negative results - old products are showing up in the new products view, and the date last modified is included in the sitemap.xml which google webmaster tools is comlaining about.

    I would to be able to bulk modify those date fields... help?! I'm fairly comfortable with SQL and sysadmin type stuff...
    Reply With Quote Reply With Quote
  2. 16 Jul 2012, 04:25 AM #2
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: How to bulk update the products last modified?

    Quote Originally Posted by Terrill_Taylor View Post
    I would to be able to bulk modify those date fields... help?! I'm fairly comfortable with SQL and sysadmin type stuff...
    Yes, you may update the last_modified_date field in the database.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
    Reply With Quote Reply With Quote
 

 
« Previous Thread | Next Thread »

Similar Threads

  1. Date problem on customers last modified
    By wirefram in forum General Questions
    Replies: 0
    Last Post: 4 Nov 2011, 10:25 PM
  2. last modified Date
    By purelypoultry in forum Basic Configuration
    Replies: 1
    Last Post: 28 Jan 2010, 12:06 PM
  3. show last modified products in what's new
    By 100asa in forum Templates, Stylesheets, Page Layout
    Replies: 9
    Last Post: 5 Oct 2007, 05:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

disjunctive-egg
Content and Graphics Copyright (c) 2003 - 2026 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC