User points value not changing correctly

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #275740

Having just taken the site live, it appears as though I have something configured incorrectly as the user points do not seem to be reducing correctly.

I have a mass action to give 200 on registering. That is working.
Points are set up to be earnt £1 = 1 point.
point redeem value .01 = 1 point
However, when a customer spends £26.03 uses 200 points (£2.00) - her account is still showing as having 200 points

Can you advise?

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275742

Hello,

Please provide your HikaShop version number.
Please provide more details about your "user points" payment configuration, details about the orders (order page in the backend) and also details about your configuration of order statuses.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #275796

Thank you. My version is Business 3.1.1

HikaShop user point plugin configured as follows:
valid order statuses=confirmed
active checkout step - yes
hide when no points - yes
show points = hikashop
ask for no coupon - yes
do not use point by default - yes
show earn points - yes
status-enabled
access-registered
----
HikaSop options for this plugin -
points mode - Hikashop user points
Give on price with point discount
Points round down = no
give virtual points = no
rate= 1.00
limit by tupe = no
shipping gives point = no


Hikashop user points payment plugin configuration -
Specific config section-
mode = Hikasho_user_points
rates = 1points=.01 GBP£
tax - default tax category
-
-
-
shipping = no
partial payment= yes
maximum (percent)= 100%
minimum (percent)-
Minimum (value) -
Give back points on cancellation =yes
Use virtual coupons = yes
User points -mass action configured as follows:
Date=user
trigger=after a user is created
action=update the value
user_point INT 200

order status in screenshot

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275803

Hello,

Please provide screenshots instead of text.

You can remove the setting "valid order statuses" in the Joomla part of the plugin since your order statuses are configured.
Selecting only "confirmed" can generate side effect if you're also using other statuses like "shipped" and in your case, "processing".

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #275884

Thank you, I have made that change. Here are the screenshots

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 4748
  • Thank you received: 644
  • MODERATOR
7 years 3 months ago #275907

Hello,

Can you add concerned order listing in your screenshot, especially their statuses because right now hard to find the root issue.
Awaiting news from you.

Regards

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #275955

I'm not sure what you need, except the order status which I have attached here.

When the order is paid, the invoice is generated and the system marks as confirmed.



I am currently manually editing the customer's points to the correct amount when an order has been created, so what is showing in my admin section will not be what the system is giving.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #275961

Ok, I think I've found it.

I've gone through and made a test order (including paying) and checked the admin area at every stage.
The correct points were removed when the order was confirmed,
but the new points were not added .

Upon changing the status to "processing" the points went weird - giving 199.
So, I guess I should not use any other other status?

However, the new point for purchasing was not added to the account - so there is still something wrong with my set up. I've added screenshots of the front-end and back-end of the order process.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276007

update. my orders today seem to be calculating, so I would like to monitor for a while and see if the status change is what caused the problem.
I'll report back again tomorrow.
thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275978

Hello,

You let the field "valid order statuses" blank in the configuration of the User Points plugin (Joomla part).
So the plugin is using the "invoices" column in your order statuses to determine if an order is valid or not.

That's why when you switch the order to "processing", it gave you back the 200 points but it also take back the 1 point you earned.

If you take a look at your order details in the database (PHPMyAdmin) you will see a column "order_payment_params" where some data is serialized.
That data contains the result of the points processing ; indicating how many point has been used and how many point has been earned.

The points are removed when the order is created but you earn your points only when the order is confirmed.
So the order status "created" is a bit special because it is used as transition (since you do not want your customer to create a lot of order using points but without loosing them).
That's why the plugin is making mix between "invoice" and "cancelled" in order to determine what it should do with the points.

But I think that your customer received his 1 point when the order has been confirmed ; even if you do not see the notice message in the backend or in the paypal IPN server-to-server confirmation system.

Regards


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: GB11

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276049

Thank you very much! :cheer:

Do you recommend that in the 'valid order status' I include all of the following- Confirmed, processing, despatched - or will this cause more issues?

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #276055

Hello,

You need to list all order statuses which are considered as "valid" so the points should be taken to the customer and not refunded.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276141

Thank you.
Should I use a comma -
i.e
confirmed, despatched, processing
or
confirmed despatched processing
Thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #276151

Hello,

Comma and not spaces.

Regards,

PS : For your future post, please always check the category where you're posting in. So all your message won't be in the "install/update" section. Thanks !


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: GB11

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276200

Thank you very much for your help!

...and yes, I will :)

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276205

So sorry, something is still not correct.

I have put the valid order status as
confirmed,shipped,processing

The customer's points have been taken away at confirmed.

But, no new points have been added. They remain at 0.

Please Log in or Create an account to join the conversation.

  • Posts: 4748
  • Thank you received: 644
  • MODERATOR
7 years 3 months ago #276227

Hello,

Please note that you have to use your order statuses Namekey and not the name used for the listing.
For see each order status Namekey, you have to edit required order status like this :



Check that what you write in plugin input text fit all Namekey.

Regards

Attachments:
Last edit: 7 years 3 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276292

Hi,
yes, having checked, these are the namekeys

I think I may have found where the problem lies

1 order overnight did not add any points to the existing total. Customer paid with PayPal, did not use any points
1 order overnight removed used points, did not add any. Customer paid by PayPal.
(these use the HikaShop Paypal payment plugin)

1 order overnight removed used points, and added - this customer paid by credit/debit card - using the HikaShop PayPal Pro payment plugin

The status of all three orders is confirmed.
Invoice numbers for all have been generated.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #276334

Hello,

I'm afraid that's not possible to understand your message since there is no concret information to see what is going on.
So please, read all of my message very carefully because it contains a lot of useful information and things you have to check and access in order to see what is going on and understand the source of the issue.

Like as example:

If you take a look at your order details in the database (PHPMyAdmin) you will see a column "order_payment_params" where some data is serialized.
That data contains the result of the points processing ; indicating how many point has been used and how many point has been earned.

Since, we are recommend you to perform actions and you're not doing it ; we can't help you further.
But regarding the different topics you have ; I really think that you have issues with your order statuses.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 94
  • Thank you received: 0
7 years 3 months ago #276508

I apologise, I did not realise that you wanted this information from the database, that was not made clear.
I did look at the "order_payment_params" - of course this serialised information means nothing to me. I could not see anything to indicate why they are not on the user's account.

Here is information from the database from two orders - the first which worked correctly, the second which did not. Both orders are still at 'confirmed' as I don't feel that I can change them to 'shipped' as it will probably change them again.

Correctly added- the account shows 42 (order id 725)

O:8:"stdClass":1:{s:10:"userpoints";O:8:"stdClass":4:{s:10:"use_points";i:200;s:11:"earn_points";a:1:{s:2:"hk";d:42;}s:8:"use_mode";s:2:"hk";s:9:"give_back";b:1;}}

(payment id - 5)

incorrectly added- the account shows 0 (order id 822)

O:8:"stdClass":1:{s:10:"userpoints";O:8:"stdClass":4:{s:10:"use_points";i:200;s:11:"earn_points";a:1:{s:2:"hk";d:4;}s:8:"use_mode";s:2:"hk";s:9:"give_back";b:1;}}

(payment id - 1)

both have a status of confirmed

Now, the only thing here that I can see as different is what I assume are the number of points. This does not show why those points are not on the user's account.


I agree, there must be something incorrect with either my status or perhaps payment method. As I explained, I have noticed when the payment used the PayPal pro plugin (entering card details), it has appeared to have worked. When the payment used the standard Paypal plugin it does not. That may be a co-incidence of course.

Here is the screenshot of my status namekeys, and my plugin after you advised me regarding the commas and spaces. I have also included the shown user points in the admin are for the above examples.

If you still require more information, I will gladly supply it, just ask.

I realise that it must be frustrating for you when it is no doubt a problem caused by me. However, it is far more frustrating for me, as I cannot see what I have done incorrectly

.

Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.135 seconds
Powered by Kunena Forum