Download to Quickbooks?

[confused_aswell]

Hi

I am in the process of putting together a mod that will allow you to download your customers name, address, phone and email address to a csv file, which can be used to insert those details into quickbooks pro.

This is my first contribution so I would appreciate any comments good or bad on the mod. I will upload the mod shortly, but I expect it won't be available straight away.

This has been made for users of quickbooks UK, I have not tested it in other countries.

Thanks,

Phil

[confused_aswell]

Hi Everyone

I have just had confirmation that the mod is available to download.

http://www.zen-cart.com/index.php?ma...oducts_id=1147

Please take a minute to have a look if you can, especially if you are a Quickbooks user.

Any comments or suggestions would be appreciated.

Thanks,

Phil

[confused_aswell]

Hi

I am putting together an interface for people with large databases, the current Quickbooks Download retrieves all of the database records making this a large file to download if you have a large database. In the new version users will be able to select a number (entry) in the database and then download entries from that number (entry).

It should be ready soon,

Phil

[confused_aswell]

Hi

The improved Quickbooks Download is now complete and ready for downloading. The new module allows people to see their orders table and select from which person in the database to download. This was for people with large databases who could only download the enitre file before.

As always, if you could take the time to post your views or questions.

Thanks,

Phil

[confused_aswell]

Hi

At the time of writing this 62 people have downloaded my script. I am not one for glory or acknowledgements, I don't even want any donations!
But I thought one or two people might have had the decency to write a few lines to say something!

It only took me a few weeks nailed to the computer to do this, is everyone out there that rude not to say at least thanks!

Phil

[cornhustlah]

dude i just registered right now for the sole purpose of sending a thank you.

[confused_aswell]

Hi Cornhustlah

Thank you very much for your reply.

I would be interested in where you are in the world and what version of Quickbooks you are using, and obviously what do you think of my module?

Thanks,

Phil

[Tezla]

Thanks for the contribution. Overall, it works pretty good. I have some problems and suggestions for you. I'm not trying to be critical ... just trying to help make your module even better and easier to use.

Problem:
State/County is missing from exported .CSV
Country is missing

Suggestion:
Not sure about the way you decided to handle missing Suburbs. In the USA, we have Suburbs, but it's rarely part of our postal address. Our address would be incorrectly labeled if we included it in most cases. If we have an usually long street address, we will break it into 2 lines (Address Line 1 & Address Line 2). We know we can use the Suburb line in this case. Seems like Address 2 (Suburb) should export as (blank) if it's blank in ZenCart, unless it gives QuickBooks Import problems, in which case you might just make it a . (period) or something.

Suggestion:
You might want to modify the contribution's description to include the word "export". Right now, it's a little hard to find with the site's search engine. Also, I know you intended it to work with QuickBooks, I likely plan to use it as a basic CSV exporter to take the data to other desktop apps. (not just QB).

Observations:
When you first run it, if you get:
Fatal error: SQL in .../admin/quickbooks_download_view.php on line 45
... that just means your table prefixes are wrong. A quick Search and Replace for zen_ and you are back in business.

I'm running QuickBooks 2007. Like I said, I wasn't really planning on using it in this way. However, once I get a proper export, I wouldn't mind importing them into a test company file to see if it's compatible.

[Tezla]

I also wanted to add that although the State is shown on the export screen (right before you download) Billing Address4 gets exported empty or blank.

The Country is NOT shown on the export screen yet, but it would be nice if it was included (as Billing Address6 I suppose).

[confused_aswell]

Can you give an example of a long address and also the state problem?

I think I might make an ammerican version in addition to the current version so people can choose.

Phil