{"id":190,"date":"2022-11-14T13:11:09","date_gmt":"2022-11-14T13:11:09","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=190"},"modified":"2022-11-16T16:31:53","modified_gmt":"2022-11-16T16:31:53","slug":"matching-new-records-to-existing-customers","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/","title":{"rendered":"Matching New Records to Existing Customers"},"content":{"rendered":"<h2>Overview<\/h2>\n<ul>\n<li class=\"BulletedList\">When orders or customer records are <i>imported<\/i>\u00a0into\u00a0<span style=\"font-size: small;\">SEOM<\/span>, the system attempts to associate an existing customer record with the incoming order or customer information. This association is for purchasing history only and DOES NOT change any of the billing or shipping, name, or address information on the incoming\u00a0record as it is imported. This basic functionality is controlled by the setting of the Customer Search parameters. Manual Orders are not affected by the parameters in this topic.<\/li>\n<li class=\"BulletedList\">Unfortunately, mismatching can sometimes occur, particularly if a shopping cart doesn&#8217;t require a customer email address or phone number to be entered with each order. For example, if the email or phone field is left blank in an order, some carts may read that as &#8220;0,&#8221; and\u00a0<span style=\"font-size: small;\">SEOM<\/span> interprets all orders with &#8220;0&#8221; in the email or phone field as belonging to the same customer when in actuality, they do not. The orders are erroneously matched to the initial customer record that contains &#8220;0&#8221; in the email or phone fields.<\/li>\n<li class=\"BulletedList\">The program provides the Customer Match feature to avoid the potential mismatching of new orders to existing customer records and to allow you to update existing customer records with newer information. Through this feature, you specify additional criteria to determine if customer information matches an existing customer record. When this feature is enabled, the program pauses the import process when a potential customer match is found and allows you to determine how it should proceed.<\/li>\n<li class=\"BulletedList\">The customer matching information in this topic does not apply to Manual Orders, only to imported orders.<\/li>\n<\/ul>\n<h2>Configuring the Customer Search Parameters<\/h2>\n<ul>\n<li class=\"BulletedList\">The program automatically determines customer matches based on the criteria specified in the Customer Search parameters <i>unless<\/i>\u00a0the Customer Match feature is enabled. The program applies the Customer Search criteria in the ascending order of the parameters (CustomerSearchField1-4). For example, the value selected in\u00a0<strong>CustomerSearchField1\u00a0<\/strong>is checked first, and\u00a0<strong>CustomerSearchField4\u00a0<\/strong>is checked last.<\/li>\n<li class=\"BulletedList\">If the Customer Match feature is enabled, the program displays the\u00a0<i>Customer Match<\/i> screen\u00a0and allows you to decide the action to be taken. See the section\u00a0below\u00a0for more details.<\/li>\n<li class=\"BulletedList\">The following system parameters control how the program determines that customer information for incoming orders or customer records matches existing\u00a0<span style=\"font-size: small;\">SEOM<\/span>\u00a0customer records. They also control the order in which fields are searched to identify a match. These parameters are set via the\u00a0<i>Set System Parameters<\/i>\u00a0screen or via the third page of the\u00a0<i>Order Processing<\/i>\u00a0section of the\u00a0<i>Store Setup Wizard<\/i>.<\/li>\n<\/ul>\n<h3>CustomerSearchField1<\/h3>\n<ul>\n<li class=\"BulletedList\">The field specified by\u00a0<strong>CustomerSearchField1\u00a0<\/strong>is searched first. This field is required and cannot be set to &#8220;<strong>None<\/strong>.&#8221; The default setting of this parameter is &#8220;<strong>Email<\/strong>.&#8221;<\/li>\n<\/ul>\n<h3>CustomerSearchField2<\/h3>\n<ul>\n<li class=\"BulletedList\">If no match is found after searching\u00a0<strong>CustomerSearchField1<\/strong>, then the data specified in\u00a0<strong>CustomerSearchField2\u00a0<\/strong>will be searched unless the parameter is set to &#8220;None&#8221;. The default setting for <strong>CustomerSearchField2\u00a0<\/strong>is &#8220;<strong>Phone<\/strong>.&#8221; The new order is associated with that customer record if a match is found. <span style=\"color: black; font-size: small;\">Unless the shopping cart validates phone numbers, it is recommended that a different selection criterion is chosen to avoid potential customer matching problems. If a customer leaves the phone field blank, some carts may interpret that as &#8220;0&#8221; and include that value in the customer phone number on order. If multiple customers leave the phone field blank, then all new orders with &#8220;0&#8221; in the customer phone field will be erroneously matched to the first customer who left their phone number field blank.<\/span><\/li>\n<\/ul>\n<h3>CustomerSearchField3<\/h3>\n<ul>\n<li class=\"BulletedList\">If no match is found using the data specified in\u00a0<strong>CustomerSearchField2<\/strong>,\u00a0then the data specified in\u00a0<strong>CustomerSearchField3\u00a0<\/strong>is searched unless the parameter is set to &#8220;<strong>None<\/strong>&#8221; (the default setting). The order is associated with that customer record if a match is found.<\/li>\n<\/ul>\n<h3>CustomerSearchField4<\/h3>\n<ul>\n<li class=\"BulletedList\">If no match is found using the data specified in\u00a0<strong>CustomerSearchField3, <\/strong>then the data specified in\u00a0<strong>CustomerSearchField4\u00a0<\/strong>are searched unless it is set to &#8220;<strong>None<\/strong>&#8221; (the default setting). The order is associated with that customer record if a match is found.<\/li>\n<\/ul>\n<h3>Possible Parameter Settings for CustomerSearchField1 &#8211; 4<\/h3>\n<h4>Email<\/h4>\n<ul>\n<li class=\"BulletedList\">Search the billing customer&#8217;s email address.<\/li>\n<\/ul>\n<h4>Phone<\/h4>\n<ul>\n<li class=\"BulletedList\">Search the billing phone number exactly as it is entered by the customer.<\/li>\n<li class=\"BulletedList\">For example, if the phone number is stored in the record as (717) 555-1212, the program searches for &#8220;(717) 555-1212&#8221;, not &#8220;7175551212.&#8221;<\/li>\n<\/ul>\n<h4>Phone &#8211; No Formatting<\/h4>\n<ul>\n<li class=\"BulletedList\">All spacing and punctuation are removed from phone numbers.<\/li>\n<li class=\"BulletedList\">The first time this option is chosen for any customer search fields, the program warns you that it will build the search string for each customer record.<\/li>\n<li class=\"BulletedList\">The amount of time it takes to complete the process depends on the number of customer records in the system.<\/li>\n<li class=\"BulletedList\">The new search string is stored in a field called <strong>PhoneIndex.<\/strong><\/li>\n<\/ul>\n<h4>Web ID<\/h4>\n<ul>\n<li class=\"BulletedList\">Use the customer&#8217;s ID number from the website if the site provides one.<\/li>\n<\/ul>\n<h4>Name, Address, Zip<\/h4>\n<ul>\n<li class=\"BulletedList\">Use up to the first two letters of the first name, the full last name, the numeric value of the street address, the first word from the street address, and the 5-digit zip code of the customer billing information to produce a unique ID string for comparison.<\/li>\n<li class=\"BulletedList\">The first time this option is chosen for any of the customer search fields, the program warns you that it will build a search string for each customer record.<\/li>\n<li class=\"BulletedList\">The amount of time it takes to complete the process depends on the number of customer records in the system.<\/li>\n<li class=\"BulletedList\">The new search string is stored in a field called <strong>NameAddrIndex.<\/strong><\/li>\n<\/ul>\n<h4>None<\/h4>\n<ul>\n<li class=\"BulletedList\">Indicates that <strong>CustomerSearchField2<\/strong>, 3, or 4 are not used.<\/li>\n<li class=\"BulletedList\">This is not an option for <strong>CustomerSearchField1.<\/strong><\/li>\n<\/ul>\n<h3>Disclaimer<\/h3>\n<ul>\n<li class=\"BulletedList\">While using multiple customer search fields decreases the chances of duplication and mismatching customer records, it may still not totally eliminate the problem. The Customer Match feature provides the best level of protection in the prevention of matching errors in conjunction with the setting of the customer search fields.<\/li>\n<li class=\"BulletedList\">Be aware that using multiple customer search fields will degrade the performance of the customer record or order import process to some degree, depending on the number of fields that have been selected for searching.<\/li>\n<\/ul>\n<h2>Configuring the Customer Matching Feature<\/h2>\n<ul>\n<li class=\"BulletedList\">The parameters discussed in this section can be set on the third page of the <i>Order Processing<\/i> section of the Store Setup Wizard or by the\u00a0<i>Set System Parameters<\/i>\u00a0screen.<\/li>\n<\/ul>\n<h3>UseCustomerMatching<\/h3>\n<ul>\n<li class=\"BulletedList\">Set to TRUE to enable the Customer Match feature.<\/li>\n<\/ul>\n<h3>CustomerMatchCompanyCheck<\/h3>\n<ul>\n<li class=\"BulletedList\">Set this parameter to TRUE to use the Bill To: Company Name as part of the search criteria in addition to those specified in the CustomerSearchField1-4 parameters.<\/li>\n<\/ul>\n<h3>CustomerMatchConfirmEmails<\/h3>\n<ul>\n<li class=\"BulletedList\">Set this parameter to TRUE to have the Customer Match form appear when one of the customer search parameters is set to Email and a match is found based on the email address.<\/li>\n<\/ul>\n<h3>CustomerCustField1 &#8211; 2<\/h3>\n<ul>\n<li class=\"BulletedList\">Identify which custom, Customer fields are used to identify a match<\/li>\n<li class=\"BulletedList\">For example, if <strong>CustomerTextField1\u00a0<\/strong>contains data that should be used to identify a match, set the <strong>CustomerMatchCustField1\u00a0<\/strong>or\u00a0<strong>CustomerMatchCustField2<\/strong>\u00a0to\u00a0<strong>Text1.<\/strong><\/li>\n<\/ul>\n<h2>Description of the Customer Match Screen<\/h2>\n<ul>\n<li class=\"BulletedList\">When the Customer Match feature is enabled and the program finds one or more matching customer records during the course of importing orders or customer records, the\u00a0<i>Customer Match<\/i>\u00a0screen is displayed to allow you to decide the action to be taken.<\/li>\n<\/ul>\n<div>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1540\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4.jpg\" alt=\"\" width=\"625\" height=\"455\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4.jpg 625w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4-300x218.jpg 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4-50x36.jpg 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4-60x44.jpg 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4-100x73.jpg 100w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p><i>Customer Match screen<\/i><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<h3>One or more existing customers have been found matching the customer on the imported order<\/h3>\n<ul>\n<li class=\"BulletedList\">This field is only populated during order imports, and it contains the <span style=\"font-size: small;\">SEOM<\/span> order number.<\/li>\n<\/ul>\n<h3>Bill To information from New Order<\/h3>\n<ul>\n<li class=\"BulletedList\">Choose which fields of the existing <span style=\"font-size: small;\">SEOM<\/span> customer record will be updated with the new information found in the imported order or customer record.<\/li>\n<li class=\"BulletedList\">If the check box next to the Address information is checked, all related fields are updated, <strong>Address<\/strong>,\u00a0<strong>City<\/strong>,\u00a0<strong>State<\/strong>,\u00a0<strong>Zip\u00a0<\/strong>and\u00a0<strong>Country<\/strong>.<\/li>\n<\/ul>\n<h3>Update checked fields in selected customer record<\/h3>\n<ul>\n<li class=\"BulletedList\">The program can update the existing customer record with information from an incoming order or customer record.<\/li>\n<li class=\"BulletedList\">A note is written to the customer record indicating the changes made.<\/li>\n<\/ul>\n<h3>Check All Fields<\/h3>\n<ul>\n<li class=\"BulletedList\">Selects all of the check boxes next to the fields in the <strong>Bill To<\/strong> information from the <strong>New Order<\/strong> section.<\/li>\n<\/ul>\n<h3>Assign imported order to selected customer<\/h3>\n<ul>\n<li class=\"BulletedList\">Select this box to associate the incoming order with the existing customer record identified as a match.<\/li>\n<li class=\"BulletedList\">This field is not visible when customer records are imported.<\/li>\n<\/ul>\n<h3>Create a new customer record<\/h3>\n<ul>\n<li class=\"BulletedList\">Select this box to create a new customer record in <span style=\"font-size: small;\">SEOM<\/span> with the information contained in the incoming record.<\/li>\n<li class=\"BulletedList\">If the update is a result of an order import, the order is associated with the new customer record.<\/li>\n<\/ul>\n<h3>Do not import this customer (Order will still import)<\/h3>\n<ul>\n<li class=\"BulletedList\">No customer data is changed or added as a result of the imported order or customer record.<\/li>\n<\/ul>\n<h3>Existing Customer Information<\/h3>\n<ul>\n<li class=\"BulletedList\">Displays the information in the existing customer record which is identified as a match.<\/li>\n<\/ul>\n<h3>Show customers with matching:<\/h3>\n<ul>\n<li class=\"BulletedList\">The corresponding radio button is automatically selected if matching data is found in one of these fields in the incoming record.<\/li>\n<\/ul>\n<h3>Turn off customer matching for the remainder of this import<\/h3>\n<ul>\n<li class=\"BulletedList\">Temporarily disable the Customer Matching feature for the duration of the current import (customer or order).<\/li>\n<\/ul>\n<h3>Continue<\/h3>\n<ul>\n<li class=\"BulletedList\">Allow the import process to proceed after choosing the desired action or actions for the current order or customer record.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Overview When orders or customer records are imported\u00a0into\u00a0SEOM, the system attempts to associate an existing customer record with the incoming order or customer information. This association is for purchasing history only and DOES NOT change any of the billing or shipping, name, or address information on the incoming\u00a0record as it&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[89,19],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Matching New Records to Existing Customers - Stone Edge Order Manager<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Matching New Records to Existing Customers - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"Overview When orders or customer records are imported\u00a0into\u00a0SEOM, the system attempts to associate an existing customer record with the incoming order or customer information. This association is for purchasing history only and DOES NOT change any of the billing or shipping, name, or address information on the incoming\u00a0record as it...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-16T16:31:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/\",\"name\":\"Matching New Records to Existing Customers - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2022-11-14T13:11:09+00:00\",\"dateModified\":\"2022-11-16T16:31:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matching New Records to Existing Customers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Matching New Records to Existing Customers - Stone Edge Order Manager","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/","og_locale":"en_US","og_type":"article","og_title":"Matching New Records to Existing Customers - Stone Edge Order Manager","og_description":"Overview When orders or customer records are imported\u00a0into\u00a0SEOM, the system attempts to associate an existing customer record with the incoming order or customer information. This association is for purchasing history only and DOES NOT change any of the billing or shipping, name, or address information on the incoming\u00a0record as it...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2022-11-16T16:31:53+00:00","og_image":[{"url":"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/customermatchform-4.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/","url":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/","name":"Matching New Records to Existing Customers - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2022-11-14T13:11:09+00:00","dateModified":"2022-11-16T16:31:53+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/matching-new-records-to-existing-customers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Matching New Records to Existing Customers"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/190"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":9,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/190\/revisions"}],"predecessor-version":[{"id":2799,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/190\/revisions\/2799"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=190"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}