Quickbooks Import QBI

[adam5532]

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

[nels267]

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

[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 (danielcor######################)

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

[adam5532]

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 (danielcor######################)

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

[landshark]

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?

[danielcor]

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

[adam5532]

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 .

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

[adam5532]

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

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

[adam5532]

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