AbleCommerce Shopping Cart Software

Hi All,

I used to use an online marketing program which allows customers to subscribe to my mailing list. Since Ablecommerce already allows me to do this, i want to import all the users into Ablecommerce and create a login for them. I was able to successfully import a user into the ac_Users table, but didn't see them in the People | Users page of the admin area. I would imagine I need to add other information into other tables, such as ac_UserPasswords, but don't know which tables.

Basically, I want all my users from the old system to show up in Ablecommerce without the user having to create a login. Then I will email all the users informing them that an account has been created on the new system.

If anyone can be of some assistance, that would be appreciated.

You need to have a field for passwords in your upload file. If you download the users from the store using the DataPort utility in .csv format there is a field for PasswordPlainText. If you fill that in and upload the users again into the store, they should have passwords created. I just don't remember if the dataport will update the users or only create new ones.

I used the Data Client Utility with a CSV file and it worked fine, the only issue was I couldn't pick a group for the newly added users.

Is there a way to add them to a group? Also is it possible to send them a link to crate a new password, as if they had clicked on forgot password?

I was able to add users to a group, but I had to use an xml file.

User's CSV import doesn't provides a way to import user group information. Have a look at the user information that could be imported using CSV from here
http://wiki.ablecommerce.com/index.php/ ... CSV_Import:

Have a look at the following post about custom CSV import routines
viewtopic.php?f=47&t=9720