Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
hiddentrue

Instead of manually creating website users one by one, administrators can bulk import users, user customers, user IDs and user customers deletions via CSV import. 


With a CSV file, new website users and user customers can be imported in bulk, saving the administrator from manually creating each record individually. Each row of the CSV file corresponds to a user record. You can also bulk import User ID changes and user deletionsThe administrator can add new users, user customers, change user IDs or delete website user records one by one by manually creating records individually. However, if there are many records to add or edit, they can be bulk imported via the CSV user import feature. Just prepare the CSV file with each row corresponding to a required or optional fields user record. Example templates can be downloaded from this page.


Import User Records

This procedure adds new users. Fields that are marked with * are mandatory. Some fields may not be in use on your site.

Expand
titleClick here for a guide to user fields...

The following fields are used when importing a user. Fields marked with * are mandatory.

Field NameField Description
EmailAddress*User ID (in most cases, the User ID is the user's email address)
NotifyEmailAddress*
Notification
Contact Email Address
DeactivatedShould user be disabled upon creation? Enter 'Yes' or 'No'. If 'Yes', the user will not be able to login until 'Disabled' is removed in the CMS. NOTE - If left blank, the default 'No' will apply. This means the user will automatically be
active
able to login to your website and receive notification of new user registration.
FirstNameFirst Name
LastNameLast Name
Password*Password
ConfirmPasswordForce the user to change
to new
their password when they first
logon
login to your website after the import. Enter
:
'Yes' or 'No'. NOTE - If left blank,
it defaults to
the default 'No' will apply. This means the user does not have to change their password the first time they login.
JobTitleJob Title
SectionDepartment
PhoneNumber*Contact Phone Number
Fax NumberFax Number
DefaultCostCentre(Only applicable if Cost Centre feature is used.) Default Cost Centre. See guide on Cost Centres
CustomerCode*Default Customer
Account 
Account. See guide on Default Customer Account
GlobalCatalogueAccess
For custom catalogue use. Enter: Denied, Full, ViewOnly or leave blank
Can the user view the entre product range? Enter 'Denied', 'Full', 'ViewOnly', or leave blank if custom catalogues are not used.
OrdersApprovedByFor use with order approvals feature.
SpecialInstructionsSpecial Instructions
ContractItemsOnlyContract Items Only. Enter
:
'Yes' or 'No'.
InitialRole*Initial Role
ApprovalType(Only applicable if Approvals has been set up for this user or customer account.) Enter: SPU, MPU, SPA, MPA, MPAS, H, HC, HAL or leave blank
ApproveNonContract
Enter: Yes or No
(Only applicable if Approvals has been set up for this user or customer account.) Enter 'Yes' or 'No'.
DenyApprovalProductEntryDeny Product Entry on Approval. Enter
:
'Yes' or 'No'
AllowApprovalProductEntryAllow Product Entry on Approval. Enter
:
'Yes' or
No

...

'No'.


1. Create CSV file

Download this csv template or follow the instructions to create one.

...