{"id":158569,"date":"2026-11-08T10:15:57","date_gmt":"2026-11-08T10:15:57","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/import-sales-and-sales-cost-accounts-products\/"},"modified":"2026-11-16T09:34:47","modified_gmt":"2026-11-16T09:34:47","slug":"import-sales-and-sales-cost-accounts-products","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/","title":{"rendered":"Importing Sales Account and Sales Cost Account for Products"},"content":{"rendered":"<div dir=\"ltr\" lang=\"en\">\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The product import and export file now includes the <strong style=\"color: #111827;\">Sales Account<\/strong> and <strong style=\"color: #111827;\">Sales Cost Account<\/strong> columns, so you can set Accounts Routing for hundreds of products at once instead of setting each product individually. This works for both adding and updating products.<\/p>\n<div style=\"background: #f6f8fb; border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px; font-size: 15px; line-height: 1.8;\">\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">Required Permissions<\/span><span style=\"color: #1f2430;\">The permission to import and add products, and Apply Accounting enabled.<\/span><\/div>\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">How to Access<\/span><span style=\"color: #1f2430;\"><a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/products\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Products<\/strong><\/a> &gt; <strong style=\"color: #111827;\">Import<\/strong> (<a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/products\/import\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Import Products<\/strong><\/a>)<\/span><\/div>\n<\/div>\n<div style=\"border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px;\">\n<p style=\"margin: 0 0 6px; font-weight: bold; color: #111827;\">Article Contents<\/p>\n<ol style=\"margin: 0; padding-left: 22px;\">\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#condition\"><strong style=\"color: #1a56db;\">Condition for the Two Columns to Appear<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#values\"><strong style=\"color: #1a56db;\">Accepted Cell Values<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#update\"><strong style=\"color: #1a56db;\">When Updating Existing Products<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#export\"><strong style=\"color: #1a56db;\">Export<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#steps\"><strong style=\"color: #1a56db;\">Quick Steps<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#after\"><strong style=\"color: #1a56db;\">What Happens After the Import?<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#trouble\"><strong style=\"color: #1a56db;\">Why Isn&#8217;t It Working as I Expect?<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#errors\"><strong style=\"color: #1a56db;\">Error Messages and Solutions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#faq\"><strong style=\"color: #1a56db;\">Frequently Asked Questions<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"condition\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Condition for the Two Columns to Appear<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The Routing Type of <strong style=\"color: #111827;\">Product Sales Account<\/strong> must be <strong style=\"color: #111827;\">Specify per Each<\/strong> in <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/settings\/accounts_routing\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Accounts Routing<\/strong><\/a> (Sales section).<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">If it is set to <strong style=\"color: #111827;\">Without Routing<\/strong>, the two columns do not appear in the column validation, the example file, or the export.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A special example file that contains the two columns is available when the condition is met.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Location of the two columns: after the Taxes columns and immediately before Category.<\/li>\n<\/ul>\n<h2 id=\"values\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Accepted Cell Values<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Value<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Result<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Account Number (Code)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The account with that number is linked<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The exact Account Name<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">It is linked if no two accounts have the same name<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">\u201cNumber \u2013 Name\u201d as exported by the system<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">It is linked by the number<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Empty cell<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The product&#8217;s current account stays unchanged<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">\u2013 (a dash only)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The account set for the product is deleted<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-left: 4px solid #1a56db; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p><span style=\"flex: 0 0 auto; font-size: 18px; line-height: 1.6;\">\ud83d\udec8<\/span><\/p>\n<p style=\"margin: 0; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Note:<\/strong> The account must be a visible Sub-Account that is not on hold. A Main Account, a hidden account, an account on hold, or a name shared by more than one account is treated as an error.<\/p>\n<\/div>\n<h2 id=\"update\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">When Updating Existing Products<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The values in the file replace the product&#8217;s current accounts.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The two columns are not fields used to match products for the update.<\/li>\n<\/ul>\n<h2 id=\"export\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Export<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The two columns are exported in the \u201cNumber \u2013 Name\u201d format, so you can re-import the file as it is.<\/li>\n<\/ul>\n<h2 id=\"steps\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Quick Steps<\/h2>\n<ol style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Set <strong style=\"color: #111827;\">Product Sales Account<\/strong> to <strong style=\"color: #111827;\">Specify per Each<\/strong> in <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/settings\/accounts_routing\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Accounts Routing<\/strong><\/a>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Open <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/products\/import\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Import Products<\/strong><\/a> and download the example file.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Fill in the two columns, then upload the file and match the columns.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Review the results list.<\/li>\n<\/ol>\n<h2 id=\"after\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">What Happens After the Import?<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The Sales Account and the Sales Cost Account are saved for each product, just as in the Edit Product screen.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">New Sales Invoices for these products are posted to the specified accounts.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Previous Invoices do not change.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A row with an error is not created, its product is not updated, and none of its accounts are partially saved.<\/li>\n<\/ul>\n<h2 id=\"trouble\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Why Isn&#8217;t It Working as I Expect?<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Problem<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Reason<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Solution<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The two columns are missing<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The routing is not <strong style=\"color: #111827;\">Specify per Each<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Change it<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">An error message appears even though the name is correct<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The name is duplicated, or the account is hidden or on hold<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Use the number<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The account did not change<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The cell is empty<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Enter the value<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The account was deleted<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The cell contains \u2013<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Enter the account<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"errors\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Error Messages and Solutions<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Message<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Reason<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Solution<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">The Sales Account is invalid in row number %s. Please make sure you select an existing Sub-Account.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A value that does not exist, or a Main Account, hidden account, account on hold, or duplicated name.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Use the number of an active Sub-Account.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">The Sales Cost Account is invalid in row number %s. Please make sure you select an existing Sub-Account.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The same reasons, for the Cost of Sales column.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Correct the cell.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">To use the delete symbol, the dash (-) must be the only character in the cell<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You entered a dash together with other text.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Enter \u2013 on its own.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"faq\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Frequently Asked Questions<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does the whole file fail if I make a mistake in one account?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, only that row fails, and the product in it is not created or updated.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why don&#8217;t I see the two columns?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The Routing Type is not <strong style=\"color: #111827;\">Specify per Each<\/strong>, or Apply Accounting is not enabled.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">How do I remove a product&#8217;s account through the import?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Enter \u2013 in the cell.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does an empty cell clear the account?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, you leave it as it is.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does the name accept any language?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The name is accepted exactly as it is recorded in the Chart of Accounts.<\/p>\n<\/div>\n","protected":false},"author":38,"featured_media":0,"template":"","categories":[2177,2184],"tags":[23922,30772,30773,11448,30770,18772,30771,19745,30652],"class_list":["post-158569","tutorial","type-tutorial","status-publish","hentry","category-inventory","category-products-services","tag-account-mapping","tag-assign-individually","tag-cost-of-goods-sold-account","tag-import","tag-import-product-sales-account-and-cost-of-goods-sold-account","tag-import-products","tag-no-account-mapping","tag-product-sales-account","tag-sales-account"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing Sales Account and Sales Cost Account for Products - 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\/tutorial\/import-sales-and-sales-cost-accounts-products\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Sales Account and Sales Cost Account for Products - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"The product import and export file now includes the Sales Account and Sales Cost Account columns, so you can set Accounts Routing for hundreds of products at once instead of setting each product individually. This works for both adding and updating products. Required PermissionsThe permission to import and add products, and Apply Accounting enabled. How [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-16T09:34:47+00:00\" \/>\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\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/\",\"name\":\"Importing Sales Account and Sales Cost Account for Products - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\"},\"datePublished\":\"2026-11-08T10:15:57+00:00\",\"dateModified\":\"2026-11-16T09:34:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Sales Account and Sales Cost Account for Products\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Sales Account and Sales Cost Account for Products - 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\/tutorial\/import-sales-and-sales-cost-accounts-products\/","og_locale":"en_US","og_type":"article","og_title":"Importing Sales Account and Sales Cost Account for Products - Daftra Knowledge Base","og_description":"The product import and export file now includes the Sales Account and Sales Cost Account columns, so you can set Accounts Routing for hundreds of products at once instead of setting each product individually. This works for both adding and updating products. Required PermissionsThe permission to import and add products, and Apply Accounting enabled. How [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-16T09:34:47+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/en\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/en\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/en\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/en\/#website","url":"https:\/\/docs.daftra.com\/en\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/","name":"Importing Sales Account and Sales Cost Account for Products - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/en\/#website"},"datePublished":"2026-11-08T10:15:57+00:00","dateModified":"2026-11-16T09:34:47+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/import-sales-and-sales-cost-accounts-products\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing Sales Account and Sales Cost Account for Products"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/38"}],"version-history":[{"count":2,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158569\/revisions"}],"predecessor-version":[{"id":158571,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158569\/revisions\/158571"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=158569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=158569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=158569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}