Listing a Product That Exists in Amazon's Catalog Using a Spreadsheet

If the product you want to sell has already been added to Amazon's catalog, you can easily add yourself to the existing listing through Solid Commerce using a UPC, ISBN, EAN, or ASIN.

NOTE:

This listing process works for Amazon.com (in the U.S.) and all of the international Amazon marketplaces.

 

If you need to create new listings in Amazon's catalog, please see Creating New Catalog Listings on Amazon Through Solid Commerce.

You can create new merchant fulfilled listing through Solid Commerce. To turn your merchant fulfilled listings into FBA listings, see Amazon's help article Listing products for Fulfillment by Amazon.

 

In this article:

  1. Before You List to Amazon
  2. Explanation of the Product Identifiers You Can Submit to Amazon
  3. Required Fields
  4. Optional Fields
  5. Uploading Your Spreadsheet
  6. Downloadable Excel Example of an Amazon Product Listing
  7. Related Articles

 

Before You List to Amazon

Before you can list, you need to connect to your Amazon account. If you haven't done so, please see Connecting to Amazon Marketplaces, Amazon FBA, and Amazon Webstore.

 

Explanation of the Product Identifiers You Can Submit to Amazon

This table contains information about ASINs, UPCs, ISBNs, and EANs. It also describes how we submit these product identifiers to Amazon to list your items.

Identifier Description and Listing Information
ASIN

The Amazon Standard Identification Number is a unique product code that Amazon assigns to each listing.

When listing products, we give the ASIN priority over any other product identifier. If you provide both the ASIN, and another identifier, like the UPC, we will ignore the UPC and send the ASIN to Amazon.

If you don't have the ASIN for your product, but want to use it to list, you will need to find the ASIN on Amazon and supply it to Solid Commerce. That is not usually convenient, so many people list via the UPC instead.

UPC

The Universal Product Code is 12 digit number. We assign it the second highest priority. If you provide a UPC and ISBN, we will send the UPC to Amazon.

IMPORTANT!

Each UPC should only exist in Amazon's system once. However, sometimes the same UPC gets assigned to multiple ASINs. Other times UPCs get assigned to the incorrect listings.

That means that Amazon may not match your UPC to the correct listing. We have developed safeguards to protect you from ending up on the incorrect listing when there are multiple matches, but we cannot catch every mismatch.

ISBN You can provide the International Standard Book Number if you are listing a book.
EAN

The International Article Number is most common in Europe. In the United States, and many other parts of the world, products are assigned UPCs instead.

 

Required Fields

Field Name
Field Description and Valid Values
results Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool.
product custom sku

The SKU of your product.

warehouse id The Warehouse ID of your product.
amazon item asin

If you have the ASIN for your product, you can provide it with your other Amazon information.

You can also use this field to help you list the same item on multiple ASINs. To learn how, see Creating Multiple Listings for One Product (Product Merge).

upc, isbn, or ean

If you don't provide an ASIN, you must provide one of these product identifiers. We will use the value to match your item to a listing in Amazon's catalog.

We recommend including the UPC, ISBN, or EAN with your other Product level fields so you can set the identifier when you create your products. Our downloadable template has these fields on the Products & Inventory tab.

amazon sell price exp

This field controls the price of your item on Amazon.

To populate this field, you may enter a number without a currency symbol (up to two decimal points). You can also enter the word cost, or simple formulas with the word cost, such as cost*1.5 or cost+5. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well.

There is no currency associated with this field. Entering 5 will display as 5 U.S. dollars on amazon.com or 5 pound sterling on amazon.uk. We don't do any currency conversion.

If you are using an Amazon repricing rule, this is the value we will use to calculate your floor, ceiling, and no other sellers prices (unless you provide these values on an listing-by-listing basis).

IMPORTANT!

If you upload files through the web uploader in your Solid Commerce account, instead of uploading directly from Excel through the Add-In tool, please use the column header amazon sale price exp instead of amazon sell price exp. We are currently adding support for both column headers. However, at this time, the uploader only recognizes amazon sale price exp.

 

market auto rule

The name of the Amazon Pricing Rule you want to use on your listing.

Amazon Pricing Rules specify how we should set your price. The rules include fixed price and automated repricing options.

list name The name of your Amazon Market List in Solid Commerce.
po sources The name of the Warehouse(s) Solid Commerce should use as the inventory source for your listings.
amazon qty exp Enter lq in this field if you want to make your entire inventory available on Amazon. You can also enter formulas. See Using the Listing Quantity Expression to Control the Quantities on Your Listings for more.
run amazon

Enter Yes to turn the automation on. Automated items are automatically submitted to Amazon for listing.

If you enter No, your product will not list until you turn the automation on.

amazon condition (required for conditions other than New)

If you don't provide Solid Commerce with an Amazon Condition, by default, we will submit your item in new condition.

If you sell items in conditions other than new, please include this column in your file.

Valid Values:
new, refurbished, used acceptable, used good, used like new, used refurbished, used very good, collectible acceptable, collectible good, collectible like new, collectible very good

amazon comments (required for conditions other than New)

If you list an item that is not in new condition, Amazon requires that you provide a Condition Note.

The comment is supposed to be about the condition of the product. It is visible below each sellers' name when a buyer views all of the sellers available on a listing.

 

Optional Fields

The following table includes the most popular optional fields.

To see a complete list of fields, click on the Manage Excel Columns in the Solid Commerce Excel Add-In Tool. For more information on using the Manage Excel help, please see Creating and Customizing a Solid Commerce Excel Template.

Field Name
Field Description and Valid Values
product name
Pasting your Product Names into the Amazon Existing tab of your spreadsheet can make it easier to see which products you are working on.
amazon shipping template name

Enter the name of one of the shipping templates you created in your Amazon Seller Central account.

If you leave this field blank:

  • For new listings, Amazon will assign your default shipping template.
  • When updating existing listings, the current template will remain assigned.
amazon leadtime to ship

The maximum number of days between when an order is placed and when you ship it. If you do not include this column in your file, Amazon will set your lead time to their default of 1-2 days. If you include the column, but do not provide a value, Amazon will also use their default of 1-2 days.

Valid Values:
Enter a single whole number between 1 and 30. You don't need to define a range or use the word "days."

amazon onsale price exp

A sale price that is different than the standard price.

One option for populating this field is to enter a number without a currency symbol. The other option is to enter the word cost, or simple formulas with the word cost, such as cost*1.5 or cost+5. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well.

There is no currency associated with this field. Entering 5 will display as 5 U.S. dollars on amazon.com or 5 pound sterling on amazon.uk. We don't do any currency conversion.

If you supply an amazon onsale price exp, you must also provide an amazon sale start date and an amazon sale end date.

Any changes to the standard price on Amazon removes the on sale price. You should use a fixed price rule on sale items, not a repricing rule.

amazon sale start date The date the sale price will begin overriding the product's standard price on Amazon.
amazon sale end date The last date the sale price will be displayed on Amazon. Only the standard price will be displayed after this date.

 

Uploading Your Spreadsheet

ASIN, UPC, ISBN, and EAN are Product Level fields. We included the UPC with the other product information on the Products & Inventory tab of our template. If you included any of these fields with your Amazon specific information, you will need to check the Product update option during upload.

To use our Excel Add-In Tool to upload the Amazon Existing tab of the attached template, click the Upload Data button, and check only the Update Marketplace box.

amazon_integration_excel_marketplace_update.png

 

To upload the Amazon Existing tab through our web uploader instead, go to the Products menu -> Import Products and Inventory. Check the Import Marketplace box and select Amazon from the Select marketplace drop-down.

amazon_integration_web_uploader.png

 

NOTE:

Our listing service runs on a cycle. It may take up to 15 minutes for us to submit your items to Amazon. We only submit items that have the automation turned on.

 

Downloadable Excel Example of an Amazon Product Listing

The example product included in this template is ready to be listed by UPC.

 

Related Articles

 

Attachment from the Downloadable Excel Example of an Amazon Product Listing section:

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.