andrew40 Posted March 17, 2006 Posted March 17, 2006 Does anyone know of a quick way to clear the products list. I have duplicate items and need to update clean list through EasyPopulate. But EasyPopulate only updates and adds, so I have ended up with a bunch of duplicates and need to start a fresh..
Guest Posted March 17, 2006 Posted March 17, 2006 quick and easy m8 - just use this: http://www.oscommerce.com/community/contri...,empty+database
andrew40 Posted March 17, 2006 Author Posted March 17, 2006 quick and easy m8 - just use this: http://www.oscommerce.com/community/contri...,empty+database Looks great, but I just want to empty the products in the db for a clean install not all the other setups..
Guest Posted March 17, 2006 Posted March 17, 2006 well, just use the parts of that download relating to products; you will need to clean ALL products tables, not just the products table itself (i.e. products, products_to_categories, products_descriptions, products_options, etc. etc.)
Guest Posted March 17, 2006 Posted March 17, 2006 You could use MyODBC through Microsoft Access. It dials in to your database using MySQL and allows you to edit or add information as you wish. MyODBC Install the connector as per instructions and then, just open Access/open file/scroll down to your ODBC Databases in file types/machine connections/your new connection and you're away.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.