Download to Quickbooks?

[confused_aswell]

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

[Vortex12]

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 :)

[confused_aswell]

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

[loosefast]

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!

[confused_aswell]

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

[missslady]

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

[missslady]

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

Thanks!
Niki

[confused_aswell]

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

[missslady]

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

[confused_aswell]

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