QuickBooks integration has many issues that seriously diminish the usefulness of this interface. For example:

1) Item Number is completely ignored. When a customer orders an item, and the order details are downloaded from Network Solutions E-Commerce to QuickBooks, the item number is not included.

2) The Product Name is downloaded to QuickBooks, but product names can easily exceed the field size allowed by QuickBooks. Item Number is the field that should be used to state what item(s) the customer has purchased -- NOT the product name. On the other hand, item numbers are unique identifiers and are SHORT. Product names are meant for only humans to read. Here is an example:

Product Name: Giorgio Armani GA476/S - Dark Ruthenium
Product ID: GA_476_CWFPN

The above product name and product ID both describe a single item. Since QB Web connector will only download product name, the information is TRUNCATED, so there is no way to know what the customer wanted.

In 30 years of computing experience, this is the ONLY time I've seen product ID ignored. This is completely unacceptable, and makes the whole interface virtually worthless.

3) Network Solutions E-Commerce will not allow order details to be downloaded to QuickBooks until the status is marked as 'shipped'. Yet, until the order is downloaded, the order cannot be shipped because QuickBooks is used to produce a pick list, and print the shipping label. I can work around this by turning off the Network Solutions E-Commerce customer email notification in the "Shipped Status". If you don't do this, the customer gets an email saying the product has been shipped, when in fact, the fulfillment process only begins after the line item detail is downloaded to QuickBooks. This is not a logical work flow.

I will post other issues relative to the QuickBooks Web Connect interface soon.

Operations Mgr.
Sunglasses Worldwide Inc.
www.SunglassesWorldwide.com

Hi SunglassesWorldwide.com,

With QB you can in fact setup your products to make sure the part number is used by many methods. One would be if your products were first in QB with the Partnumber, you can then import that product into the storefront from QB and this will then have that information. Secondly, after a product was on the Storefront, and then you had it moved to QB through an Order - all products are marked with a custom field called webstore ID.

You can match this ID up with the product through the import/export tool of your admin panel and then you could simply add the partnumber to your products in QB. You can do this very easily using the export from your admin panel as well as exporting all products from QB into excel. This way you will be able to uniquely identify the products the way that you wish to.

In the end while you may not use the order flow that we use, we consider the shipped status as a final status meaning you have received the funds for your order thus it is okay to place it in QB so that your accounting will not be skewed in any way. In terms of the email that is sent you have mentioned that you can simply turn that off and your customer will not notice this at all then.

Joe

I would like to add, that if you don't flag an order as "shipped" until it is actually shipped to get the order details into QB, then that keeps us from using QB to handle our orders.
Quickbooks integration is the the key reason I chose Network Solutions Cart software.

Now it seems I need to create a "Work Around" to use quickbooks the way I would like.

I would suggest allowing us to move order details into Quickbooks at the "Order Status" of our choosing.

Thanks

I totally agree with the order status thing and I know that alot of other users do as well. I don't understand why NetSol refuses to listen to what the customers want instead of taking the stance that "it is our way or nothing", you way of thinking does not work for a large majority of your users. Most have just found some way to work around it.

So far, I have found the Webstore ID field to be completely usless. I have built items every way I can think of and imported back and forth each way. This field has never been populated with anything. Can you give a little more detail on how this is supposed to work? I have called into tech support on this many times, no one seems to know how it works. I know it's there but that is it.

Thanks...

I'd also like to offer my two cents on this subject. I'd also like the option of being able to download into Quickbooks directly when an order is received. The Web Connector software offers an option to "Auto-Run" but that option is useless because without my direct intervention of changing an order status to "shipped", nothing will download into Quickbooks. I too use Quickbooks shipping manager to ship directly from Quickbooks and print my UPS labels and therefore can't ship anything until the order is in Quickbooks.

Does anyone on this post have an update. I am suffering through these things right now and struggling to find good work arounds. I'm going on two weeks of no integrations, well over 200 orders. And since I used my Quickbooks to integrate with my UPS computer, my warehouse is much slower as well.

Any help or insite would be greatly appreciated. My sense is that the new interface isn't working very well for a lot of the NetSol customers....

I ended up clearing all the items out of my quickbooks and creating all the items in the website first. Then I had to create an order for every item on the website and process it all the way through. When I sync'd, the the items were built in quickbooks for me. Then I had to edit each item in quickbooks to add info that the sync didn't populate (i.e. Default vendor, order points, short description). On the items that had variation, I would assign each variant as a sub item of the first one that got created, so it would be easyier to find them. It created the variants with some random number at the begining of the part number (i.e. (64)partnumber).

This also made 2 journal entries for each item created. One for creating the item (a negative amount) and one for the order, giving me a -2 initial balance. I manually deleted the item adjust entry and canceled the order, which brought my inventory to 0. Then I had to update the inventory amount by entering a bill for received items.

What a mess, but it is working now.

Good Luck,
Danny