Caution: This post was published in 2015 and may contain information, techniques, or code examples that are no longer current. Please double-check official documentation and modern best practices before using anything from this article.

Useful Excel Commands for Magento Image Import

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.

My Magento Expertise

If you are planning a new e‑commerce store, considering a platform upgrade or looking for ongoing Magento support, I can provide the expertise you need. Based in Northern Ireland and working with clients locally and internationally, I deliver solutions that help businesses grow.

Contact me to discuss your Magento project

More Magento posts

Magento database structure

The database structure of Magento is designed to store and manage various aspects of an e-commerce website, including products, orders, customers, and more. Understanding the Magento database structure is crucial…

Continue reading

Accessibility in ecommerce websites

In the digital age, where online shopping has become an integral part of our lives, ecommerce websites hold the key to business success. Amidst the rush to create visually appealing…

Continue reading

Using Magento to get small businesses online

For small businesses aiming to establish a formidable online presence and drive sales, Magento emerges as a powerful e-commerce platform offering a suite of features tailored to their needs. Scalability…

Continue reading

How can I speed-up my Magento website?

Speed optimisation is crucial for a Magento website as it directly impacts user experience, conversions, and search engine rankings. You should prepare your server so it is set-up to use…

Continue reading