Quickbooks Import QBI

[blackjm75]

Ok Adam thanks for the update.

Joe

[pinkchalkstudio]

First off, thank you Adam for this functionality. The robustness of the features and the professionalism of the documentation is very impressive.

I've gone through my setup and the documentation several times and I'm now stuck on two things that are not working as I think they should:

1) I have two payment methods in Zen Cart, Credit Card via a linkpoint.api and Paypal where the user goes over to the Paypal system at the end of checkout to make their payment. My CC transactions are correctly being transmitted as Sales Receipts. The Paypal transaction is going over as an invoice. I have specified my Quickbooks Payment method of Paypal as 'Paid w/Paypal' on the setup screen. On the matching screen I've linked 'Paypal' to the shopping cart options: Purchase (paypal), Voiding Order Authorizations (paypalwpp), and Voiding Order Authorizations (paypaldp).

One thing I don't completely understand is why I can't setup the Quickbooks Payment method 'Paypal' as 'Paid online'? The documentation seems to make clear it should be set as 'Paid w/Paypal'.

2) I have several products that have single attributes. I have matched them with a single item in Quickbooks. The matching info seems to be ignored. The other non-attribute products that I'm matching are going through correctly. From reading the doc it seems like this should be OK, that only multiple attribute products have difficulties.

Thank you!

Kathy

[welchyboy]

I am confused I just installed the quickbooks import qbi and get all these errors with qbi_mysql.php. I have the latest version i believe which is 3.21 or so and my php on my servier is 5 point something. What am i doing wrong. I am tried to recopy the files to the admin directory and it made no difference. I haven't do anything with the sql tables because i read that it was supposed to have a setup to do all of that. I am going to throw this information out there just in case it has something to do with the problem. I have installed this before a few weeks ago but messed up and had to recopy the files back to it. So this could be causing some kind of issue not sure. I have all the permissions and when i go to the admin portion of zen cart and go to customer menu I get the setup tab and all the other stuff but lots of errors and no button to install. Please help thanks.

[adam5532]

Hi,

One thing I don't completely understand is why I can't setup the Quickbooks Payment method 'Paypal' as 'Paid online'? The documentation seems to make clear it should be set as 'Paid w/Paypal'.

You can do it either way. The Paid w/Paypal setting just lets you set a different status for PayPal orders. This is to assure that only orders that have completed the PayPal payment process are considered as paid.

If you use the PayPal gateway directly, and customers do not have to go off your site to PayPal and return, then you can consider PayPal like any other gateway and don't need to use the special PayPal settings.

2) I have several products that have single attributes. I have matched them with a single item in Quickbooks. The matching info seems to be ignored. The other non-attribute products that I'm matching are going through correctly. From reading the doc it seems like this should be OK, that only multiple attribute products have difficulties.

Thank you!

Kathy

Don't know why you are having this problem without looking at it.

Thanks,
Adam

[adam5532]

Hi,

I am confused I just installed the quickbooks import qbi and get all these errors with qbi_mysql.php. I have the latest version i believe which is 3.21 or so

3.21 is the latest free version. 3.74 is the latest paid version.

when i go to the admin portion of zen cart and go to customer menu I get the setup tab and all the other stuff but lots of errors and no button to install. Please help thanks.

I can't help you without you copying some the errors to your post so I can see what is happening.

Thanks,
Adam

[welchyboy]

Sorry about that...When i log into the customer menu and go to the qbi option i get a page full of errors as follows;

Warning: Some products are missing the model name! Correct this issue before creating iif files!


Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE qbi_imported='0' AND orders_status='1' in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Orders

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE qbi_imported='1' in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Orders

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Orders

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='0' in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Products

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='1' in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Products

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/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/stxmill/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/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Products
All Customers
Quan: 1
No.: 1


This copy of QBI is not registered!
Please go to www.libermansound.com/qbi to register this copy, and then click the support tab on the QBI menu above to enter your registration into QBI.
Registration will facilitate technical support, and will allow you to receive notification of updates.

QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

[adam5532]

Sorry about that...When i log into the customer menu and go to the qbi option i get a page full of errors as follows;

Warning: Some products are missing the model name! Correct this issue before creating iif files!


Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL:

Somehow you did not install QBI correctly and the qbi_imported fields did not get added to your database.

Make sure that you have copied over all the QBI files. Then, delete the table qbi_config and go back to QBI in the admin. This should reinstall the tables he first time you open QBI.

Thanks,
Adam

[mvs179]

Adam,
Thank you for redirecting me to the forum page.
My original question for you was:
"I am trying to match discounts/fees... Quickbooks discounts/fees show in the drop-down menu but Shopping Cart discounts/fees that I set up under Gift Certificates/Coupons/Coupon Admin do not show in the list. Please help."
You replied that "the discount module will be listed in the match list, not each individual coupon that you have added."
Please explain. Thank you.

[welchyboy]

I don't actually have to install any databases do I? All i did was copy all the files within each folder to the same folder and path on the server. I have done this many times with other templates and addons to zen cart so i was sure i did that correctly. However the sql files and such i did nothing with because it didn't say to add them or anything like that. From what i understood it was supposed to do all that when i went into the admin portion of zen cart and clicked on the qbi tool under customers. How should i delete qbi from my server then readd it?

[adam5532]

Adam,
Thank you for redirecting me to the forum page.
My original question for you was:
"I am trying to match discounts/fees... Quickbooks discounts/fees show in the drop-down menu but Shopping Cart discounts/fees that I set up under Gift Certificates/Coupons/Coupon Admin do not show in the list. Please help."
You replied that "the discount module will be listed in the match list, not each individual coupon that you have added."
Please explain. Thank you.

There should be one entry for each module, like ot_discount. You will not see the individual coupons that you set up. That doesn't really matter, because the name and discount amount will import properly with each order.

Thanks,
Adam