Download to Quickbooks?

Hi

That's really nice of you, thanks.

Stay in touch,

Phil

Sure, no problem.

I just added a "config section". Now you can change one digit at the top of the module to control whether or not it does the UK phone number formatting.

I think I'm done now. I'll zip it up and get it to you. Look for a PM soon.

Trying to figure out how to fix this:
Fatal error: SQL in .../admin/quickbooks_download_view.php on line 45

And ty for your work on this:):clap:

Hi

This is your table prefix, what are your table prefixes?

Phil

schunard:

Trying to figure out how to fix this:
Fatal error: SQL in .../admin/quickbooks_download_view.php on line 45

And ty for your work on this:):clap:

Yes, this is the error you get when your database table prefixes are incorrect. Take another peak at the ReadMe.txt.

In my case, I had no prefix, so I replaced the zen_ on the SQL lines with nothing (stripped them away).

As far as recent work goes, you are welcome. But I'm just trying to "help out around here". Phil deserves most of the credit.

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

just to say thank you thank you thank you for your time :smile:

Hi there!

It's my pleasure, I hope it serves a purpose for you.

Thanks for the comment,

Phil

Hi everyone,

I got this great module working without any errors.

But when I download the file it is blank? :blush:

Any suggestions?

Thank you

Sam (Australia)

Hi

Do you have any customers that have placed and completed orders?

thanks

Phil

Tezla:

Yes, this is the error you get when your database table prefixes are incorrect. Take another peak at the ReadMe.txt.

In my case, I had no prefix, so I replaced the zen_ on the SQL lines with nothing (stripped them away).

As far as recent work goes, you are welcome. But I'm just trying to "help out around here". Phil deserves most of the credit.
Hello all Great scrip its just what ive been looking for, I have been trying to get this script working and also getting this error, i Am a biginner to code, so Im not sure what to do .
Any help would be heaps appreciated
thanks in foreword :)

Hi Vortex

What is the prefix to your database tables - Zen_admin....,Shop_admin... or admin etc? Find out what they are and get back to me. It is a really easy problem to fix.

Phil

Sorry about taking so long, Im not sure what you meen by "What is the prefix to your database tables" do you meen my admin in shop name?
Solar-shop/admin/ ?

Ps your help is much appreciated thank you for this great addon :)
:lamo:

Hi

You will need to log on to your phpmyadmin, then click on the database for the zen-cart mine is Zc_1. When you click on the link there will be a lot of tables on the left hand side of the page like this....

zen_address_book
zen_address_format
zen_admin
zen_admin_activity_log
zen_authorizenet
zen_banners
zen_banners_history
zen_categories
zen_categories_description
zen_configuration
zen_configuration_group
zen_counter
zen_counter_history
zen_countries
zen_coupons
zen_coupons_description
zen_coupon_email_track
zen_coupon_gv_customer
zen_coupon_gv_queue
zen_coupon_redeem_track
zen_coupon_restrict
zen_currencies
zen_customers
zen_customers_basket
zen_customers_basket_attributes
zen_customers_info
zen_customers_wishlist
zen_db_cache
zen_email_archive
zen_ezpages
zen_featured
zen_files_uploaded
zen_geo_zones
zen_get_terms_to_filter

As you can see my tables are prefixed with the zen_ whatever your tables are prefixed with is what you need to change according to the read me.txt document.

Any other problems then come back to me.

Thanks for the comment

Phil

Would it be possible to filter the results by some of the same options available in the Newsletter Options
"All Newsletter Subscribers"
"Dormant Customers"
Active customers"
Active customers in past 3 months
or
by address

This is for import into a 3rd party newsletter service

thanks for the mod!

Hi

Thanks for the idea, I can see how you would want it to work. Unfortunately I am really tied up with some website work at the moment, and to configure this would take some time. Therefore I am not going to be able to help on this occasion.

If you like, you could set to work on this and come back to me when you have got somewhere, it maybe something that I want to put into the next version. But as I said, I just don't have the time to do this upgrade at the moment. Any other issues regarding the current version I will be happy to assist with.

Hope this is ok?

Phil

I've install the add-on and it's not working.

I get a blank page when I click on customer > quickbook download.

I had to removed the "prefix" from quickbooks_download.php and quickbooks_download_view.php

Please help.

-Niki

Also - would it be hard to add "Company Name" to the csv file?

Thanks!
Niki

Hi Niki

All I can say is did you install it correctly? You may have deleted something when you removed the prefix.

Also, have you uploaded all of the files to the correct places, this mod has been downloaded over 1000 times and yours is the first not to be working, please check you have done everything correct.

As for your other query, you can easily add the company but it will need some code alteration.

In quickbooks_download_view.php around line 87, change

$sql = "SELECT zen_orders.orders_id, zen_orders.customers_name, zen_address_book.entry_firstname, zen_address_book.entry_lastname,

to

$sql = "SELECT zen_orders.orders_id, zen_orders.customers_company, zen_address_book.entry_firstname, zen_address_book.entry_lastname,

Also at line 98, change

<tr><?php echo "<td bgcolor='$color'>" . $list['orders_id'] . " , " . $list['customers_name'] . " , " 

to

<tr><?php echo "<td bgcolor='$color'>" . $list['orders_id'] . " , " . $list['customers_company'] . " , " 

Also in quickbooks_download.php at line 48, change

$values = mysql_query("SELECT zen_orders.customers_name,

to

$values = mysql_query("SELECT zen_orders.customers_company,

This should do it for you.

Let me know how you get on, I am pretty sure you have made an error somewhere.

Keep in touch.

Phil

Phil:

I found another prefix I forgot to remove from the "quickbooks_download_view.php" - line 44

Re: Instructions for Company Name export works! Thank you! Thank you!!!!

One more question:

I have a total of 97 customer and I would like to export all of them to csv file...

"If you want to export all records in the table enter 0, but if you are exporting from entry number 1000 then enter 999."

I enter 0 in the text box and hit export... but only 4 records got exported.

Please help.

Thanks
Niki

Hi Niki

I am pretty sure it only lets you view and download customers who have bought something from your shop. Have all 97 customers bought something?

Thanks

Phil