{"id":26851,"date":"2024-12-17T14:27:27","date_gmt":"2024-12-17T14:27:27","guid":{"rendered":"https:\/\/help.xodox.in\/?post_type=docs&p=26851"},"modified":"2024-12-17T14:27:27","modified_gmt":"2024-12-17T14:27:27","password":"","slug":"import-export-products","status":"publish","type":"docs","link":"https:\/\/help.xodox.in\/pt\/docs\/import-export-products\/","title":{"rendered":"Import\/Export Products"},"content":{"rendered":"
\n

Import Products:<\/span><\/h1>\n

Steps:<\/span><\/h2>\n
    \n
  1. Go to Products -> Import Products<\/li>\n
  2. Download the template file.<\/li>\n
  3. Fill all the information as per the displayed columns name & instructions. Don\u2019t remove the heading from template file.<\/li>\n
  4. Import the file<\/li>\n<\/ol>\n

    Common Errors:<\/span><\/h2>\n
      \n
    1. Error:<\/strong> UNIT not found
      \nSolution:<\/strong> Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again.<\/li>\n
    2. Error:<\/strong> The separation symbol could not be found the separation symbol could
      \nSolution:<\/strong> Format your cells in excel as text in your excel for the expiry date field and give the date as specified(11-25-2018).<\/li>\n<\/ol>\n

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

      Not well-defined error:<\/span><\/h3>\n

      Many times it can show some not well-defined errors like \u201cnon-numeric value encounter\u201d or others<\/p>\n

      In this case, the best way is to split your import into multiple files.<\/p>\n

      For example, if you\u2019re importing fil with 500 products, divide it into 2 files of 250 each and import it.<\/p>\n

      Export Products:<\/span><\/h1>\n

      The products can be exported in excel\/pdf formats from the list products screen.<\/p>\n

      In version 4.7.8, a new export feature is added to export the product in the same template as the import product template.<\/p>\n

      In the list products screen, click the download excel button.<\/p>\n

      \"\"<\/a><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

      Import Products: Steps: Go to Products -> Import Products Download the template file. Fill all the information as per the displayed columns name & instructions. Don\u2019t remove the heading from template file. Import the file Common Errors: Error: UNIT not found Solution: Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again. Error: The separation symbol could not be found the separation symbol could Solution: Format your cells in excel as text in your excel for the expiry date field and give the date as specified(11-25-2018). Not well-defined error: Many times it can show some not well-defined errors like \u201cnon-numeric value encounter\u201d or others In this case, the best way is to split your import into multiple files. For example, if you\u2019re importing fil with 500 products, divide it into 2 files of 250 each and import it. Export Products: The products can be exported in excel\/pdf formats from the list products screen. In version 4.7.8, a new export feature is added to export the product in the same template as the import product template. In the list products screen, click the download excel button.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[63],"doc_tag":[77],"class_list":["post-26851","docs","type-docs","status-publish","hentry","doc_category-pos-products","doc_tag-pos"],"acf":[],"year_month":"2026-07","word_count":207,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"help-xodox","author_nicename":"help-xodox","author_url":"https:\/\/help.xodox.in\/pt\/author\/help-xodox\/"},"doc_category_info":[{"term_name":"POS Products","term_url":"https:\/\/help.xodox.in\/pt\/docs-category\/pos-products\/"}],"doc_tag_info":[{"term_name":"pos","term_url":"https:\/\/help.xodox.in\/pt\/docs-tag\/pos\/"}],"yoast_head":"\nImport\/Export Products - My CMS<\/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:\/\/help.xodox.in\/pt\/docs\/import-export-products\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import\/Export Products - My CMS\" \/>\n<meta property=\"og:description\" content=\"Import Products: Steps: Go to Products -> Import Products Download the template file. Fill all the information as per the displayed columns name & instructions. Don\u2019t remove the heading from template file. Import the file Common Errors: Error: UNIT not found Solution: Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again. Error: The separation symbol could not be found the separation symbol could Solution: Format your cells in excel as text in your excel for the expiry date field and give the date as specified(11-25-2018). Not well-defined error: Many times it can show some not well-defined errors like \u201cnon-numeric value encounter\u201d or others In this case, the best way is to split your import into multiple files. For example, if you\u2019re importing fil with 500 products, divide it into 2 files of 250 each and import it. Export Products: The products can be exported in excel\/pdf formats from the list products screen. In version 4.7.8, a new export feature is added to export the product in the same template as the import product template. In the list products screen, click the download excel button.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.xodox.in\/pt\/docs\/import-export-products\/\" \/>\n<meta property=\"og:site_name\" content=\"My CMS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.xodox.in\/docs\/import-export-products\/\",\"url\":\"https:\/\/help.xodox.in\/docs\/import-export-products\/\",\"name\":\"Import\/Export Products - My CMS\",\"isPartOf\":{\"@id\":\"https:\/\/help.xodox.in\/#website\"},\"datePublished\":\"2024-12-17T14:27:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/help.xodox.in\/docs\/import-export-products\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.xodox.in\/docs\/import-export-products\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.xodox.in\/docs\/import-export-products\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.xodox.in\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import\/Export Products\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.xodox.in\/#website\",\"url\":\"https:\/\/help.xodox.in\/\",\"name\":\"My CMS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/help.xodox.in\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.xodox.in\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/help.xodox.in\/#organization\",\"name\":\"My CMS\",\"url\":\"https:\/\/help.xodox.in\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/help.xodox.in\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/help.xodox.in\/wp-content\/uploads\/2024\/10\/Xodox-Logo-01-2.png\",\"contentUrl\":\"https:\/\/help.xodox.in\/wp-content\/uploads\/2024\/10\/Xodox-Logo-01-2.png\",\"width\":573,\"height\":192,\"caption\":\"My CMS\"},\"image\":{\"@id\":\"https:\/\/help.xodox.in\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import\/Export Products - My CMS","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:\/\/help.xodox.in\/pt\/docs\/import-export-products\/","og_locale":"pt_PT","og_type":"article","og_title":"Import\/Export Products - My CMS","og_description":"Import Products: Steps: Go to Products -> Import Products Download the template file. Fill all the information as per the displayed columns name & instructions. Don\u2019t remove the heading from template file. Import the file Common Errors: Error: UNIT not found Solution: Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again. Error: The separation symbol could not be found the separation symbol could Solution: Format your cells in excel as text in your excel for the expiry date field and give the date as specified(11-25-2018). Not well-defined error: Many times it can show some not well-defined errors like \u201cnon-numeric value encounter\u201d or others In this case, the best way is to split your import into multiple files. For example, if you\u2019re importing fil with 500 products, divide it into 2 files of 250 each and import it. Export Products: The products can be exported in excel\/pdf formats from the list products screen. In version 4.7.8, a new export feature is added to export the product in the same template as the import product template. In the list products screen, click the download excel button.","og_url":"https:\/\/help.xodox.in\/pt\/docs\/import-export-products\/","og_site_name":"My CMS","twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.xodox.in\/docs\/import-export-products\/","url":"https:\/\/help.xodox.in\/docs\/import-export-products\/","name":"Import\/Export Products - My CMS","isPartOf":{"@id":"https:\/\/help.xodox.in\/#website"},"datePublished":"2024-12-17T14:27:27+00:00","breadcrumb":{"@id":"https:\/\/help.xodox.in\/docs\/import-export-products\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.xodox.in\/docs\/import-export-products\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.xodox.in\/docs\/import-export-products\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.xodox.in\/"},{"@type":"ListItem","position":2,"name":"Import\/Export Products"}]},{"@type":"WebSite","@id":"https:\/\/help.xodox.in\/#website","url":"https:\/\/help.xodox.in\/","name":"My CMS","description":"","publisher":{"@id":"https:\/\/help.xodox.in\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.xodox.in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/help.xodox.in\/#organization","name":"My CMS","url":"https:\/\/help.xodox.in\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/help.xodox.in\/#\/schema\/logo\/image\/","url":"https:\/\/help.xodox.in\/wp-content\/uploads\/2024\/10\/Xodox-Logo-01-2.png","contentUrl":"https:\/\/help.xodox.in\/wp-content\/uploads\/2024\/10\/Xodox-Logo-01-2.png","width":573,"height":192,"caption":"My CMS"},"image":{"@id":"https:\/\/help.xodox.in\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/docs\/26851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/comments?post=26851"}],"version-history":[{"count":0,"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/docs\/26851\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/media?parent=26851"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/doc_category?post=26851"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.xodox.in\/pt\/wp-json\/wp\/v2\/doc_tag?post=26851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}