Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Sep 2007
    Posts
    128
    Plugin Contributions
    0

    Default Clearing my Products Completely

    My client has had a complete rethink of their category structure. This is a client with over 40,000 products. We have every single product in the new structure ready to upload but I really need to just dump everything in the existing product tables so far.

    I realize this could be dangerous for some people but we really want to start fresh and I don't want to reinstall the cart. Can anyone give an an idea of how I can drop every product? I've learned that deleting them through admin really doesn't make them go away.

    I am able to execute sql queries through PHPmyAdmin but I don't think it's a simple as dropping the products table.

    Any help is appreciated!

  2. #2
    Join Date
    Sep 2007
    Posts
    128
    Plugin Contributions
    0

    Default Re: Clearing my Products Completely

    I should probably also mention that there is nothing complicated about any of these products - no attributes and nothing other than straight across product creation.

  3. #3
    Join Date
    Sep 2004
    Location
    Western Massachusetts
    Posts
    2,945
    Plugin Contributions
    5

    Default Re: Clearing my Products Completely

    Deleting products and categories from admin does delete them completely, but it would take a long time to do with that number of products.
    To do it through phpMyAdmin is pretty simple - but I'd make a backup first just in case the client changes their mind again.
    From phpmyadmin, select the database so you see the complete list of tables.
    Select each of the following tables:
    products
    products_description
    categories
    categories_description
    products_to_categories
    products_discount_quantity *
    products_attributes *
    products_attributes_download *
    specials *
    featured *
    * only necessary if you have any data in them

    Once they are all selected, use the dropdown at the bottom of the list and select EMPTY - that will delete all of the entires in the selected tables.
    Neville
    An assumption is what you arrive at when you get tired of thinking...

  4. #4
    Join Date
    Sep 2007
    Posts
    128
    Plugin Contributions
    0

    Default Re: Clearing my Products Completely

    Yep - made a good backup. Thanks so much!

 

 

Similar Threads

  1. How to link from my "Featured Products" photos to a completely different website?
    By wsapp4 in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 12 Jan 2011, 10:15 PM
  2. Replies: 1
    Last Post: 20 May 2008, 12:01 PM
  3. How do I switch off New Products completely?
    By lockettpots in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 25 Jan 2008, 10:19 AM
  4. Clearing Test Database/Catagories/Products/Pictures
    By jtlswan in forum General Questions
    Replies: 0
    Last Post: 22 May 2007, 03:04 PM
  5. E-check clearing
    By disciple in forum General Questions
    Replies: 2
    Last Post: 11 Apr 2007, 03:12 AM

Posting Permissions

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