Your CSV should consist of a minimum of 2 and a maximum of 4 columns. The first column should contain the e-mail addresses, the second column the order numbers and the third column optionally the language of the invitation, in the fourth column you can specify in how many days the invitation should be sent. You can set this fourth column to 0 to send the invitations today. The CSV must be separated by a comma (,) and not by a semicolon (;). Dutch versions of Excel almost always save a CSV in ; format. We expect the following file format:
- Email - johndoe@domain.com / jansmit@domein.nl
- Order number - abc123 / test1
- Language - eng / nld
- Customer name (optional) - John / Jan
- Delay (optional) - 3 / (empty)
The contents of the sample .csv would be the following:
johndoe@domain.com,abc123,eng,john,3 jansmit@domein.nl,test1,nld,jan,
CSV separated by semicolon?
Do you have a CSV which is separated by a semicolon (;). Then you can easily convert it to the correct format with the online Online CSV Tools. Just follow these steps:
1. Open the website Online CSV Tools
2. Select your CSV file by choosing "Import file".
3. Under "Delimiter used in source CSV", choose ";".
4. At "Delimiter used in output CSV", choose ",".
5. Under New CSV, click "Save as...".
6. The file is now ready to import at WebwinkelKeur.