12,478 items- need to get OSC to recognize images FTP'd

[my2002feathers]

I found a comment by someone that said:

You cannot have the images already on the server when you add them in the admin. They cannot already be there. osCommerce must grab them from your computer and upload them through the admin.

Please tell me there is a way around this! I have too many items to have to upload them one-at-a-time.

[Geotex]

I set up a cart with about 4000 items. I uploaded the images directly to the /image directory, and loaded image names to proucts.products_image using phpMyAdmin, though any program that can execute a text file or sql commands will work.

Do you have the items installed? you are dealing with several linked tables that have to be coordinated to get product id, description and categories aligned.

[my2002feathers]

I am using EZ Populate to upload a txt file for my catalog. The jpg name is listed in that uploaded file. When I go to modify the individual items, the jpg file name is shown on the "edit" screen but I get the red X'd box for the image. I'll browse and grab the jpg off my hard drive but it won't upload it because the image exists on the server. I'll have to use FTP to delete the server's jpg and edit the item again, browse and upload the image that way. Sometimes it works, sometimes not. Maybe because of the cookies and pages stored in my IE?

I have looked in phpMyAdmin and cannot find products.products_image. Where did you find this?

[Geotex]

Using phpMyAdmin

Open your database for the shopping cart.

The table is products.

Depending on modifications you have done (added big imgage, sm-med.-large images, or 3 images or any of the many other mods for images) the image column may have a different name. The default column is products_image. When you browse table products, you should have all your image files listed here.

If not, you can create a text file listing something unique, like products model

sql statement would be

UPDATE products SET products_image = "picture.jpg" WHERE products_model = "(your product model name, no quotes for straight numbers)";

This file is easy enough to create in Excel, inserting the above line for each image you need to upload. export as a csv, or text file, check in notepad.exe or equal, to make sure the syntax is okay.

Hope this helps.

George

[Geotex]

sorry for the double post on this....

Before you go to all that work, check your catalog/includes/configure.php to be sure that your image path is correctly defined.

define('DIR_WS_IMAGES', 'images/');

[jpf]

Remember to chmod the graphic files. 744 or 644 (read only) and the directory as 777 if your going to use the upload feature of HTML editor or such...

[jpf]

Originally Posted by my2002feathers

I found a comment by someone that said:

Please tell me there is a way around this! I have too many items to have to upload them one-at-a-time.

This is when you "add" a single item in the ADMIN interface and using the UPLOAD feature. You can't add a graphic using the upload feature and put it into a SUB-direcotry ether. You can still define the full file name (with subdirecotry if needed).

Using Easy Poplulate would be perfered with the graphic file full name (and sub directory path if used).

[my2002feathers]

Actually, I found what my problem was. As I saved my tab delimited .txt file to upload with EZ Populate, the jpg file definitions were losing their leading zeros. So as I defined a product jpg file as "0011683492.jpg" in the txt file, it was looking for "116683492.jpg". I simply renamed all the jpg files with leading zeros.

Now I've got to figure out how to get the manufactures image to show up after ftp. I'm going to look for a "manufacturer.php" file. Wish me luck.