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 |
|---|---|---|
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 |
|---|---|---|---|---|
$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
This is disabled by default.
For many products a specific UPC will link to just one colour of that product, for example “T-Shirt - Yellow - Size M”. Enabling this option will cause PC2 to discover all other variations of the same product, e.g. “Red Size M”, “Yellow Size S”, “Red Size S”, etc.
The cost and other input data will be cloned from the original variation that was in your file.
This will slow down the run in direct proportion to the number of additional products discovered.
Change Output File
Please see https://pricechecker2.atlassian.net/wiki/spaces/PC2/pages/229429