{"id":39198,"date":"2025-09-21T07:56:36","date_gmt":"2025-09-21T07:56:36","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%b6%d8%b1%d9%8a%d8%a8%d8%a9-%d8%a7%d9%84%d9%85%d9%86%d8%aa%d8%ac%d8%a7%d8%aa\/"},"modified":"2025-11-26T12:19:54","modified_gmt":"2025-11-26T12:19:54","slug":"how-to-update-product-tax","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/","title":{"rendered":"How to Update Product Tax"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]<\/p>\n

The system enables you to update all products at once, which helps you quickly adjust tax data without having to update each product individually. This guide walks you through the detailed steps to perform the update easily.<\/span><\/p>\n

[\/vc_column_text][vc_empty_space height=”64″ css=”.vc_custom_1677491013241{margin-left: 120px !important;}”][vc_custom_heading text=”Download a Backup of Products” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759063578123{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text]<\/p>\n

First, go to \u201cSettings\u201d<\/strong> from the main menu, then open \u201cAccount Information.\u201d<\/strong> Click the \u201cDownload Backup\u201d<\/strong> button.<\/span><\/p>\n

\"\"<\/span><\/a><\/p>\n

Next, check the box of Products<\/strong>. Choose the required branch and click \u201cDownload.\u201d<\/strong> An Excel file containing all products will be downloaded.<\/span><\/p>\n

\"\"<\/a>[\/vc_column_text][vc_custom_heading text=”Prepare the File in Google Sheets” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759063772059{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text]<\/p>\n

Open Google Sheets<\/strong>, then use \u201cImport\u201d<\/strong> to upload the Excel file you downloaded.<\/p>\n

\"\"<\/span><\/a><\/p>\n

Once the file is open, delete all columns except for the \u201cProduct\u201d<\/strong> column. Then create a new column named \u201cTax\u201d<\/strong> to prepare it for entering tax data.<\/span><\/p>\n

\"\"<\/a>[\/vc_column_text][vc_custom_heading text=”Add the Tax Data” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759063930839{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text]<\/p>\n

Go back to \u201cSettings\u201d<\/strong> and select \u201cTax Settings\u201d<\/strong>. Copy the name of the tax you want to apply.<\/span><\/p>\n

\"\"<\/span><\/a><\/p>\n

Return to Google Sheets<\/strong> and paste the tax name into the new “Tax”<\/strong> column you created.<\/span><\/p>\n

\"\"<\/span><\/a><\/p>\n

When finished, go to the \u201cFile\u201d<\/strong> menu, select \u201cDownload\u201d<\/strong>, and save the file as Comma Separated Values (.csv)<\/strong> so it\u2019s ready for import.<\/span><\/p>\n

\"\"<\/a>[\/vc_column_text][vc_custom_heading text=”Import the Updated File into the System” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759064217730{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text]<\/p>\n

From the main menu, go to \u201cInventory\u201d<\/strong>, choose \u201cProducts & Services\u201d<\/strong>, then click \u201cImport\u201d<\/strong>.<\/span><\/p>\n

\"\"<\/span><\/a><\/p>\n

Click \u201cChoose File\u201d<\/strong> and upload the CSV file you saved from Google Sheets<\/strong>. Select the \u201cComma Separated\u201d<\/strong> option, then click \u201cNext Step\u201d<\/strong>.<\/p>\n

\"\" <\/span><\/a><\/p>\n

On the Fields Mapping<\/strong> screen, map name to the Name<\/strong> field, and map Tax to the Tax 1<\/strong> field.<\/span><\/p>\n

\"\"<\/a><\/p>\n

Next, enable the option \u201cUpdate an existing Product with new data\u201d<\/strong> and set “Name”<\/strong> as the primary key for the update. Finally, click \u201cImport\u201d<\/strong> to complete the process.<\/span><\/p>\n

\"\"<\/a>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":29,"template":"","categories":[],"tags":[],"class_list":["post-39198","user_manual","type-user_manual","status-publish","hentry"],"yoast_head":"\nHow to Update Product Tax - 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-product-tax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Update Product Tax - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text] The system enables you to update all products at once, which helps you quickly adjust tax data without having to update each product individually. This guide walks you through the detailed steps to perform the update easily. [\/vc_column_text][vc_empty_space height=”64″ css=”.vc_custom_1677491013241{margin-left: 120px !important;}”][vc_custom_heading text=”Download a Backup of Products” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759063578123{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-26T12:19:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.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=\"2 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-product-tax\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.png\",\"width\":845,\"height\":391},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/\",\"name\":\"How to Update Product Tax - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#primaryimage\"},\"datePublished\":\"2025-09-21T07:56:36+00:00\",\"dateModified\":\"2025-11-26T12:19:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Update Product Tax\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Update Product Tax - 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-product-tax\/","og_locale":"en_US","og_type":"article","og_title":"How to Update Product Tax - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text] The system enables you to update all products at once, which helps you quickly adjust tax data without having to update each product individually. This guide walks you through the detailed steps to perform the update easily. [\/vc_column_text][vc_empty_space height=”64″ css=”.vc_custom_1677491013241{margin-left: 120px !important;}”][vc_custom_heading text=”Download a Backup of Products” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1759063578123{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: […]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2025-11-26T12:19:54+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 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-product-tax\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/09\/Screenshot-2025-09-28-140026-1.png","width":845,"height":391},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/","name":"How to Update Product Tax - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#primaryimage"},"datePublished":"2025-09-21T07:56:36+00:00","dateModified":"2025-11-26T12:19:54+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/how-to-update-product-tax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to Update Product Tax"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/39198","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\/29"}],"version-history":[{"count":4,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/39198\/revisions"}],"predecessor-version":[{"id":40885,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/39198\/revisions\/40885"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=39198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=39198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=39198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}