As an Amazon seller, keeping your inventory organised is key to running a successful store. Whether you’re clearing out old stock or removing underperforming products, deleting listings in bulk can save you time. One of the best ways to do this is by using a flat file, a spreadsheet tool that lets you manage multiple listings at once. In this guide, we’ll walk you through how to delete product listings on Amazon Seller Central using a flat file, covering both the old and new interfaces. This process works for sellers worldwide, and we’ll make it simple to follow.
For expert help with your Amazon business, consider partnering with a UK agency for Amazon sellers.
What Is a Flat File and Why Use It?
A flat file is a spreadsheet template provided by Amazon that allows you to upload or edit multiple product listings in one go. It’s a time-saver for tasks like updating inventory or deleting listings, especially if you manage a large catalogue.
Why use a flat file to delete listings?
- Speed: Delete many listings at once instead of one by one.
- Accuracy: Avoid errors that might happen with manual deletion.
- Control: Perfect for sellers with big inventories who need a scalable solution.
Let’s get started with the steps for each interface.
Deleting Listings via Flat File (Old Interface)
If you’re using the older Seller Central interface, here’s how to delete listings with a flat file.
Step 1: Log In to Seller Central
- Go to Amazon Seller Central.
- Sign in with your credentials.
Step 2: Download the Template File
- Navigate to Catalogue > Add Products via Upload
- Under "Download Templates", click Download an Inventory File.
- Select the category-specific inventory file that matches the product you want to delete.
- Download the file.
Step 3: Fill Out the Template
- Open the file in Excel or your preferred spreadsheet software.
- Add these details:
- SKU: Enter the SKU of the product you’re deleting.
- Product Delete: In the "Action" column, type "DELETE".
- Save the file as .txt or .xsl.
Step 4: Upload the File
- Return to Catalogue > Add Products via Upload.
- In the "Upload File" section, click Choose File, select your saved file, and click Upload.
Step 5: Monitor Processing Status
- Check the progress by going to Monitor Upload Status.
- Review the Processing Report to confirm success or spot any errors.
Step 6: Verification
- Head to Manage Inventory and ensure the listing is gone.
Deleting Listings via Flat File (New Interface)
For those using the updated Seller Central interface, the process is nearly the same with a few small differences.
Step 1: Log In to Seller Central
- Visit Amazon Seller Central.
- Log in with your credentials.
Step 2: Download the Template File
- Go to Catalogue > Add Products via Upload.
- Under "Download Blank Templates", select Download an Inventory File.
- Pick & download the category-specific inventory file for the product you’re deleting.
- Click the 'product template' hyperlink.
- Select your product browse nodes and relevant stores, then click 'Generate spreadsheet.'
Step 3: Fill Out the Template
- Open the file in Excel or another spreadsheet tool.
- Fill in:
- SKU: Add the SKU of the product to delete.
- Product Delete: In the "Action" column, enter "DELETE".
- Save it as .txt or .xsl.
Step 4: Upload the File
- Back in Catalogue > Add Products via Upload, click Choose File in the "Upload File" section.
- Upload your saved file by clicking Upload.
Step 5: Monitor Processing Status
- Go to Monitor Upload Status to track the process.
- Check the Processing Report for confirmation or errors.
Step 6: Verification
- Visit Manage Inventory to verify the listing has been removed.
Tips for Success
Here are some pointers to make the flat file process smoother:
- Test First: If you’re new to this, start with a small batch to get the hang of it.
- Check SKUs: Double-check your SKUs to avoid deleting the wrong items.
- Backup Files: Save copies of your flat files in case you need to troubleshoot.
Want to dig deeper into managing your Amazon store? Check out What are the Amazon selling fees? To understand how costs affect your profits.
Take Control of Your Inventory Today
Using a flat file to delete product listings is a fast, reliable way to keep your Amazon store tidy and efficient. Whether you’re on the old or new Seller Central interface, these steps will help you clear out listings with ease. Ready to grow your business further? A UK agency for Amazon sellers can provide the expertise you need. Start streamlining your inventory now!