Product Attachments Import
Product Attachments can be linked to products via CSV by following this tutorial.
You can manage your Product Attachments via CSV from Import & Export > Product Attachments
Exporting
Exporting Product Attachments
If you are looking to get a report of, or to manage your product attachments, you can use the "Export Product Attachments" section of the Import/Export tool.
Export Product Attachments
The Export will provide you with a CSV that looks like this:
Sample CSV Export of Product Attachments
| Column | Description |
|---|---|
| attachment_id | This is the unique ID for the attachment. This is used for making edits to the attachment during import. |
| product_sku | This is the SKU of the product the attachment is associated with. |
| filename | This is the Filename of the Attachment |
| render_mode | 1 = Download (Default) 2 = Open in browser 3 = Open in a new tab |
| store | For multi-language. Use the Code in Web Settings > Translations |
| label | This is the Label used on the store front-end for the customer to click to download. |
| customer _group | Restrict the attachment to specific customer groups. List the groups who can have access. |
| is_logged_in | Require the customer to be logged in to view the attachment. 0 = No 1 = Yes |
| sort_order | This is the sort order within the product SKU for this attachment. |
| attachment_url | This is the full URL where the file can be found/downloaded. |
| delete_attachment | This field is used during import to determine if the attachment should be deleted or not. |
Exporting File Manager Data
If you have imported your files to the File Manager and are looking for a list of all available files, you can use this export tool. You can select to download a report of all files, image files only, or non-image files only.
Export File Manager Data
The Export will provide you with a CSV that looks like this:
Sample CSV Export of File Manager Data
Importing - Adding New Attachments To Products
Step 1 - Create CSV
To add new attachments to products you will need to create a CSV with the below columns:
- attachment_id - Leave blank for new attachments
- product_sku - SKU of product to attach file
- filename - a Filename that exists in your File Manager Data (see Exporting File Manager Data above)
- label - The label you would like customers to see when clicking the link to download (leave blank to use filename as label)
- sort_order - If there are multiple attachments on one product you can specify a sort order (1,2,3 etc...)
Sample File for Importing new Attachments
Note: You do not have to specify the attachment URL. This will be done automatically from the file-name.
Step 2 - Upload CSV
In Import & Export > Product Attachments in the "Create or Update Product Attachments" section, choose your file and click to Upload.
Step 3 - Import
Once your file has been uploaded you can click to import the file.
Step 4 - Test
Now you can verify that your product attachments have imported correctly by checking one of the products you have imported.
Updating
To update existing attachments, follow the same steps as above, but be sure the "attachment_id" column has the attachment you would like to update.
Changing a File
You can change the File for an attachment simply by changing the "filename" column. You do not need to include the attachment_url column as it will be updated automatically by the filename. Be sure the new file already exists and has been uploaded into your File Manager.
Deleting an Attachment
You can delete an attachment ID by putting the value "1" into the "delete_attachment" column.
Updated over 1 year ago