Uploading Mass Pictures in Web Shop Manager

When setting upwards an online store, importing images has historically been one of the about painful activities, peculiarly for wholesalers with massive catalogs. That's why nosotros built a system that makes information technology quick to proceed your unabridged catalog updated.

With a scrap of spreadsheet magic and the power of the cloud, you'll save yourself from miserable hours painstakingly uploading images and pointing them to the right production. Simply a few edits to your product list spreadsheet are required and you're good to become.

While the guide is created for B2B Wave for running your B2B eCommerce portal, similar steps tin can exist followed for other eCommerce solutions.

Steps for Bulk Uploading Product Images

Bulk uploading is the procedure of uploading multiple images at in one case. It'southward a process that you can (and should) automate for the most office.

Bulk importing images is a straightforward procedure that's done in four steps:

1. Name your images
2. Upload your production images to animage management solution (Cloudinary).
3. Set up your spreadsheet for compatibility with B2B Moving ridge's "Import" tool.
4. Import your spreadsheet (new or modified) to your B2B Wave admin panel.
   

Name Your Images Accordingly

Let's say you lot take 3 products whose SKUs are 11010, 11020, and 11030, respectively. Rename 11010's product image with to 11010.jpg, same for 11020.jpg and 11030.jpg.

Information technology's important to note that our images are in .jpg format in the example above — but the B2B Wave platform too accepts .png images. Brand sure your product photos are in either of these formats (choice only one extension to stick to).

Create an Account to a Cloud-Based Epitome Management Solution Like Cloudinary

If you aren't currently using whatever deject service to shop your product images, it's time to beginning. We are going to apply Cloudinary in this article considering of its generous free plan.

Create a gratis account on Cloudinary, log in, and visit your Media Library (top left). Create a new folder (we are going with the proper noun product-images), and upload your product images by dragging and dropping them in there.

Important: If Cloudinary adds random letters to your prototype's names, visit the settings page (top right). Go to the Upload tab, and turn off "Unique filename" in the ml_default settings (in the Upload Presets section).

"Upload presets" is found nether the "Upload" tab in Settings (gear icon).

Click Edit, and y'all'll land on a tab that says Storage and Access. Toggle "Unique filename" and so that information technology is off.

"Unique filename" is establish under the "Storage and Access" tab when you click Edit on ml_default.

Now correct click your prototype and select "Re-create URL". It should look like this: https://res.cloudinary.com/**********/image/upload/five***********/production-images/10110.jpg

The 2 groups of asterisks represent your cloud and account's IDs, respectively. "product-paradigm" is the name of the folder yous created.

Preparing Your Spreadsheet for Import

Go back to your B2B Wave dashboard, click on the Export tab under Products, and export your product list.

Easy method

For each product epitome in Cloudinary, copy the image URL (right-click and Copy URL) and paste the URL to the Excel file in the image_url column (create it if information technology does not be). Practise this for every product that you want to alter the main image.

Advanced method

Look for the image_url column in the exported spreadsheet (create it if it does not exist), and give information technology a dynamic value with a concatenation of:

1. Your Cloudinary folder path — in our case URL: https://res.cloudinary.com/**********/prototype/upload/v***********/product-images/
2. The value from the product_sku cavalcade
3. The file extension of your images — eg .jpg

This lets you automatically update all of your product images at once. Suppose nosotros start from row 2, here'south how the formula in the image_url cell should look:

="https://res.cloudinary.com/**********/paradigm/upload/v***********/production-images/" & A2 & ".jpg"

Extend the function to your unabridged production list by selecting its prison cell and dragging the bottom right corner through the cavalcade. So, relieve the spreadsheet.

Importing Additional Production Images (optional)

Importing boosted images to each of your product's galleries follows a similar process as the method higher up.

First, ensure you have a standard naming scheme for your images. For example, attach "_A" to your product's main image'southward filename, and so "_B", "_C", and so on to the actress ones.

Adjacent, create columns named gallery_image_url1, gallery_image_url2, gallery_image_url3, etc. (up to nevertheless many images yous'd like to showcase).

Afterward, paste the formula we used for the main paradigm into the gallery_image_url1, gallery_image_url2, etc., columns. Edit the last part of the formula to match your production naming scheme (in bold below). For your product on row 2, gallery_image_url1 should look like this:

="https://res.cloudinary.com/**********/image/upload/5***********/product-images/" & A2 & "_B.jpg"

Your spreadsheet should wait like to this (ensure the rows don't match other rows).

The same goes for gallery_image_url2, where you'll supplant "_B.jpg" with "_C.jpg". Echo the procedure for each relevant column, then extend the formula to the rest of your spreadsheet.

Each boosted "gallery_image_url" column will crave yous to echo the process.

Important: It's common to accept a varying number of images for each of your products. Some volition accept i or ii — others will have 4 or more. You'll take to delete links you lot don't utilize from the cells manually throughout your spreadsheet.

The next (and last) stride is to import the spreadsheet we but modified. Become to your B2B Moving ridge dashboard, select the Import tab under Products, then striking the "Browse…" button. Select your spreadsheet, then hit Import.

B2B Wave'south import tool located in your admin dashboard

Note: Y'all don't need the Bulk import with column matching function since your production list comes from B2B Wave.

But, if you're using a custom spreadsheet, make sure your columns match the sample sheet. Our software lets y'all pick which columns exercise what — so as long every bit y'all stay consistent, you shouldn't have any problems.

You'll come across the "Imports log" window that'll prove you the import's progress. The log will tell you how many products were updated (should be all of them).

If your products already had an paradigm, importing will override it. Additional images — if present — will stay at that place.

Congratulations!

You've updated your entire product itemize in just a few quick actions. We recommend uploading product images this way considering of this method's scalability. And every fourth dimension you desire to add more than products (images included) to your itemize, you can just consign your listing.

Important: We recommend attempting to utilise this guide's method with 3-four products at first. If everything goes smoothly, you can repeat the procedure for your unabridged itemize. It won't take more than five minutes in one case you've learned the procedure, we promise!

Spend Time and Endeavor More Wisely with B2B Wave

When you have a lot of products in your catalog, uploading all of the images at once can experience daunting  — but with B2B Moving ridge, it'south effortless.

Yous upload your images to a cloud service, then use their URLs to populate your spreadsheet'southward image_url column. Since the cloud service has a predictable URL scheme, y'all can utilize this method for catalogs of any size. No affair if you have thousands of products or tens of products, it'll take you lot minutes, not hours, to update your list.

Do you lot desire to salve time on keeping your storefront updated? Request a demo today, and you'll be able to spend more than fourth dimension growing your wholesale business and less on inventory direction.

mccafferydeniess67.blogspot.com

Source: https://www.b2bwave.com/p/how-to-quickly-import-product-images-to-your-online-store

Share this post