{"id":27595,"date":"2024-11-28T17:02:45","date_gmt":"2024-11-28T15:02:45","guid":{"rendered":"http:\/\/support.simplbooks.ee\/?post_type=ht_kb&#038;p=27595"},"modified":"2024-11-28T17:02:45","modified_gmt":"2024-11-28T15:02:45","slug":"partners-import-clients-suppliers-reporting-persons","status":"publish","type":"ht_kb","link":"https:\/\/support.simplbooks.ee\/en\/kasutusjuhendid\/partners-import-clients-suppliers-reporting-persons\/","title":{"rendered":"Partners import (clients, suppliers, reporting persons)"},"content":{"rendered":"<p><strong>Partners -&gt; Clients and Suppliers -&gt;<\/strong> <strong>Actions<\/strong> button <strong>-&gt; Import<\/strong><\/p>\n<p>If you have exported partner data from previously used software, you can import it into SimplBooks. To do this, prepare a <strong>CSV<\/strong> file with the required data. Below, you\u2019ll find information on the fields that can be imported and whether they are mandatory or not.<\/p>\n<p>Once you have entered the necessary data into the file, save it using the &#8220;<strong>Save As<\/strong>&#8221; option in the format <strong>&#8220;CSV (Comma delimited) (*.csv).&#8221; Do not open this saved file again before importing it into SimplBooks!<\/strong><\/p>\n<p><em><span class=\"su-label su-label-type-warning\">Advice<\/span>\u00a0When adding new clients\/suppliers to the system, importing data beforehand is not necessary, as data for Estonian companies is automatically loaded from the Business Register. For suppliers, it is useful to add bank account details, and for clients, an email address (information not retrieved from the Business Register).<\/em><\/p>\n<p><a href=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27597\" src=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG.png\" alt=\"\" width=\"986\" height=\"223\" srcset=\"https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG.png 986w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-300x68.png 300w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-768x174.png 768w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-50x11.png 50w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-920x208.png 920w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-600x136.png 600w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/01_partnerite-import-ENG-320x72.png 320w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><\/a><\/p>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-folder-1 spoiler-green su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Mandatory and optional data for import<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Mandatory fields:<\/strong><\/p>\n<ul>\n<li>company&#8217;s or person&#8217;s name<\/li>\n<li>street address (company)<\/li>\n<\/ul>\n<p><strong>Optional fields:<\/strong><\/p>\n<ul>\n<li>registration number (company)<\/li>\n<li>VAT number (if applicable)<\/li>\n<li>partner type (client, supplier, reporting person, private person), marked as yes or no in the file column<\/li>\n<li>detailed address information (city, county, postal code, country)<\/li>\n<li>contact details (email, phone, website)<\/li>\n<li>bank account IBAN number (supplier), with the bank name and SWIFT code also optional<\/li>\n<li>payment term in days<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-folder-1 spoiler-green su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Example of CSV file columns<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"> The mandatory fields are highlighted in the image, but we also recommend adding information to the other columns. A reporting person is always an individual, so in this case, you should mark &#8220;yes&#8221; in both columns (see the third row in the image).<\/p>\n<p><a href=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27666\" src=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2.png\" alt=\"\" width=\"1114\" height=\"96\" srcset=\"https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2.png 1114w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-300x26.png 300w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-768x66.png 768w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-1024x88.png 1024w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-50x4.png 50w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-920x79.png 920w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-600x52.png 600w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/02_partnerite-import-ENG-2-320x28.png 320w\" sizes=\"auto, (max-width: 1114px) 100vw, 1114px\" \/><\/a><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-folder-1 spoiler-green su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Import preview<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\u00a0When you click the import button, an additional window will open where you can add the CSV file.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27603 aligncenter\" src=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG.png\" alt=\"\" width=\"300\" height=\"299\" srcset=\"https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG.png 402w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG-150x150.png 150w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG-300x300.png 300w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG-50x50.png 50w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG-60x60.png 60w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/05_partnerite-import-ENG-320x319.png 320w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>After clicking the <strong>Import<\/strong> button, the import preview will open.<\/p>\n<p><strong>In the import preview<\/strong>, you need to define the mapping between the file columns and the program&#8217;s data fields. The image already shows the mappings selected. Until the mapping is chosen, the text &#8220;<strong>Select target field<\/strong>&#8221; will appear above the column.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27606\" src=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG.png\" alt=\"\" width=\"1140\" height=\"851\" srcset=\"https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG.png 1140w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-300x224.png 300w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-768x573.png 768w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-1024x764.png 1024w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-50x37.png 50w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-920x687.png 920w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-600x448.png 600w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/03_partnerite-import-ENG-320x239.png 320w\" sizes=\"auto, (max-width: 1140px) 100vw, 1140px\" \/><\/a><\/p>\n<p>Once all the necessary mappings are selected, click <strong>Import<\/strong>.<\/p>\n<p>At the end of the import, you will be informed about how many rows were imported and whether the import of all rows was successful.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-folder-1 spoiler-green su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Warning during import \u2013 row overlap<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"> If you have added a partner before importing data, and the partner&#8217;s information is also in the import file, the system will notify you and ask whether the rows can be overwritten or if they should be skipped in the import.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-27609\" src=\"http:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG.png\" alt=\"\" width=\"1139\" height=\"271\" srcset=\"https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG.png 1139w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-300x71.png 300w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-768x183.png 768w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-1024x244.png 1024w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-50x12.png 50w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-920x219.png 920w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-600x143.png 600w, https:\/\/support.simplbooks.ee\/ee\/wp-content\/uploads\/2024\/11\/04_partnerite-import-ENG-320x76.png 320w\" sizes=\"auto, (max-width: 1139px) 100vw, 1139px\" \/><\/a><\/p>\n<p>Overwriting the data may be necessary if you have added additional information to the file that you wish to include on the partner&#8217;s profile.<\/p>\n<\/div><\/div>\n<\/div>\n<p><em>If you have any additional questions, write to us at\u00a0<a href=\"mailto:support@simplbooks.ee\">support@simplbooks.ee<\/a><\/em><\/p>\n","protected":false},"author":426,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht_kb_category":[170,171],"ht_kb_tag":[],"class_list":["post-27595","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-where-to-start","ht_kb_category-partners"],"_links":{"self":[{"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb\/27595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/users\/426"}],"replies":[{"embeddable":true,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/comments?post=27595"}],"version-history":[{"count":12,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb\/27595\/revisions"}],"predecessor-version":[{"id":27926,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb\/27595\/revisions\/27926"}],"wp:attachment":[{"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/media?parent=27595"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb_category?post=27595"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.simplbooks.ee\/en\/wp-json\/wp\/v2\/ht_kb_tag?post=27595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}