{"id":1219,"date":"2023-04-13T17:30:46","date_gmt":"2023-04-13T14:30:46","guid":{"rendered":"https:\/\/akaunting.com\/hc\/docs\/import-export\/importing-product-variants\/"},"modified":"2025-09-11T16:25:48","modified_gmt":"2025-09-11T13:25:48","slug":"importing-product-variants","status":"publish","type":"docs","link":"https:\/\/akaunting.com\/hc\/docs\/import-export\/importing-product-variants\/","title":{"rendered":"Importing Product Variants"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Akaunting makes it easy to import and manage your product variants in one place.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You need the <a href=\"https:\/\/akaunting.com\/apps\/inventory\" target=\"_blank\" rel=\"noreferrer noopener\">Inventory App<\/a> to add product variants and perform other Inventory management functions. See how to <code><a href=\"https:\/\/akaunting.com\/hc\/docs\/apps-and-integrations\/installing-an-app\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install<\/a><\/code> or <code><a href=\"https:\/\/akaunting.com\/hc\/docs\/apps-and-integrations\/purchasing-an-app\/\" target=\"_blank\" rel=\"noreferrer noopener\">Purchase<\/a><\/code> an app on Akaunting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Importing Product Variants:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Inventory<\/strong> on the <strong>Navigation menu<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"1080\" style=\"aspect-ratio: 1920 \/ 1080;\" width=\"1920\" controls src=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/13174115\/import-variants.mp4\"><\/video><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Variants <\/strong>from the expanded menu options.<\/li>\n\n\n\n<li>On the Variants page, click <strong>Import<\/strong> or the ellipses icon <img loading=\"lazy\" decoding=\"async\" width=\"25\" height=\"18\" class=\"wp-image-574\" style=\"width: 25px;\" src=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/06155359\/Screenshot-2023-04-06-at-15.52.49.png\" alt=\"ellipses menu icon\" srcset=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/06155359\/Screenshot-2023-04-06-at-15.52.49.png 52w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/06155359\/Screenshot-2023-04-06-at-15.52.49-50x38.png 50w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> at the top left corner.<\/li>\n\n\n\n<li>Select <strong>Import<\/strong> from the ellipses dropdown options.<\/li>\n\n\n\n<li>On the Import Variants page, <strong>Download<\/strong> the sample file and fill in the provided fields.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">On the <strong>Options<\/strong> tab, you can enter the following details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Name<\/strong>: Product variant name.<\/li>\n\n\n\n<li>Enabled: Enter <strong>TRUE<\/strong> to enable the Product variant.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"1024\" src=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173414\/image-12-1-599x1024.png\" alt=\"Importing Product Variants_Excel Options tab\" class=\"wp-image-1222\" srcset=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173414\/image-12-1-599x1024.png 599w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173414\/image-12-1-175x300.png 175w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173414\/image-12-1-768x1313.png 768w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173414\/image-12-1.png 786w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">On the <strong>Option Values <\/strong>tab, you can enter the following details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Option name<\/strong>: Size, Color, etc.<\/li>\n\n\n\n<li><strong>Name: <\/strong>L, XL, XXL, Red, Yellow, etc.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"1024\" src=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173519\/image-13-1-580x1024.png\" alt=\"Importing Product Variants_Excel Options value tab\" class=\"wp-image-1223\" srcset=\"https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173519\/image-13-1-580x1024.png 580w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173519\/image-13-1-170x300.png 170w, https:\/\/assets.akaunting.com\/hc\/2023\/04\/13173519\/image-13-1.png 764w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Save<\/strong> the file as <strong>XLS<\/strong> or <strong>XLSX<\/strong>.<\/li>\n\n\n\n<li>Upload your file to Akaunting.<\/li>\n\n\n\n<li>Click <strong>Import <\/strong>and wait for a few seconds. This may vary depending on the size of the data.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">You&#8217;ll get a notification on the sidebar notification icon. Also, a confirmation will be sent to your email once the upload is completed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Akaunting makes it easy to import and manage your product variants in one place. You need the Inventory App to add product variants and perform other Inventory management functions. See how to Install or Purchase an app on Akaunting. Importing Product Variants: On the Options tab, you can enter the following details: On the Option [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":13,"menu_order":10,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-1219","docs","type-docs","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/docs\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":4,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/docs\/1219\/revisions"}],"predecessor-version":[{"id":1573,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/docs\/1219\/revisions\/1573"}],"up":[{"embeddable":true,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/docs\/13"}],"wp:attachment":[{"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/akaunting.com\/hc\/wp-json\/wp\/v2\/doc_tag?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}