Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Help to clean out test entries in database


Recommended Posts



I am ready to go online with a new store but need to clean out all the sample entries such as customers and orders we have made in testing.


What is the best way to do this?


If I use phpMyAdmin what are the fields I need to export, clean in Excel then re-import clean?


Of course need the products left there.




Oz :(

Link to comment
Share on other sites

You're over-thinking this. Just go to your osCommerce admin control panel and delete the sample products and customers + orders.


You can delete sample manufacturers image folders and images via FTP, after you've run the deletes mentioned above.


Make sure that you have some real products, and at least one real customer before doing this - otherwise you may get the dreaded "1064 you have an error in your SQL syntax" error.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...