Quickbooks Import QBI

Hi,

helpme:

Forgive the stupidity of this question but I am struggling to find a good way to keep up on books without giving myself a migrane :blush:
Do you find it better to update orders and such through QB or through ZC? My problem is, I am used to using ZC to update, send new info to customers and I like it because they can login and see any updates I have made.
Plus it keeps things more odvious for me if there is a pending order that was missed, etc.

How do you all handle this? I am open to any ideas, just really struggling at this point.
Thanks!!
QBI can be used either way. It really is a preference of how you run your store, and there isn't one correct answer.

QBI can change the status of orders it exports automatically.

Thanks,
Adam

adam5532:

Don't try to copy the iif into a post -- the columns get messed up and it is unreadable.

Did they look in both Sales Receipts and Invoices?

• Adam

I was actually referring to uploading the iif file as an attachment. Would that be "OK"?

I will check with them in the meantime, to see if they checked in both sales receipts and in invoices.

Thanks, and please do let me know if you would be willing to look at the actual iif file.

A little more feedback from the client:

When I went to import the file I got a “Warning” box stating “Quickbooks has detected one of your items does not have an account associated with it. Go to the item list to make sure all items are associated with accounts. I clicked OK anyway and got another Error message “Error line 10 can’t record invalid transaction” I clicked OK again and the program said import successful but I do not see any orders etc.

Does that clarify anything?

hockey2112:

A little more feedback from the client:

When I went to import the file I got a “Warning” box stating “Quickbooks has detected one of your items does not have an account associated with it. Go to the item list to make sure all items are associated with accounts. I clicked OK anyway and got another Error message “Error line 10 can’t record invalid transaction” I clicked OK again and the program said import successful but I do not see any orders etc.

Does that clarify anything?
Yes. Your client has not filled in all the required fields on the Configure page. Specifically, they need to fill in all the account fields in the Items section and that should fix this problem. Then, they should read the User Manual completely and go through all the configuration options and set them appropriately before trying to use QBI.

Thanks,
Adam

Hi Adam,

I asked this question before (http://www.zen-cart.com/forum/showpost.php?p=895892&postcount=1062) and is glad cause you answered. However, I wasn't able to find a more sensible solution for this error.

I'm not sure if this was already answered before so sorry if you have to repeat it for me or something... T~T

Anyway, I tried to update the foreach statement where the error seems to be starting.

The error I'm getting says there's something wrong with the foreach argument. It seems that an array is being expected but the value it returns is null. I updated the foreach code (couple of lines before 450)

if (count($attributes)==1) {
		$attr_1=$this->get_product_option_values_list($this->product['products_id'],$attributes[0],$this->product['products_model'],$this->product['products_name'],$this->product['products_price']);
		if (count($attr_1) > 0) {
			foreach ($attr_1 as $data1) {
				$output[]=$data1;
			}
		}
}

I added the if statement so that if the value is null, it doesn't have to go to the foreach statement.

This is however my temporary solution... and I'm not sure yet if this will contradict other statements. :/

Hi Adam,

Thank you for the great module.

I was trying to integrate the QBI module and I was able to successfully add it to my zencart v1.3.8, however I am running into a few problems. I was wondering if you can give me insight on how to fix the issues.

1. Fatal error: Maximum execution time of 60 seconds exceeded
   This error occurs when I try to import previous order data.

I tried all the other imports and they work.

2. QBI does not recognize new orders. (Create iif -> New Orders = 0) Even though I have orders that are not imported yet. The configuration for Import orders with status is set to Pending.

Thank you in advance.

Hi,

hbjapsurfer:

Hi Adam,

1. Fatal error: Maximum execution time of 60 seconds exceeded
   This error occurs when I try to import previous order data.
   Importing all your old orders can be problematic, especially if you have ever deleted products in your store (don't do it! Just set them as inactive if you ever want to import those orders). If you insist, then you may need to extend your PHP max execution time in your php.ini file.
2. QBI does not recognize new orders. (Create iif -> New Orders = 0) Even though I have orders that are not imported yet. The configuration for Import orders with status is set to Pending.
   New orders are those that:

1. Were placed after you first installed QBI.
2. Have the status you've set on the QBI Configuration page.
3. Have never been imported before by QBI.

If they are not appearing as new orders, then it HAS to be one of those three things.

Thanks,
Adam

Hi,

fallen_angel21:

... Anyway, I tried to update the foreach statement where the error seems to be starting.

The error I'm getting says there's something wrong with the foreach argument. It seems that an array is being expected but the value it returns is null...
I don't think I can give you a better answer than I did the last time. The problem isn't in the QBI code, so helping you make changes to the code isn't going to solve the root cause. And, I can't give that level of help for the free version.

Thanks,
Adam

Hi Adam,

Thank you for your quick reply.

I was able to import all my orders.

I have some warnings and notices that I wanted to confirm with you.

I have the following:

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'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

These warnings show up on the products import.

I created a kit module that allows customers to select from an admin selected kit (Products grouped together and customers select a few products from the kit). I have the database somewhat modded, so I'm thinking that it's just on my end. I just wanted to confirm.

Thank you in advance. :smile:

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!

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

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

adam5532:

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!

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

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. :blush:

Thank you in advance to anyone that can help.

Kelly

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.

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

hbjapsurfer:

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

hbjapsurfer:

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

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