Get Excelify now
Get Excelify now

Export and import file 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 also use the dynamic placeholders when importing file from URL. You can use them in any part of the URL including directories and file name.

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

%YYear with 4 digits2018
%yYear with 2 digits18
%mMonth with padded zero (01 – 12)04
%-mMonth, not padded (1 – 12)4
%BMonth full nameApril
%^BMonth full name uppercaseAPRIL
%bMonth abbreviatedApr
%^bMonth abbreviated uppercaseAPR
%dDay of the month with padded zero (01 – 31)05
%-dDay of the month, not padded5
%jDay of the year (001 – 365)124
%HHour in 24-hour format, with padded zero01
%IHour in 12-hour format, with padded zero01
%PMeridian indicator, lower caseam
%pMeridian indicator, upper caseAM
%zTime zone as hour and minute offset from UTC+0900
%ZTime zone abbreviation nameUTC
%AFull weekday nameThursday
%^AFull weekday name, uppercaseTHURSDAY
%aWeekday abbreviationThu
%^aWeekday abbreviation, uppercaseTHU
%uDay number of the week where Monday is 1 (1 – 7)4
%wDay number of the week where Sunday is 0 (0 – 6)4
%UWeek number of the year where the week starts with Sunday (00 – 53)14
%WWeek 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:

ExampleResulting file name
%Y-%m-%d at %H-%M-%S2018-04-05 at 01-45-23