Difference between revisions of "Customer Database"
(Created page with "'''Search Criteria:''' You may filter your search for an existing customer by ''Customer #'', ''Company Name'' and ''Phone No''.") |
|||
| (7 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
'''Search Criteria:''' You may filter your search for an existing customer by ''Customer #'', ''Company Name'' and ''Phone No''. | '''Search Criteria:''' You may filter your search for an existing customer by ''Customer #'', ''Company Name'' and ''Phone No''. | ||
| + | |||
| + | <u>'''Actions:'''</u> | ||
| + | |||
| + | '''<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]]. | ||
| + | |||
| + | |||
| + | '''<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. | ||
| + | |||
| + | |||
| + | '''<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.