What Does the Listings Configuration Sheet Include?

The Listings Configuration sheet is part of the Inventory & Listings configuration file, and it is used to set up cost structures, configure repricing settings, repricing methods and more.

1. How to Import and Export the File

2. Cost Structure

3. Floor Price Calculations and Validations

4. Repricing Methods

5. Additional Columns

6. Mandatory Fields

Import and export

Click here to learn how to import and & export this file

Cost Structure

These columns are the cost elements for which the floor prices are calculated, in accordance with the desired profit amount (Desired Markup- column J).

Columns that are grayed out are read-only fields containing data Feedvisor receives from Amazon.

Floor Price Calculator and Validations

Based on the values in the Cost Structure columns, you will be able to see:

• Suggested Floor Price (column L) - the minimal price for which you will make exact the desired profit.

• Profit at Floor price (column O) - the actual profit made when selling at your floor price (column N), which isn't necessarily the suggested floor price.

• Your current Floor Price (column N) - this is the value that currently exists in the system. your floor price > current listed price

• Your Ceiling price (column P) - When the ceiling price is first calculated, the default value is twice the floor price. When editing the floor price, the set ceiling price will not follow the floor price.

The Excel file includes color code validations:

Red - Will cause import failure OR negative profit.

Yellow - Warning, these changes might have a negative profit.

For the full validation list (or Dos and Don'ts) please click here

Repricing Methods and Targets

The following columns allow you to enable or disable repricing of SKUs and set up their Repricing Methods and Repricing Configurations, such as MAP, On-sale and more.

• Reprice - Select Yes / No to activate or disable repricing.

• Repricing Method - select between Buy Box Optimization, Target Velocity, Fixed Price or Liquidation

To learn more about the different Repricing Methods, click here

• Minimum Advertised Price ($) - the Minimum Advertised Price for this item. If a value was entered, any price below it published by Feedvisor will be masked.

• Business Price - allows you to set the price and quantity bounds for sellers who are selling B2B on Amazon

• On-Sale Repricing - Publishing your items as on-sale attract more buyers. You may also set a specific repricing method for the on-sale period (i.e, Fixed price in the holiday season).

To learn more about the various Repricing Configurations, click here

Additional Columns

• Buy Box Share - the daily buy box share, as calculated at the time of export.

• Shipping price on Amazon - The shipping price charged and listed on Amazon - this is not the Shipping Cost (Est. Fulfillment Cost) for FBM items

• Comment - A free text box, add any comment you like, and it will appear in the Product Slider (and vice versa)

Mandatory fields for the Listings Configuration Sheet

ASIN, SKU, and Fulfillment Channel (blue) are required columns for making any changes to any of the other fields on this sheet.

The column heading title must remain unchanged.

• Repricing Settings Only file

• Floor Price Only file

• Repricing Settings and Floor file

For Non- Amazon Listings, Listing ID column is required.