Exporting the newsletter database using Master Data
To export your customer base that have chosen to receive newsletter, follow the step-by-step below:
- In the VTEX Admin, access Store Settings > Storefront > Master Data.
- Click on the Clientes tab.
- Click
Export XLS
. - Select the
Receive Newsletter?
filter, as well as others you like (Name
andemail
, for example). - Click on
Export
. - A window will appear informing you that the export has been successfully programmed. Click
OK
to close it.
In the spreadsheet that has been sent to your email there will be a column titled isNewsletterOptIn
, which assigns the value true to customers who receive newsletter and false to those who do not.
This option is only valid for stores with their Newsletter registered in the CRM. If your store is not yet configured in this way, and still uses the page control, read the article Configuring the inclusion of a newsletter in Master Data to find out how to do it.