I was able to successfully export orders from my Version 7.6.1 store and then import them into Quickbooks. I know this is a huge issue for many merchants as well as for my company. This issue was causing us to cancel the migration of our V-4 store, however we are now planning to migrate due to this new capability.

To export the orders I used the upgraded order report on V-7 and included the product information on that report. You need to massage the data on the csv so that the customer and the product information is on the same line and if there is more than one line of product on a single order you need to copy the customer information on all lines of that order.

The import tool we use is made by Baystates Consulting, http://www.baystateconsulting.com/. It is the "Transaction Pro Import Wizard 3.0" and it costs $199. We have been using it for several years to import Amazon and EBay orders into Quickbooks. Please note I am providing this information only because it works for our company. I have no financial or other interest in this company. If your orders are different than ours it may not map.

Our order needs are fairly common in that we use SKU#s to match the product in QB and have quantity discounts and shipping fees and taxes. The fields on the new order report mapped over to QB quite easily. Once your map is built, then importing orders is a simple process and takes a few minutes.

Thanks for the info. I'm still waiting to migrate because of QB issues also. I would prefer that NS fix this so I don't need a 3rd party solution to import orders (from a QB compatible shopping cart???)

Just out of curiosity, how long did it take you to set up the map you're now using? Do you know if it will handle shipping and handling separately? What about discount codes? Gift certificates? Yours sounds simple, but mine would need all of the above (and probably something I'm forgetting).

Thanks again for posting! (IMG:http://forums.networksolutions.com/style_emoticons/default/smile.gif)

I am not an expert at all. I was able to get most of the map done in a few minutes and then Baystates helped me finish it after it didn't import correctly. They give free service for initial setup, then you gotta pay or beg. Begging is easy and you can always pay (IMG:http://forums.networksolutions.com/style_emoticons/default/bigsmile.gif) .

As for the variety of functions you use, I am guessing that if the field is in the order report, then it is mappable to QB. I would pull an order report and see if those fields you need exist. I know discounts, shipping, handling are separated out. There is no payment method field and I do wish we had that, but it is easily added in the csv.

I agree that a QB compatible platform that actually worked with SKU's would be better, but this is easier than changing platforms altogether for us. We have a V-4 and a V-7 store and I do like the functionality in the V-7 store.

I agree. I don't want to have to pay for a service that should be working properly with the fee I am now paying with NS.

I'm also in complete agreement regarding the way the QB connector doesn't work and really stymied by the apparent lack of concern by NS. From a business perspective the bottom line is that entering orders manually costs money too if you place any value on your time. As I mentioned, we also use the importer for other platforms that don't have a QB connector (EBay has one but it sucks) so this tool does triple duty for us and has paid for itself many times over.

The thing I am curious about is the other functions the QB connector does and how it helps other NS merchants. I guess that stems from my paranoia that I am missing something fundamental here. Am I?

OK so 4 months has gone by since this post. So Network Solutions has a working solution for all of us right? Migrating from version 4 to version 7 is now painless and we have a working process where by we can export our orders from MCP to QB without issues right?

NO? A full year has gone by since people started complaining about this and still no solution? We need to spend hundreds on a work around?

We must all be ridiculous to expect you can export orders from MCP to QB, after all NS never said that version 7 supported QB right? OH wait they did! Well we must be asking way to much to expect that a product number would export as a product number right, I mean that is just asking way to much.

I just don't get it. How does NS maintain customers with service like this? I am new to NS (bought an existing business 4 months ago from someone who was a customer for 5 years). After going through a long and painful migration from 4 to 7 and the loss of business as a result and now the QB mess, I am thinking the pain of migrating to a new cart provider would have been easier.

So frustrated.....

I would like to keep this post alive. I think NetSol has really overlooked the fact that we need better reporting for our store and are willing to work with QB if it gave us the information we could actiually use, which it does not. The order number goes into Memo and the Item number is the title. How lame is that. Come on guys. The other shopping carts have this functionality. I do not want to move but you have to start giving your customer what they want and we want better reporting vehicles.

I agree Dani. Lame. I have complained about this repeatedly. They keep telling me that this isn't a "bug" - IT WAS DESIGNED TO WORK THIS WAY! Then they proceed to explain the "work around" (why do you need a work around if it isn't a bug????) Bottom line for me - I'm not "working around" anything. It will work right or I won't use it. I'm staying with V4 for now, but I am looking at other options, especially since they're discontinuing support for V4 at the end of this year. I keep coming back here hoping that they'll finally see the light and give us what we want. *Sigh* Wishful thinking I guess.

The move would be easier if I didn't have to go to a different company, but it's going to be a pain either way, so when the time comes, I'll move to something that works right.

[quote name='AAAIndustrialSupply' date='May 22 2009, 08:20 PM' post='18771']
There is no payment method field and I do wish we had that, but it is easily added in the csv.

NS... is it possible to add the payment method field to the Orders export. this would save significant time!!

The inability to import sales data in to the correct Quick Book fields is inexcusable when NS claims to be compatible with QB. It would require far too much time to open each Sales Receipt and hand correct the incorrect field mapping of WebConnect. As a last resort I have looked at several 3rd party packages that import cvs files -- ZED, QImport3, IIF Transaction Creator, and Transaction Pro Importer (TPI). The last, TPI, is by far the best and is the one mentioned in the first post of this thread.

I have spent 8-10 hours figuring out the changes needed in my cvs file and then to get it to map correctly into QB. I amost have it. I hope I can get the same installation support mentioned in that first post. I don't want to purchase the software it if I can't get it to map correctly.

Has anyone else used this or other 3rd party software to import sales?
What mapping problems did you have? How did you solve these?

I would be happy to share what I have learned about the necessary changes in the cvs file and mapping in TPI with anyone who would like it. Just send me an email.

It truely stinks that NS is making us pay $200 for 3rd party software that does QB integration correctly.

This is not the only costly complaint I have about the new NS. Our migration to version 7 has been very costly. My Variants were not migrated correctly resulting in confusing product pages with option prices that could not be understood. Our sales fell by 75%. Ugh. I am still spending staff time to go in and correct each of more than 1000 products.

I am thinking seriously of moving to another platform. Any suggestions?

SonomaEcon
www.futonsAndBeanBags.com

NOTE: I called intuit and spoke to a sales rep. He indicated that most users of the QB web connect do not have a problem with integration or it's compatibility with the web hosting company product that uses it.(NS). Maybe we can start a calling campaign to them to find out why our version is so lame!

It would also be nice if someone at NS would organize these forums to reduce duplicate content/posts. I searched for this topic and couldn't find it so I started my own string here: QB Web Connect Post

How hard could it be to have a more organized forum that is streamlined in its discussions and topics. There really is some good information available here IF you can find it. (PS good luck with the search feature and Tags)

Andy B

Hi, If you send me an email I will be happy to provide you and anyone else with our csv file manipulation process and map file for TPI. The mapping is a bit tricky, but works well once done. Send an email to jack.weiss@aaaindustrialsupply.com.

Jack

Thank you for the offer Jack.

While Transaction Pro Importer gets the job done, I think I have found an even easier 3rd party program that does not require any manipulation or changing of the csv file exported by Network Solutions®. I know how big an issue this lack of a workable interface between our store and QuickBooks is, how WebConnect doesn't do the job correctly, and how we are essentially having to invest several hundred dollars to purchase our own third party software to transfer data from our store to QB. For the benefit of others on this forum who are in the same situation, I want to share my experience with this program.

AaaTeXShoppingCartIntegrator provides a map for an exported csv file that works very well. This program has no problem importing correctly into QuickBooks the multi-row per item csv files we get from our Network Solutions® export. No alteration of the csv file required.

A big advantage of AaaTeXShoppingCartIntegrator is that not only does it create a Sales Receipt for each order, it also has the option of automatically creating a Purchase Order for each different Vendor on a Sales Receipt. From these PO's I can quickly create Bills payable to my vendors. This automates many steps that had previously been done by hand and reduces my bookkeeper hours, thereby saving me money.

The AaaTeX designers are currently working on an interface with Network Solutions® so that the user will not even need to export the Orders csv file. It will work the same way the old MonsterBooks did, but probably better. For me, MonsterBooks always had problems importing some orders into QB which then required manually creating their Sales Receipt. In comparison, AaaTeXShoppingCartIntegrator does a better job of understanding the csv file and successfully importing to QB these more complicated Orders -- thus, less staff time on data entry.

I experimented with Transaction Pro Importer 4.0 for a couple of days, I even recommended it in this thread a few days ago, and while it imports OK once I manipulate the downloaded csv file, I was very concerned about having my part-time bookkeeper, or anyone else doing this manipulation. Even a small error in this manipulation would be amplified as incorrect data is transferred into my Sales Receipts, Purchase Orders, and Bills Payable.

AaaTex, the maker of the program has given me great support getting it set up and working correctly for my particular store. I think it is well worth the $299 cost. I will easily save this in staff time in a month or two.

You can try it for free: http://www.aaatex.com/QuickBooks_Shopping_...grator_Cart.htm