Using ProductCart - Report for Missing Images

Print Page | Close Window

Report for Missing Images

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3790
Printed Date: 03-March-2025 at 1:29pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Report for Missing Images

Posted By: espresso4home
Subject: Report for Missing Images
Date Posted: 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?

Replies:

Posted By: Greg Dinger
Date 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/ - 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?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Hamish
Date 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.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: espresso4home
Date Posted: 17-June-2010 at 4:30pm

Greg Dinger wrote:

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?

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.

Posted By: espresso4home
Date Posted: 17-June-2010 at 4:46pm

Hamish wrote:

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.

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.

Posted By: Hamish
Date Posted: 17-June-2010 at 5:35pm

Good point!

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |