- \n
- To know about how many “FBA” products\u2019 quantity available in Amazon Warehouse.<\/li>\n\n\n\n
- Time-saving. (It\u2019ll require just about 1 hour for creating this report)<\/li>\n<\/ul>\n\n\n\n
How many you have left in Warehouse (which is the CAR units) – Downloading Channel Advisor Report<\/strong><\/h2>\n\n\n\n
Step 1:<\/strong> On Channel Advisor, go to Inventory <\/strong>and then select All Products<\/strong>.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 2:<\/strong> In the All Products page, go to the \u201cExport<\/strong>\u201d button on the right-hand side and select \u201cQty Available<\/strong>\u201d from the Drop Down.<\/p>\n\n\n\n
Note: Make sure there are no filters in any columns or you want to get a complete download of all products.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 3:<\/strong> On the Export Product page, under the \u201cExport Fields<\/strong>\u201d section, make sure that you have these four Product Fields <\/strong>selected: SKU<\/strong>, Title<\/strong>, ASIN<\/strong>, Quantity Total<\/strong>. Once selected, click the \u201cExport<\/strong>\u201d button on the right to download a report.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 4:<\/strong> When the report is processed, click the file name link to download the data on your computer.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 5:<\/strong> Open the text file inside the .zip folder.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 6:<\/strong> Copy paste all the Data from the text file, into a new excel file and save the file as a name.<\/p>\n\n\n\n
Step 7:<\/strong> Rename Auction Title<\/strong> column to Title<\/strong>, Inventory number<\/strong> to SKU, Total Quantity<\/strong> to CAR<\/strong>.<\/p>\n\n\n\n
Step 8:<\/strong> Sort the Title <\/strong>Column and delete all rows that are empty.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 9:<\/strong> Repeat the same cleaning procedure in CAR <\/strong>and Quantity <\/strong>Column.<\/p>\n\n\n\n
Step 10:<\/strong> Cut and reorganize columns to go in this order from left to right: SKU<\/strong>, Title<\/strong>, ASIN<\/strong>, CAR<\/strong>.<\/p>\n\n\n\n
You are now ready to start downloading Amazon reports!!!<\/p>\n\n\n\n
Adding in US FBA A column – FBA A Column = Total FBA Quantity Available in Amazon Warehouse<\/strong><\/h2>\n\n\n\n
Step 11: <\/strong>Download an Amazon Fulfilled Inventory Report and download the .txt file when it ready. Copy and paste the data into a new spreadsheet.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 12: <\/strong>Sort the Column E (<\/strong>Warehouse-Condition-code<\/em><\/strong>)<\/strong> in Descending <\/strong>order and delete all the rows with \u201cUNSELLABLE<\/strong>\u201d as the condition. Since these cannot be sold, we do not need to know their quantity.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 13: <\/strong>Sort column A \u201cSeller-SKU<\/strong>\u201d in Descending <\/strong>order and delete all lines that are not FBA SKU. Keep only SKU that have the \u201cFBA\u201d prefix.<\/p>\n\n\n
\n<\/figure>\n<\/div>\n\n\n
Step 14: <\/strong>Sort in Ascending <\/strong>order and delete any rows that have a poorly formatted FBA SKU (might have space in between FBA- and TD-TPU). Our normal SKU’s look like this TD-TPUXXXX or FBA-TD-TPUXXXX. In the past, we have accidentally made incorrect SKU by adding space in between FBA- or in between those SKU. So, there are some SKUs that ended up looking like this FBA- TD-TPUXXXX (spare after FBA-) or FBA-TD -TPUXXXX (space in between those SKU). Once we create these SKU, they are in the system forever and we have to manually delete them this way. <\/p>\n\n\n\n
<\/p>\n\n\n\nStep 15: <\/strong>Sort Column C (ASIN) in order and in Cell D2 enter the formula =exact (c2, c3). <\/p>\n\n\n\n
Drag this down so all cell in column D is full.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Step 15:<\/strong> Copy and Paste Column D as Values.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Step 16:<\/strong> Ctrl + F the word True and highlight. Scroll through Column D to find any duplicate ASINs. If you find matches, delete the ones that have 0 in FBA and keep the one with stock. Again, this is the result of having created wrong SKUs in the past. What we did to fix it is to create the correct formatted SKU, under the same ASIN again. But once we have created the wrong SKU in FBA Inventory, it is there forever and we are not able to delete it from our system again. There might be multiple SKU under the same ASIN and we have to remove duplicate ASIN. Remove the wrong SKU and leave only the correct SKU that is live on FBA. This happens on all marketplaces US \/ CA \/ UK<\/p>\n\n\n\n
<\/p>\n\n\n\n
Step 17:<\/strong> Back on the main report page and do VLOOKUP formula to get data from FBA available inventory report.<\/p>\n\n\n\n
Step 18:<\/strong> Pull down the formula to fill all lines in column D and copy and paste as values \/ text.<\/p>\n\n\n\n
Step 19:<\/strong> Sort by descending and replace any cell with #N\/A with a 0. US FBA A column should be done!<\/p>\n\n\n\n
The completely finished file should look like this!<\/strong><\/p>\n\n\n\n
<\/p>\n\n\n\n
Trouble Shooting Errors<\/strong><\/p>\n\n\n\n
- \n
- Be careful in how you do sort to avoid the data from being mixed up I would suggest you make a couple highlighted lines to make sure all the data is staying correctly aligned. By making a couple different colored lines straight across you will be able to make sure all the data stays correctly aligned as you do sorting.<\/li>\n<\/ol>\n\n\n\n
<\/p>\n\n\n\n
- \n
- One common reason why Data gets mis-sorted is if you insert an empty column in between two other columns. If you sort while there is an empty break, it will definitely mess up the data alignment.<\/li>\n<\/ol>\n\n\n\n
<\/p>\n\n\n\n
Note: If the data gets mis-sorted, then even if you do everything else 100% correct, your file will be inaccurate so it’s very important to keep it all properly sorted. Feel free to use lots of colored lines just to make sure everything is staying in order!<\/p>\n\n\n\n
And so, that is how you can update daily inventory using Channel Advisor. Very soon we will be released on how to do this same task on other third-party apps such as Linnworks, Ecomdash, Sellercloud, and others. So keep reading our blog.<\/p>\n","protected":false},"excerpt":{"rendered":"
When we are sending our products to Amazon Warehouse (FBA), we often need to know certain information, such as how many items are available now in Amazon, calculating the previous sales i.e. order history and currently available quantity in Amazon Warehouse. If it seems any Top or Hot selling item is low in stock we … Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":15983,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[337,299,338],"class_list":["post-6349","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-market-place-store","tag-amazon-fba","tag-amazon-warehouse","tag-daily-report"],"_links":{"self":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6349","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=6349"}],"version-history":[{"count":2,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6349\/revisions"}],"predecessor-version":[{"id":23132,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/6349\/revisions\/23132"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media\/15983"}],"wp:attachment":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media?parent=6349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/categories?post=6349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/tags?post=6349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- One common reason why Data gets mis-sorted is if you insert an empty column in between two other columns. If you sort while there is an empty break, it will definitely mess up the data alignment.<\/li>\n<\/ol>\n\n\n\n
- Be careful in how you do sort to avoid the data from being mixed up I would suggest you make a couple highlighted lines to make sure all the data is staying correctly aligned. By making a couple different colored lines straight across you will be able to make sure all the data stays correctly aligned as you do sorting.<\/li>\n<\/ol>\n\n\n\n
![](\"https:\/\/lh5.googleusercontent.com\/-o0avsinOpszi6HmU-xNI1MwSwCr8teijtMuEZBXB1KihhtWagGnavA_65iUm5V0rlz87OJEXfmXWF-UVW8_9-9B4Eq8JSTElzNkm7drNl50NTPvTlX_RLm_6L5cFyEwtMssAjX_iQklHgOObKJr5piXHVwjRJY\")