I am not from Canada, but I have a bit of experience with the full QB Retail Edition. I've no idea if Enterprise acts the same, but QB has some major problems when it gets down to importing IIf files. I played with integration to QB in the area of inventory. Scenario:
- Site fully tracks inventory, reporting what's in stock, what's in pending, what's sold.
- Goal was to export this as QB .IIf files, then import into QB regularly to synchronize the two.
As a programmer, I was able to export the data fine, import it into QB fine, and spent many hours on the QB forums and with support trying to get this to work, but it failed miserably for the following reasons.
Items list. QB has an "items list" for all QB items. This is the only "place" in QB to put products. The result, if you have thousands of products, your product listings get mixed in with other QB "items." It's chaos.
Inventory. When you try to import inventory items, it just doesn't work. QB has a set of manual processes when you update inventory that affect several areas (can't give specifics, it is too far in the past.) so while my inventory .IIf's were imported fine, it didn't update the "other areas" properly.
The really big deal for us was the items list, the products have a variety of options and the only way to get all the items and their options in QB was like this:
0101rgt Widget red gold trim
0101bgt Widget blue gold trim
0101ybt Widget yellow gold trim
0101rst Widget red silver trim
0101bst Widget blue silver trim
0101yst Widget yellow silver trim
Which is horribly inefficient, this is one item with various options.
IMO the lack of support was to motivate web publishers to use QB integrated solutions, so we just gave up and went with manual daily cash entries, called it a day. We use the site for statistical analysis and inventory reporting, it works, QB doesn't (for us.)
