Bulk add store credit to customer account
This is a step by step guide of how to bulk add or remove store credit from a customers account.
- You must create a csv and save it using this template BulkStoreCredit.csv
a. The file must be in a text format
b. Customer number must be entered
c. Amount of store credit you wish to give or remove must be entered in amount column. If you wish to minus store credit then a minus symbol must be used e.g -20
d. The right store must be entered either vwshop or dmshop - Go to Telesales > Tasks > Bulk Uploader > Store account > Store Credit
- Click 'Choose file' on the details screen
- Select the correct file and then click 'open'.
- You must then select a relevant reason code. Reference and description are optional the bulk tool will still work if they are not filled in.
- Click 'execute task' in the right hand corner.
- To check the status click 'Jobs' if the option to click it isn't there then refresh the page
8.You then click 'Details' and then 'Get report' on the job. If the job is showing as 'unknown' then keep refreshing the page because this means the job is still running
9.This will then load the job report which will tell you weather or not you were successful in adding/removing store credit balance. Alternatively if it has failed to add/remove balance then it will also show you this and give you a reason why.
10..Some common failures you will see are "Customer not found" this will appear when either the customer account doesn't exist. You will also get a failure if you try to minus from an account that has no store credit because it can't go lower than zero.