Quickbooks Import QBI

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.

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.

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

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.

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.

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:

danielosko:

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:

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!

Hi,

g00glethis1:

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)

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!

Our Shopping Cart eIntegrator for QuickBooks has been running for years. It has extreme flexibility to meet your business needs. Supports all recent versions expect Simple Start editions including QB Online and QuickBooks Point of Sale (QBPOS). We ourselves are using ZenCart 1.5.

Hi,

lunabug:

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.
The Order Status does not necessarily have to be =1. It can be whatever you select in the QBI configuration.
Thanks,
Adam

Hi there,
new to the zen cart community, had a couple of questions for anyone who may be able to help.
first, how does the QBI work for you? and second, will it support Quickbboks Premier 2013?
any help would be greatly appreciated.

jbw2cool:

Hi there,
new to the zen cart community, had a couple of questions for anyone who may be able to help.
first, how does the QBI work for you? and second, will it support Quickbboks Premier 2013?
any help would be greatly appreciated.

I'd like to be able to import my inventory items from Quickbooks Pro 2013 into ZenCart, and then my ZenCart orders back to quickbooks (thus decrementing the inventory appropriately) -now THAT is integration.

In simple terms, this "plugin" does not work with Zen Cart 1.50 or above. I have attempted "everything known to man" and re-read EVERY posting..., and there is no response or solution. (other than to PURCHASE the authors new "plugin" for $175.00).

Even though Zen Cart is a highly technical program to get "up and running"..., I have used Zen Cart for nearly five years. (however, since the update..., I am now, unfortunately, committed to using it)

With that said, I STRONGLY regret updating to 1.50! Most of the "bells and whistles" are no longer available or supported. I am VERY displeased with this new release and the lack of functioning "plugins". Especially, when you take away one of the main functions that every shopping cart program should have, (which I believe is to have the ability to actually download your customer and order information into a format in which your accounting program can actully utilize)!!!! Because, if you can't download this info into a usable format..., YOU HAVE TO COPY EVERYTHING INTO YOUR ACCOUNTING PROGRAM BY HAND!

This is a great program, with a multitude of knowlegable authors. All of whom deserve credit and thanks. But overall, If I had to do this over again..., I would have paid for a FUNCTIONING shopping cart.

Best Regards,
Dan Osko
Owner of:
Bubbas Pools
http://bubbaspools.com
&
USA Spa Parts
http://usaspaparts.com

Daniel,

danielosko:

In simple terms, this "plugin" does not work with Zen Cart 1.50 or above. I have attempted "everything known to man" and re-read EVERY posting..., and there is no response or solution. (other than to PURCHASE the authors new "plugin" for $175.00).
The free version of QBI is quite old, I don't guarantee its functionality, and I only provide minimal support for it. That being said, there is nothing about ZC 1.5 that presents any compatibility issue. In fact, there were no changes made to the paid version of QBI to accommodate the move from ZC 1.39 to ZC 1.5 and it works perfectly with it.

QBI uses no ZC code whatsoever and interacts directly with the ZC MySQL database (the only changes made in ZC during installation are to place a link to QBI in the admin menu). So, it is immune to changes in ZC code, and only affected by changes in the ZC database structure, of which there were none of importance that affected QBI.

The issues you may run into have to do with deprecated PHP functions and SQL commands, both of which I have addressed in a recent post. Additionally, if you created a new database for your ZC 1.5 installation, you will likely need to update the QBI config file to connect to it.

I don't know what the problem is that you are experiencing, but I can pretty much be sure that it is not due to any difference between ZC 1.39 and 1.5. I suggest that you make the PHP and MySQL fixes in QBI if needed (depending on the PHP and MySQL versions on your server), check the database connection login details in the QBI config, and check your server log for any PHP errors when you try to run QBI.

Thanks,
Adam

You should check out our Integrator. We use ZenCart as our eCommerce system and have been integrating with QuickBooks for over 8 years. This includes QB Online and QB Point of Sale. EXTREMELY FLEXIBLE and rapid responses to emails, our forum and you even get us on the phone.

http://www.aaatex.com/QuickBooks_Shopping_Cart_Integrator_Cart.htm

I just installed this on 1.5 cart - used the page admin registration (BOX_CUSTOMERS_QBI for both the first 2 boxes, FILENAME_QBI for filename. Put it under tools with sort of 20). It shows up and installs. I have not and will not be the one configuring it so I may eventually hear back that something doesn't work but it looks good at first glance.

I have an installation of 1.51 and am trying to install QBI. After following the installation procedures, when I login to zen-cart admin there is no link for the installation module in customers, therefore I am unable to complete installation.
After reading through numerous pages of this blog the only thing I am able to find addressing this issue is back in Jan 2010 stating that qbi_customers_dhtml.php should be in extra_boxes rather than boxes. I checked and the version I downloaded already has this change made so that is not my issue.

My question now is: will QBI work with version 1.51 or does anyone know what I can do to make it work?

RBiZ:

I have an installation of 1.51 and am trying to install QBI. After following the installation procedures, when I login to zen-cart admin there is no link for the installation module in customers, therefore I am unable to complete installation.
After reading through numerous pages of this blog the only thing I am able to find addressing this issue is back in Jan 2010 stating that qbi_customers_dhtml.php should be in extra_boxes rather than boxes. I checked and the version I downloaded already has this change made so that is not my issue.

My question now is: will QBI work with version 1.51 or does anyone know what I can do to make it work?

OK I followed the instructions posted by delia for Admin Page Registration and was able to get to the database installation page (I placed it in "customers" rather than tools). I ran this step and it said that the installation was successful, however when I follow the instructions to configure QBI it takes me back to the install page /qbi_install.php?db_ver=0&qbi_vers=3.21
There is no option to configure.