Customer Profiles
- 1 Customer Profiles
- 1.1 Customer Profile Options
- 1.2 Export Customer Profiles
- 1.3 Import Customer Profiles
- 1.4 Loyalty
- 1.4.1 Past Ledger
- 1.4.1.1 Fields
- 1.4.2 Future Ledger
- 1.4.2.1 Fields
- 1.4.3 New Ledger Entry
- 1.4.3.1 Fields
- 1.4.1 Past Ledger
- 1.5 Manage Customer Profiles
- 1.6 Pricing Tiers
- 1.7 Send Password Notice
- 1.8 Settings
- 2 Frequently Asked Questions
- 3 Related Documentation
Customer Profiles
Customer Profile Options
This Section contains 6 options to assist in managing customer profiles. They are:
Export | Pricing Tiers |
Import | Send Password Notice |
Loyalty | Settings |
Manage |
|
Export Customer Profiles
The customer profile export utility allows you to quickly generate an Excel Spreadsheet or CSV file of all the information contained within your customer profiles. A quick way to update a lot of information is to generate a spreadsheet with this utility, edit the spreadsheet, and then import the information back into UltraCart. Click on the Export link to create your spreadsheet. The following screen will appear.
Related: Customer Profiles Export Tutorial
Import Customer Profiles
Using this tool, you can import an Excel Spreadsheet or CSV file containing your customer profile information, and the profiles will be automatically be created or updated with the specified information.
Related: Customer Profiles Import Tutorial
Loyalty
The Loyalty program provide a way to reward customers for their patronage. The customer can accumulate points that they will then be able to redeem for purchases within your store.
The Loyalty sections in the customer profile editor give merchants a complete view of a customer's loyalty status, transaction history, and pending activity.
Merchants use these sections to:
Review earned and redeemed points
Inspect transaction details
Manually award or deduct points
Understand upcoming reward eligibility
All ledger data is read from the global loyalty ledger and is only visible when a Loyalty Program is active for the merchant account.
Note: If no loyalty program is enabled, these sections display a message indicating that the feature is not available. Contact support to enable the Loyalty Program.
Past Ledger
The Past Ledger displays all completed loyalty transactions for the customer.
Fields
Field | Description | Format / Notes |
|---|---|---|
| Timestamp when the transaction occurred | MM/DD/YYYY HH:MM AM/PM |
| Category of the loyalty event | e.g., |
| Human-readable summary of the event | Text; may include order ID or reward name |
| Net point change for the transaction | Integer (positive for credits, negative for debits) |
| Running point balance after the transaction | Integer; cumulative total |
| Associated order (if applicable) | Hyperlink to order details when present |
| Specific item or reward involved | Text or empty |
Location: Customer profile editor → Accounting / Tracking tab → Loyalty section
Future Ledger
The Future Ledger shows pending or scheduled loyalty activity that has not yet been finalized.
Fields
Field | Description | Format / Notes |
|---|---|---|
| Expected or scheduled date | MM/DD/YYYY HH:MM AM/PM |
| Category of the pending event | e.g., |
| Summary of the anticipated activity | Text |
| Expected point impact | Integer (positive/negative) |
| Current state of the future entry | e.g., |
| Linked order (if applicable) | Hyperlink when present |
Location: Customer profile editor → Accounting / Tracking tab → Loyalty section (below Past Ledger)
New Ledger Entry
This section provides a form for merchants to manually create new ledger entries (typically for adjustments, goodwill credits, or corrections).
Fields
Field | Description | Format / Notes |
|---|---|---|
| Date of the manual entry | Date picker (defaults to today) |
| Type of adjustment | Dropdown: |
| Reason for the adjustment | Free text field; required |
| Point value to apply | Integer input (positive or negative) |
| Additional internal notes | Optional multiline text |
| Button to record the entry | Creates a new Past Ledger record immediately |
Location: Customer profile editor → Accounting / Tracking tab → Loyalty section (form at bottom)
Important: Manual ledger entries are immediately reflected in the Past Ledger and update the customer's current point balance. They are auditable and tied to the merchant user who performed the action.
For more about the Loyalty program, see the following 'help' doc: Loyalty Program
Manage Customer Profiles
The customer profile manager is the place you'll use to search, create, edit and delete customer profiles:
Customer Profile Menu
The menu at the top right portion of the page provides options for:
Searching Profiles
Modifying the Profile Table layout
Creating a new profile.
Searching customer profiles
Clicking the magnifying glass icon will open the search form:
Search Tip: Use Wildcard In Your Searches
You can use the asterisk * character (shift+8 on keyboard) as the search wildcard.
Example:
You are looking for an email of a customer that you know begins with the customers first name and is a gmail.com account.
You could enter the email address as:
Y*@gmail.com
Which would return all email addresses beginning with a "Y" and has the @gmail.com domain.
Configure Columns for the Customer Profile Table
Clicking the middle button will open a dialog window for editing the columns that will be displayed in the customer profile table:
Blue indicates that the column is enabled, and a grey color indicates that the column disabled.
Creating A New Customer Profile
Clicking the third button (the '+' symbol) will open the customer profile editor:
The dialog window will prompt you with the essential fields:
Field | Description |
|---|---|
First Name | optional |
Last Name | optional |
Required Field | |
Password | Required Field |
Phone | optional |
Company | optional |
You'll have the option of performing a quick add with just those basic fields
Profile Editor
The Profile Editor has 11 tabs:
Tab | Description |
|---|---|
General | This tab contains the Customer login credentials and other customer information:
|
Billing | Billing Address books and also Checkout & Payments settings for the customer.
|
Shipping | Shipping Address Books and Shipping options:
|
Accounting / Tracking | QuickBooks, Affiliate and Sales Rep assignment, and Loyalty / Cashback ledger:
|
Orders | Order history associated with customer profile. |
Quotes | If Quote Requests are enabled, Quotes for the customer are viewable here. |
Reviews | If Product Reviews are enabled, Reviews and reviewer details are displayed here. |
Uploads | File attachments, such as resales certificates are viewable here. |
Taxes | Reseller Tax ID number, Avalara & TaxJar codes configuration. Tax Exemption configuration.
|
Software | If applicable, Software Entitlements are viewable here. |
Activity | View the shopping and sales activity captured by UltraCart Analytics.
|