{"id":49243,"date":"2024-03-29T10:53:12","date_gmt":"2024-03-29T10:53:12","guid":{"rendered":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=49243"},"modified":"2025-02-25T15:46:44","modified_gmt":"2025-02-25T15:46:44","slug":"how-to-export-import-supplier-prices","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=49243","title":{"rendered":"How to: Export\/Import Supplier Prices"},"content":{"rendered":"\n

**You will need to know your Season admin password to be able to access the database maintenance import and export programs. If you do not know you system admin password, contact Datos Support**<\/strong><\/p>\n\n\n\n

Go to the main Season menu found along the top of your screen, go to Office Tools and then select Database Maintenance.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

On the next window, select the tab Export Data followed by the Export Prices tab underneath. Click the button for Supplier Prices.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

A new window will open, here you will see what data will export for you and in which format the data will appear. When you are ready to export, click the browse button.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

When you click the browse button, your file explorer window will open. You will need to select a location and give a name for the file you are exporting. Once that is done, click the save button. Your file explorer window will close. Click the button in the bottom right corner of the window to export. A box will pop up to confirm the export, click yes to complete it. A pop up will confirm when the export has finished. You can then browse to the location you saved the file and open it.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

How to import Supplier Prices<\/p>\n\n\n\n

Follow the first step in the export process above to open the database maintenance section. Once there, select the Import Data tab followed by the Import Prices tab below that. Click the button for Supplier Prices.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

A new window will open, here it tells you which format you need to have the data in to import it in. You need to have \u201cSUPP_PRICE_IMP\u201d in column A followed by the correct data in each column following that, ending with \u201cSUPP_END\u201d in column H. If you have exported the data out first, the data will already be in this format, you will just need to make sure to change column A as that is different on the export.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

When you are ready to import your CSV file, Click the browse file to import button. Your file explorer window will open to allow you to select the file you want to import. Select the file you need and click open. You will see your file path now in the yellow box. When ready to import, click the Click to Import button. <\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

On the next window you need to click the stage 1 Check Data button. Season will check the data to make sure it is in the correct format and any codes within the file match up with existing codes within the system. If there are any issues with the data you will get an error message and you will need to correct the problem data before attempting to import. If the file is correct, you can move onto Stage 2; Import Data, when you click this button the file will be imported. When complete a pop up will appear, click ok to complete. You can close the database maintenance windows now.<\/p>\n\n\n

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

**You will need to know your Season admin password to be able to access the database maintenance import and export programs. If you do not know you system admin password, contact Datos Support** Go to the main Season menu found along the top of your screen, go to Office Tools and then select Database Maintenance. […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[328,579,630,631,632],"class_list":["post-49243","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice","tag-import","tag-export","tag-import-supplier-prices","tag-export-supplier-prices","tag-supplier-prices"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/49243","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=49243"}],"version-history":[{"count":1,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/49243\/revisions"}],"predecessor-version":[{"id":49252,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/49243\/revisions\/49252"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=49243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=49243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}