{"id":6690,"date":"2019-03-09T20:12:19","date_gmt":"2019-03-09T14:12:19","guid":{"rendered":"https:\/\/www.ecomclips.com\/?p=6690"},"modified":"2026-01-31T07:42:49","modified_gmt":"2026-01-31T07:42:49","slug":"channel-wise-data-import-or-bulk-update-information-on-linnworks","status":"publish","type":"post","link":"https:\/\/ecomclips.com\/blog\/channel-wise-data-import-or-bulk-update-information-on-linnworks\/","title":{"rendered":"Channel Wise Data Import or Bulk Update Information Using Linnworks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>In this documentation, we will describe<\/strong><strong> <\/strong><strong>how to define the Parent-child relationship on Linnworks and List Variation product on Linnworks using Excel template file in Bulk.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Linnworks is an eCommerce based multichannel software for online retailers. Importing and populating Variation Groups is a common use for Inventory Imports. The process of creating the import is identical to any other Inventory Import, but the preparation of the CSV file requires certain columns to be presented, in order to be successful.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Preparing CSV file<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">In order to upload, we need to prepare an Excel or CSV file. No need to download any file from Linnworks, we can create a CSV file from Microsoft Excel. The CSV file requires a few columns that need to be presented. We can give the columns name by ourselves or matching with the Linnworks properties.<\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td><strong>Column<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><tr><td>SKU<\/td><td>Unique identifier to reference this item in Linnworks.<\/td><\/tr><tr><td>Is Variation Group<\/td><td>Enter Yes if the SKU is to be a Variation group.<\/td><\/tr><tr><td>Variation Group Name<\/td><td>If the item is the parent SKU of a variation group, this is the name given to the group as a whole.<\/td><\/tr><tr><td>Variation SKU<\/td><td>This is the Parent SKU that the Child SKUs will belong to.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/YhJfiZCMd8TmiDfnczi2ep64sxVAb9DiOdtrdemlAz9ZRGtajUp2opxvOOcmM8NMrCPfKTIKmiWLd52FGG1NRw8Y-kfy24myem6SzLQIcZItZQxP8sgW7R_Rf-F5SdVu-2z-rwJNdobifT1Osxej-A\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>2.<\/strong> <strong>Uploading CSV file.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.1&nbsp; Once logged into the Linnworks, we can see that, on the left side of the screen- Linnworks features are grouped into categories that we can use. To upload the CSV, we need to choose the <strong>Import Data<\/strong> from <strong>SETTINGS<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/VbCjzddu3JixKm0PzJk6UswnZTw0W1wq3PfqRfz26Xx2u58qi_SraK0pBNnDer1j9sPA5uXeZPslNb_fA94ha1AszLDijL22rID6mCnAbbBmSCjChFjS2HefEE70lU8z9T09mD05eEK3S8VQ-nDVAw\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">2.2 After that, we have to click on <strong>Import Now <\/strong>on the top right side of the page to upload our CSV file.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/iopSuGpC0Uut3OrekRBDg5WSiknePF2V-j1imZpC1qnGwjIz_HwO5QREhmcHfq9LYTcnTXT7NlprXTc97QGCFnUTN2WCXILlUtLFrth_NH9qn8hWzi05Qij4j8ELrJlJojXI4mTg0bjD2eei41Leig\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">2.3 In <strong>Import Configuration<\/strong>, we have to give a Name and select the Type <strong>Inventory Import<\/strong> from the drop-down. Then click on <strong>Next<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/xDIy6Kb3wFU_q9ADn5RNQfrxG7J7U6zwaFD7feTALbcnI9gA8nSDm7eoB45QKySY-U13KmvvnvDyqKtSH9aG__-b1-GLl2-XOFLpGJQHLXEwB1d2DSSHmeFTEPsJj8xzWQ6Uts0I6R9Nubf_-I8RHA\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">2.4 Now we have to select our CSV file. Click on <strong>Choose File<\/strong> and then again click on <strong>Next<\/strong>.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/zMMPwa-VtsGmmo7SlaXtz68WVU-wWNao1-bqBcdVdlxAZdHxlA1YTPYhm4HblWxUgh7ljxr9NypOjiXLKpyWR6G8JZ0FkA_D4BSwc0oDn0bYDPO8rpP2GXIYfdyscUeD2mmYzVextO6QAXAPZALMnw\" width=\"624\" height=\"241\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.5 In this section, we have to map <strong>File Column<\/strong> with <strong>Map to<\/strong>. After mapping properly Click <strong>Run Now<\/strong>. This section is very important, make sure we have to map the file column with the proper name. Although most columns will be mapped automatically, due to the CSV file&#8217;s column names matching with Linnworks properties, columns such as color would need to be mapped as <strong>Extended Item Properties<\/strong> of type <strong>Attribute<\/strong>.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/b_9dIJU-PQjqd4gWyGMEa35zTPosrRJ_iE05c83EMLq_iXEdcvIGFW7AQKjYsuC6zAMdAo1Y9qb74dUklC1i3qszZZyag7Q2jkV6sjwsmpVDuoTqk7eCj_8A0egrRRQVdY1ZjDs8acf2rk4XK5QTcg\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Also please note that when creating a variation group, ensure that the SKU and Variation SKU match.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Finally, the bulk upload variation item on Linnworks is completed.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.6 For checking our items we need to go to <strong>My Inventory<\/strong> from Inventory.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/QPktPSmpGALU61aTJADEWR2akcYqDv1Qe-O0DXNSYxsT4kYhb_r3ex-zQTp3l1enfUXElbswsxM6c_BKjHBzxgNMvLBw6SZ2qTG51VGDWtTK3eX4t0IDwk2nhVrJPgEcHUO-ggeAqyNdJLypSVcZBg\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">2.7 In <strong>My Inventory<\/strong> search box we have to search for our items and we will find our items.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/amWBtCqD_gbhcFI92oI-mdQTgMeHlmGYBx9p6AxyJNjXl4066AuaVtaqcn4n3cjinG04SD9VlLJHWVDKFagqE-QWLt8XmzNq12fMmwRQyAlwjuqFL2smnIGpCLTj0NSzq-t3JDT697Fu4TchJhUhDw\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">If we click on that plus button with the parent SKU we can also find the child variations.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/EXWNHw2yUhNFOluze7SIlxD-BQL_z02dfOwCrioaca9h5Qa2hOw1AcsqiI5ONoV3_8XkY76NKFIlSzIYEhethgrg5sgCCKugHn0VsRcLlw924BrwmOODbNZsfKn3AMkTCj5MMvPCO94XTn_JPpz2lQ\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">That is the end of this article. Please contact us for any kind of support. We would be glad to help you out. Thank you and best of luck for your business.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this documentation, we will describe how to define the Parent-child relationship on Linnworks and List Variation product on Linnworks using Excel template file in Bulk. Linnworks is an eCommerce based multichannel software for online retailers. Importing and populating Variation Groups is a common use for Inventory Imports. The process of creating the import is &#8230; <a title=\"Channel Wise Data Import or Bulk Update Information Using Linnworks\" class=\"read-more\" href=\"https:\/\/ecomclips.com\/blog\/channel-wise-data-import-or-bulk-update-information-on-linnworks\/\" aria-label=\"Read more about Channel Wise Data Import or Bulk Update Information Using Linnworks\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":13098,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,73],"tags":[387,388,389,390],"class_list":["post-6690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linnworks","category-shopify","tag-bulk-edit-information","tag-import-data-in-marketplace","tag-import-ebay-specific-data","tag-upload-amazon-information-in-linnworks"],"_links":{"self":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/comments?post=6690"}],"version-history":[{"count":3,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6690\/revisions"}],"predecessor-version":[{"id":23120,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6690\/revisions\/23120"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media\/13098"}],"wp:attachment":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media?parent=6690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/categories?post=6690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/tags?post=6690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}