Difference between revisions of "Customer Database"

From KB
Jump to: navigation, search
 
(5 intermediate revisions by one other user not shown)
Line 3: Line 3:
 
<u>'''Actions:'''</u>
 
<u>'''Actions:'''</u>
  
'''Add Customer:''' You may create a new customer and assign a <u>Customer #</u>. You may input the billing and shipping data: ''First Name'', ''Last Name'', ''Company Name'', ''Address'', ''City'', ''State'', ''Zip Code'', ''Country'', ''Phone'', ''Fax'' and/or ''Email''.
+
'''<span style="color:#191970">Add Customer:''' You may create a new customer and assign a <u>Customer #</u>. You may input the billing and shipping data: ''First Name'', ''Last Name'', ''Company Name'', ''Address'', ''City'', ''State'', ''Zip Code'', ''Country'', ''Phone'', ''Fax'' and/or ''Email''.
 
*Once customer is added, it will display within the customer database and in the Customer Profiles of [[Web Terminal]].
 
*Once customer is added, it will display within the customer database and in the Customer Profiles of [[Web Terminal]].
  
''Import Setup:'' You may choose to import customers into the customer database from a CSV spreadsheet or comma delimited text file. You will use import setup to match the relevant columns on your spreadsheet. Use Skip to bypass a field.
 
  
'''Import Customers:''' Once you have configured your <u>Import Setup</u>, browse for the CSV spreadsheet or comma delimited text file and Submit.
+
'''<span style="color:#191970">Import Setup:''' You may choose to import customers into the customer database from a CSV spreadsheet or comma delimited text file. You will use import setup to match the relevant columns on your spreadsheet. Use Skip to bypass a field.
  
'''Export Customers:''' You are able to export your customer database into a comma delimited text file. This can easily be converted into an excel spreadsheet by adding ".csv" to the end of the file name. (e.g, "Testexport.csv)
 
  
'''Credit Cards Report:'''
+
'''<span style="color:#191970">Import Customers:''' Once you have configured your <u>Import Setup</u>, browse for the CSV spreadsheet or comma delimited text file and Submit.
 +
 
 +
 
 +
'''<span style="color:#191970">Export Customers:''' You are able to export your customer database into a comma delimited text file. This can easily be converted into an excel spreadsheet by adding ".csv" to the end of the file name. (e.g, "Testexport.csv")
 +
 
 +
 
 +
'''<span style="color:#191970">Credit Cards Report:''' Displays all credit cards for all customers within the Customer Database. You can filter your search to by credit card expiration date (MMYY).
 +
 
 +
 
 +
'''<span style="color:#191970">Expired Credit Cards Report:''' Display all credit cards that are expired for any customer within the Customer Database.

Latest revision as of 12:26, 31 March 2020

Search Criteria: You may filter your search for an existing customer by Customer #, Company Name and Phone No.

Actions:

Add Customer: You may create a new customer and assign a Customer #. You may input the billing and shipping data: First Name, Last Name, Company Name, Address, City, State, Zip Code, Country, Phone, Fax and/or Email.

  • Once customer is added, it will display within the customer database and in the Customer Profiles of Web Terminal.


Import Setup: You may choose to import customers into the customer database from a CSV spreadsheet or comma delimited text file. You will use import setup to match the relevant columns on your spreadsheet. Use Skip to bypass a field.


Import Customers: Once you have configured your Import Setup, browse for the CSV spreadsheet or comma delimited text file and Submit.


Export Customers: You are able to export your customer database into a comma delimited text file. This can easily be converted into an excel spreadsheet by adding ".csv" to the end of the file name. (e.g, "Testexport.csv")


Credit Cards Report: Displays all credit cards for all customers within the Customer Database. You can filter your search to by credit card expiration date (MMYY).


Expired Credit Cards Report: Display all credit cards that are expired for any customer within the Customer Database.