Add Customers from admin addon

[MaureenT]

Oh, trust me. I know exactly how you feel.

If you can't find a way to get the bulk upload working, an alternative is to use one of the CSV to SQL conversion programs that are out there. That's what I was considering. It will take more work to do it that way since you have to split the customer data into two SQL files, one that you install into the Customers table and the other into the Address_book table because the info for each customer doesn't all go into one place in the database. You also need to do some sequential numbering for one of the fields. If you have any experience with working with databases in MySQL, you should be able to figure it out by taking a look at the structure and contents of those two tables, seeing what records go where.

[MaureenT]

Presently, the email format preference is defaulting to HTML on the form. I need to change it to TEXT. I tried changing line 74 in add_customers_backend.php from 'customers_email_format'=>'HTML' to 'customers_email_format'=>'TEXT' , but that didn't work. The default for the store is set to TEXT.

[mprough]

Do you have "Mime HTML" enabled in the email configuration of ZC?


~Melanie

[MaureenT]

No. I want to completely eliminate the option of HTML emails. I suppose that if I don't have that enabled, it wouldn't send them out as HTML regardless of what was selected.

[mprough]

Hi Maureen,

Try changing this

, 'customers_email_format'=>'HTML'

to

, 'customers_email_format'=>$customers_email_format

Then add column customers_email_format to your CSV using TEXT as the option.

~Melanie

[MaureenT]

I think you misunderstood what I was trying to do. I wanted to change the default selection on the form itself that so that when a customer is being added in manually, something that will happen on occasion, the person entering in the info doesn't have to remember to change HTML to TEXT for the email format.

I managed to figure it out for myself this morning. I made the following change to add_customers.php.

$email_pref_text = ($cInfo->customers_email_format == 'TEXT') ? true : false;

changed to

$email_pref_text = ($cInfo->customers_email_format == 'TEXT') ? true : true;

By the way, since the default setting in the database is to put TEXT into the email preference field, if there is nothing in the CSV file to override that, any customer entered via CSV is going to automatically be set to TEXT, so what you suggested wouldn't be necessary for my situation. Adding that column, however, would be useful for store owners who want to preserve customer email preference settings from an old store. In that situation, I don't think it would be necessary to make that change to add_customers_backend.php, though.

Thanks anyway for your attempt to help.

[mprough]

Hi Maureen,

Glad you got it figured out...

I did misunderstand as when you referenced add_customers_backend.php I automatically assumed your were referring to the bulk feature which we added to the module.

add_customers.php is part of the original mod and we have made just a couple of tweaks to it.

The change I posted would be handy to keep current email preferences and would be necessary to make the accounts a mix of html and text using the bulk import.

I would like to add some other stuff to this mod and we have been working on it, but time is short ....

~Melanie