|
Report for Missing Images |
Post Reply 
|
| Author | |
espresso4home 
Newbie 
Joined: 11-May-2009 Location: New Jersey Status: Offline Points: 0 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Report for Missing ImagesPosted: 17-June-2010 at 2:53pm |
|
Another one of our PC web sites has 51k+ items. In the products file, we uploaded the directory paths for the images. The manufacturer gave us 36k+ images.
Is there any report functionality for the following in PC where we can see the items that have missing images? If not, does anyone have a quick script for this? |
|
 |
|
|
Greg Dinger
Certified ProductCart Developers 
Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 3:43pm |
|
Hello - that's quite a request. That number of images is going to require a lot of processing power to work through. We have this tool, but it is intended to do the reverse of what you are requesting:
http://www.greybearddesign.com/productcart/orphan-image-manager/ The tool first identifies what images are registereed within the database, then ascertains what images in the catalog folder are not associated with a product - and thus are "orphans".
Could I confirm your goal, perhaps two of them to be the following?
- which products do not have any image reference at all
- which products have an image reference but point to a non-existent or incorrectly named image
Is that what you need to do?
|
|
|
|
|
Hamish
Admin Group 
Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 4:03pm |
|
Hi,
Try the Custom Data Export and select the reverse import wizard - you can select to export the image information. This will allow you to identify missing images. If you upload the images and fill in the fields on the spreadsheet you will be able to easily update the products. |
|
|
|
|
espresso4home
Newbie
Joined: 11-May-2009 Location: New Jersey Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 4:30pm |
All of our image filed are named after the sku. The first one is easy by just downloading the product file with the image fields and seeing which ones are empty. It is the second one above that has become the problem to solve. There is a reference, but the actual image file may be missing from the server. And, yes, this can take server resources. |
|
|
|
|
espresso4home
Newbie
Joined: 11-May-2009 Location: New Jersey Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 4:46pm |
Yes, this identifies if the reference tot he file is missing, but if the reference is there, but no image file exists on the server, we would not know unless we combed through all 51k+ items. |
|
|
|
|
Hamish
Admin Group
Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 5:35pm |
|
Good point!
|
|
|
|
|
Greg Dinger
Certified ProductCart Developers
Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-June-2010 at 9:16pm |
|
Manual approach: I created a script that is a clone of the product search feature in the product admin section of PC. It lists all images associated with an image. We use it to allow a client to browse their store to visually review what product images are assigned to products, and make determinations if those images need to be replaced, resized, and so on. Running through the number of products you are using sounds like a brutal effort. For an automated process, I guess I would take an approach as follows. In the product admin there is the ability to upload products. when you wish to assign images to a product, there is a popup window that provides the option to index and then browse/select the available images. The index of available images is in a database table.
I would use that as a lookup table, and build a script that reads the product table, checking to see if the images in the product table appear in the image index table.
If you have a developer you work with they may wish to pursue this as a starting point.
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options
Greg Dinger wrote: