Quickbooks Import QBI

nels267:

Adam,

I too am getting the below errors, however, my database_tables.php file is entered correctly? This was a new install for me using ZenCart Ver. 1.3.0.1

Thanks in advance,
Keith
Keith,
The code you copied is caused when you are using a database table prefix, and you are installing QBI v3.00, or by installing v3.01 but not using the revised database_tables code in the 3.01 installation manual. The column names all start with qbi_. If the error message shows your database prefix beforehand, like "avtec_qbi_" in the example, then you aren't using 3.01 with the revised instructions.

If you error message is actually something different, then please repost with a copy of your own error message.

Thanks,
Adam

Adam,

My bad. I never uncommented the last lines of the sql file, since I install the files manually.

Thank you for your quick response and an awsome contribution,

Keith

My need is to integrate not with Quickbooks itself, but instead with Quickbooks POS... I was hoping this package would work for me, but as I see that it works with iif files, it will not. I would be interested in co-developing an XML interface.

Thanks!

• Daniel ([email protected])

adam5532:

So, you'd have to get the API from Intuit, and I don't know if it even has the ability to communicate directly with a shopping cart. QBI will work with any payment module that you use with ZenCart, because the payment actually happens in the shopping cart, and QBI only needs to determine if the order has been paid for or not. Besides, iif files don't have fields for credit card numbers (a future release of QBI will be able to make XML files, which can hold that information and then you will be able to process credit cards within QB using their merchant service if you wish).

danielcor:

My need is to integrate not with Quickbooks itself, but instead with Quickbooks POS... I was hoping this package would work for me, but as I see that it works with iif files, it will not. I would be interested in co-developing an XML interface.

Thanks!

• Daniel ([email protected])
  The future capability to produce XML output is built into QBI. In fact, it can produce just about any kind of output desired, because the output format is located in a separate class file. I just did not have time before the initial release to study the Intuit SDK and xml tag format. I'm not sure exactly what you mean by co-development in this case, but I would be glad to add xml at some time in the future, and donations in advance from those who need this feature to cover my time would bring it to the top of the list.

Thanks,
Adam

adam5532:

I'll take a look at it, and get back to you -- probably on Monday.

I'll look at this also.

Thanks,
Adam

Ok Adam, Thanks.

In the meantime is anyone that has this working having similar issues or am I the only one?

I am also getting this error in the code... As far as I can tell it is installed correctly...

Warning: array_walk(): Unable to call strip_quotes_array() - function does not exist in C:\Inetpub\wwwroot\DivaSplendorium - siteground\catalog\admin\includes\classes\qbi_classes.php on line 2446
Configuration successful

Looking through the code, I cannot find a definition of strip_quotes_array anywhere, and i do see the call to array_walk in qbi_classes.php. I do have the database defines correct (without the database prefeix).

Can you provide the code for strip_quotes_array?

Thanks,

• Daniel

danielcor:

I am also getting this error in the code... As far as I can tell it is installed correctly...

Looking through the code, I cannot find a definition of strip_quotes_array anywhere, and i do see the call to array_walk in qbi_classes.php. I do have the database defines correct (without the database prefeix).

Can you provide the code for strip_quotes_array?

Thanks,

• Daniel
  This is an error in the code :blush: .

In qbi_classes.php, line 2446, please replace:

if (get_magic_quotes_gpc()) array_walk($this->config_data,'strip_quotes_array');

with:

if (get_magic_quotes_gpc()) stripslashes_array($this->config_data);

Please fix this if you are using QBI 3.00 or 3.01. I will include this fix in the next update. This error occurs when you save configuration changes on the Configuration page and will only affect you if you have magic_quotes_gpc turned on in your PHP configuration.

Thanks,
Adam

landshark:

Adam,
I even went to far as to take "merchandise" out of the "sales" catagory and made it top level so now instead of entering "sales:merchandise" in config all i have is "merchandise", updated the config in QBI, re-exported my lists from QuickBooks and imported them into QBI then went through setup, double checked my matches and experted the previous orders. Same results. Duplicate items and the ones that are imported have no associated account, in my case should be merchandise.

Thanks in advance.
The Items:Item Income Account configuration setting only affects items that have not been matched when they appear on orders or in the Products iif file that QBI produces. This is because items in the store don't already have any account. When you match a store item to a Quickbooks item, the item account becomes what that item has in Quickbooks. Please check that the items you have matched have all the accounts filled in in Quickbooks. I have retested with both matched and unmatched items and everything appears to be working correctly.

Thanks,
Adam

I'm not sure if you understood what I was saying whith my comment. I probably didn't explain it very clearly. But i think it was irrevelant anyway...

All Items have been matched to thier corresponding products since the begining and remain matched now, I am still getting these items imported from my cart (via the import of orders), seprate items are being created in Quickbooks and the accounts column is left blank for these "new" items.

landshark:

I'm not sure if you understood what I was saying whith my comment. I probably didn't explain it very clearly. But i think it was irrevelant anyway...

All Items have been matched to thier corresponding products since the begining and remain matched now, I am still getting these items imported from my cart (via the import of orders), seprate items are being created in Quickbooks and the accounts column is left blank for these "new" items.
I would be glad to help you further, but at this point it is going to involve more time and we will need to escalate it. Please go to the QBI support page at https://www.libermansound.com/qbi for more details.

I am going to need to see your lists.iif export file from Quickbooks, a qbi_orders.iif file from QBI, and the QBI Orders Error Log, which you can download from the QBI Support tab in your store. Then I will know exactly what is going on and can solve it quickly.

Thanks,
Adam

adam5532:

I would be glad to help you further, but at this point it is going to involve more time and we will need to escalate it. Please go to the QBI support page at https://www.libermansound.com/qbi for more details.

I am going to need to see your lists.iif export file from Quickbooks, a qbi_orders.iif file from QBI, and the QBI Orders Error Log, which you can download from the QBI Support tab in your store. Then I will know exactly what is going on and can solve it quickly.

Thanks,
Adam

Adam,

The only thing i see at the link provided is donation information. Is there something specific i should be looking for? I will be more than happy to donate which i often do with working software.

The issues i have been having with paypal payments going to accounts recievable has also not been addressed. Do you have any input on this or am i in the same boat as with the items? Which looks like I will have to pay to get it to work correctly.

Is there anyone that has gotten this contribution working without problems, consistantly?

I am going to try to uninstall this and reinstall it. If it is truely a piece of working software and the problem is with me and no one else is having similar problems maybe something went wrong during the installation.

Any pointers for uninstalling this completely?

landshark:

Adam,

The only thing i see at the link provided is donation information. Is there something specific i should be looking for? I will be more than happy to donate which i often do with working software.
I think Justin Simoni, the Developer of DadaMail, puts it perfectly, so I am copying what he says here, substituting the name of QBI:
"QBI is an Open Source program, no support for the program is implied in the license. The program is free, direct support is not. But, free support can be had through the ZenCart/QBI community, of which the developer is a part of."

I provide a certain basic level of support in the forums, but at the point where a problem is not solved in a few posts and/or it requires me to examine your files, then we need to go to direct support. It still isn't clear to me from your description what the problem is that you are having, so I think that examining your files will save both of us time and resolve the issue. QBI is used by thousands of people (on the "other" cart as well as ZenCart) and works well. I've spent 535 hours so far developing it, and I hope that those who wish me to give of my time to help them with their individual issues can feel gracious and not reluctant to give something back. I don't work for free or on spec because someone has their own doubts about whether my software works. Because I don't want to violate the rules of the forums, details about advanced support options are located on the support site at https://www.libermansound.com/qbi.

The issues i have been having with paypal payments going to accounts recievable has also not been addressed. Do you have any input on this or am i in the same boat as with the items? Which looks like I will have to pay to get it to work correctly.
PayPal is working fine on the "other" cart. There may be differences on ZenCart, and I haven't had a chance to test it yet. This may be an issue with QBI, and I will set up and test PayPal on my own cart, so it probably won't involve your time or money to resolve. QBI was released on June 5th -- it is now June 13th. Please give me a little more time to address this issue!
Is there anyone that has gotten this contribution working without problems, consistantly?
I use it every day on my site, and it continually receives praise on the "other" cart's forum, where likely thousands of people use it. It has about 4,000 lines of code -- so far, only a couple of bugs have been discovered in version 3, and only a handfull of people (out of 200+ downloads) have reported any issues.
I am going to try to uninstall this and reinstall it. If it is truely a piece of working software and the problem is with me and no one else is having similar problems maybe something went wrong during the installation.
I find that 99% of problems are due to people not configuring it properly or fully, or not fully reading or understanding the instructions. If you do discover a bug, I am glad to fix it.
Any pointers for uninstalling this completely?
Reinstallation rarely is the fix. Instructions for reinstallation are in the Installation Manual.

Thanks,
Adam

Thank you adam, this is an important contribution. I will be installing and testing shortly.

Will update - :thumbsup:

On another side note... I have had a quick search of the forums and can't see anything directly related...

Are there any plans to do the same service for Sage Accounts? Many of our clients use Sage accounts, so I know this would benefit them.

I am also aware that there is quite a charge for becoming a sage partner, wrt developing API's etc. ( £1500+ I believe? ) Correct me if I am wrong.

Does QBI work with Quickbooks Online?

businesstoweb:

Thank you adam, this is an important contribution. I will be installing and testing shortly.

Will update - :thumbsup:

On another side note... I have had a quick search of the forums and can't see anything directly related...

Are there any plans to do the same service for Sage Accounts? Many of our clients use Sage accounts, so I know this would benefit them.

I am also aware that there is quite a charge for becoming a sage partner, wrt developing API's etc. ( £1500+ I believe? ) Correct me if I am wrong.
Thanks for letting me know about it. At the rate of $ that I am receiving for QBI (no donations yet out of 200 downloads, except for some generous people who gave donations in advance, and will recieve recognition) (and I do understand that people want to set it up and see how it works for them before donating) it is unlikely that I could afford the fee or the time to develop anything for Sage Accounts on a donation basis. If you are interested in persuing this however, please contact me privately and we can discuss it further.

Thanks,
Adam

Hi Adam,

As with all things, one can never rely on donations. If someone donates, then that’s great, but if you relied on the donations for any particular reason, you would probably fall short.

I'm sure if you offered a free "cut down version" of QBI, then offered a few extra more sophisticated features for a small fee, say $5, $10, $20, (to cover the extra expenses) then people would be more than prepared to pay. I for one know that if something provides value & works 100%, I would “invest” in it. That would then promote you to re-invest in the community and make other great contributions.

I believe a popular term is ‘People want solutions to problems, not products’

I'll be in contact re: sage, maybe we can work something out.

Rgds,

Stuart

cleo9933:

Does QBI work with Quickbooks Online?
No, Quickbooks online does not have the capability to import orders.

Thanks,
Adam

I'm a n00b who can cut and paste code according to directions but can't write it to save my life, so I've got a stupid question. I've got ZC v.1.2.7 (couldn't upgrade to 1.3.0.1 because I NEED that products with attributes stock module). I went to install QBI and discovered that there's no directory called "catalog" into which to copy files. Should I just make a directory called "catalog," or will I need to do some other change? Are there any other changes I would need to make to use QBI with 1.2.7?

Thanks,
Sarah

Many people install their store in a folder, like 'catalog' or 'store'. But, you don't have to do that, and perhaps you installed your store directly in the root.

Just copy in all the files from the admin folder of the contrib to the admin folder on your server.

Thanks Magicpants! Silly me, I did install my ZC into a folder; I just didn't realize it would correspond with the "catalog" folder. Thanks again for being tolerant of stupid newbie questions!