Export to custom file name with dynamic placeholders

Shopify export custom file name with placeholders

When exporting, under Options you can specify the “Custom file name” for the export.

This is especially useful for scheduled exports so that you can specify what the file name should be for your exports.

You can include the dynamic fields of the Export starting date and time in the file name, using the placeholders like this:

Placeholder Meaning Example
%Y Year with 4 digits 2018
%y Year with 2 digits 18
%m Month with padded zero (01 – 12) 04
%-m Month, not padded (1 – 12) 4
%B Month full name April
%^B Month full name uppercase APRIL
%b Month abbreviated Apr
%^b Month abbreviated uppercase APR
%d Day of the month with padded zero (01 – 31) 05
%-d Day of the month, not padded 5
%j Day of the year (001 – 365) 124
%H Hour in 24-hour format, with padded zero 01
%I Hour in 12-hour format, with padded zero 01
%P Meridian indicator, lower case am
%p Meridian indicator, upper case AM
%M Minute 45
%S Second 23
%z Time zone as hour and minute offset from UTC +0900
%Z Time zone abbreviation name UTC
%A Full weekday name Thursday
%^A Full weekday name, uppercase THURSDAY
%a Weekday abbreviation Thu
%^a Weekday abbreviation, uppercase THU
%u Day number of the week where Monday is 1 (1 – 7) 4
%w Day number of the week where Sunday is 0 (0 – 6) 4
%U Week number of the year where the week starts with Sunday (00 – 53) 14
%W Week number of the year where the week starts with Monday (00 – 53) 13

You can use those placeholders in any combination inside your filename.

Some examples:

Example Resulting file name
%Y-%m-%d at %H-%M-%S 2018-04-05 at 01-45-23
%m%d_%H%M 0405_0145
Products_%Y-%^b-%-d Products_2018-APR-5