Profile: Jackluv

4.2 now, and upgraded for many years. I have images stored on web, not database. There are 7 duplicates of every image in different sizes. I'm not sure how that happened but how do I know which ones are being used and which ones are not? And if I knew, how can I delete the extra ones easily? 35,000 images for 2000 products that have images. Thats a lot of images.,

Look for one or more of your excel cells exceeding the width of the corresponding database column, like a Name, Sku or GTIN over 400 chars.

I've never used the excel import, but I imagine it's handling categories, images, and attributes, etc too, so that's a lot of columns to search. I would start with 1 product at a time until you find the first that definitely fails. Then use excel formulas on that 1 failed product to determine the guilty cell, and truncate or handle as necessary for the remaining products in a final import.

That was the problem! Thanks for your help! Actually it was a "MetaDescription" that was very long I think. If not that, it was a couple SeName's that I shortened as well. But the MetaDescription was very long in a couple of them. Accidentally. What I did to quickly find them is make the columns wider one column at a time and it was easy to see what stood out as being too long.