Import Rewards Points Via CSV
hen using your store's built-in Rewards Points program, you have the option of also adding reward points to individual customer records. You can also perform the same function via a CSV file import.
To import reward points for customers:
Log into your Shift4Shop Online Store Manager.
Using the left navigation menu, go to Customers > Customer List.
Look to the top right of the page, and click on Export / Import.
On the right side of the page, you will see a series of CSV import options.
4. Click on the + icon next to Reward Points.
5. Then click on the Sample File link to download an example of the CSV file for import.
When you open up the sample file in your spreadsheet program, it will contain the following column headers that can be used to populate your mailing list.
contactid
The customer's database ID in your store*
This will be the same as the contactid shown in the customer export CSV file.
rewardid
This is the database ID created for the reward points record.
This is typically generated by the store, and may be left blank when importing a new set of reward points.datentime
This will be used for the date and time stamp of the reward record.
The format for this field is mm:dd:yyyy hh:mm. It may be left blank for new entries.points
The actual number of points being added to the record.reference
Any reference notes to explain why the points are added.
After populating the CSV file with your list reward points, save the file as a CSV and proceed with the following steps to import it:
Log into your Shift4Shop Online Store Manager.
Using the left navigation menu, go to Customers > Customer List.
Look to the top right of the page, and click on Export / Import.
Click on the + icon next to Reward Points.
This time, use the browse button to locate the newly created CSV file on your computer.
Click on Import Data to have it uploaded to your store's database.
After completion, your Reward Points will be present in the store.