Manually add customers

[DrByte]

When you say subscription addition, I don't want to add any subscription data, I just need to insert email addresses into the database and flag those addresses as accepting the newsletter.

Can someone provide me with the proper SQL code to do this and then I can handle that on my own?

Thanks!

That's why you want the subscription addon.
By default, Zen Cart doesn't merely track email addresses for newsletters. It flags customer records as being part of newsletters. As such, you need to create complete customer records in order to subscribe them to the newsletter.
Or, you can use the Newsletter Subscribe addon which alters this behaviour by adding an additional table to track the email addresses specifically.

[aerodynamic hippo]

i wrote a contribution to manually add a customer through the admin. it has recently been activated and is available in the download section, should it still be desired.

[eccentric]

i wrote a contribution to manually add a customer through the admin. it has recently been activated and is available in the download section, should it still be desired.

Wish I had known this earlier! I ended up doing it myself (: I'll test out your contribution when I get a chance.

[gracemelodic]

i wrote a contribution to manually add a customer through the admin. it has recently been activated and is available in the download section, should it still be desired.

Thank you, thank you, thank you!

[Ryk]

just for curiosity sake, WHY,
is it any easier to type the information in on the admin side as opposed to the catalog side?

One advantage of doing it through this mod in admin is that you can choose whether or not to send the welcome email.

Another is that it just gives an easier workflow for the store administrator.

[swguy]

I think also that one of the folks who wanted this had turned off user registration and wanted the only mechanism to be registration by admin. :shrug:

[aerodynamic hippo]

the whole reason I wrote it was because I needed it for a client who wanted to only sell to current customers - their store is behind the login, and registration is turned off. Thus, if they want to add someone, its easier if they can enter it on the admin side, than having to turn on registration, put the user info in as if they were the customer, then go back and turn registration back off (which also opens up the slim possibility that someone else could visit and register on the site in that time).

so the short answer is, ease of use. :)

[jacque427]

Is the Add Customers mod compatible with 1.2.6?

[jacque427]

Yep, it is compatible with 1.2.6.

As it didn't overwrite anything I just installed it and it works fine. Doesn't appear to send the welcome e-mail but I'm not worried about that.

Great mod. Thanks for taking the time.

Jacque

[jacque427]

I stand corrected, it isn't adding the new person to the database.

They show up on the Admin side but not in the database.

Any suggestions?