m using nopCommerece 2.50 i gives a reward point to my coustomers for theier purchases but when if i delete any order given by customer (due to some reason) but aloted reward point cannot deduct back from their account. there is big problem pls give me some solution.
m using nopCommerece 2.50 i gives a reward point to my coustomers for theier purchases but when if i delete any order given by customer (due to some reason) but aloted reward point cannot deduct back from their account. there is big problem pls give me some solution.
You can add negative points (i.e. deduct) in admin>customer>edit (your customer account)>reward points tab
There are a number of options to delete the whole set of records for 1 customer.
If you are only doing it very rarely then just run some SQL on the DB table to delete all the records for that customer
eg
DELETE FROM RewardPointsHistory WHERE CustomerId = ###;
Haven't tested that you might have issues with the FK's and that's from Nop 2.3 DB
You could also delete a specific orders reward point history in a similar fashion.
I would warn against either as the customer may get upset. Better to make an adjustment and note why. That way when they contact you in 6 months time asking where their reward points are, you know why they are not there.
There are a number of options to delete the whole set of records for 1 customer.
If you are only doing it very rarely then just run some SQL on the DB table to delete all the records for that customer
eg
DELETE FROM RewardPointsHistory WHERE CustomerId = ###;
Haven't tested that you might have issues with the FK's and that's from Nop 2.3 DB
You could also delete a specific orders reward point history in a similar fashion.
I would warn against either as the customer may get upset. Better to make an adjustment and note why. That way when they contact you in 6 months time asking where their reward points are, you know why they are not there.
HTH
Dave
Thanks Daveb, U spent valuable time for me. as u wrote when customer contact you in 6 months time asking where their reward points are, you know why they are not there.
its ok, but u think order placed by customer deleteed any time by admin even pending, processing or Compeleted. so why the reward point delete option think big issue.
I know in Nop 1.7 there are settings as to when reward points are allocated eg when order is completed / paid etc and when they are removed eg cancelled.
Try playing around with those? cant imagine they have been removed don't have 2.5 set up in front of me to test.
m using nopCommerece 2.50 i gives a reward point to my coustomers for theier purchases but when if i delete any order given by customer (due to some reason) but aloted reward point cannot deduct back from their account. there is big problem pls give me some solution. You can add negative points (i.e. deduct) in admin>customer>edit (your customer account)>reward points tab
this is manual work to negative points. on the other way when order is canceled, given reward point also deducted. so why when delete order it must reward point also deleted linked with order.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.