This is a discussion on Mass deleting products and catagories,.. and other questions within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; In the test fase I have installed a lot of products and I want to delete them all. All the ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| In the test fase I have installed a lot of products and I want to delete them all. All the products with a manufacturer are deleted by deleting the manufacturer. How can I delete the products without a manufacturer ? To populate the database... Easypopulate works but not on a 5 MB CVS file with >17500 lines Someone in the forum wrote about a pdf of the complete DB structure. Where can I find this pdf file? Thanks in advance, Maurice Lucas |
|
#2
| |||
| |||
| you can go to a dos or unix promt and type the folowing and press enter after each line. mysql use database (database being the name of the database you are using) delete from customers; this will delete everything in the customers table and leave the structure untouched. |
|
#3
| |||
| |||
| Quote:
Thanks, Maurice Lucas |
|
#4
| |||
| |||
| The pdf is called tep_database-pr2.2-CVS.pdf and is in the root where you installed OSC. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Possible Bug with SEO URL's? Adding and Deleting Products | groggory | osCMax v2 Features Discussion | 3 | 01-29-2006 07:51 PM |
| catagories & products HELP!!! | krystaleyes | osCMax v2 Installation issues | 0 | 11-11-2005 12:44 PM |
| 2 questions (STMP & text field under New products) | dunik | osCommerce 2.2 Modification Help | 2 | 03-25-2005 04:30 AM |
| no 'new products' displayed in 'sub-catagories'? | killermonkey | osCommerce 2.2 Installation Help | 4 | 02-15-2003 11:00 AM |
| deleting RHS of header | starchild | osCommerce 2.2 Modification Help | 2 | 12-09-2002 06:47 PM |