How to orient your customers to the nearest store

How to orient your customers to the nearest store, using Email Studio & Content Builder 


Have you ever been to your favorite store, just to realize once there that it had moved? Well, very often, it moves but only to remain in the same area…However, you could not guess that since no communication on the new address was shared via email, SMS or even social media.

We will see here how to take care of your customers by giving them the right information and guaranteeing an enjoyable shopping experience.

First, we can communicate the address of the store closest to their home by email. To do this we will need:

1- Data extension sendable with customer information (email, first name, address)

1 –Data extension not sendable with store codes and their addresses.

And also, the basics of the LOOKUP function of the AMPscript code.

A-Our sendable data extension for sending emails to the customer

 B-Our non-sendable data extension with stores attributes

Here the corresponding code that will be displayed in your email sending with the store address closest to the customer.


Dear %% First Name %%

Your return request has been taken into account.

Thank you for returning your item in its original condition to the nearest store:


Var @StoreAddress, @ Address1

Set @ Address1 = [Address1]

Set @StoreAddress = Lookup( “Data_ExtensionB”, “ City ”, “Address2”, @ Address1)



See you soon for an upcoming article!

Live with pleasure!



Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *