Order paid, but missing in HikaShop

  • Posts: 88
  • Thank you received: 20
4 years 3 months ago #324204

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.4

Hi
More than once now, I've experienced that an order has somehow been created and paid, but is missing from HikaShop. Checking the email log, the client didn't get an "order is confirmed mail". The client is created in hikashop, but has no orders. But I can see the order in the payment gateway.

Do you have any idea as what could cause this strange behavior?

Checking the server log, I could see that no-one has accessed the order in the backend. I could also see the callback from the payment gateway:

193.162.142.212 - - [21/Sep/2020:08:27:29 +0200] "POST /index.php?option=com_hikashop&ctrl=checkout&task=notify&notif_payment=quickpay&tmpl=component&lang=da&Itemid=986 HTTP/1.1" 200 3398 "-" "QuickPay Callback Service (http://tech.quickpay.net/api/callback/)"

193.162.142.212 - - [21/Sep/2020:08:27:29 +0200] "POST /index.php?option=com_hikashop&ctrl=checkout&task=notify&notif_payment=quickpay&tmpl=component&lang=da&Itemid=986 HTTP/1.1" 200 3398 "-" "QuickPay Callback Service (http://tech.quickpay.net/api/callback/)"

First callback is auth, second is capture

Log from the payment gateway:
{
    "id": XXXXXXXXX,
    "merchant_id": XXXXX,
    "order_id": "004523",
    "accepted": true,
    "type": "Payment",
    "text_on_statement": null,
    "branding_id": null,
    "variables": {
        "CUSTOM_orderid": "4523"
    },
    "currency": "DKK",
    "state": "processed",
    "metadata": {
        "type": "card",
        "origin": "form",
        "brand": "mastercard",
        "bin": "547133",
        "corporate": false,
        "last4": "XXXX",
        "exp_month": 11,
        "exp_year": 2020,
        "country": "DNK",
        "is_3d_secure": false,
        "issued_to": null,
        "hash": "0b911cf0c8b128c02826cOPTaaZWfCcdAZtE7yqkGMCwqH8HnAtS",
        "number": null,
        "customer_ip": "87.72.XXX.XXX",
        "customer_country": "DK",
        "fraud_suspected": false,
        "fraud_remarks": [],
        "fraud_reported": false,
        "fraud_report_description": null,
        "fraud_reported_at": null,
        "nin_number": null,
        "nin_country_code": null,
        "nin_gender": null,
        "shopsystem_name": "HikaShop",
        "shopsystem_version": "4.3.0"
    },
    "link": null,
    "shipping_address": null,
    "invoice_address": null,
    "basket": [],
    "shipping": null,
    "operations": [
        {
            "id": 1,
            "type": "authorize",
            "amount": 98500,
            "pending": false,
            "qp_status_code": "20000",
            "qp_status_msg": "Approved",
            "aq_status_code": "000",
            "aq_status_msg": "Approved",
            "data": {},
            "callback_url": "https://www.XXXXXXXXXXXXX.dk/index.php?option=com_hikashop&ctrl=checkout&task=notify&notif_payment=quickpay&tmpl=component&lang=da&Itemid=986",
            "callback_success": true,
            "callback_response_code": "200",
            "callback_duration": 20142,
            "acquirer": "teller",
            "3d_secure_status": null,
            "callback_at": "2020-09-21T06:27:28+00:00",
            "created_at": "2020-09-21T06:27:27Z",
            "operationStatus": {
                "status": "Godkendt",
                "color": "text-green"
            }
        },
        {
            "id": 2,
            "type": "capture",
            "amount": 98500,
            "pending": false,
            "qp_status_code": "20000",
            "qp_status_msg": "Approved",
            "aq_status_code": "000",
            "aq_status_msg": "Approved",
            "data": {},
            "callback_url": "https://www.XXXXXXXXXXXXX.dk/index.php?option=com_hikashop&ctrl=checkout&task=notify&notif_payment=quickpay&tmpl=component&lang=da&Itemid=986",
            "callback_success": true,
            "callback_response_code": "200",
            "callback_duration": 10158,
            "acquirer": "teller",
            "3d_secure_status": null,
            "callback_at": "2020-09-21T06:27:28+00:00",
            "created_at": "2020-09-21T06:27:28Z",
            "operationStatus": {
                "status": "Godkendt",
                "color": "text-green"
            }
        }
    ],
    "test_mode": false,
    "acquirer": "teller",
    "facilitator": null,
    "created_at": "2020-09-21T06:26:41Z",
    "updated_at": "2020-09-21T06:27:49Z",
    "retented_at": null,
    "balance": 98500,
    "fee": null,
    "deadline_at": null
}

Last edit: 4 years 3 months ago by dyvel.

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

  • Posts: 83024
  • Thank you received: 13403
  • MODERATOR
4 years 3 months ago #324211

Hi,

I would recommend to check the hikashop_order table via your PHPMyAdmin. Search for the id 4523.
Do you see the order there ?
If yes, then, there is some data in that order which make it so HikaShop doesn't see it.
For example, if the order_type has been changed to something else than "sale" it won't appear on the orders listing interface of the HikaShop backend.
If no, then it means that the order has been deleted at some point. It could be done manually, or with a mass action, or by another extension. I would first check if you have mass actions configured. If so, review them.
If not, I would check the hikashop_history table to see if there are still records left for that order.

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

Time to create page: 0.041 seconds
Powered by Kunena Forum