Start Free Trial
Start Free Trial

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:

  • 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: at first, 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.

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:

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

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.

  • contains any of

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.

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

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

  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between

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

  • Failed
  • Uploaded
  • Processing
  • Ready