How to Reprice in Bulk
How do you get rid of stale inventory on Amazon? Keeping old non selling inventory is bad for business. Aged inventory hurts cashflow, incurs storage fees and affect your IPI score. You lose out on potential gains from recycling your money on profitable inventory. If it doesn’t sell in 90 days, time to get rid of it. Here is how you can do it in bulk.
Reprice it in Bulk
At this point I hope you are using a repricer. If you have a small amount of skus, this article may not help you anyways as it’s more efficient to just reprice one by one. We will also assume your repricer has a bulk upload feature. Two repricers that has this is GoAura and Profit Protector Pro. We will go over how to do this with the latter repricer. We will also do this using Excel but this works in Google Sheets as well with a few tweaks.
Steps to Reprice in Bulk
Click on Manage Inventory Health report and request the download the csv
Setting up the Bulk file Steps
Open the downloaded file using Excel. You will see several columns. This report shows all your inventory at certain inventory ages. You want to look for the column that says inv-age-91-180-days. These are all Inventory older than 90 days but less than 180 days. Click any column header and select filter like below.
Now you only want to isolate 91 days -180 days. Filter and uncheck the 0 for this column. Also set the filter to 0 for all ranges other than column J. This will show you all inventory between 91-180 days and no inventory that fits the other date ranges.
Select zeros here on all other date ranges
Still with me? At this point you have all your 91-180 day inventory. This is an important step so make sure you don’t miss it. Right now Excel is showing you your filtered data. It didn’t get rid of it. This is an important distinction. It’s only hidden, not gone. If you were to copy the data now, you will still copy everything you filtered out. To copy only visible data, use this shortcut. On your keyboard, hit CTRL G. This will pull up the Go To window.
From here select Special then Visible cells only.
Now you are able to copy only the data that you see displayed instead of all the hidden data.
Next download your Inventory from your repricer. In Profit Protector Pro, Go to Bulk Inventory and download your In Stock Inventory.
Open the Repricer CSV and add a new tab. Then go back to your filtered Inventory file and copy over the sku column to the new tab.
In the repricer file, add a new column at the end and call it findsku.
Click on the empty cell below the header and type the VLOOKUP formula:
Hit enter. Apply the formula to all cells below in by “Double Clicking” the small square button in the bottom right hand corner.
Now any cell that says #N/A, that means those are NOT matching your sku list of 91-180 days. Any cell that returns the sku data is your filtered data you want.
Sort the findsku column by right clicking the header findsku>Sort>Sort A to Z. Delete all rows that show #N/A.
Now you want to Insert 2 new columns to set your new Max and Min Price. Right Click on MinPrice> Insert. Do the same for MaxPrice column.
Call these New columns NewMinPrice and NewMaxPrice
Then click on the empty cell and type this formula:
Note above formula sets the New Min Price to be 75% of the original Min Price. This is just an example. If you want to do 50% reduction, use .50 instead of .75.
Do the same for the Max Price and click the small square to apply the formula.
Minor step is to format the new columns to Number in case your repricer is picky.
This is another Important step so don’t miss it. You want to harden the data by getting rid of all the formulas. If you don’t do this, when you delete the old min and max price, you will get errors for your new price columns. Right click the top left triangle to select all data > Copy. Select All Then Select Paste Special > Values.
Now you can safely delete your old Min and Max Price column
Rename the new columns to MinPrice and MaxPrice so your repricer doesn’t complain. Review your final data and export to CSV. Upload to your new file to your repricer.
In this blog, we only demonstrated repricing 90 day old inventory. You can do this exercise for 180 days or older and be more aggressive in your pricing. You can also change the repricing strategy as well. Get creative with it.
Thank you for reading! See you on our next blog!