{"id":764,"date":"2021-10-26T08:03:23","date_gmt":"2021-10-26T08:03:23","guid":{"rendered":"http:\/\/www.2ba.nl\/2021\/10\/26\/definition-tsv-format\/"},"modified":"2023-11-24T08:25:36","modified_gmt":"2023-11-24T08:25:36","slug":"definition-tsv-format","status":"publish","type":"post","link":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format","title":{"rendered":"TSV format Definition"},"content":{"rendered":"\n

TSV format Definition<\/h1>\n\n\n

The TSV-file can be used to add supplier selection rules to an existing selection profile. The supplied file will override the existing rules of the selection profile.<\/p>\n\n\n\n\n
\n
Upload:<\/h5>\n

You can upload the TSV file by clicking on an existing selection profile<\/a>\u00a0and then Data selection click New supplier > Import selection profile -> Select file.<\/p>\n<\/td>\n

\u00a0<\/td>\n\"Import<\/td>\n<\/tr>\n
\n
Download:<\/h5>\n

Click\u00a0here<\/a> for an example file. A TSV template can also be generated by using the “Download TSV” button at the suppliers. If supplier selection rules are already present, these will be exported.<\/p>\n<\/td>\n

\u00a0<\/td>\n\"Download<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The column layout of the TSV file (TAB file) is as follows:<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

Column names must be in order and are case sensitive, values that do not meet criteria give no values.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Column<\/th>\nContent<\/th>\nMandatory<\/th>\n<\/tr>\n
GLNSupplier<\/td>\nMust be 13 digits long
A non-valid GLN number will give an error message<\/td>\n		Yes<\/td>\n<\/tr>\n
ArticleCodeSupplier<\/td>\nFree text, Wildcards (* and ?) accepted<\/td>\n\u00a0<\/td>\n<\/tr>\n
DiscountGroupSupplier<\/td>\nFree text wildcards (* and ? ) accepted
Separate multiple discount groups with a comma (,)
The discount groups specified must be enclosed in double quotes: \u201cgroep1, group2, groupX\u201d<\/td>\n		\u00a0<\/td>\n<\/tr>\n
GroupIDSupplier<\/td>\nMay be one existing supplier purchase group<\/td>\n\u00a0<\/td>\n<\/tr>\n
AssortmentType<\/td>\nOLD (advanced filtering): with filtering
ALL (all data from specified GLN) : no filtering, only specify GLNSupplier and DownloadRowType
SRA (product range): not usable in this TSV file<\/td>\n		\u00a0<\/td>\n<\/tr>\n
CustomPropertyValue<\/td>\nFreeValue01, Free text, max 70 characters long<\/td>\n\u00a0<\/td>\n<\/tr>\n
ManufacturerGLN<\/td>\nMust be 13 digits long<\/td>\n\u00a0<\/td>\n<\/tr>\n
ProductCodeManufacturer<\/td>\nFree text, Wildcards (* and ?) accepted<\/td>\n\u00a0<\/td>\n<\/tr>\n
ProductClassManufacturer<\/td>\nFormat EC######<\/td>\n\u00a0<\/td>\n<\/tr>\n
BrandNameManufacturer<\/td>\nBrand must exist in 2BA
A non-existing brannd will give an error<\/td>\n		\u00a0<\/td>\n<\/tr>\n
ProductSeriesManufacturer<\/td>\nFree text, Wildcards (* and ?) accepted<\/td>\n\u00a0<\/td>\n<\/tr>\n
ProductTypeManufacturer<\/td>\nFree text, Wildcards (* and ?) accepted<\/td>\n\u00a0<\/td>\n<\/tr>\n
InverseRowSelection<\/td>\nTrue \/ False<\/a>, default value is False
If the value is True, the values that meet the criteria are removed from the result. More information Not-Regels<\/a><\/td>\n		\u00a0<\/td>\n<\/tr>\n
DownloadRowType<\/td>\nComplete, Mutation, Restore<\/a><\/td>\nYes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"

TSV format Definition The TSV-file can be used to add supplier selection rules to an existing selection profile. The supplied file will override the existing rules of the selection profile. Upload: You can upload the TSV file by clicking on an existing selection profile\u00a0and then Data selection click New supplier > Import selection profile -> […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","footnotes":""},"categories":[124],"tags":[],"class_list":["post-764","post","type-post","status-publish","format-standard","hentry","category-selection-profile"],"acf":[],"yoast_head":"\nTSV format Definition - 2ba<\/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:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TSV format Definition - 2ba\" \/>\n<meta property=\"og:description\" content=\"TSV format Definition The TSV-file can be used to add supplier selection rules to an existing selection profile. The supplied file will override the existing rules of the selection profile. Upload: You can upload the TSV file by clicking on an existing selection profile\u00a0and then Data selection click New supplier > Import selection profile -> […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\" \/>\n<meta property=\"og:site_name\" content=\"2ba\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-26T08:03:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-24T08:25:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg\" \/>\n<meta name=\"author\" content=\"Marcel van der Zee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marcel van der Zee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\"},\"author\":{\"name\":\"Marcel van der Zee\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d\"},\"headline\":\"TSV format Definition\",\"datePublished\":\"2021-10-26T08:03:23+00:00\",\"dateModified\":\"2023-11-24T08:25:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\"},\"wordCount\":284,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg\",\"articleSection\":[\"Selection profile\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\",\"url\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\",\"name\":\"TSV format Definition - 2ba\",\"isPartOf\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg\",\"datePublished\":\"2021-10-26T08:03:23+00:00\",\"dateModified\":\"2023-11-24T08:25:36+00:00\",\"author\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d\"},\"breadcrumb\":{\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage\",\"url\":\"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg\",\"contentUrl\":\"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/2ba.wimwillems.nl\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TSV format Definition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/#website\",\"url\":\"https:\/\/2ba.wimwillems.nl\/\",\"name\":\"2ba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/2ba.wimwillems.nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d\",\"name\":\"Marcel van der Zee\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g\",\"caption\":\"Marcel van der Zee\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TSV format Definition - 2ba","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:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/","og_locale":"en_US","og_type":"article","og_title":"TSV format Definition - 2ba","og_description":"TSV format Definition The TSV-file can be used to add supplier selection rules to an existing selection profile. The supplied file will override the existing rules of the selection profile. Upload: You can upload the TSV file by clicking on an existing selection profile\u00a0and then Data selection click New supplier > Import selection profile -> […]","og_url":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/","og_site_name":"2ba","article_published_time":"2021-10-26T08:03:23+00:00","article_modified_time":"2023-11-24T08:25:36+00:00","og_image":[{"url":"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg","type":"","width":"","height":""}],"author":"Marcel van der Zee","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marcel van der Zee","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#article","isPartOf":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/"},"author":{"name":"Marcel van der Zee","@id":"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d"},"headline":"TSV format Definition","datePublished":"2021-10-26T08:03:23+00:00","dateModified":"2023-11-24T08:25:36+00:00","mainEntityOfPage":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/"},"wordCount":284,"commentCount":0,"image":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage"},"thumbnailUrl":"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg","articleSection":["Selection profile"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/","url":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/","name":"TSV format Definition - 2ba","isPartOf":{"@id":"https:\/\/2ba.wimwillems.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage"},"image":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage"},"thumbnailUrl":"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg","datePublished":"2021-10-26T08:03:23+00:00","dateModified":"2023-11-24T08:25:36+00:00","author":{"@id":"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d"},"breadcrumb":{"@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#primaryimage","url":"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg","contentUrl":"http:\/\/2ba.wimwillems.nl\/wp-content\/uploads\/2021\/10\/Import-TSV.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/2ba.wimwillems.nl\/en\/documentation\/file-exchange\/file-download\/selection-profile\/definition-tsv-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/2ba.wimwillems.nl\/en\/"},{"@type":"ListItem","position":2,"name":"TSV format Definition"}]},{"@type":"WebSite","@id":"https:\/\/2ba.wimwillems.nl\/#website","url":"https:\/\/2ba.wimwillems.nl\/","name":"2ba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/2ba.wimwillems.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/2ba.wimwillems.nl\/#\/schema\/person\/bd0802672838e9af9de861f030684d6d","name":"Marcel van der Zee","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b7e48e3b50e4e9aed4e63c19fc037752e22b927025e1bb0f1a403c11efc5475?s=96&d=mm&r=g","caption":"Marcel van der Zee"}}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"gform-image-choice-sm":false,"gform-image-choice-md":false,"gform-image-choice-lg":false},"uagb_author_info":{"display_name":"Marcel van der Zee","author_link":"https:\/\/2ba.wimwillems.nl\/en\/author\/mvdz2ba-nl\/"},"uagb_comment_info":0,"uagb_excerpt":"TSV format Definition The TSV-file can be used to add supplier selection rules to an existing selection profile. The supplied file will override the existing rules of the selection profile. Upload: You can upload the TSV file by clicking on an existing selection profile\u00a0and then Data selection click New supplier > Import selection profile ->…","_links":{"self":[{"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/posts\/764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":6,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":3606,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/posts\/764\/revisions\/3606"}],"wp:attachment":[{"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2ba.wimwillems.nl\/en\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}