Quickbooks Import QBI

[shadez2270]

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did )but I got the follwing error messages

This is a brand new cart that has just a couple test products in it, as I am trying to get everything modified and working before loading all the products in, not sure if that is what is casuing the issue or not, but thought I would point it out.

Notice: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119

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

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

Warning: array_walk(): The argument should be an array in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line 958

Warning: Invalid argument supplied for foreach() in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line

Here is my server info
Database Host: localhost (127.0.0.1)
Server OS: Linux 2.4.25-HRGRP4smp
Database: MySQL 4.0.22-standard
PHP Version: 4.3.11 (Zend: 1.3.0
HTTP Server: Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2634a mod_ssl/2.8.22 OpenSSL/0.9.6

I did try to delete from the server the two pages qbi_classes.php and qbi_mysql.php and re upload them, however that didn't help. I also checked the original zip files and compared them to the ones I uploaded and couldn't find a difference however I might aw well have been comparing ancient egyptian hieroglphics LOL

Any guidance as to what I should be looking for or a fix would be fantastic

Looking forward to hearing how I messed it up this time LOL

Thanks in advance
Shadez

[adam5532]

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did )but I got the follwing error messages

Notice: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119

The table name is qbi_config, not qbi-config.

You wrote in the table definitions wrong in the installation. I suggest you use the word document copy of the installation instructions and do copy and paste instead of recopying, to avoid any typing mistakes.

Thanks,
Adam

[shadez2270]

DOUHHHH (in my best homer Simpson voice) This always happens when I type code--->

I corrected the typo and it worked like a charm... See I knew I had screwed it up.

I will be sure to make a contribution... thanks for helping me get it running

Also thank you Adam for a great mod!

[adam5532]

Also thank you Adam for a great mod!

Thanks!
- Adam

[djstern]

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.

[adam5532]

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.

The type setting in the QBI configuration only affects items in ZC that are directly imported by QBI, since ZC has no such designations.

If you use the Matching feature in QBI, and match those items to your items in QB, then the type of each QB item will be preserved.

Thanks,
Adam

[djstern]

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.

[djstern]

Problem is that the same thing is showing up dozens of times. Flat Rate (Best Way) fills the entire page even if I have it configured to show 25 rows. If I attempt to go to the next page the number of Shipping Methods increases and I can never manage to get to the next shipping method.

Just for grins I dropped all of the database entries for QBI and recopied the files to my server. Verified the file changes and went through the configure process again. All went well until I entered match | shipping. When I first entered the page I had 32 entries. Making no changes of any kind I hit the "Update Matches On This Page" button and ended up with 64 shipping methods. Hit the button again and I have 96 entries. One more time and I have 128 entries. Same thing happens if I click next or a page number. The number of Shipping Method increases by more than is displayed on the page.

HELP!!!

Basically, I can't set up shipping with this problem.

[adam5532]

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.

This is a bug in 3.10 and will be corrected in 3.11. Please see the Bug Reports section of the QBI forum at http://www.libermansound.com/qbi for a simple solution.

All known bugs are listed in the QBI forum. It is a good idea to check there first if you have any problems.

Thanks,
Adam

[adam5532]

QBI 3.20 has been released!
- Adam

New Features:
1. Invoice class can be set in config
2. Default customer name option added
3. Automatic detection of available output formats
4. Customer, order, and products header and footer output lines added for additional flexibility
5. Shipping methods are now manually loaded from cart (by clicking a button)

Fixes:
1. Missing PayPal constants added
2. Shipping match was multiplying shipping methods every time Match:Ship was selected
3. Clarified difference between iif file uploading and processing
4. QB group tables entries are now deleted properly
5. Assembly subitem descriptions no longer get deleted
6. QB groups now alphabetically sorted in match dropdown box
7. Chron misspelling changed to cron in files and docs