homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

Ecommerce solution for Canadian version of Quickbooks Enterprise
David Bruning

10+ Year Member

Msg#: 4070624 posted 5:41 pm on Jan 29, 2010 (gmt 0)

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!




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

Msg#: 4070624 posted 6:41 pm on Jan 29, 2010 (gmt 0)

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

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved