Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Murfreesboro, TN
    Posts
    588
    Plugin Contributions
    0

    Default Inserting data into the products_description table with phpMyAdmin

    I did a site for a customer awhile back and when we did their site the product URL's were left blank. Now they want to export their data to be used on Google Base (a.k.a froogle) and individual url's are a requirement.

    I was able to extract the data using easy populate advance and then manipulate the data in excel. Now I want to put the data into the product_url column in the products_description table with phpMyAdmin if I can. For data safety reasos I have deleted all other columns in the excel text file to prevent overwriting any live data.

    Another concern I have is when I look at this table through phpMyAdmin, the products do not show up in id order. I want to also be sure that the right url's end up with the right products.

    tia...

    0be1
    "Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley

  2. #2
    Join Date
    Sep 2004
    Location
    Murfreesboro, TN
    Posts
    588
    Plugin Contributions
    0

    Default Re: Inserting data into the products_description table with phpMyAdmin

    Problem has been solved :o) Always better to use Open Office or some other non related Microsoft product to do delimited file edits.

    0be1
    "Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley

 

 

Similar Threads

  1. v150 Inserting a jpg into the footer
    By ocmusic in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 6 Jun 2013, 02:59 AM
  2. How do I import products in my newly hosted shop if i lost the data on phpmyadmin.
    By Oredayo in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 7 Oct 2010, 02:31 AM
  3. How to insert data into a new table
    By MCanes in forum General Questions
    Replies: 3
    Last Post: 19 Feb 2008, 11:19 AM
  4. Importing Table Data via phpMyAdmin and Excel CSV
    By webomat in forum General Questions
    Replies: 6
    Last Post: 16 Mar 2007, 12:52 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