1. Import by next-card
2. Filter the relodify list for lightspeed customers

Filter tips

1. Merge these customers with the subscribtion status included

Stappenplan:

1. Export Customers
2. Verander naar met Lightspeed-customer
3. Dry-run
4. Import in spreadsheets
5. Find and replace + sign with “”
6. Find and replace 06 with 6
7. Add ‘+ to every row of phone number.
8. Row G → =IF**(TRIM(AO16)="no", "not_subscribed", IF(TRIM(AO16)="yes", "subscribed", ""))**
9. Copy row G → speciaal plakken alleen waarden
10. Plaatst de subscription in de 1e klant colom
11. Data controleren

To do: