surfalot Posted October 21, 2010 Share Posted October 21, 2010 (edited) Is there a way to wipeout all the products online and then reimport the file or will I have to manually go and enter all codes online first? Thanks Rob please backup your database just in case. The following script will clear all products for the default osc database. Run it in a utility that your host would offer like phpMyAdmin (popular free MySQL php database manager) DELETE FROM `categories`; DELETE FROM `categories_description`; DELETE FROM `manufacturers`; DELETE FROM `manufacturers_info`; DELETE FROM `products`; DELETE FROM `products_attributes`; DELETE FROM `products_attributes_download`; DELETE FROM `products_description`; DELETE FROM `products_notifications`; DELETE FROM `products_options`; DELETE FROM `products_options_values`; DELETE FROM `products_options_values_to_products_options`; DELETE FROM `products_to_categories`; DELETE FROM `specials`; Then import the products from easypopulate. You *can* avoid clearing your manufacturers and categories by leaving out the top four lines. Edited October 21, 2010 by surfalot Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.