Printable View
Adam, I have a client who wants to proccess payments through quickbooks with zen-cart. I see the free version is outdated and since we are using 1.5 can you give me an idea of a cost for a plug-in that will work or will the free version work with 1.5.
We want to make sure this will work without any issues for this client.
QBI does not work with UK Quickbooks.
1) QBI does not import credit card information into Quickbooks. Most people process credit cards in real time inside of Zen Cart using a payment gateway, so it is not necessary for QBI to import this information.Quote:
Originally Posted by vman570
2) The old free version of QBI (almost 6 years old) works with ZC 1.3.x and probably also works fine with 1.5.x, however I have not tested it and don't offer help with that.
3) The old free version may have some issues with PHP 5.x. I have not tested it on PHP 5 and can't offer help with that.
4) I can't discuss non-free versions here, but try using Google to find out about it.
Adam
i have read most of the post, so my questions is, i have just opened up business in australia, so if it was to buy quickbooks to use as my tax information for the accountant, then i can transfer from zen cart into the quickbooks and this is automated from the zen cart. it will keep the books up to date with invoices and etc, i dont use a payment gateway only bank deposit as payment reference on the website
No luck with installation at all. Nothing ever shows up. I've tried uploading to the "admin" directory and also the "zc_admin" directory and still nothing. I have yet to see a menu item for QBI anywhere in my store. I know I must be doing something wrong, but what I have no clue. And yes, I'm new to ZenCart.
If you are using ZenCart Version 1.50 or higher, the QBI Free Plugin will not function. You would need to spend well over $100.00 to BUY the Plugin for ZenCart Version 1.50 from the Author. :shocking:Quote:
Originally Posted by Rathius
Quote:
Originally Posted by danielosko
However, after many hours of research and learning code on the way. I found out how to get Quickbooks Import QBI Version: 3.21b to work for my Zen Cart 1.3.9x since Adam is keeping most of us in the dark. I don't blame him. If I spent as many hours as he did working on an awesome plug-in, I would want to be compensated for my time as well instead of giving out free support.
Anyways, anybody who wants Quickbooks Import QBI Version: 3.21b to work on at least Zen Cart 1.3.9x (have not tested v1.5x) need to update the following files:
qbi_v3_21b_zen/catalog/admin/qbi_0_00_3-21.sql
qbi_v3_21b_zen/catalog/admin/qbi_1_00_3-21.sql
Look thru each file for this line of code:
AND CHANGE IT TO (REMOVE THE (14)):Code:updated timestamp(14) NOT NULL,
added timestamp(14) NOT NULL,
Also you may need to change the following code depending on which version of phpMyAdmin/MySQL you are using from:Code:updated timestamp NOT NULL,
added timestamp NOT NULL,
To:Code:TYPE=MyISAM;
and Save changes and Install Databases.Code:ENGINE=MyISAM;
Let me know if this works for you!
Hi,
Thank you! The current version has about 7,000 lines of code and people need help from time to time. It would be impossible (and I wouldn't want to!) do this for free! I had intended to make an updated "lite" free version at some point, but just haven't found the time.Quote:
Originally Posted by g00glethis1
I haven't looked at 3.21 for quite some time, but I don't think any significant changes are needed for ZC v1.5. There were no changes needed in the paid version. QBI talks directly to the database, and the basic database structure in the relevant tables in ZC has had few changes over the years.
The problems you may run into with QBI v3.21 are related to deprecated PHP and MySQL code, and have to do with the version of PHP and MySQL you are running.
The changes mentioned in the previous post are needed if you are running MySQL v5.5 or later, and are not directly related to the version of ZC. You do need to remove the "(14)" after timestamp. As for "TYPE=MyISAM", you can change it as suggested to "ENGINE=MyISAM", or just leave it out entirely. If you leave it out, the table engine will be whatever your MySQL default is. It should work fine with either MyISAM or InnoDB.
Thanks,
- Adam (creator of QBI)
As soon as my store starts making some money, I will invest into the paid version QBI. Just launched the website & it went live tonite!!!
I finally figured out what is happening here. If the "Orders.Orders_Status" field is not = 1 then the QBI add-on won't pull the record as being a new order. This happens if the invoice has no dollar value, I'm guessing the core code has something that sets zero dollar values to in process.Quote:
Originally Posted by lunabug
Regardless, now before I use the QBI to download new invoices I run this simple code as a sql patch in the admin tools section:QBI then sets the order status to whatever you have that configured to in the QBI configurations settings.Code:UPDATE orders
SET orders_status = 1
WHERE qbi_imported = 0;
YAY!