Quickbooks Import QBI

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

Thanks in Advance
Emily

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

Thanks in Advance
Emily
Emily,

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

Thanks,
Adam

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

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

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.

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

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

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

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

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

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

I can't promise a date. But, I just purchased the QB UK and Canada development versions, so I am committed to working on it. Hopefully it won't be too much longer!

Thanks,
Adam

Thats great Adam, thanks for letting me know. I look forward to the release.

Many thanks.

Kind regards,

H

Is there a version of this mod for 1.2.7d? Has anyone used it on this version?

ksoup:

Is there a version of this mod for 1.2.7d? Has anyone used it on this version?
QBI should work with any version, as it is almost completely self contained. The contribution section doesn't let you specify a range of versions, so I set it to the latest version (I currently test it with 1.3.5) to indicate that it works with the latest versions of Zen Cart, but that doesn't mean it won't work with earlier versions.

Thanks,
Adam

Thank you for your quick response! :) We will try it out. Does it change any files? or just add to? :)

adam5532:

QBI should work with any version, as it is almost completely self contained. The contribution section doesn't let you specify a range of versions, so I set it to the latest version (I currently test it with 1.3.5) to indicate that it works with the latest versions of Zen Cart, but that doesn't mean it won't work with earlier versions.

Thanks,
Adam

ksoup:

Thank you for your quick response! :) We will try it out. Does it change any files? or just add to? :)
It has its own files. The only thing you need to do in the Zen Cart files is add the database table definitions and the menu item.

Thanks,
Adam

Adam, I was having trouble finding some files but its becuase I can read properly. I assumed something and thats why I am having trouble.

Thanks for the killer module

Hi Adam,

can you please give a quick overview of which Quickbooks versions are currently supported?

I run a business in Germany and was thinking of purchasing the German Version from Lexware (Quickbooks Plus 2007) but I guess this is totally incompatible with the current QBI version, right?

So is it possible to have the US version (Quickbooks Pro 2007) and set it up to use the German Tax system (19% sales tax in 2007) ?

I greatly appreciate your answers!

surfmueller:

Hi Adam,

can you please give a quick overview of which Quickbooks versions are currently supported?

I run a business in Germany and was thinking of purchasing the German Version from Lexware (Quickbooks Plus 2007) but I guess this is totally incompatible with the current QBI version, right?

So is it possible to have the US version (Quickbooks Pro 2007) and set it up to use the German Tax system (19% sales tax in 2007) ?

I greatly appreciate your answers!
It is only tested to work with US versions of QB that have iif import. That includes Pro, Premier, and Enterprise. Because the column names and taxation lines differ in each version, it is unlikely to work at all with other country versions of QB. I am currently working on adding support for UK and Canadian versions. That is because these are the most requested, and Intuit has available developer's versions of these programs so I can test the integration. I will add other countries after that.

The US version can't display prices in Euros. Also, in the US tax is not included in the price of the product and is added as a separate item at the end. And currently, QBI can only support one tax rate, so if you have to charge different tax rates for different customers or products then it can't do that yet. It can support customers or products that are or are not taxed at that one rate.

Thanks,
Adam

Hi All,

Just a heads up that I am working on QBI 3.11, which fixes a few bugs found in 3.10 (the constants error message, and shipping methods multiplying each time you go to the Match:Shipping page) and has other minor improvements. It should be done this weekend. For more information, you can also visit the QBI support site at https://www.libermansound.com/qbi, where you can register your copy, view screen shots, and also visit the forum.

Thanks,
Adam