How to Bulk Close Inventory in Neatoscan
Using Inventory feeds is the most accurate way to bulk close inventory from Inventory Manager. This guide will cover how to create and submit close feeds.
In order to use inventory feeds, we’ll start by running the report before formatting the feed file, and then finally submitting the feed and verifying everything is closed on your marketplaces.
Quick Links
- Run and Open the Active Inventory V2 Report
- Format the Close File
- Submit the Close File
- Verify Inventory is Closed
- Quick Process List
- Quick Reference: Close Feed Formatting
If you need assistance with this process at any time, please reach out to support@neatoscan.com
Run and open the Active Inventory V2 report
- Click Reporting from the Home Screen
- Set the report Type to Active Inventory V2 and click Submit
- Click on Feed Processing on the left
- Double-click on today’s Active Inventory V2 in the list and click Download
- Choose a location (use Documents if unsure) and click save
- Click OK once the download is complete
- The report should automatically open in Excel
Format the Close File
To bulk close ALL inventory on ALL marketplaces
The following steps are for closing ALL inventory on ALL marketplaces. If you are only closing your inventory on one specific marketplace, skip to the next steps.
- Select the entire SKU column (Column A), then right-click and copy it
- Click the New sheet button (the + button on the bottom left of the window)
- On the new sheet, right-click on Column B and click Paste
- Enter the word action as the header for Column A
- Enter the word DELETE in every row in Column A, after the word action. A shortcut to apply this to every row is to enter it into row 2, then with it selected, double-click the bottom right corner of that box to apply it all the way down
- Select both columns A and B together by first clicking on Column A, then hold the shift key and select Column B while holding shift. Then right-click and copy them
- Open up Notepad from Windows and start a new blank document. Right-click and paste your columns A and B into the blank notepad document
- Press the Delete key once, so the cursor is blinking after the last SKU in the list instead of on its own row. Note: If this step is missed, the feed will not be accepted by the tool
- Click File and Save As, then save the text file in an easy location to access it the next step
To bulk close ALL inventory on ONE marketplace
The following steps are for closing all inventory on one marketplace, but leaving that inventory listed on all others. If you are bulk deleting for all marketplaces instead, skip to submitting the close file.
- Select the entire SKU column (Column A), then right-click and copy it
- Click the New sheet button (the + button on the bottom left of the window)
- On the new sheet, right-click on Column B and click Paste
- Enter the word action as the header for Column A
- Enter the word EDIT in every row in Column A, after the word action. A shortcut to apply this to every row is to enter it into row 2, then with it selected, double-click the bottom right corner of that box to apply it all the way down
- Enter Close on [Chosen Marketplace] as the header for Column C. For example “Close on Amazon”. For a full list of Close on [Marketplace] commands refer to the Quick Reference: Close Feed Formatting section.
- Enter TRUE underneath every row in Column C. Use the shortcut in step 14 to quickly fill all rows in
- Select both columns A, B and C together by first clicking on Column A, then hold the shift key and select the last row Column C while holding shift. Then right-click and copy them
- Open up Notepad from Windows and start a new blank document. Right-click and paste your columns into the blank notepad document
- Press the Delete key once, so the cursor is blinking after the last SKU in the list instead of on its own row. Note: If this step is missed, the feed will not be accepted by the tool.
- Click File and Save As, then save the text file in an easy location to access it the next step.
Submit the Close File
- Back in Neatoscan, click Inventory Management from the Home Screen
- Click on Inventory Tools (the red toolbox)
- Click on Feed Processing on the left
-
Go to the Submit Feed tab
-
Click the small button next to the Feed “...”
-
Locate your text file, select it, and click Open
-
Click the Validate button
-
If you see a blue checkmark, click Submit Feed
- If you see a red exclamation point, review previous steps or contact support@uprightlabs.com
Verify Inventory is Closed
- We recommend waiting at least 24 hours before physically pulling inventory after any bulk close. This is to allow time for pending orders to settle in case the product needs to be pulled prior to bulk removing inventory.
- To fully verify that inventory is closed on your marketplaces, you will need to log into each seller hub and check your active inventory totals to make sure everything has delisted properly.
Quick Process Actions
Run and open the report
- Click Reporting from the Home Screen
- Set the report Type to Active Inventory V2 and click Submit
- Click Refresh Reports every so often until the Report Status shows Done
- Double-click on today’s Active Inventory V2 in the list and click Download
- Choose a location (use Documents if unsure) and click save
- Click OK once the download is complete
- The report should automatically open in Excel
Format the close file
- Select the entire SKU column (Column A), then right-click and copy it
- Click the New sheet button (the + button on the bottom left of the window)
- On the new sheet, right-click on Column B and click Paste
- Enter the word action as the header for Column A
- Enter the word DELETE in every row in Column A, after the word action. A shortcut to apply this to every row is to enter it into row 2, then with it selected, double-click the bottom right corner of that box to apply it all the way down
- Select both columns A and B together by first clicking on Column A, then hold the shift key and select Column B while holding shift. Then right-click and copy them
- Open up Notepad from Windows and start a new blank document. Right-click and paste your columns A and B into the blank notepad document
- Press the Delete key once, so the cursor is blinking after the last SKU in the list instead of on its own row. Note: If this step is missed, the feed will not be accepted by the tool.
- Click File and Save As, then save the text file in an easy location to access it the next step.
Submit the close file
- Back in Neatoscan, click Inventory Management from the Home Screen
- Click on Inventory Tools (the red toolbox)
- Click on Feed Processing on the left
- Go to the Submit Feed tab
- Click the small button next to the Feed “...”
- Locate your text file, select it, and click Open
- Click the Validate button
- If you see a blue checkmark, click Submit Feed
If you see a red exclamation point, review previous steps or contact Support.
Quick Reference: Close Feed Formatting
Use the formats below to prepare the close feed file you will submit in Neatoscan.
Follow the correct template based on whether you’re closing all marketplaces or just one.
Bulk Close on All Marketplaces
Action |
SKU |
DELETE |
12346789_ns |
DELETE |
12346790_ns |
Instructions:
- Copy the SKU column from the Active Inventory V2 report.
- Paste SKUs into Column B of a new Excel sheet.
- Type action as the header in Column A.
- Fill every row in Column A with DELETE.
- (Tip: type it once in row 2, then double-click the cell’s lower-right corner to fill all rows.)
- Copy Columns A & B, paste into Notepad, press Delete or Backspace for Windows, once so the cursor is at the end of the last SKU (not on a blank line).
- Save the file as a .txt file.
Bulk Close on One Marketplace
Action |
SKU |
Close on [Insert Marketplace] |
EDIT |
12346789_ns |
TRUE |
EDIT |
12346790_ns |
TRUE |
Instructions:
- Copy the SKU column from the Active Inventory V2 report.
- Paste SKUs into Column B of a new Excel sheet.
- Type "action" as the header in Column A and fill all rows with “EDIT”.
- Type Close on [Marketplace] as the header in Column C.
(Example: “Close on Amazon” or “Close on eBay”) - Fill every row in Column C with TRUE.
- Copy Columns A-C, paste into Notepad, press Delete once so the cursor is at the end of the last SKU (not on a blank line).
- Save the file as a .txt file.
Supported “Close on [Marketplace]” Commands
Use these exact phrases for the third column when closing a single marketplace:
- Close on Amazon
- Close on Amazon UK
- Close on Amazon DE
- Close on Amazon FR
- Close on Amazon ES
- Close on Amazon IT
- Close on Amazon CA
- Close on eBay
- Close on Half
- Close on Alibris
- Close on Abebooks
- Close on BigCommerce
- Close on Magento
- Close on Chrislands
- Close on Valore
Submission Tips
- Always remove the blank final line in the Notepad file before saving.
(Feeds with an extra empty line will fail validation.) - Validate the feed in Inventory Tools → Feed Processing → Submit Feed tab.
- ✅ Blue checkmark → click Submit Feed
- ❌ Red exclamation → review steps or contact support@uprightlabs.com
- If you close your inventory on all marketplaces, wait at least 24 hours before pulling physical inventory to allow pending orders to settle.
If you need assistance with this process at any time, please reach out to support@neatoscan.com