{"id":7692,"date":"2019-07-06T22:58:40","date_gmt":"2019-07-06T16:58:40","guid":{"rendered":"https:\/\/www.ecomclips.com\/?p=7692"},"modified":"2026-01-31T07:42:49","modified_gmt":"2026-01-31T07:42:49","slug":"get-status-report-of-listed-and-unlisted-items-from-linnworks","status":"publish","type":"post","link":"https:\/\/ecomclips.com\/blog\/get-status-report-of-listed-and-unlisted-items-from-linnworks\/","title":{"rendered":"Get status report of listed and unlisted items from Linnworks"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>How to download or export a report from Linnworks to get the listing status of the specific channel<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For every seller in the eCommerce business, the first priority is to display all of our product on the marketplace or list all of our inventory on sales channel so that there create the possibility to generate sales. To make sure every item listed, we have to know which items are listed and which are not. From marketplace backend, we can\u2019t find the exact report, cause on the marketplace they just give us the report against the listed item but they have no idea how many items still need to upload on the marketplace. If we use any third party multi-channel system like Linnworks it is very easy to know. Normally third-party system has a database so it can be very easy to get a report with the listing status of all listing like which are listed and which are not. In this article, we will show how to get such kind of reports from Linnworks so that we can easily get a report from Linnworks of the status of all listing which are listed and which are not.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Linnworks provides this opportunity to find out items for any specific channel easily. So let\u2019s start with how to download linked items report for all channels.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Why it is necessary?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sometimes we need to know<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Channel ID or Item ID or ASIN for all of the listed items or for some particular items<\/li>\n\n\n\n<li>Which items have already been listed on a specific channel or store and which items are still remaining to be listed&nbsp;<\/li>\n\n\n\n<li>The submitted quantity from Linnworks for all listed items or for some particular items on a specific channel<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Which information we will get from this report?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We will be able to find the following information from this report<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stock SKU<\/li>\n\n\n\n<li>Stock Item Title<\/li>\n\n\n\n<li>Channel ID<\/li>\n\n\n\n<li>Channel SKU<\/li>\n\n\n\n<li>Channel Item Name<\/li>\n\n\n\n<li>Source (The Name Of The Marketplace)<\/li>\n\n\n\n<li>Sub Source (The Store Name)<\/li>\n\n\n\n<li>Submitted Quantity From Linnworks<\/li>\n\n\n\n<li>Status<\/li>\n\n\n\n<li>Barcode Number<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Linnworks.Net<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s get started the procedure.<br>First of all, you need to click on the <strong>Dashboards<\/strong> opening the Linnworks, it is on the middle of the left side.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"551\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-66.png\" alt=\"\" class=\"wp-image-14771\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-66.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-66-300x161.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-66-768x413.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You will see <strong>Query Data<\/strong> at the right side under the dashboard. Click on the <strong>Query Data<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-69.png\" alt=\"\" class=\"wp-image-14773\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-69.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-69-300x160.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-69-768x410.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">There is a drop down menu beside <strong>Query<\/strong> type, clicking on there you will find the available information. Click on the <strong>Inventory &#8211; All channel linked items<\/strong> and then <strong>Generate Report<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"496\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-70.png\" alt=\"\" class=\"wp-image-14774\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-70.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-70-300x145.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-70-768x372.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The report of the linked items on all channels will be generated. Now click on the <strong>Download (CSV file)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"553\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-71.png\" alt=\"\" class=\"wp-image-14776\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-71.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-71-300x162.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-71-768x415.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A notification will appear at the bottom left corner that &#8220;The file is being downloaded&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"555\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-72.png\" alt=\"\" class=\"wp-image-14777\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-72.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-72-300x163.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-72-768x416.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Opening the downloaded file you will find your required information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"556\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-73.png\" alt=\"\" class=\"wp-image-14779\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-73.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-73-300x163.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-73-768x417.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">By filtering you can find information like which items are already listed on any specific channel or how many quantities have been submitted on that marketplace of any linked item.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-74.png\" alt=\"\" class=\"wp-image-14780\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-74.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-74-300x162.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-74-768x416.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Linnworks Desktop Version<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">From Linnworks Desktop, Go to <strong>Inventory Control<\/strong> and then click on <strong>Inventory Linking<\/strong>. Here, in the search bar, type the item\u2019s name and click on the <strong>Find<\/strong>. The items will appear and you will see all the item-channel linking connection here.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-75-1024x360.png\" alt=\"\" class=\"wp-image-14782\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-75-1024x360.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-75-300x105.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-75-768x270.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-75.png 1354w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, if you want to export a feed for these items, click on <strong>Export<\/strong>.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"431\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-76-1024x431.png\" alt=\"\" class=\"wp-image-14783\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-76-1024x431.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-76-300x126.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-76-768x323.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-76.png 1360w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here, you will get three options. You can select any one view from here. As we want to download a report to get the listing status of a specific channel, we have to go with the third option &#8211; <strong>Current view with stock item data and extended properties.<\/strong>\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"486\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-77-1024x486.png\" alt=\"\" class=\"wp-image-14786\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-77-1024x486.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-77-300x142.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-77-768x365.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-77.png 1356w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Then, click on <strong>Export Selected<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"488\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-78-1024x488.png\" alt=\"\" class=\"wp-image-14787\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-78-1024x488.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-78-300x143.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-78-768x366.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-78.png 1355w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Choose the location of your computer where you want to save the file. And click on <strong>Save<\/strong>. Save the file in CSV format.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-79-1024x506.png\" alt=\"\" class=\"wp-image-14788\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-79-1024x506.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-79-300x148.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-79-768x379.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-79.png 1357w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After saving the file, the selection window will pop-up. From here, you can choose the column that you want to export.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-80-1024x541.png\" alt=\"\" class=\"wp-image-14789\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-80-1024x541.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-80-300x158.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-80-768x405.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-80.png 1364w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here, we are exporting the Linking connection to one of our Amazon channels on Linnworks. So we have selected the two columns for that channel. Also, select the Item name (Title), SKU, and Quantity column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"181\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-81.png\" alt=\"\" class=\"wp-image-14791\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-81.png 662w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-81-300x82.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, you can open your downloaded file by clicking on <strong>YES<\/strong> when they ask if you want to check preview!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the file, you will see all the columns you have selected previously.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"630\" src=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-82-1024x630.png\" alt=\"\" class=\"wp-image-14792\" srcset=\"https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-82-1024x630.png 1024w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-82-300x185.png 300w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-82-768x472.png 768w, https:\/\/ecomclips.com\/blog\/wp-content\/uploads\/2023\/08\/image-82.png 1104w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Linked column will show the linking connection in <strong>Binary<\/strong> format (0 or 1).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here,&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0 = Not Linked<\/li>\n\n\n\n<li>1 = Linked<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">And, the<strong> Status<\/strong> column will show \u201c<strong>OK<\/strong>\u201d if the item is linked with Linnworks. If your item is not linked, it will clearly show the status \u201c<strong>Not Linked<\/strong>\u201d.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So, you can check the listing status of a specific channel this way from Linnworks Desktop.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong> This is very important to know that these reports both from Linnworks.net and Linnworks Desktop version generate based on mapped items on Linnworks, if any item listed on marketplace backend directly but still didn\u2019t map the channel SKU with Linnworks, then this report will show those items as not listed. So, make sure every item is mapped to get the exact and correct report from Linnworks.<br>Hope this article will be helpful to run your business successfully. If you have any questions regarding this article, please feel free to contact us. We would love to hear from you! Please leave a comment below.&nbsp;&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to download or export a report from Linnworks to get the listing status of the specific channel For every seller in the eCommerce business, the first priority is to display all of our product on the marketplace or list all of our inventory on sales channel so that there create the possibility to generate &#8230; <a title=\"Get status report of listed and unlisted items from Linnworks\" class=\"read-more\" href=\"https:\/\/ecomclips.com\/blog\/get-status-report-of-listed-and-unlisted-items-from-linnworks\/\" aria-label=\"Read more about Get status report of listed and unlisted items from Linnworks\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":14108,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[481,482],"class_list":["post-7692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linnworks","tag-download-listing-report-from-linnworks","tag-export-report-from-lw"],"_links":{"self":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/7692","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=7692"}],"version-history":[{"count":4,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/7692\/revisions"}],"predecessor-version":[{"id":23088,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/7692\/revisions\/23088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media\/14108"}],"wp:attachment":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media?parent=7692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/categories?post=7692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/tags?post=7692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}