Warning: Your browser is very out-of-date. You should upgrade to a better browser.

Magento image import can be pretty flaky with case and spaces in the filename of images being uploaded.

=CONCATENATE("/",SUBSTITUTE(LOWER(F2)," ",""))

The above code will add a “/” at the beginning of the file name (CONCATENATE), it will strip out spaces (SUBSTITUTE) and it will make the filename lowercase (LOWER), in this example for the file name in cell F2.

This will result in a filename like “B1268 ED100 red 3.JPG” being provided by the customer in their spreadsheet which could cause all sorts of bother being translated as “/b1268ed100red3.jpg” which won’t cause much bother when importing into Magento.

Of course, after changing the name of the file in the spreadsheet you’ll need to rename the actual files themselves. This can be easily achieved using something like Bulk Rename Utility which, as the name suggests will allow you to manipulate all the file names in a given directory by stripping out characters and making the filename and extension lowercase.

Magento

Magento is a feature-rich ecommerce platform built on open-source technology that provides online merchants with unprecedented flexibility and control over the look, content and functionality of their ecommerce store.

About Magento Ecommerce · Magento Posts

Related Magento Posts

Magento July 2021

Magento 2 Blog Extensions

While Magento isn't the go-to platform for blogs it can be useful for store owners to have a quick and easy way to post updated...
Magento April 2021

Notes: Magento 2 Directory Structure

## Magento 1 A brief reminder of the Magento 1 folder structure: * **app/code** followed by either * **/core** for core files * **/community** for...
Magento March 2021

Magento 2.4.2

The latest version of [Magento](/magento-ecommerce) has been released - Magento version 2.4.2 is the usual mix of security updates, performance and some improvements to the...

More Magento Posts...