With the Matrixify app, you can bulk import and export Shopify Files from Shopify Admin -> Settings -> Files section.
See what each field/column from our “Files” template means including possible allowed values and examples.
Fields marked with the “Exported only” tag cannot be imported/set in Shopify and but can be exported with the Matrixify export.
Excel Sheet Name
Files
To tell the app that you are importing Files you need:
- If using CSV file then the file name needs to contain the word “Files”, for example, “my-shopify-files.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “Files”. The file name for the XLSX file does not matter.
Columns Available For Export And Import
Basic Columns
Column | Description / Example Value |
---|---|
ID | The ID is an automatically generated GID number by Shopify to identify the item. It is filled in by Export. Can be used for Import to identify and update existing Files. When importing a new File, leave this value empty.Text gid://shopify/MediaImage/33351235212327 |
File Name | Name of the file. Cannot be updated or set for a File, but this field can be used to identify and update other updatable Files fields by using only the File Name.When importing/creating a new file, the file name will be taken from the actual file name in the Link.
red_shirt_123.jpg |
Command | When importing a Files row – tell the app, what to do with it:
If no Command is specified, then the app will assume the MERGE command. NEW MERGE UPDATE REPLACE DELETE IGNORE MERGE |
Link | Public Shopify CDN link to the File. You can copy the same link in your Shopify Admin Files section.
When importing Files, here you can put a link from outside of Shopify. The app will pass that external link to Shopify for uploading to the Files section. If importing files from external links, the app will still check if such a file exists among Files by the file name from the provided URL. If it exists, it will regard that as being the same file. This allows you to do repeated imports and not to create duplicate files.
https://cdn.shopify.com/s/files/1/2244/9876/1234/files/red_shirt_123.jpg?v=1612358112 |
Alt Text | Your files can be used in your store’s theme so, by SEO best practices, it is strongly suggested that images have “Alt Text” specified because this is how search engines know what is inside the file.
T-shirt red small size |
Created At
Exported only |
The date and time when the file was created/added in your Shopify Files.
2020-10-07 10:33:34 +0000 |
Type | The file type – an image or generic file.
When importing – you can, for example, force images to be handled as generic files. If you do not specify the Type for import, then it will be automatically detected from the file contents. IMAGE FILE IMAGE |
Mime Type
Exported only |
If File Type is IMAGE then you can see the image MIME type here.
image/jpeg |
Image Width
Exported only |
If File Type is IMAGE then here you can see the image width in pixels.
5184 |
Image Height
Exported only |
If File Type is IMAGE then here you can see the image height in pixels.
3456 |
Status
Exported only |
Status of the file creation in Shopify:
When importing Files to Shopify, the app will pass the file URL to Shopify. It might take a while to upload larger files, because it is up to Shopify to process them. Failed Processing Ready Uploaded Ready |
Errors
Exported only |
If the file has failed to be added/created in Shopify then here you will see the error.
red_shirt_123.jpg |
Size
When exporting, selecting “Size” will include these field in the exported file for each File.
Column | Description / Example Value |
---|---|
Size Bytes
Exported only |
File size in MB.
Decimal Number 221734 |
Size MB
Exported only |
File size in MB.
Decimal Number 0.222 |
Size
Exported only |
File size in user-friendly form.
Decimal Number 222 KB |