Quickbooks Import QBI

Remove all the tables in the DB and overwrote all the files with the new version. Everything went smooth until I clicked submit (or whatever) on the configuration page I then received :

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/growtron/public_html/store/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

Really wish there was a way to edit my posts.

I proceeded to export the customer, products , and orders. When trying to import to QBs the customers and products seems to work fine but the order received error:

Error on Line 11 : Can't record invalid transaction

Hit ok and get

Transaction not in balance , make sure the amounts in the detail area on the form for this transaction equals the amount at the top of the form

I get this set of errors several times. Before it ends. The orders are there but only contain the customer information.

What am I doing wrong? Any ideas?

Thanks for all your help thus far. I'm very excited to have this functionality and I certianly will be donating.

.

adam5532:

Make sure that you have entered the account in the QBI configuration.

Unless you increase your inventory in QB to cover all your past sales, the inventory is going to go negative when you import all those orders, because each one is subtracting from inventory. QBI does let you import all past orders, but really unless you have a compelling reason to do so, it is probably best to just start importing with the new orders.

Oh I realized that is what was happening with the negative numbers. I have already entered all inventory purchased into quickbooks so I would like for the past orders to be subtracted from existing inventory since I'll be tracking this with quickbooks as well. I don't think this would be an issue if the accounts matched up.

Only importing new orders would not work for me. I want all data from the start of my business to be in quickbooks. it is onle 60 orders so not too big of an issue although it is over 2000 units that have been sold so it does have an impact on inventory.

The account i have entered into QBI is "Sales:Merchandise" just as it is in quick books actually I copied and pasted it into QBI config.

I can live with the Customers only being those that have made purchases. This is not a huge issue to me at this point.

I'll go ahead and run the update and wait for your feedback.

Thanks again!

When I try to import the iif file from QB to QBI I get errors for all tabs :

Fatal error: Using $this when not in object context in /home/growtron/public_html/store/admin/qbi_pay.php on line 53

tronix:

Really wish there was a way to edit my posts.

I proceeded to export the customer, products , and orders. When trying to import to QBs the customers and products seems to work fine but the order received error:

Error on Line 11 : Can't record invalid transaction

Hit ok and get

Transaction not in balance , make sure the amounts in the detail area on the form for this transaction equals the amount at the top of the form
.
Make sure that:
You have set up any discount coupons in QBI
That all your products in ZenCart have Model filled in and not blank.

Thanks,
Adam

After ignoring all the errors. I find that Inventory Assemblies (which are the products in my cart) are not showing up in the match screen. Only the unit items (the parts to the assembilies). I've read through the instructions. (My previous question was answered there) but didn't see anything refer to this except that assembilies need to be matched.

Hi All,

Sorry that some of you are having problems! I am working hard to resolve any bugs that have been found -- was up all night last night getting 3.01 done! It is working fine on my system, but of course everyone's set up is different so there are bound to be some issues that my testing didn't discover. I will take a look at the latest posts and resolve those issues shortly. In the meantime, I see that QBI has been downloaded 75 times so far! How is it going for the rest of you? If you haven't posted anything, does that mean you haven't installed it yet, are having similar issues, or that it is working perfectly? Let me know!

Thanks,
Adam

tronix:

After ignoring all the errors. I find that Inventory Assemblies (which are the products in my cart) are not showing up in the match screen. Only the unit items (the parts to the assembilies). I've read through the instructions. (My previous question was answered there) but didn't see anything refer to this except that assembilies need to be matched.
Do you have assemblies checked in the configuration?

Thanks,
Adam

Appears to not work with the version of ZenCart that I am using. There is no includes/database_tables.php or includes/filenames.php

I'm still very pleased with this module, and I hope to get it working someday :) :thumbsup:

brivers:

Appears to not work with the version of ZenCart that I am using. There is no includes/database_tables.php or includes/filenames.php

I'm still very pleased with this module, and I hope to get it working someday :) :thumbsup:
What version are you using? They should be there! Make sure you are looking in catalog/includes and not in catalog/admin/includes

Thanks,
Adam

Hey adam, you were right.

Now after doing all this, I get this error:

Upgrade QBI database from version 3.00 to 3.01?

I click on the button to upgrade, and it says:

Database table upgrades successfull. Now you must go to the configuration page.

1. Recheck your configuration options and configure new options.
2. Click "Update" at the bottom of the page.
   Note: You must click update to finish the upgrade, even if you did not change any settings!

Now you must go to the configuration page.

I click on "Now you must go to the configuration page." and it prompts me to "Upgrade QBI database from version 3.00 to 3.01?" again.. and it keeps doing it. Anything I am missing?

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

And if I go to "match" to create products, I get this error:

Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks for the help :)

brivers:

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

> 
> And if I go to "match" to create products, I get this error:
> 
> ```
Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks for the help :)
Important for anyone upgrading from v3.00 to 3.01:

In the database_tables.php file, remove DB_PREFIX from each line added for QBI. So, for example:

define('TABLE_QBI_CONFIG', DB_PREFIX . 'qbi_config');

becomes:

define('TABLE_QBI_CONFIG', 'qbi_config');

Sorry, I forgot to put this in the Upgrade manual. This will solve your problem!

Thanks,
Adam

Hey it worked. Thanks a lot!

Adam,

I ran the update to 3.0.1 it went flawlessly no more warnings. I also redid all of my synchronization and still no change in the two major problems i'm having.

Have you gotten a chance to talk a look at the PayPal showing up under accounts receivable issue?

Also the Imported previous orders not matching to their proper item and associated account?

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.

landshark:

Adam,

I ran the update to 3.0.1 it went flawlessly no more warnings. I also redid all of my synchronization and still no change in the two major problems i'm having.

Have you gotten a chance to talk a look at the PayPal showing up under accounts receivable issue?
I'll take a look at it, and get back to you -- probably on Monday.

Also the Imported previous orders not matching to their proper item and associated account?
I'll look at this also.

Thanks,
Adam

Hey Adam,

 I'm having a problem when trying to access the match menu...  when I hit the update matches on this page button I get an error message saying 

"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

 Thanks!!

TommyxD:

Hey Adam,

 I'm having a problem when trying to access the match menu...  when I hit the update matches on this page button I get an error message saying 

"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

 Thanks!!

Hi,

It isn't your problem, as even if you did something wrong, the program should tell you what to do instead of delivering a cryptic PHP error message!

Tell me if I am correct in these assumptions:
You already completed the Set up before going to Match.
The match page showed a list from ZenCart on the left and drop-downs on the right with a list from QB.
After getting the error, and the "Matches Updated" message, your matches were not actually updated.

Let me know about the above questions.

Thanks,
Adam

TommyxD:

Hey Adam,

 I'm having a problem when trying to access the match menu...  when I hit the update matches on this page button I get an error message saying 

"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

 Thanks!!

And, I assume you selected a match in at least one of the dropdowns and didn't leave them all blank?

• Adam

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

brivers:

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

> 
> And if I go to "match" to create products, I get this error:
> 
> ```
Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks in advance,
Keith