Do you have a lot of pictures you want to upload to inFlow? If you have your pictures saved online, the Product Images import option is the best way to do so and illustrate your products!
Getting your images ready
In order to import your images, they must be stored online and have a public URL. If you have them stored locally on your computer, we recommend using Airtable to generate URLs for your images.
Uploading your images to Airtable
- Before uploading your images from your local computer to Airtable, your product images must be named after the inFlow Product Name or SKU. If you have multiple pictures for the same product, name them after the same Product Name or SKU followed by a dash “-” and the image number (e.g. “Firebird-1”, “Firebird-2”). Do not use parenthesis.
- Sign up for a free account in Airtable (if you already have an account, skip this step and sign in).
- Create a new base and select “Start from scratch” .
- In the bottom left menu, click on the “+” next to Gallery.
- To upload your images into the Airtable gallery, open the folder on your computer where your images are stored. Select one or multiple images from the local folder then drag them into Airtable into the “Drop here” button in the bottom right corner of the screen. If you’re uploading multiple images at one time, make sure that each record in Airtable has only one attached image (by selecting the Create separate records option).
- Once all pictures have been uploaded, click on Gallery in the top menu bar and select Download CSV.
- Open the downloaded file in Excel. Select the Name column, then go to Home > Find and Select > Replace. When the window pops up, search for the file extensions in your product names (.jpeg, .png, …) and leave the Replace with: field empty. to remove the extensions from the image names. Click Replace All. Repeat this process as many times as you need for different file extensions.
- If you have multiple pictures for the same product, the product name must be the same in all rows for the different URLs. With the Name column still selected, go once again to Home > Find and Select > Replace. This time, in the Find what: field type the extensions you added previously: “-2”, “-3”, and so on. Alternatively, you can find the repeated names and drag the original one down until it replaces all variants.
Note: If you have more than one picture for the same item, make sure that the name is the exact same in every row. You can do so by selecting the first cell (with the correct name) and then dragging it until it replaces any duplicates.
- Select the Attachments column. Go to Data > Text to Column. In the Text Wizard, select Delimited and click Next.
- In the next screen, under Delimiters, tick Other and enter “(“ (without quotations) into the textbox. This will separate the image URL from junk text you don’t need. Click Next and Finish. If a window pops up saying there’s data in the cells, select “Ok”. Delete the Attachments column.
- Select the URL column (name it if it’s empty), go to Home > Find and Select > Replace. Type “)” (without quotations) in the Find what: field and leave the Replace with: field empty. Click Replace All.
- Save your file – you’re ready to upload into inFlow!
Setting up your spreadsheet file
You can download a template for your picture import by going to Main Menu > General > Export and selecting Product Images, then “Export”. Alternatively, you can create your own file by following the steps below.
In a new spreadsheet, create the following mandatory columns:
- Product Name / SKU (at least one field is required)
- Image URL
Things to note:
- The Product name or the SKU you enter in the spreadsheet must match the Product Name or SKU of your products in inFlow Cloud.
- If a product has multiple images, the first image that is imported will be set as the default image in inFlow.
- If you’re importing images for a product that already has them, they will be replaced with the imported ones. If you leave the URL column blank, it will delete all images associated with the product.
Saving as a .csv file from Excel
Before you import, make sure your file is saved as a CSV.
- In your spreadsheet, click File > Save As.
- At the bottom of the window click the Save as Type dropdown, and select CSV (comma delimited).
- Click Save.
- Excel will warn you about the loss of formatting, this is not a problem. Please click Yes to complete your save.
Importing in the Windows App
Go to Main Menu > General > Import Data and select Product Images. Browse your file location and select the CSV you prepared earlier. Click Next.
You will see the screen above. Match the columns in the CSV to the fields. Click Import. You’ll receive an email when all pictures have been uploaded.
Importing in the Web App
Go to Main Menu > Import and select Product Images. Browse your file location and select the CSV you prepared earlier. Click Next.
You will see the screen above. Match the columns in the CSV to the fields – once you match the URL field, you’ll see a preview of the first image you’re importing. Click Import. You’ll receive an email when all pictures have been uploaded.