Welcome to WebmasterWorld Guest from 54.166.87.123

Forum Moderators: buckworks

Message Too Old, No Replies

Ecommerce solution for Canadian version of Quickbooks Enterprise

   
5:41 pm on Jan 29, 2010 (gmt 0)

10+ Year Member



Hi guys,

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!

David

6:41 pm on Jan 29, 2010 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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