{"id":1812,"date":"2017-09-04T10:23:42","date_gmt":"2017-09-04T09:23:42","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=1812"},"modified":"2017-09-04T10:23:42","modified_gmt":"2017-09-04T09:23:42","slug":"how-to-import-customer-promotional-prices-from-an-excel-csv-file","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=1812","title":{"rendered":"How to Import Customer Promotional Prices from an Excel (CSV) File"},"content":{"rendered":"
    \n
  1. Go To-> Season Button -> Office Tools -> Database Maintenance<\/li>\n<\/ol>\n

    \"\"<\/p>\n

     <\/p>\n

      \n
    1. Select the \u2018Import Data\u2019 tab -> Then click on the “Import Prices” tab\"\"<\/li>\n
    2. Enter in your Admin or Supervisor Password in the Password field<\/li>\n
    3. Click on “Customer Promotional Prices” option<\/li>\n
    4. This\u00a0will load the “Customer Promotional Prices Import Wizard”\"\"<\/li>\n
    5. Click on \u2018Browse \u00a0File to Import\u2019 and choose the location to which you want to import from. (Ensure that the file name ends in .csv) \u00a0<\/strong>Alternatively you can type in the file directory into the yellow text box shown in the image above<\/li>\n
    6. Click on the \u2018Click to Import\u2019 button<\/li>\n
    7. Click \u2018Yes\u2019 to import\u00a0Customer Promotional Prices\"\" <\/li>\n
    8. Once completed, a window will appear called “Data Import Wizard” as shown below\"\"<\/li>\n
    9. Now click on the “Stage 1: Check Data” option.<\/li>\n
    10. Some “Information” windows will appear on the screen, just click on “Ok” when they do<\/li>\n
    11. Now the window should look like the following\u00a0\"\" <\/li>\n
    12. Now repeat the same steps for “Stage 2: Import Data”<\/li>\n
    13. Both icons should now appear with ticks on them<\/li>\n
    14. Now any changes to the Customer Promotional Prices on the system should be updated.<\/b><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Go To-> Season Button -> Office Tools -> Database Maintenance   Select the \u2018Import Data\u2019 tab -> Then click on the “Import Prices” tab Enter in your Admin or Supervisor Password in the Password field Click on “Customer Promotional Prices” option This\u00a0will load the “Customer Promotional Prices Import Wizard” Click on \u2018Browse \u00a0File to Import\u2019 […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[33,328,366],"class_list":["post-1812","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice","tag-database-maintenance","tag-import","tag-customer-promotional-prices"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1812","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1812"}],"version-history":[{"count":0,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/1812\/revisions"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}