Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jul 2007
    Location
    Jakarta
    Posts
    358
    Plugin Contributions
    0

    help question Editing tables directly with phpMyAdmin

    I know that many may cringe at this, but just want to know what are the ramifications of editing product descriptions (product already added) via the phpMyAdmin program.

    I have many product descriptions to update with minor changes. Selecting product by product in the ZC Admin is laborious, so I figure I could just display the records using phpMyAdmin select the records I want to edit and paste in the changes to the descriptions. Walah! I could do quite a few in allot few clicks than if I used ZC Admin.

    I just want to know what ramifications should I be aware of? What logic am I bypassing by updating the descriptions this way?

    Of course I have a backup.

    also I had the notion to do the same with the attributes_image. I started out using GIF now I want to change some of the file names to PNGs. Doing this through the Attribute Controller would be murder!

  2. #2
    Join Date
    Nov 2003
    Posts
    1,987
    Plugin Contributions
    15

    Default Re: Editing tables directly with phpMyAdmin

    phpMyAdmin is a great fast tool for edits like that, I do not expect any problems.

    A more user friendly tool (for daily usage) is quick updates: http://www.zen-cart.com/index.php?ma...roducts_id=101

    For the image name edits you would need to make a small modification to the quick updates code though (currently it allows to browse the server for images but no direct filename edits).

 

 

Similar Threads

  1. MySQL to display changed tables / rows - phpmyadmin
    By DogTags in forum General Questions
    Replies: 2
    Last Post: 29 Sep 2011, 05:42 PM
  2. Replies: 2
    Last Post: 5 Dec 2010, 01:56 AM
  3. Faster way to remove tables in phpMyAdmin?
    By greenenergies in forum General Questions
    Replies: 1
    Last Post: 30 Sep 2010, 06:51 PM
  4. Editing Existing Tables with CSS
    By rob_opm in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 15 Apr 2009, 11:00 PM
  5. Is it okay to directly edit small data tables??
    By tlyczko in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 10 Mar 2008, 04:24 AM

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