Download to Quickbooks?

[confused_aswell]

Just a thought, but if you are using the company name for import into quickbooks you will need to change the way the csv file titles the company name.

on line 25 of quickbooks_download.php change

'customers_name' => 'Customer Job',

to

'customers_company' => 'Company Name',

Hope that helps.

Phil

[missslady]

Phil:

I think I know why there is only 4 records... I had to re-install zen cart and did a customer dump into zen cart.. And since then only 4 new orders.

I think it's best for me to export the customer from the database - this one time and any then afterward my client would be able to use your add-on.

Re: company name - got it.


Thanks again - really appricate your quick reply.

-Niki

[kernheimer]

THANK YOU so much, you have no idea how proud i am of myself doing the zen_ thingy and so on. myself...
and how greatfull i am for your module
thank you!!

[littlehawk]

I havent downloaded yet, but i apperciate your effort!!!!!!!!!!!!keep it up, support you

[David Canham]

Hi,

I installed this mod today and I have removed the zen_ from the database entries in the quickbooks_download.php and the quickbooks_download_view.php

When I use the drop down menu I see all the orders but when I try to export them I get these errors

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/reliant1/public_html/adojd73/quickbooks_download.php on line 54

Warning: Cannot modify header information - headers already sent by (output started at /home/reliant1/public_html/adojd73/quickbooks_download.php:54) in /home/reliant1/public_html/adojd73/quickbooks_download.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/reliant1/public_html/adojd73/quickbooks_download.php:54) in /home/reliant1/public_html/adojd73/quickbooks_download.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /home/reliant1/public_html/adojd73/quickbooks_download.php:54) in /home/reliant1/public_html/adojd73/quickbooks_download.php on line 79

Any help would be greatly appreciated.

[confused_aswell]

Hi

Not sure why it has started to malfunction, but I got the same Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/reliant1/public_html/adojd73/quickbooks_download.php on line 54 error.

In the same file as above, change line 16 from that really long number to say 200000.

If you have a problem with that then I will PM the file over to you.

Let me know if this worked for you?

Thanks

Phil

[David Canham]

Hey Phil,

That fixed it, THX!

[AATECH]

Yes, I see what you mean. That Customer Import inside QB (even with proper mappings) is pretty weak. The fix is to make sure there is a least a space in the export field so it will actually count as a valid field like this ," ",

My previous suggestion about Suburbs was premature. However, I was speaking of the IF THEN loop in the routine and ONLY when empty. Now that I've actually tested it it seems the right thing to do might be as stated above. Export Suburb if it is filled in ... Export "a space" if it is empty. I would think this should apply to all "optional" fields that might be empty.

When I use the QB-SDK (qbFC) to write VB programs to import customers I do something similar. I first use IF-THEN statements to check that the variable is not empty before trying to work with it.

Hi Guys... This is a great Module... Great Job.

I was wondering if anyone did come up with a fix here. Some customers used this section (suburb) to put their suite number (don't know why) so the duplicate cities is not going to work, as some have suite number and some are just duplicates. I was wondering if it's possible to just put a space if that field is empty, and if so how?

Also, How do we go about adding the fax number to this as well. This is not for QB, but rather to have a customer database.

One Last thing, anyone know why it's giving a bunch of duplicates?

Thanks in advance.

[mjdeslon]

Installed the plugin but do not see the dropdown...any thoughts?

Michael

[confused_aswell]

Hi

You could try un-installing it and redoing again, it sounds as if some of the files are not in the right directories for the dropdown to appear.

Assuming you did backup before you installed the mod, you should restore back and then retry the installation.

Good luck

Phil