{"id":75,"date":"2010-07-14T07:36:41","date_gmt":"2010-07-14T11:36:41","guid":{"rendered":"http:\/\/www.amixa.com\/blog\/?p=75"},"modified":"2010-07-14T07:38:14","modified_gmt":"2010-07-14T11:38:14","slug":"aspdotnetstorefront-excel-import-error-ignoring-badduplicate-categoryref","status":"publish","type":"post","link":"https:\/\/www.amixa.com\/blog\/2010\/07\/14\/aspdotnetstorefront-excel-import-error-ignoring-badduplicate-categoryref\/","title":{"rendered":"ASPDOTNETSTOREFRONT Excel Import error Ignoring bad\/duplicate CategoryRef"},"content":{"rendered":"<p>If you are trying to do a bulk product import into ASPDNSF and come across the following error <\/p>\n<p>Ignoring bad\/duplicate CategoryRef, Name=<\/p>\n<p>This is usually solved in one of two ways.<\/p>\n<p>First, you have a malformed XPATH (category) field.  The proper syntax is \/category name 1\/category name 2\/subcategory name 1<\/p>\n<p>for example, \/Sports\/All types of balls\/Basketballs<\/p>\n<p>NOTE:  You do not need to manually create the categories in the admin interface.  If you&#8217;ve formed the categories properly as above, the system will auto-create the categories during the import process.  This is a real timesaver.<\/p>\n<p>Second, this import error message can also be triggered if the &#8220;PRODUCT SKU&#8217;s&#8221; are duplicated in the import file.  Please check your import data carefully to ensure that you don&#8217;t have duplicate SKU numbers for the same category (or at all).  Good business practices dictate that you have a unique sku for each product.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are trying to do a bulk product import into ASPDNSF and come across the following error Ignoring bad\/duplicate CategoryRef, Name= This is usually solved in one of two ways. First, you have a malformed XPATH (category) field. The proper syntax is \/category name 1\/category name 2\/subcategory name 1 for example, \/Sports\/All types of balls\/Basketballs NOTE: You do not<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[102,26],"class_list":["post-75","post","type-post","status-publish","format-standard","hentry","category-aspdotnetstorefront","tag-aspdotnetstorefront","tag-e-commerce"],"_links":{"self":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":2,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":77,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions\/77"}],"wp:attachment":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}