Quickbooks Import QBI

[vman570]

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.

[adam5532]

QBI does not work with UK Quickbooks.

[adam5532]

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.

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.
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

[fraser coast]

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

[Rathius]

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.

[danielosko]

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.

[g00glethis1]

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.

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:

  updated timestamp(14) NOT NULL,
  added timestamp(14) NOT NULL,

AND CHANGE IT TO (REMOVE THE (14)):

  updated timestamp NOT NULL,
  added timestamp NOT NULL,

Also you may need to change the following code depending on which version of phpMyAdmin/MySQL you are using from:

TYPE=MyISAM;

To:

ENGINE=MyISAM;

and Save changes and Install Databases.

Let me know if this works for you!

[adam5532]

Hi,

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.

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.

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)

[g00glethis1]

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!!!

[lunabug]

I've been using this add-on for several months and aside from a few minor issues has worked flawlessly, until today.

When I exported my orders there is one missing, I've looked at the data, the qbi_imported field is set to 0 in the orders table. Does anyone know what other fields are in the query and what they need to be set to to show as a new order?

Thanks for your help!

Leslie

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.

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:

UPDATE orders
SET orders_status = 1
WHERE qbi_imported = 0;

QBI then sets the order status to whatever you have that configured to in the QBI configurations settings.

YAY!