Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: buckworks
Our company is seriously looking to upgrade to the Quickbooks Enterprise edition. We're based in Canada and are hoping to have an ecommerce setup that fully integrates and works really well.
I am hoping some of the guys here are from Canada and use Quickbooks. If so, what software solution did you go with and how happy are you with it?
I'm doing my own research and seeing what I can find, but I'd love to hear from anyone that has already gone through this process.
Have a great weekend!
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.)