{"id":21030,"date":"2023-10-23T10:33:04","date_gmt":"2023-10-23T14:33:04","guid":{"rendered":"https:\/\/certek.com\/kb4\/?post_type=ht_kb&#038;p=21030"},"modified":"2023-10-23T10:33:04","modified_gmt":"2023-10-23T14:33:04","slug":"merging-duplicate-item-records","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/merging-duplicate-item-records\/","title":{"rendered":"Merging Duplicate Item Records"},"content":{"rendered":"\n<p>If you have duplicate item records, you can merge the records (while preserving both items&#8217; purchase history and quantity on hand). Follow the steps in this article to learn how.<\/p>\n<p>In this example, we have two item records, both called &#8220;Purple Cotton Dress,&#8221; but with different Item Codes.<\/p>\n<p><strong>ASP1:<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21033\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25.png\" alt=\"\" width=\"969\" height=\"614\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25.png 969w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25-300x190.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25-768x487.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_25-100x63.png 100w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/a><\/p>\n<p><strong>ASP2:<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21034\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39.png\" alt=\"\" width=\"972\" height=\"614\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39.png 972w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39-300x190.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39-768x485.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h13_39-100x63.png 100w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/a><\/p>\n<p>We&#8217;ve received five units each.<\/p>\n<p>We sold one of ASP1 on October 23, 10:14 AM, which leaves us with a quantity on hand of four.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21035\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10.png\" alt=\"\" width=\"982\" height=\"622\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10.png 982w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10-300x190.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10-768x486.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h15_10-100x63.png 100w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/a><\/p>\n<p>We sold one of ASP2 on October 23, 10:18, which also leaves us with a quantity on hand of four for this record.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21036\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29.png\" alt=\"\" width=\"977\" height=\"614\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29.png 977w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29-300x189.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29-768x483.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29-50x31.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h18_29-100x63.png 100w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/a><\/p>\n<p>We are going to merge ASP2 with our original item record, ASP1.<\/p>\n<p>To do so, we&#8217;ll copy the item code &#8220;<strong>ASP1<\/strong>&#8221; and paste it into the item code for &#8220;<strong>ASP2<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21037\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08.png\" alt=\"\" width=\"972\" height=\"619\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08.png 972w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08-300x191.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08-768x489.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_08-100x64.png 100w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/a><\/p>\n<p>Once we hit &#8220;<strong>Save<\/strong>,&#8221; Artisan will ask if we want to merge this record we&#8217;re currently on with the other record. Click &#8220;<strong>Yes<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21038\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51.png\" alt=\"\" width=\"971\" height=\"619\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51.png 971w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51-300x191.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51-768x490.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h22_51-100x64.png 100w\" sizes=\"auto, (max-width: 971px) 100vw, 971px\" \/><\/a><\/p>\n<p>Artisan will return to the &#8220;<strong>Item Records<\/strong>&#8221; screen. We&#8217;ll notice that item record ASP2 is gone. Our QOH has been updated to &#8220;carry over&#8221; the four from the ASP2 record.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21039\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58.png\" alt=\"\" width=\"961\" height=\"202\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58.png 961w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58-300x63.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58-768x161.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58-50x11.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58-60x13.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h23_58-100x21.png 100w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/p>\n<p>You&#8217;ll notice that other fields, like the &#8220;<strong>UPC<\/strong>&#8221; field, have been preserved to reflect the original record&#8217;s fields. ASP2&#8217;s UPC field was ASP2, but it is now ASP1 since this was the original record&#8217;s UPC code.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21041\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1.png\" alt=\"\" width=\"969\" height=\"615\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1.png 969w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1-300x190.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1-768x487.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h26_04-1-100x63.png 100w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/a><\/p>\n<p>Viewing the &#8220;<strong>Activity<\/strong>&#8221; tab, we&#8217;ll notice that our &#8220;<strong>Total # of Units Sold<\/strong>&#8221; reflects both the one item we sold using the original item record and the one item we sold using the duplicate record. Artisan also shows the five we received of ASP1 and ASP2, bringing that total to 10.<\/p>\n<p>Our &#8220;<strong>Receiving Log<\/strong>&#8221; is updated accurately as well.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21042\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24.png\" alt=\"\" width=\"959\" height=\"197\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24.png 959w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24-300x62.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24-768x158.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24-50x10.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24-60x12.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2023\/10\/2023-10-23_10h29_24-100x21.png 100w\" sizes=\"auto, (max-width: 959px) 100vw, 959px\" \/><\/a><\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have duplicate item records, you can merge the records (while preserving both items&#8217; purchase history and quantity on hand). Follow the steps in this article to learn how. In this example, we have two item records, both called &#8220;Purple Cotton Dress,&#8221; but with different Item Codes. ASP1: ASP2:&#8230;<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[324],"ht-kb-tag":[],"class_list":["post-21030","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-item-records"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/21030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=21030"}],"version-history":[{"count":1,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/21030\/revisions"}],"predecessor-version":[{"id":21043,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/21030\/revisions\/21043"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=21030"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=21030"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=21030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}