[Solved] [3.0.1.1] Square Payment

`amount_money.amount` must be greater than 100. Field: amount_money.amount

2017-10-18 23:17:26 - SQUAREUP DEBUG START...
2017-10-18 23:17:26 - SQUAREUP ENDPOINT: https://connect.squareup.com/v2/locations/CBASEHT1FRZvI9DyBdYNX6kNVpggAQ/transactions
2017-10-18 23:17:26 - SQUAREUP HEADERS: Array
(
    [0] => Authorization: Bearer sandbox-sq0atb-YGyUaR_QrKFW_sn42mR80Q
    [1] => Content-Type: application/json
)

2017-10-18 23:17:26 - SQUAREUP PARAMS: {"idempotency_key":"59e7e1060ed14","amount_money":{"amount":0,"currency":"USD"},"billing_address":{"first_name":"Xxxxx","last_name":"Xxxxxxx","address_line_1":"XXXX Xxxxxxxx Xx","address_line_2":"","locality":"Xxxxxxx","sublocality":"Xxxxxxx","postal_code":"XXXXX","country":"US","organization":""},"buyer_email_address":"Xxxxxxx@XXXXXXX.com","delay_capture":false,"integration_id":"sqi_65a5ac54459940e3600a8561829fd970","shipping_address":{"first_name":"Xxxxxx","last_name":"Xxxxxxxxx","address_line_1":"XXXX Xxxxxxxx Xx","address_line_2":"","locality":"Xxxxxxx","sublocality":"Xxxxxxx","postal_code":"XXXXX","country":"US","organization":""},"customer_card_id":"[redacted]","customer_id":"[redacted]"}
2017-10-18 23:17:26 - SQUAREUP RESULT: {"errors":[{"category":"INVALID_REQUEST_ERROR","code":"VALUE_TOO_LOW","detail":"`amount_money.amount` must be greater than 100.","field":"amount_money.amount"}]}
2017-10-18 23:17:26 - `amount_money.amount` must be greater than 100. Field: amount_money.amount

            foreach ($refunds as $refund) {
                $amount = $this->currency->format(
                    $this->squareup->standardDenomination(
                        $refund['amount_money']['amount'],
                        $refund['amount_money']['currency']
                    ),
                    $refund['amount_money']['currency']
                );

straightlight wrote: ↑

Thu Oct 19, 2017 7:08 am

Squareup payment module includes a debug functionality. In your admin - > extensions - > extensions - > payments - > your enabled squareup payment module - > edit, ensure to activate the debug option. Then, put your site under maintenance from your admin - > system - > settings - > edit - > server tab. Test another order on your store to see if you are able to replicate the issue. When so, see either in your admin error logs or your squareup error logs tab for new debug entries.

straightlight wrote: ↑

Thu Oct 19, 2017 7:43 am

Have you applied the last month's bug fixes on the squareup module? They can be found on Github:

- https://github.com/opencart/opencart/bl ... uareup.php
- https://github.com/opencart/opencart/bl ... order.twig

Before you apply the bug fixes, make sure to take a screenshot at your squareup admin payment modules configurations. Then, uninstall the module. Then apply the bug fixes, reinstall the module, clear all caches (Opencart's both cache, then logout, browser's cache), close the browser, reopen the browser and log back into the admin section. Then, go to the squareup module page, reconfigure the form, re-test an order in sandbox and debug mode, see if the issue persists.

straightlight wrote: ↑

Thu Oct 19, 2017 7:52 am

Follow the steps above, as indicated.

straightlight wrote: ↑

Thu Oct 19, 2017 8:03 am

The steps provided above are the step-by-step guide. However, if your settings are properly saved and you go back to the form seeing those settings as you entered them, then the issue might need to be addressed due to an invalid response with the Squareup API caused by possible missing parameters.

jpedroza2k wrote: ↑

Thu Oct 19, 2017 3:21 pm

There was an issue with the database, specifically in the oc_setting table, where some of the key->value pairs were missing. I added a UNIQUE index to the `key` column, and then ran the setup for that table from /install/opencart.sql changing the INSERT to an INSERT IGNORE. Once I did that the prices started showing correctly for logged in users. When processing payment, these missing elements caused there to be a $0 balance in the cart, which was causing the failure.