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 the CSV file you want to import.
On the following screen you'll see a preview of your file. Click 'Next'.
There is no need to change import options. Click '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.
đĄ 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.
đĄ 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.
In addition, you can find all the assets you've uploaded in the 'Assets' tab of the main navigation bar.
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:
- Take all of your files and upload them into Plytix following the steps from the first section of the article Uploading and Importing Assets.
- The from the 'Assets' tab, select all assets.
- Click 'Export'.
- Choose the 'CSV' option (XLSX is also good if you work directly with Excel).
- Select the asset attribute 'File Name' to include in the CSV.
- Click 'Export'.
- 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:
- Open your CSV or XLSX as a spreadsheet. Excel or Google Sheets is recommended.
- Choose the "File Name" column.
- Split the file name to isolate the SKU in its own column (see tip below).
- Then find the column that holds your SKU and name it "SKU".
- Rename the "URL" column to the attribute you want to import on, for example the "Files" system attribute.
- Delete any unnecessary columns.
- 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?
- Learn how to import and upload assets to Plytix
- Learn how to link and unlink assets with products manually
- Learn how to export assets
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 đ