Add Customers from admin addon

[purelypoultry]

This mod badly needs someone to implement many of the changes that are listed throughout this thread and make the updated version available for download. I just spent several hours trying to fix the broken parts. I have never done that so I don't know how but it definitely needs to be done.

[carsal]

This is such a great mod but if I cannot upload va csv it is pretty pointless and I was really praying that someone would be able to help me with this...

[tat2nu]

I have read this post so many time that I could probably recite most of it flawlessly so please do not attack my question.

There is still no answer for those of us who want the State/Province dropdown that is on the create_account page to be the same State/Province method of selection that is on the add_customers page.

Could somebody smarter than me please figure this out. The way it sits now I can type in a state name but it does not seem to recognize the state in the customers address book so I need to go into the customers "my account" area to use the dropdown to select the state otherwise the cart does is not able to quote shipping.

HELP!!!!
Marc

[margecc]

There is still no answer for those of us who want the State/Province dropdown that is on the create_account page to be the same State/Province method of selection that is on the add_customers page.

Could somebody smarter than me please figure this out. The way it sits now I can type in a state name but it does not seem to recognize the state in the customers address book so I need to go into the customers "my account" area to use the dropdown to select the state otherwise the cart does is not able to quote shipping.

I've been trying to figure this out for a while. Right now, what you type in the input field for the state gets put in the address_book table under the column entry_state, and the zone_id get filled in as zero. Problem is that the zone_id is where Zen looks for the taxes to be calculated from, hence everyone manually entered is not being charged taxes (and apparently the correct freight). The person in post # 119 changed the country to the drop down list using Zen's codes. I've tried following what they did, changing the names of the tables and columns according, but it doesn't work (big shock for me). I know it has to do with this section in the add_customers.php file:

    if (ACCOUNT_STATE == 'true') {

        echo '<tr>
            <td class="main">' . ENTRY_STATE . '</td>
            <td class="main">';

        $entry_state = zen_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state);

        echo zen_draw_input_field('entry_state', zen_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)).'(Full Name)';
    }

Can anyone work this out? I'm sure it's a super speedy fix, but it would make my life so much easier since orders keep going through without taxes, so I am either loosing money cause I've missed it or having to manually adjust things.

[frank18]

Had the same problems with email not being sent to "new customer". Applied the bug fix in post #114 and bingo!


With reference to post #130:

Okay, I think I got it. In the add_customers_backend.php file in the admin folder at line #695 comment out the "$errors = false". So change this:

if (count($errors)) {
$cInfo = new objectInfo($_POST);
$processed = true;
} else {
$errors = false;
}

to this:

if (count($errors)) {
$cInfo = new objectInfo($_POST);
$processed = true;
} else {
//$errors = false;
}

So you suffer from constant headaches or migraines and to get rid of them, you just pop a few painkillers a day. Problem fixed - the headaches are gone! Or is the problem fixed?

Pains and error messages are of the same nature: they are telling you that there is a problem! Symptoms are good, they are telling us a story! Don't just suppress the symptoms, instead look for the underlying reason and fix it. Usual result: symptoms gone.......no more error, no more pain.

I am a natural therapist and not a php savvy programmer, so I leave it to the experts to fix the underlying problem of the symptom of this error message:

Warning: Invalid argument supplied for foreach() in /zencart_folder/admin/add_customers.php on line 71

Great mod, just installed it on both of my stores but will tread with caution until it's 100%

[wendyandmilo]

Thank you very much .. works fine..
but still having error with the date.. zen cart doesnt accept the date in yyyy/mm/dd or yyyymmdd or yyyy-mm-dd . changes it to a weird date..
also the addon does accept it as mmddyyyy

Here's what I did to make it accept MM/DD/YYYY dates (like every other mod for the US :)

In add_customer_backend.php, around line #601 there are the following lines:

			$month = (int)substr($customers_dob, 4, 2);
			$day = (int)substr($customers_dob, 6, 2);
			$year = (int)substr($customers_dob, 0, 4);

...delete them. You can also delete the error message that follows, if it annoys you:

if (!checkdate($year, $month, $day)) {
				$errors[] = 'DOB is invalid (Must be YYYYMMDD, YYYY/MM/DD or YYYY-MM-DD)';
			}

Do a search in the file for "dob" and change any references of 0001-01-01 to 01-01-0001. I think only 1 of them stays changed because the other one seems to be called from the database. If you wanted to, you could go into your db and change that as well. I did not.

That is what I did and it takes (and keeps!) MM/DD/YYYY just fine.

** I am not guaranteeing anything. Just saying what works for me :)

[Donaldo01]

I'm using the most up to date ZC 1.38a and the most recent version of the add-on. I have got the add on to the stage where I can add customers one-by-one but cannot get the bulk add using CSV to work. I am in Ireland and all my current customers are there also so I need to input Ireland in the "Country" field. However the upload keeps failing with the message

" Errors on line X of the imported file
* Country is a required field"

Where X is every line in the datalist except the column headers. I have tried changing the Country to uk and UK for all but to no avail - I'm now baffled and would welcome some help.

[Donaldo01]

Bump. Anyone?

[carsal]

I have the same problem and no one has yet been able to assist me with fixing it. I had to load 180 clients manually and have another 100 to load in the next week and will have to do them manually as well. so I doubt you will get any response either.

[davewest]

I don't do massive uploads so never had any need to change this, but here where your problem is...

in ADMIN\add_customers_backend.php find this set of code and add your country....

if ($country == 'uk') {
    $country_id = 222;
    } else if ($country == 'us') {
         $country_id = 223;
    } else if ($country == 'Ireland') {
         $country_id = 223;
    }

Of course, doing it this way means you will need to use phpmyadmin to look up and use the right country code for your database. mine for the US is actually 241, I added the red.... you'll have to figure out what it is for you.... the ID is not the same for each install!