Customer Profiles

Customer Profiles


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.

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:

  1. Searching Profiles

  2. Modifying the Profile Table layout

  3. 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

Field

Description

First Name

optional

Last Name

optional

Email

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

Tab

Description

General

This tab contains the Customer login credentials and other customer information:

  • Login Email: This field is used to enter the customer's email address, which serves as their login credential for accessing the account.

  • New Password: This optional field allows the customer to set or update their password for account security; it should be filled in only if a password change is intended.

  • Sign up Date: This field records the date when the customer created their account, providing a timestamp for account registration.

  • Referral Source: This field captures how the customer learned about the service or was referred, helping track marketing or referral effectiveness.

  • Website URL: This field is for entering the customer's website address, which may be used for business verification or linking purposes.

  • Approved Signup: This toggle field indicates whether the customer's signup has been approved, likely used for administrative review or activation.

  • Business Notes: This field allows for adding general notes or comments about the customer's business, useful for internal reference.

  • Automatic Order Merchant Notes: This field is for notes that will automatically be included with each order placed by the customer, aiding in order processing or communication.

  • Tags: This field enables the addition of tags or labels to categorize or filter the customer profile for easier management.

Billing

Billing Address books and also Checkout & Payments settings for the customer.

  • Billing Address Book For support@ultracart.com

    • Address: This field is used to enter the physical address for billing purposes.

    • Name: This field captures the name of the individual or entity associated with the billing address.

    • Company: This field is for entering the company name related to the billing address.

    • Address: This field provides a secondary line for additional address details if needed.

    • Day Phone: This field records the daytime contact phone number for the billing entity.

    • Evening Phone: This field records the evening contact phone number for the billing entity.

    • Tax County: This field indicates the county for tax purposes related to the billing address.

  • Checkout & Payments

    • Allow Selection of Shipping Address Type: This toggle enables or disables the option to select different shipping address types during checkout.

    • No Real-time Charge: This toggle determines whether real-time charging is disabled during checkout.

    • No Coupons: This toggle controls whether coupon usage is allowed during checkout.

    • Allow Purchase Order: This toggle enables the use of purchase orders as a payment method.

    • Auto Approve PO: This toggle automatically approves purchase orders without manual review.

    • Allow COD: This toggle permits cash on delivery as a payment option.

    • Auto Approve COD: This toggle automatically approves cash on delivery transactions.

    • Allow Quote Request: This toggle allows customers to request quotes during checkout.

    • Allow Drop Shipping: This toggle enables the option for drop shipping in the checkout process.

    • Min Subtotal: This field sets the minimum subtotal amount required for an order.

    • Min Item Count: This field specifies the minimum number of items required for an order.

    • Max Item Count: This field sets the maximum number of items allowed in an order.

    • Qualifies for Dealer Tier ****: This toggle indicates eligibility for the configured pricing tier(s).
      *Each configured pricing tier will appear here.

    • Credit Cards on File section: Credit Cards: This field displays or allows the management of credit card information on file for transactions.

Shipping

Shipping Address Books and Shipping options:

  • Shipping Address Book for

    • Address: This field is used to enter the physical shipping address.

    • Name: This field captures the name of the individual or entity associated with the shipping address.

    • Company: This field is for entering the company name related to the shipping address.

    • Address: This field provides a secondary line for additional shipping address details if needed.

    • Day Phone: This field records the daytime contact phone number for the shipping entity.

  • Shipping Options

    • Free Shipping: This toggle enables or disables free shipping for the customer.

    • No Free Shipping: This toggle prevents free shipping from being applied to the customer's orders.

    • Exempt from Handling Charges: This toggle exempts the customer from additional handling fees.

    • Allow 3rd Party Billing: This toggle permits third-party billing for shipping costs.

    • Do not send physical marketing mail to customer: This toggle prevents the sending of physical marketing materials to the customer.

Accounting / Tracking

QuickBooks, Affiliate and Sales Rep assignment, and Loyalty / Cashback ledger:

  1. Quickbooks

    • Quickbooks Code: This field is used to enter a specific code for integration with QuickBooks accounting software.

    • Quickbooks Class: This field allows selection of a class category for QuickBooks tracking.

    • Terms: This field specifies the payment terms associated with the account in QuickBooks.

    • Quickbooks Tax Exemption Reason Code: This field allows selection of a tax exemption reason code for QuickBooks.

    • Track Separately in Quickbooks: This toggle determines if transactions should be tracked separately in QuickBooks.

  2. Conditional Options

    • Associated With Affiliate: This field allows selection of an affiliate associated with the account.

    • Sales Rep. Code: This field is for entering a sales representative code.

  3. Loyalty - Cash Back

    • Available: This field displays the amount of available cash back credits.

    • Vesting: This field shows the amount of cash back credits that are vesting.

    • Total: This field indicates the total cash back credits.

    • Expiring: This field shows the amount of cash back credits that are expiring.

  4. Past Ledger

    • Show entries: This field allows selection of the number of past ledger entries to display.

    • Description: This field provides a description of each ledger entry.

    • Cash: This field records the cash amount associated with each ledger entry.

    • Order: This field links the ledger entry to a specific order.

    • Date: This field indicates the date of each ledger entry.

  5. Future Ledger

    • No Future Ledger Entries: This section indicates the absence of future ledger entries.

  6. New Ledger Entry

    • Description: This field is used to enter a description for a new ledger entry.

    • Amount: This field specifies the amount for the new ledger entry.

    • Days Until Expiration: This field sets the number of days until the credit expires, with an option for no expiration.

    • Days Until Vested: This field sets the number of days until the credit is vested, using a merchant-configured default if left empty.

    • Add Ledger Entry: This button submits the new ledger entry.

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.

  • Taxes

    • Tax ID Number: This field is used to enter the customer's tax identification number for tax reporting purposes.

    • Avalara Entity Use Code: This field allows entry of a specific code used by Avalara to determine tax applicability based on the entity's use.

    • Avalara Customer Code: This field is for entering a unique customer code for integration with Avalara tax services.

    • TaxJar Customer Code: This field is used to input a customer code specific to TaxJar for tax management.

    • Tax Exempt: This toggle indicates whether the customer is exempt from paying taxes.

    • TaxJar Exemption Type: This field allows selection of a specific exemption type for TaxJar tax processing.

Software

If applicable, Software Entitlements are viewable here. 

Activity

View the shopping and sales activity captured by UltraCart Analytics. 

  • Activity for <customer profile>

    • All Types: This dropdown allows filtering of activity types (e.g., active on website, placed order, initiated checkout).

    • Active on website for [time]: This field records the duration of the customer's active time on the website.

    • Placed order: This field logs the placement of an order with an associated order number.

    • Initiated checkout: This field indicates when the customer began the checkout process.

  • Metrics

    • Previous 30 Days: This column displays metric data for the previous 30-day period.

    • 30 Days: This column shows metric data for the current 30-day period.

    • All-Time: This column provides metric data accumulated over all time.

    • Email Delivery: This field tracks the number of email deliveries.

    • Email Open: This field records the number of times emails were opened.

    • View: This field counts the number of product views.

    • Initiate: This field logs the number of initiated actions.

    • Ordered Product: This field tracks the number of ordered products.

    • Shipment: This field records the number of shipments.

    • Placed Order: This field shows the total value of placed orders.

  • Lists & Segments

    • Lists & Segments customer is included in: This field displays the lists or segments the customer is part of.

    • Mailing List: This toggle indicates if the customer is included in a mailing list.

    • People that have BONE: This section lists specific customer segments, such as those with a particular attribute (e.g., BONE).

  • Information

    • First Active: This field records the date and time of the customer's first activity.

    • Last Active: This field shows the date and time of the customer's most recent activity.

    • Custom Properties: This field contains additional custom properties associated with the customer (if any).

    • How They Found You: This field indicates the source through which the customer found the website.

    • First Page: This field records the first page visited by the customer.

    • Referrer: This field shows the referring URL that directed the customer to the website.

    • Most Recent Visit: This field logs the most recent page visited by the customer.

    • First Page: This field again records the first page visited (possibly a duplicate or context-specific entry).

    • Global Unsubscribed: This toggle indicates if the customer has globally unsubscribed from communications.

    • Value: This field shows the value associated with the customer's subscription status (if applicable).

    • Spam Complaint: This field indicates if the customer has filed a spam complaint.

    • Value: This field shows the value associated with the spam complaint status (if applicable).

 

 

Pricing Tiers

In this section a merchant can create pricing tiers for volume (discount) pricing. Typically pricing tiers are created when a merchant is selling B2B in some fashion.

Think of a pricing tier as a group that someone belongs to such as (Reseller, Wholesaler, Distributor, etc.).

Related: Pricing Tier Configuration

Send Password Notice

The "Send Password Notice" allows for the configuration of an email template to be used in conjunction with mass updating of customer profile passwords. This may be used, for example, after importing customer profiles from an external system.

Settings

This is the page where you can Enable and/or Require Customer Profiles at the checkout process. The Settings page also allows for the configuration of the "My Account" customer portal.  Other features are:

  • wholesale (pricing tier) sign up 

  • assignment of override URLs to the wholesale signup

  • login in links.

Related: Configuration - Customer Profiles

 

Frequently Asked Questions

Question: Is there a way to see/extract the DTS when a customer profile was imported?

Answer: Yes. The 'Signup Date' column in the Customer Profile Export represents either the date the customer created their customer profile or their customer profiles was created via a customer profile Import.

Question: I need to assign a pricing tier to a customer profile. In which tab of the customer profile editor is the Pricing Tier(s) assignment configured?

Answer: The Billing tab of the customer profile editor contains the Pricing Tier assignment.

Related Documentation

Customer Profile Tutorial

Configuration - Customer Profiles