{"id":8153,"date":"2023-09-12T07:10:52","date_gmt":"2023-09-12T07:10:52","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d8%ad%d8%af%d9%8a%d8%ab-%d8%ad%d9%82%d9%84-%d9%85%d9%86-%d8%ad%d9%82%d9%88%d9%84-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-%d8%a7%d9%84%d9%85%d9%86%d8%aa%d8%ac-%d8%b9\/"},"modified":"2025-12-24T08:44:28","modified_gmt":"2025-12-24T08:44:28","slug":"how-to-update-a-product-field-data-through-excel","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/","title":{"rendered":"How to update a Product Field Data through Excel"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1766565594021{margin-left: 200px !important;}&#8221;]Updating <span style=\"font-weight: 400;\">some of your product data on the system can be done in just a few minutes. In this article, we will learn how to modify product data for one or more products with practical illustrations.<\/span>[\/vc_column_text][vc_custom_heading text=&#8221;How to update the Data of a Product in the Regular Way&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1699353413635{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1766565731957{margin-left: 200px !important;}&#8221;]<span style=\"font-weight: 400;\">You can update any field of the data by editing each product&#8217;s information individually in the traditional way. Click on <\/span><b>&#8220;Products &amp; Services&#8221;<\/b><span style=\"font-weight: 400;\"> from the <\/span><b>&#8220;Inventory&#8221;<\/b><span style=\"font-weight: 400;\"> dropdown in the main menu, and click on the dots next to the product you want to update one of its details, then click on <\/span><b>&#8220;Edit&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-42903 size-full\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png\" alt=\"\" width=\"1536\" height=\"485\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png 1536w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-300x95.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-1024x323.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-768x243.png 768w\" sizes=\"auto, (max-width: 1536px) 100vw, 1536px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Change the information you wish to alter, let it be the product name, then click on the <\/span><b>&#8220;Update&#8221;<\/b><span style=\"font-weight: 400;\"> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8157 size-full\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26.png\" alt=\"\" width=\"1678\" height=\"703\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26.png 1678w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26-300x126.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26-1024x429.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26-768x322.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h27_26-1536x644.png 1536w\" sizes=\"auto, (max-width: 1678px) 100vw, 1678px\" \/>[\/vc_column_text][vc_custom_heading text=&#8221;How to update the Data of one or more Products through Excel&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1699353955614{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1766565863478{margin-left: 200px !important;}&#8221;]<span style=\"font-weight: 400;\">Edit the data you want to update in the Excel file for products, for instance, if you wanted to update the product name field, create a copy of the product file and change the product names as follows:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4779\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14.png\" alt=\"\" width=\"1839\" height=\"230\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14.png 1839w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14-300x38.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14-1024x128.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14-768x96.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/1-14-1536x192.png 1536w\" sizes=\"auto, (max-width: 1839px) 100vw, 1839px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4781\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13.png\" alt=\"\" width=\"1832\" height=\"337\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13.png 1832w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13-300x55.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13-1024x188.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13-768x141.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2-13-1536x283.png 1536w\" sizes=\"auto, (max-width: 1832px) 100vw, 1832px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Click on <\/span><b>&#8220;Products &amp; Services&#8221;<\/b><span style=\"font-weight: 400;\"> from the <\/span><b>&#8220;Inventory&#8221;<\/b><span style=\"font-weight: 400;\"> dropdown in the main menu. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then click on <\/span><b>&#8220;Import&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-42905 size-full\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Imports.png\" alt=\"\" width=\"1536\" height=\"592\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Imports.png 1536w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Imports-300x116.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Imports-1024x395.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Imports-768x296.png 768w\" sizes=\"auto, (max-width: 1536px) 100vw, 1536px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Upload the new Excel file containing the updated data, choose the <\/span><strong>&#8220;Semicolon Separated&#8221;<\/strong><span style=\"font-weight: 400;\"> format and click on the <\/span><b>&#8220;Next Step&#8221;<\/b><span style=\"font-weight: 400;\"> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8161 size-full\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h29_43.png\" alt=\"\" width=\"1259\" height=\"682\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h29_43.png 1259w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h29_43-300x163.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h29_43-1024x555.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h29_43-768x416.png 768w\" sizes=\"auto, (max-width: 1259px) 100vw, 1259px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Match the data from the Excel file containing the products with the corresponding fields in the system, and enable <\/span><b>&#8220;Update an existing product with new data&#8221;<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Select the field you wish to update by matching the new file data with the data previously uploaded to the system, for example, you can choose <\/span><b>&#8220;Product Code&#8221;<\/b><span style=\"font-weight: 400;\"> so that the data associated with each product&#8217;s code will be updated according to the updated Excel file, then click on the <\/span><b>&#8220;Import&#8221;<\/b><span style=\"font-weight: 400;\"> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8163 size-full\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h31_45.png\" alt=\"\" width=\"804\" height=\"642\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h31_45.png 804w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h31_45-300x240.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/2023-11-07_12h31_45-768x613.png 768w\" sizes=\"auto, (max-width: 804px) 100vw, 804px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">A message will appear indicating that the data has been successfully updated.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4791\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/7-7.png\" alt=\"\" width=\"675\" height=\"104\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/7-7.png 675w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/7-7-300x46.png 300w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[2177,2184],"tags":[],"class_list":["post-8153","user_manual","type-user_manual","status-publish","hentry","category-inventory","category-products-services"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to update a Product Field Data through Excel - Daftra Knowledge Base<\/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:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to update a Product Field Data through Excel - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1766565594021{margin-left: 200px !important;}&#8221;]Updating some of your product data on the system can be done in just a few minutes. In this article, we will learn how to modify product data for one or more products with practical illustrations.[\/vc_column_text][vc_custom_heading text=&#8221;How to update the Data of a Product in the Regular Way&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1699353413635{margin-left: 200px [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-24T08:44:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png\",\"width\":1536,\"height\":485},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/\",\"name\":\"How to update a Product Field Data through Excel - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#primaryimage\"},\"datePublished\":\"2023-09-12T07:10:52+00:00\",\"dateModified\":\"2025-12-24T08:44:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to update a Product Field Data through Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to update a Product Field Data through Excel - Daftra Knowledge Base","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:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to update a Product Field Data through Excel - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1766565594021{margin-left: 200px !important;}&#8221;]Updating some of your product data on the system can be done in just a few minutes. In this article, we will learn how to modify product data for one or more products with practical illustrations.[\/vc_column_text][vc_custom_heading text=&#8221;How to update the Data of a Product in the Regular Way&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1699353413635{margin-left: 200px [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2025-12-24T08:44:28+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit.png","width":1536,"height":485},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/","name":"How to update a Product Field Data through Excel - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#primaryimage"},"datePublished":"2023-09-12T07:10:52+00:00","dateModified":"2025-12-24T08:44:28+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-a-product-field-data-through-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to update a Product Field Data through Excel"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/user_manual"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":5,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8153\/revisions"}],"predecessor-version":[{"id":42907,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8153\/revisions\/42907"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=8153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=8153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=8153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}