Skip to main content
Solved

Payments not syncing from BigCommerce for manual orders (back end of BigCommerce)

G
Freshman II

Hi,

We are using the BigCommerce connector with acumatica 2021 R2, but have noticed that payments do not sync from BigCommerce if the order type in BigCommerce is “Manual Order”. These are orders that are taken manually by staff using the backend of BigCommerce. They use exactly the same payment method. In fact, I have compared the GET results of the “payment” endpoint for a normal website order, and a manual order, and the payment REST response looks identical from BigCommerce.

 

So is the acumatica connector programmed to NOT sync these payments? If I try to manually sync the payment (Sync History->Add New->specify the external order ID) then it says “the payment record cannot be syncronized because it does not exist in the external system)

 

Hoping someone has some insight, as I can’t find any information in the documentation as to why these payments can’t be found by acumatica.

 

Thanks

Geoff 

Best answer by geoffreym

Hi @Chris Hackett, for now I have implemented some business events to create the payments and tidy things up, and will review this issue again once we upgrade to the next major build locally which may or may not fix this issue. 

View original
    Did this topic help you find an answer to your question?

    5 replies

    smarenich
    Acumatica Moderator
    Forum|alt.badge.img+3
    • smarenich
    • Acumatica Commerce Edition Team Lead
    • 227 replies
    • September 2, 2022

    @geoffreym I think we need to review the object of the payment for your order.

    Could you please either to share with me the transaction JSON or create a support case with Acumatica, so we can arrange the review session.

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    G
    Freshman II
    • geoffreym
    • Author
    • Freshman II
    • 7 replies
    • September 5, 2022

    @smarenich sure, see details below:

     

    This is the JSON response from the payment type that acumatica can’t see (BigCommerce back end manual order)

    358 manual backend order:
    {
        "data": [
            {
                "id": 545243453,
                "order_id": "358",
                "event": "purchase",
                "method": "nonce",
                "amount": 153,
                "currency": "AUD",
                "gateway": "braintree",
                "gateway_transaction_id": "fzpmtx0d",
                "payment_method_id": "braintree.card",
                "status": "ok",
                "test": true,
                "fraud_review": false,
                "reference_transaction_id": null,
                "date_created": "2022-08-31T06:08:31+00:00",
                "avs_result": {
                    "code": "M",
                    "message": "Street address and postal code match.",
                    "street_match": "Y",
                    "postal_match": "Y"
                },
                "cvv_result": {
                    "code": "M",
                    "message": ""
                },
                "credit_card": {
                    "card_type": "master",
                    "card_iin": "555555",
                    "card_last4": "4444",
                    "card_expiry_month": null,
                    "card_expiry_year": null
                },
                "gift_certificate": null,
                "store_credit": null,
                "offline": null,
                "custom": null,
                "payment_instrument_token": null,
                "custom_provider_field_result": null
            }
        ],
        "meta": {
            "pagination": {
                "total": 1,
                "count": 1,
                "per_page": 50,
                "current_page": 1,
                "total_pages": 1,
                "links": {
                    "current": "?page=1&limit=50"
                }
            }
        }
    }

     

    This is the response from a standard website order:

    359 website order
    {
        "data": [
            {
                "id": 545273651,
                "order_id": "359",
                "event": "purchase",
                "method": "nonce",
                "amount": 43,
                "currency": "AUD",
                "gateway": "braintree",
                "gateway_transaction_id": "gmwhvej2",
                "payment_method_id": "braintree.card",
                "status": "ok",
                "test": true,
                "fraud_review": false,
                "reference_transaction_id": null,
                "date_created": "2022-08-31T09:23:02+00:00",
                "avs_result": {
                    "code": "M",
                    "message": "Street address and postal code match.",
                    "street_match": "Y",
                    "postal_match": "Y"
                },
                "cvv_result": {
                    "code": "M",
                    "message": ""
                },
                "credit_card": {
                    "card_type": "master",
                    "card_iin": "555555",
                    "card_last4": "4444",
                    "card_expiry_month": 10,
                    "card_expiry_year": 2025
                },
                "gift_certificate": null,
                "store_credit": null,
                "offline": null,
                "custom": null,
                "payment_instrument_token": null,
                "custom_provider_field_result": null
            }
        ],
        "meta": {
            "pagination": {
                "total": 1,
                "count": 1,
                "per_page": 50,
                "current_page": 1,
                "total_pages": 1,
                "links": {
                    "current": "?page=1&limit=50"
                }
            }
        }
    }

     

    You can see they are pretty much identical.

     

    The only difference is that when I query the order object itself, the response from the manual backend order is slightly different to the public website order:

     

    Manual Order:

        "is_email_opt_in": false,
        "credit_card_type": null,
        "order_source": "manual",
        "channel_id": 1,
        "external_source": null,

     

    Public Website Order:
     "is_email_opt_in": false,
        "credit_card_type": null,
        "order_source": "www",
        "channel_id": 1,
        "external_source": "",

     

    Both the public website and backend both use exactly the same payment gateway in BigCommerce.

    Let me know your suggestions, I really appreciate your help!

    Geoff

    smarenich
    Acumatica Moderator
    Forum|alt.badge.img+3
    • smarenich
    • Acumatica Commerce Edition Team Lead
    • 227 replies
    • September 5, 2022

    @geoffreym I checked the JSON and code and I don’t see any reason why payment is not imported, other than the order is not synchronized. 

    Could you please check that if you go to Sync History and use All Records tab, there are no payment with this ID?

    If no, then I would recommend to create a Case with Acumatica, so we can review it by engineers.

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • 2759 replies
    • November 1, 2022

    Hi @geoffreym - were you able to find a solution? Thank you!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    G
    Freshman II
    • geoffreym
    • Author
    • Freshman II
    • 7 replies
    • Answer
    • November 4, 2022

    Hi @Chris Hackett, for now I have implemented some business events to create the payments and tidy things up, and will review this issue again once we upgrade to the next major build locally which may or may not fix this issue. 

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved