{"id":1125,"date":"2017-05-24T11:54:34","date_gmt":"2017-05-24T10:54:34","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=1125"},"modified":"2017-05-24T11:54:34","modified_gmt":"2017-05-24T10:54:34","slug":"how-to-export-a-list-of-product-default-prices-to-excel-csv","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=1125","title":{"rendered":"How to Export a list of Product Default Prices to Excel (CSV)"},"content":{"rendered":"
    \n
  1. Open the Database Maintenance dialog, Season Button -> Office Tools -> Database Maintenance<\/li>\n<\/ol>\n

    \"\"<\/p>\n

      \n
    1. Select the \u2018Export Data\u2019 -> Export Prices tab<\/li>\n<\/ol>\n

      <\/p>\n

        \n
      1. Enter in your Admin or Supervisor Password in the Password field<\/li>\n
      2. Click on ‘Product Prices’.<\/li>\n
      3. This\u00a0will load the Product Prices Export Wizard.<\/li>\n<\/ol>\n

        \"\"<\/p>\n

         <\/p>\n

          \n
        1. Click on ‘Export Additional Fields’ if you want to export the displayed fields.<\/li>\n
        2. Click on ‘Browse \u00a0File to Export’ and choose the location to which you want to save the file. (Ensure that the file name ends in .csv)<\/strong><\/li>\n
        3. Click on the \u2018Export ALL Products\u2019 button<\/li>\n
        4. Click ‘Yes’ to Export all Product prices<\/li>\n<\/ol>\n

           <\/p>\n

          \"\"<\/p>\n

            \n
          1. Once completed, a message will appear telling you “Export Complete”. Click ‘OK’ to close the message.<\/li>\n<\/ol>\n

            <\/p>\n

              \n
            1. You now can go to the location that you saved the file and open it in Excel.<\/strong><\/li>\n<\/ol>\n

               <\/p>\n

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

              Open the Database Maintenance dialog, Season Button -> Office Tools -> Database Maintenance Select the \u2018Export Data\u2019 -> Export Prices tab Enter in your Admin or Supervisor Password in the Password field Click on ‘Product Prices’. This\u00a0will load the Product Prices Export Wizard.   Click on ‘Export Additional Fields’ if you want to export the […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[530,567,604],"class_list":["post-1125","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice","tag-export-prices","tag-product-prices-export","tag-prices-export"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1125"}],"version-history":[{"count":0,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1125\/revisions"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}