Linking Assets with Products in Bulk

How to associate a large amount of assets with existing products in Plytix

The fastest way to link assets and products together in Plytix is by using the importer. This article will discuss two methods for bulk asset mapping, depending on if you have URLs for each of your assets or you need to generate them using the PIM.

 

Linking Assets in Bulk via CSV Import

Linking Assets in Bulk via CSV Import without URLs

 

*Skip to any section in this article by clicking on the links above

 


Linking Assets to Products in Bulk via CSV Import

Linking Thumbnails to Products

First, you'll need a CSV file with the SKUS of your products in one column and the links to your assets in another column. Import this file by selecting 'Import' from the 'Products' tab in the main navigation bar.

select 'Import' from the 'Products' tab of Plytix to import assets

Select the CSV file you want to import. 

upload a CSV file to Plytix by dragging and dropping or click to browse

On the following screen you'll see a preview of your file. Click 'Next'. 

Preview of CSV file settings, click 'next' button

There is no need to change import options. Click 'Go to matching'.

Import options, no need to change, go to matching

To associate a single image with a product, match your SKU column to the 'SKU' attribute. Match your column of image links to the 'Thumbnail' attribute. 

data matching section with SKU and Thumbnail attributes

💡 If any of your product SKUs do not have assets, you can choose to ignore them, or erase existing assets associated with them. If you've previously associated assets with any of your SKUs, you can choose to add new assets or overwrite the old ones.

 

For linking multiple files with a product, keep reading.

Linking Galleries of Assets to Products

To associate multiple images (and/or videos) with a product, match your SKU column to the 'SKU' attribute and your column of links to a custom 'Gallery' attribute or the 'Files' system attribute.

gallery custom attribute matches to a set of link for multiple images

💡 If any of your product SKUs do not have assets, you can choose to ignore them, or erase existing assets linked to them. If you've previously linked assets with any of your SKUs, you can choose to add new assets or overwrite the old ones.

Viewing Uploaded Assets

Your newly uploaded assets will now appear on the product detail page of linked products and in the columns of the product overview table.

view products and linked assets in the product overview table in Plytix

In addition, you can find all the assets you've uploaded in the 'Assets' tab of the main navigation bar. 

view assets in the 'Assets' tab in the Plytix main navigation bar. Search for assets by name or filter.

Here you can search for assets by name or sort them using filters. You can view when each asset was created or modified, and by which user. By clicking on an asset, you can also view all of its linked products. 

 

ℹī¸ Note that Plytix does not have a built in video player for previewing video attributes. This means that you cannot view videos within the system, but they will appear with the rest of your assets when exported.

 


 

Bulk Association of SKUs and Assets (without URL)

ℹī¸ This method requires you to have the SKU in the file name.


If your assets use a naming convention where the SKU is included in the file name, this is one of the fastest ways to organize your files when you are first setting up Plytix. 

 

What you need:

  • Your files accessible from a local device
  • Your files with the SKU you'll use in Plytix included in the file name (e.g 4562WE2_blue.png)
  • A Plytix account


What you need to do: 

First you will need to generate URLs and put them into a CSV file. To do this:

  1. Take all of your files and upload them into Plytix following the steps from the first section of the article Uploading and Importing Assets
  2. The from the 'Assets' tab, select all assets. 
  3. Click 'Export'.
  4. Choose the 'CSV' option (XLSX is also good if you work directly with Excel).
  5. Select the asset attribute 'File Name' to include in the CSV.

    Screenshot 2021-02-03 at 17.21.27
  6. Click 'Export'.
  7. Your CSV will be automatically downloaded in the browser or you will receive an email, depending on the size of the file requested.

💡 When exporting, use filters with the "Create Date" if you already have assets in the system that you don't want to include in this process.

 

Once you've downloaded your file, you will need to open it in a spreadsheet to format the file for import. To do this: 

  1. Open your CSV or XLSX as a spreadsheet. Excel or Google Sheets is recommended. 
  2. Choose the "File Name" column.
  3. Split the file name to isolate the SKU in its own column (see tip below).





  4. Then find the column that holds your SKU and name it "SKU". 
  5. Rename the "URL" column to the attribute you want to import on, for example the "Files" system attribute.
  6. Delete any unnecessary columns.
  7. Export the file as a CSV.

💡 Use these links to learn how to split text into separate columns:

⚠ī¸ You may need to trim white space and perform other actions to make sure that your SKU column is properly isolated and formatted. 


Now you are ready to import the CSV file into Plytix. When your import has completed, all the files will automatically be linked to your products. 

 



What's next?

 

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇