Difference between revisions of "Customer Database"
| (3 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 | + | '''<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. |
| − | '''Expired Credit Cards Report:''' Display all credit cards that are expired for any customer within the Customer Database. | + | |
| + | '''<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.