Data not transferring to Quickbooks

I made a typo in a recent commit which has been fixed this morning (ie within the last 4 or so hours).

If you do a fresh pull, you should be able to make a start.

To get the accounts, products and so on from Quickbooks into Drupal, you should just need to enable the module and then run the Web Connector's update command. If you then refresh/visit the /admin/store/settings/qb page, you should see the status of the last connection and below that a collapsible fieldset containing the global defaults for matching up Drupal data with Quickbooks data. These values can be overridden at the product class level and for individual products. (I'm thinking I'll also end up making them overrideable at the level of products options/attributes, but I haven't yet gotten around to learning the detail of that area).

Having done your matching up, you can check all is well by running the Web Connector again and then refreshing the page I mentioned above. The status should tell you everything is ready to go. If it all looks good (or you just want to give it a go anyway), turn off the 'Hold orders' tick box that's just above the status and run the Web Connector update again. Orders that are ready to go should be exported into Quickbooks at this stage.

A couple of things to note:
- I'm part way through modifying how the data is stored. With the commit 30e61dc2356ca059ce6ac2f5c38d8513e9e5d5ca, you should be able to set everything up, but I don't expect that exporting will work. I'm going to be working on that after I have lunch, and don't expect it to take ages.
- Tracking of which orders have been sent to Quickbooks is another thing I need to finish this afternoon. The tracking used to be done in variables which would be lost if you did an uninstall/reinstall. I'm making this data (only) more persistent.

Regards,

Nigel

Okay. You should be able to give it a go with the commit I just made. Marking as fixed (please reopen if needs be :>)

The 'Version not provided by service' is something from the Web connector itself. I think I see that message too, so wouldn't be so worried about it.

The second error would be more helpful. To get more info, you should enable verbose logging on the Quickbooks web connector side of things. (Some Googling should show you what I'm talking about pretty quickly). There's also a log file that Quickbooks stores ... in the ProgramData area if I remember correctly ... that gives more detailed and useful messages than just 'QuickBooks found an error when parsing the provided XML text stream'. It's in AppData/Local/intuit/Quickbooks/log under the user directory on my computer.

There are a couple of bugs I need to fix, one of which (the request for the 'Merchandise Sales' account details) is showing in your log. The problem with the Products not being found though - that all looks like things are working right: are you sure you have products (items, not accounts) in Quickbooks with full names matching those values? You might try going to the admin page and telling Drupal to pull the list of products from Quickbooks.

Ah.. okay. So then those messages saying we can't find data should be followed by attempts to create the products. I'll look at the log again :)

Okay. Now I'm on the same page. Looks like there's a couple of issues:
- The AccountAdd requests are missing data
- I need to add recording of what Add requests we've already made, so we don't repeat them.

Neither should be a big change, but it will take me at least a few days to get around to them. Please bug me if I take too long to reply. (I've got a few big projects on the go at once, and this is only a small part of one of them!)

I've fixed the Merchandise Sales issue, but need prodding to get around to the other one. (I've moved on to other things in my quest to get an online enrolment system ready for January). Please keep bugging me (or better still, provide a patch :>)

Sorry for the slow reply. You're not forgotten. I'll see if I can get around to this soon.

Following this...

I'm in a very similar position. After a few issues, I have the Web Connector connecting and authenticating nicely.

Now I'm trying to get order data to transfer. Maybe this is just a user error on my part or a setting I missed but this is what my log looks like:

Status of the last Web Connector session: Last Web Connector run was 11 January 2012 21:37
For order 4
- Need to match the following customers with Quickbooks equivalents: joe666
For order 7
- Need to match the following customers with Quickbooks equivalents: test
For order 12
- Need to match the following customers with Quickbooks equivalents: tyoshimoto
For order 13
- Need to match the following customers with Quickbooks equivalents: tyoshimoto
For order 14
....

So it looks like Quickbooks doesn't know how to map customers? I have the feeling I'm really close to getting this working.

Hi Nick.

Go into the user/edit page for each of those users. You'll find a field that you can use to match the Drupal user with the Quickbooks customer (assuming you've already run a first sync to get the Quickbooks data into drupal). Set the matching Quickbooks account for each user and then rerun the web connector and you should be set.

Regards,

Nigel

Thanks for the quick response Nigel.

I see the user field but it's not really feasible to have to create a user in Quickbooks and then manually map it for every customer. We could be getting hundreds of customers a day and to have to do this for each customer would be extremely time consuming. Based on the module setting "New accounts are created in Drupal and exported to Quickbooks", I got the impression Quickbooks users will be created automatically. Am I mistaken?

It could work that way. For the project I was working on (for work), I needed the opposite, so that was got attention. It shouldn't be much more work to get the opposite working - I just need to find time to do it outside of work time.