phila3000 Posted September 18, 2005 Posted September 18, 2005 due to probably an Excel caused fault I have some zero prices in my shop which I now want to replace with the correct prices from my database backup file. Can anybody advise which part of the database file has to be copy/pasted into which file in order just to replace the product details (price, descriptions etc.) and `not to impact the whole rest of the database?
Guest Posted September 18, 2005 Posted September 18, 2005 use phpmyadmin and check the "products" table. Do a browse make sure the ids are the same with your backup. Then drop the table. Open the other table with phpmyadmin (you could make like a new dbase), export the "products" table. Switch to the new dbase import the "products" table. The products table has all the prices in it. with phpmyadmin you can also export selected rows in case the tables are different. Just watch the products_id field they must match. and backup associated dbases first
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.