{"id":23851,"date":"2025-06-16T13:10:42","date_gmt":"2025-06-16T13:10:42","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/uncategorized\/import-export-product-category\/"},"modified":"2026-02-25T12:11:25","modified_gmt":"2026-02-25T12:11:25","slug":"how-to-import-export-product-category-in-odoo18","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/bharath-india\/how-to-import-export-product-category-in-odoo18\/","title":{"rendered":"How to Import &amp; Export Product Category in Odoo18"},"content":{"rendered":"<div class=\"epyt-video-wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_43274\"  width=\"800\" height=\"450\"  data-origwidth=\"800\" data-origheight=\"450\"  data-relstop=\"1\" src=\"https:\/\/www.youtube.com\/embed\/U9pvlAzIiuY?enablejsapi=1&autoplay=0&cc_load_policy=0&cc_lang_pref=&iv_load_policy=1&loop=0&rel=0&fs=1&playsinline=0&autohide=2&theme=dark&color=red&controls=1&disablekb=0&\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Managing product categories in bulk is essential for organising a large inventory. Odoo&#8217;s import\/export tool allows users to set up their category hierarchy and accounting properties quickly.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Accessing Categories:<\/strong> Navigate to <strong>Inventory &gt; Configuration &gt; Product Categories<\/strong> to see your current list.<\/li>\n\n\n\n<li><strong>Exporting Data:<\/strong> Select existing categories and use <strong>Action &gt; Export<\/strong> to download a CSV or Excel template for reference.<\/li>\n\n\n\n<li><strong>Hierarchy Mapping:<\/strong> When importing, ensure the &#8220;Parent Category&#8221; column is correctly mapped to create a nested structure (e.g., Electronics \/ Laptops).<\/li>\n\n\n\n<li><strong>Accounting Properties:<\/strong> You can bulk-update Income and Expense accounts for entire categories through the import file.<\/li>\n\n\n\n<li><strong>Inventory Valuation:<\/strong> Use the import tool to set the &#8220;Costing Method&#8221; (Standard, FIFO, AVCO) across multiple categories at once.<\/li>\n\n\n\n<li><strong>Importing New Categories:<\/strong> Use the <strong>Favorites &gt; Import Records<\/strong> button to upload your prepared file into Odoo.<\/li>\n\n\n\n<li><strong>Testing the Import:<\/strong> Always use the &#8220;Test&#8221; button in the import wizard to identify formatting errors before finalizing the upload.<\/li>\n\n\n\n<li><strong>Internal Reference\/ID:<\/strong> Use the External ID field during import to ensure you are updating existing records rather than creating duplicates.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Managing product categories in bulk is essential for organising a large inventory. Odoo&#8217;s import\/export tool allows users to set up [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[355],"tags":[],"class_list":["post-23851","post","type-post","status-publish","format-standard","hentry","category-bharath-india"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/23851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=23851"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/23851\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=23851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=23851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=23851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}