Sellers holding larger inventories can find it easier to manage repricing from a spreadsheet.
Profit Protector Pro have a Bulk Inventory Management system in place for this. Click on the Bulk Inventory tab on the left.
From here sellers can download repricing data in CSV format to then amend in a spreadsheet and upload to update multiple Profit Protector Pro at one time.
The data columns that can be amended in these files are:
Buy Prices
Min and Max Prices
Break Even
Cost Price
Repricing strategy
Small & Light status
EFN/Pan status
Amending the other columns that appear in the CSV file won’t be saved to be uploaded and altering them will likely disrupt the results in Profit Protector Pro.
In the Bulk Inventory Management screen there are four options for which data to download as a CSV file:
The full inventory
Only inventory currently in stock
A blank CSV template with assigned columns ready to be filled out
Inventory according to selected filters
Choosing Download Inventory CSV By Filters option will open a pop-up with the filter options to whittle down which listings to download and amend.
Click on Show Strategies to choose and additional filters will appear to filter out listings by their current strategy.
To download the CSV file and it’s date into a spreadsheet, click on Export.
The spreadsheet will show the following dataset columns of Profit Protector Pro data:
SKU
ASIN
Min Price (editable)
Max Price (editable)
Buy Price (editable)
Break Even Price (editable)
Marketplace
Current Strategy – shown in ID format (editable)
Custom Strategy in place
Listing Title
Automation in place
If it is a Small & Light listing (editable)
EFN/Pan listing (editable)
VAT Override
From here the data can be amended the columns, but take care to only edit the data from the six columns marked as editable.
Each strategy has its own identifying code. The Strategy ID codes to input into that column can be found in the Bulk Inventory screen.
To change either the EFN/PAN or Small & Light status, enter “0” to turn them off and “1” to turn them on.
Save any changes to a new file location.
To upload an edited CSV file, click on Upload Inventory CSV. Find and select the required file and click on Upload to apply the changes to the inventory.
BEWARE: Any changes you have made will override the data in Profit Protector Pro, so be sure that the amendments are correct before uploading.