Run Settings

Before you start a run, you’ll be able to change several run-specific settings.

1. Input List

Shows the input file that you have selected and an estimated number of records.

For xls or xlsx input files the number of records may be larger than expected. This is due to the way Excel saves formatted cells, even if they are empty.

2. Product ID Type

Auto-detected from your input if possible.

PC2 supports the following types of product identifier:

ID Type	Description	Triggers

ID Type	Description	Triggers
ASIN	10 digit Amazon’s standard identification number	ID Lookup
EAN	13 digit European Article Number	ID Lookup
UPC	12 digit Universal Product Code	ID Lookup
ISBN 10/13	10 or 13 digit International Standard Book Number	ID Lookup
Keywords	Search word or phrase of any length	Keyword Search
SellerSKU	The SKU as used in your listed Amazon inventory	SKU Lookup - only your already listed items

ID Lookup is the fastest option for identifying matching Amazon listings.

Keyword Search can be slower, but if other identifiers are unknown or unavailable allows you to search for products as if you were searching online, such as by MPN or product title.

SellerSKU is a special option that will return only items that you have already listed in your Amazon inventory. They are looked up quickly by your own SKU. This option may not be useful for finding new products, but could allow you to, for example, assess the benefits of converting your Merchant Fulfilled portfolio to Amazon fulfilled.

PC2 will in the vast majority of cases detect types and columns correctly.
If not, the input file may be in a complex or difficult-to-parse format. To optimise your file, remove company headers, empty columns and rows, and clearly label each column, then try opening it again.
This will also make it easier to select the correct type and columns manually if you need to.

‘File has headers’

If checked, the first row will be interpreted as column headings/titles.

If unchecked, the first row will be considered regular data and passed through analysis.

Product ID column

This is the column in which PC2 should expect to find your Product IDs. Select the correct column if this doesn’t match what you know about the file.

Remove Duplicates

By default PC2 will filter out duplicated IDs. However, in some cases you may want to keep them, such as liquidation lots with separate positions and costs of the same product. Uncheck this option to keep all entries.

4. Cost Column (optional)

This is the column in which PC2 should expect to find your costs, if any.

If costs are specified (you don’t have to), PC2 will be able to calculate profits, ROI, etc for you.

5. Supplier Multipack Column (optional)

This is a special column which allows PC2 to adjust costs based on case-pack or carton-pack quantities and prices, pallets you need to split up or prep into new multi-packs, etc.

If this column is specified, costs are interpreted as if they were for the multi-pack quantity in this column.

If it isn’t specified, costs are interpreted per single unit.

Examples:

Input Cost	Supplier Multipack	Amazon Multipack	Cost per single	Cost per unit-as-sold

Input Cost	Supplier Multipack	Amazon Multipack	Cost per single	Cost per unit-as-sold
$10	1	1	$10	$10
$10	2	6	$10/2 = $5	$5 x 6 = $30
$5	1	4	$5	$5 x 4 = $20
$100	40	4	$100/40 = $2.50	$2.50 x 4 = $10
$100	40	1	$100/40 = $2.50	$2.50

6. Costs are in
7. Return profits in

PC2 supports a variety of input and output currencies, and Amazon’s marketplace use a variety of transaction currencies. To normalise profit figures the different exchange rates need to be accounted for.

PC2 downloads live rates multiple times a day and can help you convert between currencies, for example if you buy in GBP but sell in USD, or vice versa.

If you select “Marketplace Currency” for profits, PC2 will convert any relevant figures into the same currency as the market operates in. For any other combination the following conversions will take place:

From the cost currency to the profit/operating currency (only if different).
From the marketplace currency to the profit/operating currency (if different).

8. Marketplace to Analyze

This is the marketplace against which you wish to run your list. You can only choose a market for which you have valid MWS Keys.

9. Cost Profile

PC2 can make your profit estimation more accurate by including a variety of additional costs.

If you have a single cost profile, you can make basic adjustments, or click ‘Advanced’ to fine-tune or create multiple profiles.

If you already have multiple profiles configured, this section will show a drop-down selector from which to pick.

10. Additional Options

Historical Data

This is enabled by default. Our historical data stream serves data such as “Is Amazon a Seller”, certain editorial information (feature bullets, description, UPC/EAN lists), and of course historical averages. It can be turned off to save bandwidth and speed up a run.

Get Variation Reviews

This is disabled by default.

Variations are the different colours, styles, sizes, etc, which Amazon provide as options to choose from on a single product.

Amazon normally provides a headline figure for review could and average rating, which is the same for all variations. This option forces PC2 to make additional requests to discover the rating for each individual variation, however, please be aware that this can be very, very slow.

Grab all Variations