Community Add-Ons

Maintainers: geoffreywalton
Add file to this package
Top » Other

Clear Down Data Base
for osCommerce Online Merchant v2.2

This contribution clears down your database ready to add your own products either to test with or in preparation of going live.

The database you get with osc contains products, categories etc that are fine to test with but at some stage they need to be removed.
Also as you test you will have added a shedload of products, test orders and customers, these all need to be removed.

This contribution clears down the tables I believe need to be emptied.

If you have customer extra fields or product extra fields or other tables that need to be cleared feel free to edit /admin/clear_db.php.

Support Thread: http://forums.oscommerce.com/index.php?showtopic=303600

Legend:  Download   Report
Expand All / Collapse All
Clear Down Data Base - Small fix snowbird 16 Nov 2008  

If you running with session_id in admin side when you click on any link parameters order gets wrong
Like:

clear_db.php?osCAdminID=7fa6b32506f2d8f4467bc326f52d78c1?action=cust

because of wrong usage of

tep_href_link(FILENAME_CLEAR_DB). '?action=prod">' ....

should be:

tep_href_link(FILENAME_CLEAR_DB, 'action=prod') . ">' ...

Full package including this fix.

Very usefull addon if you are running a test server. It works however some code controls needed for unavailable tables in db

V 1.2 geoffreywalton 11 Nov 2008  
Clear Down Data Base v 1.1 geoffreywalton 4 Jun 2008  
Clear Down Data Base geoffreywalton 27 May 2008