Quickbooks Import QBI

[ddandlamber]

I live in the state of WA where we have not only state sales tax of 6.5% but a different % for local sales tax based on various counties throughout the state.

I am getting an error when I import any orders to QB that have sales tax. I'm assuming this is because I can't match up local sales between QB and QBI.

Any idea how to fix this. I'd be willing to manually enter the sales tax into QB if I could just get the order pulled through. Any ideas how to do this?

Thank you,
Amber

[bwood5]

I am using V1.3.9.f and quickbooks 2010. Is this compatable? Are there any modules this is not compatable with?

Bruce
Bowequipped.com

[golfrguy]

I am giving limited support for the free version, as it is quite old now. However, this one is pretty easy. If the page is not found, then either you are going to the wrong place, or the page is missing. Look at where the tab is taking you, and review that you have installed all the QBI files in the correct location.
Adam

Thanks for the reply Adam. I would purchase the new QBI but I am located in Canada and Have the Canadian QB Pro. Let me know if you provide a product that will work for this.
As for the issue mentioned above, The path it is trying to get the page from is sslpowered...the qbi file in my files does not show sslpowered in it's path. Any quick way to either unsecure the path or secure the file to match the path? Thanks very much!

[Lamplog]

Hi Adam,
I am having trouble installing qbi. I have uploaded files to server.
I am using v1.3.9h
Installing qbi v3.21
No addons
I have changed the admin file to a different name xxxx, could this be the problem. I set up two directories
catalog/xxxx/qbi_input
catalog/xxxx/qbi_output

I uploaded files to server in directory catalog/xxxx.

This is something pretty simple and I have looked everywhere to resolve. Your help would be appreciated.
Thank You,
Tom

[KADesign]

I would love to know if this product is still being supported. If so, can anyone tell me if it supports items priced by attributes?

I have a shop ready for launch and the client wants QB integration, but I didn't know attributes were not supported with some of the software out there. My own fault for not researching better I know.

Thank you in advance to anyone that can help.

Kelly

[delia]

I need to use this on a cart with wholesale pricing which means it has 3 or 4 prices per product instead of just one. Just wanting to know if it will be possible to make that change to the free mod and then again to the pro if my client decides to go this way.

[adam5532]

I need to use this on a cart with wholesale pricing which means it has 3 or 4 prices per product instead of just one. Just wanting to know if it will be possible to make that change to the free mod and then again to the pro if my client decides to go this way.

QBI puts the price that the customer actually paid when they ordered the item on the Invoice or Sales Order. So, it doesn't matter if you have quantity discounts, different prices for different customers, etc. This is the same for any version of QBI.

Thanks,
Adam

[adam5532]

Hi Adam,

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'

These warnings show up on the products import.

QBI adds a column "qbi_imported" to the PRODUCTS table. Something happened to the table and apparently that column got removed. You say you modified the database, so I assume that's where it went wrong. You can add it back by running this SQL statement:

ALTER TABLE `products` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL;

Thanks,
Adam

[adam5532]

Hi Adam,

1 more thing.
My zencart order info is in Japanese.
Is there any way that I can change the character encoding for the IIF files that are being created??

I've tried so many products for zencart -> quickbooks integration, but I can't find one that would do this.
If there is a way, I would like to mod this on my own.

Can you please direct me to the file that I must change to make it UTF-8?
Thank you in advance!

The iif file is just a tab delimited text file, and there's nowhere to indicate character encoding. I'm assuming it isn't working right now. However, you can open the iif file in Excel. Try replacing the text for some product with the Japanese and resave it as a text file with the .iif extension (not as an Excel file). Then import it into Quickbooks. If Quickbooks will import the Japanese, then I can look and see if there's anything I can do on my end (but not in the free version). If Quickbooks won't import the Japanese, then I'm afraid it's a limitation of Quickbooks.

Thanks,
Adam

[adam5532]

I live in the state of WA where we have not only state sales tax of 6.5% but a different % for local sales tax based on various counties throughout the state.

I am getting an error when I import any orders to QB that have sales tax. I'm assuming this is because I can't match up local sales between QB and QBI.

Any idea how to fix this. I'd be willing to manually enter the sales tax into QB if I could just get the order pulled through. Any ideas how to do this?

Thank you,
Amber

QBI, either version, currently can not handle more than one sales tax rate (which you set up on the Configure page). That is planned to be added some time in the future. There is no easy work-around. The file will not import if the sum of the line items doesn't equal the total, which it won't if the sales tax isn't correct.

Thanks,
Adam