Quickbooks Import QBI

[MommysTouch]

Does anyone here know how to set up discounts, coupons and Low Order fees so that I can get my QBI working? I think this is the last thing I need to fix but I am sooooo confused

Thanks in Advance
Emily

[adam5532]

Does anyone here know how to set up discounts, coupons and Low Order fees so that I can get my QBI working? I think this is the last thing I need to fix but I am sooooo confused

Thanks in Advance
Emily

Emily,

I promise I will be available today for a phone consultation!

Thanks,
Adam

[Emily-MommysTouch]

ME AGAIN!

Sorry to be such a pest but I had deleted some items that were on earlier invoices after they were sold out. This caused a problem in that QB could not import them from QBI since I did not have Models entered in for my items at that time.
Yesterday my techinal support added the module to Zen that allows you to go back and edit orders. So I went into the old orders and added models. However the orders still wil not import. Do you have any idea whay that would be?

Also I am having ordes that are not importing because they are not "in balance" What can cause that since I do not charge sales tax?

BTW I do have the newest version of QBI

Thanks in Advance

[adam5532]

ME AGAIN!

Sorry to be such a pest but I had deleted some items that were on earlier invoices after they were sold out. This caused a problem in that QB could not import them from QBI since I did not have Models entered in for my items at that time.
Yesterday my techinal support added the module to Zen that allows you to go back and edit orders. So I went into the old orders and added models. However the orders still wil not import. Do you have any idea whay that would be?

Also I am having ordes that are not importing because they are not "in balance" What can cause that since I do not charge sales tax?

BTW I do have the newest version of QBI

Thanks in Advance

Emily,

You added model numbers, but those items also need to exist in the Products list for your store, and those products need to exist in QB. Also, since you deleted those products in your products list, their products_id number is also invalid. What you would have to do is add those products back into Zen Cart, and then edit those orders to include the "new" products instead of the deleted ones.

Importing old orders can be a problem if you have deleted those products. QBI needs to refer back to the product list in order to properly construct products with attributes, and to change the language (if this option is selected) so that the invoice lists products in the store owner's language regardless of the customer's language. What I will likely do in a future version of QBI is allow QBI to create a generic product line for those items that it can't identify because they are missing. This will at least allow you to import old orders and help you to troubleshoot. Then at least you could modify that order in Quickbooks to replace the missing item.

In the meantime I suggest that you give up on importing old orders! It simply can't be done if you have deleted products (until I update QBI to accommodate this)! In the future, if you no longer wish to sell a product, you should set it to inactive in Zen Cart instead of deleting it. This is what you have to do in Quickbooks (set item to hidden) -- it doesn't allow you to delete items that have been used in transactions, because as you can see it can mess up all your record keeping and access to prior transactions. Unfortunately, Zen Cart doesn't prevent this (it should, in my opinion).

As for the out-of-balance transactions, it may be that you still don't have all the discount coupons set up and matched, or that you have deleted old discount coupons as well. If you look at the iif file in a text editor, you should be able to see what the issue is. If you need help with this, give me a call and we can do some additional consulting.

Thanks,
Adam

[Emily-MommysTouch]

You are right it was deleted coupons!!! I swear I messed things up good with my deleting. Now I just put the products as inactive but it is too late for the past items.

I will be doing an import of new orders in about a week and will see if it works for all of them, if it does we are set for the future anyway.

Emily

[djstern]

I keep a inactive category in ZenCart called "Dead Items" and move things I no longer sell to that category and then set it to inactive. This helps me to keep things a little more organized and easier to work with. Would that mess up QBI or does QB not care where something is at in my store as long as it is there?

Also, I got a little carried away with attributes when I set up the store and am re-doing it with much fewer attributes. Will removing un needed attributes also mess up QBI as well? I don't think there is a way to set attributes as inactive and I hate to have to sort through a ton on attributes that I no longer use just to find the few that I'll still need.

Keeping my self out of trouble with dumb questions instead of dumb mistakes. :)

Thanks.

[adam5532]

I keep a inactive category in ZenCart called "Dead Items" and move things I no longer sell to that category and then set it to inactive. This helps me to keep things a little more organized and easier to work with. Would that mess up QBI or does QB not care where something is at in my store as long as it is there?

As long as it is there it is fine.

Also, I got a little carried away with attributes when I set up the store and am re-doing it with much fewer attributes. Will removing un needed attributes also mess up QBI as well? I don't think there is a way to set attributes as inactive and I hate to have to sort through a ton on attributes that I no longer use just to find the few that I'll still need.

If you remove unneeded attributes and then try to re-import old orders that contain them, then yes there would be problems. As long as you don't try to import old orders, it isn't an issue. Generally, there is no reason to import old orders, except for people who are setting up Quickbooks for the first time and want to get all their order history into it. But this creates other issues anyway, because then you have negative inventory in QB and have to adjust it or enter the corresponding vendor purchases! In a future version, QBI will be able handle missing items by inserting a generic item in its place.

Thanks,
Adam

[snarkys]

ok so i had the QBI 3.02 installed but i didnt configure it . i updated to 3.1 today before i started to configure it and now i get these errors when i open qbi

QBI version 3.10

Warning: constant() [function.constant]: Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant() [function.constant]: Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

[adam5532]

ok so i had the QBI 3.02 installed but i didnt configure it . i updated to 3.1 today before i started to configure it and now i get these errors when i open qbi

QBI version 3.10

Warning: constant() [function.constant]: Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant() [function.constant]: Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Please see post #240 to correct this. I will try to upload a 3.11 version to fix this shortly. It does not cause any functional problem.

Thanks,
Adam

[BigMacYin]

Hi Adam,

I have been watching this thread for sometime and wondered if you have a time frame for releasing a version that will work in the UK?

Many thanks.

H