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 “Export 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.Text 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. URL 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.
Text T-shirt red small size |
| Created At
Export only |
The date and time when the file was created/added in your Shopify Files.
Text 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
Export only |
If File Type is IMAGE then you can see the image MIME type here.
Text image/jpeg |
| Width
Export only |
If File Type is IMAGE then here you can see the image width in pixels.
Text 5184 |
| Height
Export only |
If File Type is IMAGE then here you can see the image height in pixels.
Text 3456 |
| Status
Export 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
Export only |
If the file has failed to be added/created in Shopify then here you will see the error.
Text 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
Export only |
File size in MB.
Decimal Number 221734 |
| Size MB
Export only |
File size in MB.
Decimal Number 0.222 |
| Size
Export only |
File size in user-friendly form.
Decimal Number 222 KB |
Export Filters
In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.
Note: total displayed item count and estimated time won’t be affected by the filters applied.
| Filter | Description |
|---|---|
| File Name |
Comma-separated list of text. App will return only FIles where File Name contains at least one of the listed texts.
green, image, my-file, .jpg
|
| Created At | Allows exporting which were created in the Shopify within a specific date range.
Relative date condition allows you to export Files that has been created in the last full amount of time. For example – Last 1 Days, would export all Files events from last full day, so yesterday.
|
| Type | Allows selecting to export only Images or generic Files.
|
| Size MB | Filters the Files by their file size in MB.
Depending of how Shopify CDN stores and optimizes files, size can be different than what you see in Shopify Admin -> Settings -> Files section. This will also make filtering by Size MB be a bit approximate, because filtering happens by the original file size, but the admin shows the eventually processed CDN file size.
100
|
| Status | Status of the file creation in Shopify:
|
