osCmax v2.5 User Manual
Results 1 to 4 of 4

Mass deleting products and catagories,.. and other questions

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 ...

      
  1. #1
    Lurker
    Join Date
    Apr 2003
    Posts
    4
    Rep Power
    0


    Default Mass deleting products and catagories,.. and other questions

    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. #2
    Lurker
    Join Date
    Apr 2003
    Posts
    1
    Rep Power
    0


    Default

    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. #3
    Lurker
    Join Date
    Apr 2003
    Posts
    4
    Rep Power
    0


    Default

    Quote Originally Posted by kirk6677
    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.
    I don't have a ssh account so no unix prompt but phpmyadmin will do the trick.

    Thanks,
    Maurice Lucas

  4. #4
    Member
    Join Date
    Dec 2002
    Posts
    92
    Rep Power
    0


    Default

    The pdf is called tep_database-pr2.2-CVS.pdf and is in the root where you installed OSC.

Similar Threads

  1. Possible Bug with SEO URL's? Adding and Deleting Products
    By groggory in forum osCMax v2 Features Discussion
    Replies: 3
    Last Post: 01-29-2006, 06:51 PM
  2. catagories & products HELP!!!
    By krystaleyes in forum osCmax v2 Installation issues
    Replies: 0
    Last Post: 11-11-2005, 11:44 AM
  3. 2 questions (STMP & text field under New products)
    By dunik in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 03-25-2005, 03:30 AM
  4. no 'new products' displayed in 'sub-catagories'?
    By killermonkey in forum osCommerce 2.2 Installation Help
    Replies: 4
    Last Post: 02-15-2003, 10:00 AM
  5. deleting RHS of header
    By starchild in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 12-09-2002, 05:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •