Start Free Trial
Start Free Trial

With the Matrixify app, you can bulk import and export Shopify Files from Shopify Admin -> Content -> Files section.

See what each field/column from our “Files” template means including possible allowed values and examples.

Fields marked as “Export Only” cannot be imported/set in Shopify but can be exported with 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.

Need a quick start?

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.

Allowed Values

Text

Example
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.

Allowed Values

Text

Example
red_shirt_123.jpg
Command When importing a Files row – tell the app, what to do with it:

  • NEW: will try to create a new File with the provided details. If such a File will already exist (with the same ID, File Name, or Link), then the result will be Failed.
  • MERGE: will try to find the existing File, and update it with data from the row. If such a File will not be found, then it will create a new one.
  • UPDATE: the app will search for an existing File and update it. If an item cannot be found then that item will fail to import.
  • REPLACE: WARNING! Use this Command value to fully replace the whole file, not individual fields. Using this Command value, the app will delete the file from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file.
    If such File with provided ID, File Name, or Link exists, then the app will delete it. After that, it will create a new one. If an existing File will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of the columns, which were not included in the import file since the File will be deleted and re-created.
  • DELETE: the app will delete the existing File, which is found by ID, File Name, or Link. If such a File will not be found, then the result will be Failed. This DELETE command is very handy for deleting Files in bulk.
  • IGNORE: the app will ignore this File and will skip it.

If no Command is specified, then the app will assume the MERGE command.

Allowed Values
NEW
MERGE
UPDATE
REPLACE
DELETE
IGNORE
Example
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.

You can also import files to your Admin > Content > Files section directly from FTP/SFTP server.
The link structure in such a case would be ftp://username:password@server/path/to/file.jpg.

Allowed Values

URL

Example
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.

Allowed Values

Text

Example
T-shirt red small size
Created At

Export only

The date and time when the file was created/added in your Shopify Files.

Allowed Values

Text

Example
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.

Allowed Values
IMAGE
FILE
VIDEO
Example
IMAGE
Mime Type

Export only

If File Type is IMAGE or VIDEO then you can see the MIME type here.

Allowed Values

Text

Example
image/jpeg
Width

Export only

If File Type is IMAGE or VIDEO then here you can see the width in pixels.

Allowed Values

Integer

Example
5184
Height

Export only

If File Type is IMAGE or VIDEO then here you can see the height in pixels.

Allowed Values

Integer

Example
3456
Duration

Export only

If File Type is VIDEO then here you can see the image height in pixels.

Allowed Values

Time

Example
00:00:31
Status

Export only

Status of the file creation in Shopify:

  • Failed – File processing has failed
  • Uploaded – File has been uploaded but the processing hasn’t started yet
  • Processing – File is being processed by Shopify
  • Ready – File is ready to be displayed

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.
If you do not see your uploaded file in the Shopify Admin -> Settings -> Files section, do an export of your files with the Matrixify app and check your file Status in this column.

Allowed Values
Failed
Processing
Ready
Uploaded
Example
Ready
Errors

Export only

If the file has failed to be added/created in Shopify then here you will see the error.

Allowed Values

Text

Example
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.

Possible Conditions
  • contains any of
Example
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.

Possible Conditions
  • on or after
  • on or before
  • date range
  • relative date
Type Allows selecting to export only Images or generic Files.

Possible Conditions
  • Image
  • File
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.

Possible Conditions
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
Example
100
Status Status of the file creation in Shopify:

  • Failed – File processing has failed
  • Uploaded – File has been uploaded but the processing hasn’t started yet
  • Processing – File is being processed by Shopify>
  • Ready – File is ready to be displayed
Possible Conditions
  • Failed
  • Uploaded
  • Processing
  • Ready