{"id":8165,"date":"2023-09-11T12:56:49","date_gmt":"2023-09-11T12:56:49","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/excel-%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d8%ad%d8%af%d9%8a%d8%ab-%d8%b3%d8%b9%d8%b1-%d8%a7%d9%84%d8%b4%d8%b1%d8%a7%d8%a1-%d9%88%d8%b3%d8%b9%d8%b1-%d8%a7%d9%84%d8%a8%d9%8a%d8%b9-%d9%84%d9%84%d9%85\/"},"modified":"2025-12-24T08:34:26","modified_gmt":"2025-12-24T08:34:26","slug":"how-to-update-the-selling-and-purchase-prices-of-items-through-excel","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/","title":{"rendered":"How to update the Selling and Purchase Prices of Items through Excel"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text css=”.vc_custom_1741520090536{margin-left: 200px !important;}”]Updating the selling or buying price, or both together, is a procedure that any commercial activity needs frequently. Therefore, the software provides you with simpler methods to update the selling and buying price for one or more products together in an easy and fast way.<\/span>[\/vc_column_text][vc_custom_heading text=”Updating the Selling or Purchase Price in the Regular Way” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1702295693387{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1766565072658{margin-left: 200px !important;}”]You can update the selling or buying field for each product individually in the regular way. Click on <\/span>“Products & Services”<\/b> from the <\/span>“Inventory”<\/b> dropdown in the main menu, then click on the dots next to the product you wish to update, and press <\/span>“Edit”<\/b>.<\/span><\/p>\n

\"\"<\/p>\n

Change the selling or buying price, or both, or adjust the profit margin percentage, then press the <\/span>“Update”<\/b> button.<\/span><\/p>\n

\"\"[\/vc_column_text][vc_message message_box_style=”3d” icon_fontawesome=”fas fa-book”]You can change the selling price by altering the profit margin for one or multiple products together, as explained here<\/a>.<\/span>[\/vc_message][vc_custom_heading text=”Updating the Selling and Purchase Price through Excel” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1699355508463{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css=”.vc_custom_1766565257203{margin-left: 200px !important;}”]Create a copy of your product data Excel file, adjust the selling and purchasing prices as desired, then save the file.<\/span><\/p>\n

\"\"<\/p>\n

Click on <\/span>“Products and Services”<\/b> which is under <\/span>“Inventory”<\/b> in the main menu. <\/span><\/p>\n

Then click on <\/span>“Import”<\/b>.<\/span><\/p>\n

\"\"<\/p>\n

Upload the new Excel file containing the updated selling and purchasing prices, select <\/span>“Semicolon Separated”<\/strong> and click on the <\/span>“Next Step”<\/b> button.<\/span><\/p>\n

\"\"<\/p>\n

Match the data in the Excel file containing the products with the same field data in the system, and activate <\/span>“Update existing products with new data”<\/b><\/p>\n

Choose the field which you wish to update the selling and purchasing prices by matching the new file data with the data previously uploaded to the system, for example, you can choose <\/span>“Product Code”<\/b> to update the selling and purchasing prices associated with each product code according to the updated Excel file data, then click on the <\/span>“Import”<\/b> button.<\/span><\/p>\n

\"\"<\/p>\n

A message will appear indicating the successful update of the data. <\/span><\/p>\n

\"\"[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[2177,2184],"tags":[],"class_list":["post-8165","user_manual","type-user_manual","status-publish","hentry","category-inventory","category-products-services"],"yoast_head":"\nHow to update the Selling and Purchase Prices of Items 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-the-selling-and-purchase-prices-of-items-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 the Selling and Purchase Prices of Items through Excel - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=”.vc_custom_1741520090536{margin-left: 200px !important;}”]Updating the selling or buying price, or both together, is a procedure that any commercial activity needs frequently. Therefore, the software provides you with simpler methods to update the selling and buying price for one or more products together in an easy and fast way.[\/vc_column_text][vc_custom_heading text=”Updating the Selling or Purchase Price in […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-24T08:34:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.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=\"3 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-the-selling-and-purchase-prices-of-items-through-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.png\",\"width\":1536,\"height\":587},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/\",\"name\":\"How to update the Selling and Purchase Prices of Items through Excel - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#primaryimage\"},\"datePublished\":\"2023-09-11T12:56:49+00:00\",\"dateModified\":\"2025-12-24T08:34:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to update the Selling and Purchase Prices of Items through Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to update the Selling and Purchase Prices of Items 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-the-selling-and-purchase-prices-of-items-through-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to update the Selling and Purchase Prices of Items through Excel - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=”.vc_custom_1741520090536{margin-left: 200px !important;}”]Updating the selling or buying price, or both together, is a procedure that any commercial activity needs frequently. Therefore, the software provides you with simpler methods to update the selling and buying price for one or more products together in an easy and fast way.[\/vc_column_text][vc_custom_heading text=”Updating the Selling or Purchase Price in […]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2025-12-24T08:34:26+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 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-the-selling-and-purchase-prices-of-items-through-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/09\/Edit-Product-or-Service.png","width":1536,"height":587},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/","name":"How to update the Selling and Purchase Prices of Items through Excel - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#primaryimage"},"datePublished":"2023-09-11T12:56:49+00:00","dateModified":"2025-12-24T08:34:26+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-the-selling-and-purchase-prices-of-items-through-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to update the Selling and Purchase Prices of Items through Excel"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8165","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":7,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8165\/revisions"}],"predecessor-version":[{"id":42897,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/8165\/revisions\/42897"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=8165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=8165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=8165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}