Getting Started - Suggestions on how to organize photos for upload?

Print Page | Close Window

Suggestions on how to organize photos for upload?

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2179
Printed Date: 26-November-2024 at 5:00pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Suggestions on how to organize photos for upload?

Posted By: BlackReefDesigns
Subject: Suggestions on how to organize photos for upload?
Date Posted: 24-November-2008 at 6:21am

I have a new issue.

I have a spreadsheet created with over 800 products. I also have the images for each product in a folder on my local C:

The problem is, the image names do not correspond with the appropriate product SKU's.

I have already resized all the images, and the only thing that needs to be done before I upload them is to somehow assign them properly to the correct SKU in the spreadsheet.

What I have been doing thus far is manually going through the images - finding the appropriate product in the Spreadsheet, and renaming the Image the same as the corresponding SKU number.

I have to figure something else out, because I have only been able to make changes on 10 products in the last 15 minutes, and there is over 800 products total.

Any suggestion on what I should do?

Please advise..

-------------
Joe S.
BlackReef.net

Replies:

Posted By: Greg Dinger
Date Posted: 24-November-2008 at 10:05am

Yes, I have an idea. Recruit the client to help - with the explanation that frankly this is the penalty of running a store without image naming conventions. I cannot think of another way - it will simply be slow and tedious work without personal knowledge of the products. The best case is if you are sitting next to each other and they can identify each product while you scroll through the spreadsheet looking for the name they just uttered.

-------------
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: 24-November-2008 at 12:13pm

Hi,
It will still be tedious, but a faster method would be to work the other way round I believe, if it's you that ends up doing it and if you can recognise all the images.
i.e. Take each image in the order they come and look through the spreadsheet or the match.
P'haps move them to another directory as you rename them as well.

-------------
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: 24-November-2008 at 12:23pm

That's a good point Hamish. When I have a lot of images or other assets to deal with, I like to have a "completed" folder where I can move such items to. That makes it a lot easier to find the appropriate image as the list of outstanding files becomes shorter. I'd still encourage the client to help though - they will likely be far more familliar with the images, depending upon the nature of the products.

-------------
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: 24-November-2008 at 1:49pm

Hi Greg,
Indeed, I've never had enough detailed product knowledge to ID each photo, unless of course they have useful descriptive names which is pretty rare. That's my excuse and I'm sticking to it Wink

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

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