Forums / Setting Up Categories, Products, Attributes / Can I delete all the items that do not have an image?

Can I delete all the items that do not have an image?

Started by cpardy on 31 Jul 2014, 3:48 AM · Views: 700

Results 1 to 4 of 4
31 Jul 2014, 3:48 AM
#1
cpardy avatar

cpardy

New Zenner

Join Date:
Sep 2010
Location:
Canton, MA
Posts:
12
Plugin Contributions:
0

Can I delete all the items that do not have an image?

Is there a way I can delete all the items that do not have an image. I know this is a tricky one as when I added them with easy populate I did have a link to the image, but no image actually exists on the products I don't carry. I was hoping there was an easier way than having to make a list and go through manually.

Thanks in advance.

I Create things You'll Love & Cherish
www.cpardydesign.com
www.craftyhomesteader.com

31 Jul 2014, 9:49 AM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Can I delete all the items that do not have an image?

cpardy:

Is there a way I can delete all the items that do not have an image. I know this is a tricky one as when I added them with easy populate I did have a link to the image, but no image actually exists on the products I don't carry. I was hoping there was an easier way than having to make a list and go through manually.

Thanks in advance.

Wondering if image Manager: http://www.zen-cart.com/downloads.php?do=file&id=999 might be able to help. If at least the database entry could be updated to not have a path to an image, for items missing an image, then either as you said EasyPopulate or a sql statemment could be used to remove all of those products that don't have an image.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

1 Aug 2014, 4:30 AM
#3
cpardy avatar

cpardy

New Zenner

Join Date:
Sep 2010
Location:
Canton, MA
Posts:
12
Plugin Contributions:
0

Re: Can I delete all the items that do not have an image?

This is how I managed to do it. First, which was the tedious bit was looking up the model names of the missing files. I then went through my Excel file and put a 9 in the Status column and the Updated the database using easy populate. It took Much less time than manually doing it.

I Create things You'll Love & Cherish
www.cpardydesign.com
www.craftyhomesteader.com

1 Aug 2014, 3:07 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Can I delete all the items that do not have an image?

For future reference there are some utility plugins that can aid with similar maintenance:

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.