Importing and Exporting Square Files
Importing and Exporting Square Files
Square Menu Import Files
1
On your Square web dashboard, navigate to Items Library > Action and Export Library as a .csv or .xlsx file

2
Navigate to Reports > Modifier Sales Report > set the range to Last Month > Export the Modifier Report as a .csv or .xlsx file

3
Send these files to your onboarding specialist to import.
Square Gift Cards Import File
1
After your Kick Off call, reach out to Square Support and ask for access to the gift card file containing all 16 digits of the PAN and their respective balances
2
Once Square grants access to the gift card file, a blue button will appear near the Gift Cards Report on your Square dashboard.

3
Download the gift card file the night before your launch for the most up-to-date balances.
4
On your Dripos web dashboard, navigate to Marketing > Gift Cards > and select Import Gift Cards

Square Patron Information and Loyalty Points Files
1
Closer to your launch date, call Square and ask for access to your customer’s loyalty balance file. They will email you a .csv file that contains two rows: phone numbers and points balance.
2
Next, export your customer directory from Square as a .csv file.

3
Send both the loyalty balance file and customer directory .csv files to your onboarding specialist to import.
Importing and Exporting Toast Files
Importing and Exporting Toast Files
Toast Menu Import Files
1
On your Toast dashboard, navigate to Reports > Item Details > set range as 1+ months > download using the arrow icon next to “Show / hide columns”

2
For the modifiers, navigate to Reports > Modifier Details Report > set range as 1+ months > download using the arrow icon next to “Show / hide columns”

3
Send your onboarding specialist the reformatted files, they will review the information and import into Dripos.
Toast Gift Cards Import File
1
On your Toast dashboard, navigate to Report > Payments > Gift Card Balances.

2
Download your Gift Card Balances file the night before your launch for the most up-to-date balances.
3
Send this file to your onboarding specialist to import.
Toast Patron Information and Loyalty Points File
1
On your Toast dashboard, navigate to Engagement > Rewards Accounts to find your patrons and loyalty information.

2
Download the Rewards Accounts file the night before your launch for the most up-to-date balances.
3
Send this file to your onboarding specialist to import.