Quickbooks Import QBI

[adam5532]

Hi,

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

[hockey2112]

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.

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

[adam5532]

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

[fallen_angel21]

Hi Adam,

I asked this question before (http://www.zen-cart.com/forum/showpo...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. :/

[hbjapsurfer]

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.

[adam5532]

Hi,

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

[adam5532]

Hi,

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

[hbjapsurfer]

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.

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