6 replies [Last post]
Zsigmon's picture
Offline
Joined: 11/09/2007
Juice: 64
Was this information Helpful?

Hey,

maybe it is a dumb question, but how can I delete more products, at once?
I'm just testing the CSV import module, it seems to work great, but now I have a few hundred of dummy/test products.
How can I drop them?
I cannot manipulate tables directly, becoz' my hosting provider does not grant any ODBC link to my DB.
Now the only way is through PHPMyAdmin.
Is there any other way for this?

Thanks,

Zsigmond

Zsigmon's picture
Offline
Joined: 11/09/2007
Juice: 64
Re: Mass-deleting products?

Actually deleting this way will improve my SQL skills, so not a big deal... Eye-wink
Just askin'...

Mariano's picture
Offline
Joined: 09/04/2007
Juice: 110
Re: Re: Mass-deleting products?

I think deleting the products through phpMyAdmin is not a bad option.
Anyway, did you try at admin/content/node ?

Maybe you could do some filtering and then under update options, delete everything you selected. However, I think it would be easier at phpMyAdmin =P

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Re: Mass-deleting products?

admin/content/node would be recommended... if you do it through phpMyAdmin, be sure to empty out the node and uc_products info, along with any corresponding data in the attribute/option tables and taxonomies. It could be messy depending on the products you were importing.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Re: Re: Mass-deleting products?

I'd use the content manager in Drupal at /admin/content/node. You can only do 50 nodes at a time, but it's easy to get all the products. Also, you're guaranteed to get all the node information out of the database. You might miss a few tables with just SQL.

Shawn Conn's picture
Offline
Administrator
Joined: 08/07/2007
Juice: 916
Re: Re: Re: Re: Mass-deleting products?

If you're going to uses Lyle's method you might want to use the checkall module for that. That's what I used when I was testing imports of product nodes. It made things a lot easier. I pity the fool that has to click 100's of check boxes individually.

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

Zsigmon's picture
Offline
Joined: 11/09/2007
Juice: 64
[SOLVED]

Thanks, that is what we need right here!
[SOLVED]