Bounty PAID: BITCOIN OPEN CART PAYMENT MODULE!

[FuzzyBear]

Ok I tried to setup both versions of this BTC plugin and both fail each at different points... perhaps opencart has had an update or something? is this thread still alive to try and help me debug the issues? or am I going to have to start from scratch?

any help will be very greatly appreciated

sites i'm trying on are

jga / btcgear version - http://opencart-btc.btc-music.com

Yrock version - http://opencart2-btc.btc-music.com

i have emailed jga directly but not had a reply with detailed info of my problems,

Yurock I seemed to even just have errors pop up on trying to install the latest version of ur code... on installing bitcoin as payment method... just goes to white screen... can refresh the site and it looks to have installed anyway... but no currency added to the DB, and the settings when clicking control and bills throws errors

Code:

Notice: bitcoind: RPC getinfo failed:curl_exec () failed: The requested URL returned error: 401 in C:\_websites\YourikBTCOpencartPlugin\admin\controller\payment\bitcoind.php on line 595Notice: bitcoind: RPC getaddressesbyaccount failed:curl_exec () failed: The requested URL returned error: 401 in C:\_websites\YourikBTCOpencartPlugin\admin\controller\payment\bitcoind.php on line 595

but bitcoind is def running on the server and i can do getinfo on it in a cmd

second error is only prob cause there has been no purchases yet...

Code:

Notice: Error: Table 'opencart2btc.oc_bitcoind_bill' doesn't exist
Error No: 1146
Error in: C:\_websites\YourikBTCOpencartPlugin\admin\model\payment\bitcoind.php line 67
SELECT order_id,total,status,deadline,sent,payment_address,refund_address,IF(deadline,TIMESTAMPDIFF(SECOND,NOW(),deadline),NULL)AS time_left FROM oc_bitcoind_bill LIMIT 0,20 in C:\_websites\YourikBTCOpencartPlugin\system\database\mysql.php on line 54

But I have had another issue... i have enabled the bitcoin as payment method, set the localhost and port info as well as username and pass, set the sort value to 1.  I checkout and get past stage 5... but on stage 6 of checkout I get the same error as on your test website?? is this a sign of something else broken? or have i not done something?

any advice??

otherwise nice code and simple plugin

[1714855218]

1714855218

[1714855218]

1714855218

[1714855218]

1714855218

[1714855218]

1714855218

[1714855218]

1714855218

[Yurock]

perhaps opencart has had an update or something?

My extension is currently unmaintained due to lack of interest from users. I haven't tested it with latest OpenCart, but I'm going to do it as time permits.

is this thread still alive to try and help me debug the issues?

Sort of. You can also send me a PM or email.

Yurock I seemed to even just have errors pop up on trying to install the latest version of ur code... on installing bitcoin as payment method... just goes to white screen... can refresh the site and it looks to have installed anyway...

Code:

Notice: Error: Table 'opencart2btc.oc_bitcoind_bill' doesn't exist
Error No: 1146
Error in: C:\_websites\YourikBTCOpencartPlugin\admin\model\payment\bitcoind.php line 67
SELECT order_id,total,status,deadline,sent,payment_address,refund_address,IF(deadline,TIMESTAMPDIFF(SECOND,NOW(),deadline),NULL)AS time_left FROM oc_bitcoind_bill LIMIT 0,20 in C:\_websites\YourikBTCOpencartPlugin\system\database\mysql.php on line 54

During installation, the extension needs to create a table in the database. It seems like this step failed. Maybe the MySQL user account of OpenCart does not have the needed permission. If this is the case:

• uninstall the extension;
• grant CREATE privilege to the OpenCart database user on the OpenCart database;
• install the extension again;
• optionally revoke the CREATE privilege.

Alternatively, you can create the table manually:

Code:

CREATE TABLE`oc_bitcoind_bill`(`order_id`INT NOT NULL,`total`DECIMAL(16,8)NOT NULL,`status`ENUM('wait', 'timeout','receive','reverse','confirm','complete','cancel')COLLATE ascii_bin NOT NULL DEFAULT'wait',`deadline`DATETIME NOT NULL DEFAULT'0000-00-00 00:00:00',`sen
t`DECIMAL(16,8)NOT NULL DEFAULT 0,`payment_address`CHAR(34)COLLATE ascii_bin NOT NULL,`refund_address`CHAR(34)COLLATE ascii_bin NOT NULL,PRIMARY KEY(`order_id`),UNIQUE KEY(`payment_address`),INDEX(`status`));

but no currency added to the DB

It is not supposed to add the currency automatically. You need to add it manually and specify it in the extension settings. Also note that if you specify prices in another currency, you'll need to update BTC rate somehow.

otherwise nice code and simple plugin

That's not about my extension.

[Sebjectivist]

I would like to add a feature request and along with it 10 BTC bounty for this feature: Add an easy to implement hack into Opencart that adds Bitcoin as a currency and gives the user the choice to display prices in Bitcoin or any other currency.

Done. This is already in my latest version.  In the admin console upon install, you can choose whether or not to enable BTC as a user-visible currency.

Edit: I also have this available as a stand-alone module, but I haven't open sourced it yet.

Edit: now I have open sourced it and it is available at https://github.com/btcgear/Bitcoin_Exchange_Rate_OpenCart
This code is fully tested and has been in use at http://www.btcgear.com for months.

Please send bounty to 14dTC7bBphANAHzmK9aD7X7Wvo99rhHMTF

I'm dying for a module like this because if the strong fluctuations.. it only works if the standard valuta is USD - but mine has to be EUR.. I recon it's not too difficult to fork this module for the european market? I emailed the guy, and I just hope someone can explain me how to do it sooner rather then later

[BiTCoinRC]

I would like to add a feature request and along with it 10 BTC bounty for this feature: Add an easy to implement hack into Opencart that adds Bitcoin as a currency and gives the user the choice to display prices in Bitcoin or any other currency.

Done. This is already in my latest version.  In the admin console upon install, you can choose whether or not to enable BTC as a user-visible currency.

Edit: I also have this available as a stand-alone module, but I haven't open sourced it yet.

Edit: now I have open sourced it and it is available at https://github.com/btcgear/Bitcoin_Exchange_Rate_OpenCart
This code is fully tested and has been in use at http://www.btcgear.com for months.

Please send bounty to 14dTC7bBphANAHzmK9aD7X7Wvo99rhHMTF

I'm dying for a module like this because if the strong fluctuations.. it only works if the standard valuta is USD - but mine has to be EUR.. I recon it's not too difficult to fork this module for the european market? I emailed the guy, and I just hope someone can explain me how to do it sooner rather then later

I noticed the plugin has now been updated to use other currencies, did you manage to get it working? If possible could you PM me the URL of your store so I can see it in action? Thanks.

[Sebjectivist]

I would like to add a feature request and along with it 10 BTC bounty for this feature: Add an easy to implement hack into Opencart that adds Bitcoin as a currency and gives the user the choice to display prices in Bitcoin or any other currency.

Done. This is already in my latest version.  In the admin console upon install, you can choose whether or not to enable BTC as a user-visible currency.

Edit: I also have this available as a stand-alone module, but I haven't open sourced it yet.

Edit: now I have open sourced it and it is available at https://github.com/btcgear/Bitcoin_Exchange_Rate_OpenCart
This code is fully tested and has been in use at http://www.btcgear.com for months.

Please send bounty to 14dTC7bBphANAHzmK9aD7X7Wvo99rhHMTF

I'm dying for a module like this because if the strong fluctuations.. it only works if the standard valuta is USD - but mine has to be EUR.. I recon it's not too difficult to fork this module for the european market? I emailed the guy, and I just hope someone can explain me how to do it sooner rather then later

I noticed the plugin has now been updated to use other currencies, did you manage to get it working? If possible could you PM me the URL of your store so I can see it in action? Thanks.

Thank you so much for telling me!! It works out of the box with my 1.5.5.1 install I did already add BTC as a valuta before, keeping it up to date manually. This is such a relief!! You can visit my store by following the link in my profile..

[BiTCoinRC]

I have got this installed now (jga full version) and all seems to be working but it is not saying it has been paid or adding the order on my end?? I have 3 confirmations so far on a test payment of 0.001 BTC and the payment is in my wallet. I'm using the blockchain.info JSON RPC API login details to connect to my blockchain wallet, could this be the problem?:

Store front 1:
http://s24.postimg.org/eszb7p5zp/btc1.png

3 Confirmations:
http://s24.postimg.org/rbki20sd1/btc3.png

Store front 2:
http://s14.postimg.org/v6isvj3s1/btc2.png

It is adding the funds/address to my wallet but not adding the order or saying it has been paid on the website end:
http://s8.postimg.org/50rjt75cl/btc4.png

This was in my opencart error log:

Code:

2013-05-12 2:57:03 - PHP Notice:  Undefined variable: bitcoin_send_address in /home/*****/public_html/catalog/view/theme/default/template/payment/bitcoin.tpl on line 55

Any help is much appreciated. I'm using Opencart 1.5.5.1 and a blockchain.info wallet.

[Sebjectivist]

Yes, it is my intention to be independent of the middle men. I haven't been as brave as you to try and install the payment module, and I'm not skilled enough to help you sorry. As my shop is just starting I'm thinking about just providing a fixed bitcoin address. I don't think that's any different from providing details about a bank account. for business it is cheaper though. Before I do that I want to be able to charge the customer for the transaction costs - to make it clear what the difference is between say paypal and bitcoin. I just learned paypal forbids you to separately add the transaction costs, and I'm curious if they're going to cut me off 

[Yurock]

Before I do that I want to be able to charge the customer for the transaction costs - to make it clear what the difference is between say paypal and bitcoin. I just learned paypal forbids you to separately add the transaction costs, and I'm curious if they're going to cut me off 

One can provide a discount for Bitcoin payments instead, but who cares about PayPal?

[jga]

I'm dying for a module like this because if the strong fluctuations.. it only works if the standard valuta is USD - but mine has to be EUR.. I recon it's not too difficult to fork this module for the european market? I emailed the guy, and I just hope someone can explain me how to do it sooner rather then later

Hey, sorry I didn't get back to you when you emailed about EUR support. I integrated it and then couldn't remember what e-mail address you contacted me through or if it had been a forum PM or whatever so I couldn't let you know I had gotten it working.

As for everyone else, if you're still having issues with my extension, email me at support@btcgear.com and I'll see what I can do. I can make a test site and/or test bitcoind server available to one user at a time which can make troubleshooting much easier.

[BiTCoinRC]

As for everyone else, if you're still having issues with my extension, email me at support@btcgear.com and I'll see what I can do. I can make a test site and/or test bitcoind server available to one user at a time which can make troubleshooting much easier.

Thanks for the email. I have replied, hopefully this can be made to work with the blockchain.info JSON RPC API

Yes, it is my intention to be independent of the middle men. I haven't been as brave as you to try and install the payment module, and I'm not skilled enough to help you sorry. As my shop is just starting I'm thinking about just providing a fixed bitcoin address. I don't think that's any different from providing details about a bank account. for business it is cheaper though. Before I do that I want to be able to charge the customer for the transaction costs - to make it clear what the difference is between say paypal and bitcoin. I just learned paypal forbids you to separately add the transaction costs, and I'm curious if they're going to cut me off  

I think the problem of providing just one address is that you will not know who has sent you the BTC :-/

As said above though just do a discount for BTC, many sites do this (10% off or similar) if you pay by bank transfer rather than CC

[Sebjectivist]

I think the problem of providing just one address is that you will not know who has sent you the BTC :-/

With the current amount of orders I should be good for now  . But I'll instruct my customers to add the ordernumber as a description. anyone can add a description to their payments right?

[BiTCoinRC]

I think the problem of providing just one address is that you will not know who has sent you the BTC :-/

With the current amount of orders I should be good for now  . But I'll instruct my customers to add the ordernumber as a description. anyone can add a description to their payments right?

To be honest I'm not sure if you can add a comment/order number with a payment, maybe somebody else can let you know about this... I run a store that accepts bank transfer and that's what I do, get the customer to put the order number as the reference but 99% of the time the payment actually shows the customers name in my bank account anyway, on the odd occasion (I think when they go directly to my bank to make a deposit) it will only show the city/branch name and the reference/order number.

This is what I like about JGA's payment module, it makes a new address with the label as a prefix and the order number, so you could have a different prefix for different stores and still use the same wallet without it getting confusing, like in the screen shot below:

http://s24.postimg.org/4bcsocibp/btcrccri.png

  

[Sebjectivist]

I think the problem of providing just one address is that you will not know who has sent you the BTC :-/

With the current amount of orders I should be good for now  . But I'll instruct my customers to add the ordernumber as a description. anyone can add a description to their payments right?

To be honest I'm not sure if you can add a comment/order number with a payment, maybe somebody else can let you know about this... I run a store that accepts bank transfer and that's what I do, get the customer to put the order number as the reference but 99% of the time the payment actually shows the customers name in my bank account anyway, on the odd occasion (I think when they go directly to my bank to make a deposit) it will only show the city/branch name and the reference/order number.

This is what I like about JGA's payment module, it makes a new address with the label as a prefix and the order number, so you could have a different prefix for different stores and still use the same wallet without it getting confusing, like in the screen shot below:

http://s24.postimg.org/4bcsocibp/btcrccri.png

  

Sure. Well I'm using Electrum and it's possible to add a description to your payment. Will have to check if that's standard.

Eventually jga's module is what I need, because it's the only way to automate things. For small scale I think it can be done my way as well..

[alfabitcoin]

Can somebody help me?
Have a problem with btc-usd exchange (bitcoin_update.php) with change by adding one line in index.php

Fatal error: Call to undefined function strptime()

running php version 5.4.3

Maybe can be replaced with date_parse_from_format() ?

[BiTCoinRC]

Sure. Well I'm using Electrum and it's possible to add a description to your payment. Will have to check if that's standard.

Eventually jga's module is what I need, because it's the only way to automate things. For small scale I think it can be done my way as well..

I have not tried Electrum yet, just having a look at it now and it seems quite impressive. My plan is to just dump all the BTC into an offline wallet each day/week.

From the standard bitcoin-qt client, I just had a look and it does not look like you can add a comment when sending a payment, only a label for yourself. Maybe I am missing something.

[jga]

Well, I finally figured out why it wasn't working with the Blockchain.info JSON-RPC API. It appears the JSON-RPC API returns Bitcoin values rounded to three decimal points (!) So... the smaller orders I was testing with returned 0.000 received when they should have returned 0.0001... There was some other weird behavior with the blockchain API so I need to test more thoroughly before I push out a fix.

I also have some other features (including a timer and a bit cleaner interface) and bugfixes that I'm hoping to roll out in the next day or two.

[jga]

Well, friends, I have some bad news. It appears the Blockchain.info JSON-RPC API can not play nice with my payment module in its current incarnation. The payment module relies upon immediate acknowledgement of a transaction (0 confirmations) in order to function properly. There is a delay between sending payment to a Blockchain.info MyWallet address and Blockchain's acknowledgement of the transaction. It appears to wait until 1 confirmation. This means that it is impossible to do a slick immediate recognition of payment (as my payment module is programmed to do) with the Blockchain.info API at the present.

I could write an extension that would accept any order regardless of whether payment was ever sent, OR I could write an extension that would instruct the user to wait 10 or 15 minutes to see if their order went through. Both sound like a rather silly way of doing business, but unfortunately that's all that would be possible with the Blockchain.info JSON-RPC API (until they improve it).

[BiTCoinRC]

Well, friends, I have some bad news. It appears the Blockchain.info JSON-RPC API can not play nice with my payment module in its current incarnation. The payment module relies upon immediate acknowledgement of a transaction (0 confirmations) in order to function properly. There is a delay between sending payment to a Blockchain.info MyWallet address and Blockchain's acknowledgement of the transaction. It appears to wait until 1 confirmation. This means that it is impossible to do a slick immediate recognition of payment (as my payment module is programmed to do) with the Blockchain.info API at the present.

I could write an extension that would accept any order regardless of whether payment was ever sent, OR I could write an extension that would instruct the user to wait 10 or 15 minutes to see if their order went through. Both sound like a rather silly way of doing business, but unfortunately that's all that would be possible with the Blockchain.info JSON-RPC API (until they improve it).

This is a shame. Could you possibly make a version that shows a button "click here when you have sent payment", that will close the window and put the order through regardless of payment? I know this is not ideal but it would be no harder to check if the payment has been made than it would for say a bank transfer payment. Thanks for your time on this.

[Yurock]

Could you possibly make a version that shows a button "click here when you have sent payment", that will close the window and put the order through regardless of payment? I know this is not ideal but it would be no harder to check if the payment has been made than it would for say a bank transfer payment.

It makes sense to separate verification from the ordering process. The payment extension will only need to generate and display a new address for every order, which can be done in PHP. The extension can generate public keys using a deterministic wallet algorithm. The corresponding private keys can be generated locally on operator's computer. This scheme does not need a hot wallet or a third-party service.

[BiTCoinRC]

Could you possibly make a version that shows a button "click here when you have sent payment", that will close the window and put the order through regardless of payment? I know this is not ideal but it would be no harder to check if the payment has been made than it would for say a bank transfer payment.

It makes sense to separate verification from the ordering process. The payment extension will only need to generate and display a new address for every order, which can be done in PHP. The extension can generate public keys using a deterministic wallet algorithm. The corresponding private keys can be generated locally on operator's computer. This scheme does not need a hot wallet or a third-party service.

In all honesty I would personally still check each payment had been made manually anyway, so for me this solution would be fine. I can understand how others may want the whole process to be automatic though, especially for digital goods.