Creating New Catalog Listings on Amazon Through Solid Commerce

This article covers creating brand new listings in Amazon's catalog through Solid Commerce. To list through Solid Commerce, you must use one of Amazon's Templates for specific categories (Flat Files). We'll show you how to reformat your Flat File so you can upload it into your Solid Commerce account.

NOTE:

This listing process works for all of the international Amazon marketplaces. However, we are currently building support for international Flat Files one at a time as they are requested by clients. We are working on full documentation for the international Amazons, which will include a list of all supported categories. In the meantime, please contact support to see if the category you want to list to is supported. We apologize for the inconvenience.

 

If you're interested in adding yourself to listings that already exist in Amazon's catalog using a UPC, ISBN, EAN, or ASIN, please see Listing a Product That Exists in Amazon's Catalog Using a Spreadsheet.

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.

 

Downloadable Template: Solid Commerce Columns to Use With Amazon Flat Files.xlsx

This template contains the most common columns people use when reformatting their Amazon Flat Files for Solid Commerce. It also includes a Products & Inventory tab for creating new products in Solid Commerce and adding them in a Warehouse.

 

What we'll cover:

  1. Before You Create New Listings on Amazon
  2. Amazon Flat Files & Browse Tree Guides (BTG)
  3. Creating Your Solid Commerce Template
  4. Required Fields
  5. The Popular Used Optional Solid Commerce Fields
  6. Amazon Variations
  7. Uploading Your File
  8. Related Articles

 

Before You Create New Listings on Amazon

Before you can create listings, you need a Warehouse (or Vendor Inventory List), an Amazon Market List, and an Amazon Pricing Rule.

You also need to add your products to Solid Commerce and save them in a Warehouse.

For more information about these topics, see the Related Articles section.

 

Amazon Flat Files & Browse Tree Guides (BTG)

In order to list through Solid Commerce, you need to download the Flat File template and Browse Tree Guide (BTG) for your category directly from Amazon. To learn how, see Finding Amazon Templates for Specific Categories (Flat Files).

If you are new to creating catalog listings on Amazon, the file may look intimidating. However, you only need to populate a small percentage of the fields. Each Flat File also includes valuable documentation to help you populate the template.

The Data Definitions tab is the most useful. It defines each column, identifies required fields, and specifies the formatting for the field. It also provides some valid values.

The Valid Values, Example, Instructions, and Images tabs will also help you create your first listings. The Template tab is the sheet you actually populate to create your listings.

NOTE:

When populating the item_type column in many Flat Files, you may need to refer to Amazon's Browse Tree Guide (BTG) for a list of valid values. The Item Type determines the subcategory of your item. It allows buyers to find your listing when browsing.

 

Creating Your Solid Commerce Template

1) Delete the top two rows from Amazon's Flat File. Row 3 will become your column headers.

2) Copy all of the columns from Amazon's Flat File.

3) Download and open the template included with this article: Solid Commerce Columns to Use With Amazon Flat Files.xlsx. Paste the Amazon column headers to the right of the last header in the template (amazon sale end date).

  • You can rearrange the columns—the order doesn't matter.
  • You can also delete, or hide, any columns that Amazon does not require for your category (consult Amazon's Data Definitions tab before deleting columns).
  • Some of Amazon's fields are replaced by Solid Commerce fields. They are identified in the tables below. You can delete the corresponding Amazon columns.

amazon_integrationl_flat_file_columns_added.png

 

4) Save the revised version of your file. You can use it as a template next time you want to create listings.

  • If you list across multiple Amazon categories, you will need to use multiple Amazon Flat Files.

 

Required Fields

Required Fields Field Descriptions 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.

We submit the warehouse id to Amazon in their item_sku field. You can delete the item_sku field from your Flat File.

amazon title

The title for your product. Amazon has a limit of 500 characters. They don't allow Type 1 High ASCII characters, such as ®, ©, ™, or other special characters.

We submit the title to Amazon in their item_name field. You can delete the item_name column from your Flat File.

amazon description

This field allows you to create a product description specifically for Amazon. Amazon has a limit of 2,000 characters. They don't allow Type 1 High ASCII characters, such as ®, ©, ™, or other special characters.

If you don't provide an amazon description, we will submit the description saved in the general description field. The description field can also be used for other marketplaces.

We submit the description to Amazon in their product_description field. You can delete the product_description column from your Flat File.

amazon catalog

Select the Solid Commerce catalog name that corresponds to the name of the Flat File you are using.

Click the Turn inline help ON button in the Solid Commerce Excel menu, and a drop-down list with the valid catalog names will appear in your file. The list is also available if you open the Manage Excel Columns help from the Solid Commerce menu.

amazon sell price exp

This field controls the price of your item on Amazon.

One option 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.

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 a listing-by-listing basis).

We submit your price to Amazon in their standard_price field. You can delete the standard_price column from your Flat File.

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.

We will submit the correct quantity to Amazon. You can delete the quantity column from your Flat File.

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.

external_product_id

This field is independent from the Solid Commerce UPC, ISBN, and EAN fields. Even if you have provided Solid Commerce with a UPC, ISBN, or EAN, you still need to populate Amazon's external_product_id field (unless Amazon has granted you a UPC exemption).

external_product_id_type

This field is independent from the Solid Commerce UPC, ISBN, or EAN fields. Even if you have provided Solid Commerce with your UPC, ISBN, or EAN, you still need to populate the external_product_id_type field.

Use it to specify the type of product identifier you entered in the external_product_id field.

Valid Values:
UPC, ISBN, EAN, ASIN, GCID

GCID stands for Global Catalog Identifier. Amazon generates the GCID as part of their brand registry program. The brand registry program was created for sellers that don't have standard identifiers for their products. You must apply to participate in the brand registry program.

If you are part of the brand registry program, you can leave the external_product_id and external_product_id_type fields empty. Amazon will generate a GCID after you list.

If you participate in the brand registry program and sell some products that have standard product identifiers, it is recommended that you provide the identifiers when they are available.

update_delete

This is an Amazon field, not a Solid Commerce field. Please leave it blank. We only send "updates" to Amazon.

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.

 

The Most Popular Optional Solid Commerce Fields

There are few additional fields available beyond the commonly used fields detailed in the following table. You can view all the Amazon fields by selecting the Solid Commerce menu in Excel, and clicking on the Manage Excel Columns button.

Common Optional Fields Field Descriptions and Valid Values
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.

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.

We submit this price to Amazon in their sale_price field. You can delete the sale_price column from your Flat File.

amazon sale start date

The date the sale price will begin overriding the product's standard price on Amazon.

We submit this date to Amazon in their sale_from_date field. You can delete the sale_from_date column from your Flat File.

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.

We submit this date to Amazon in their sale_end_date field. You can delete the sale_end_date column from your Flat File.

Amazon Variations

To create new variation listings on Amazon, you follow Amazon's variation format, as specified in their Flat Files. You will use Amazon's parent_child, parent_sku, relationship_type, and variation_theme columns.

IMPORTANT!

Unlike in Amazon's instructions, populate the parent_sku field for your parent item as well as all child items.

In Solid Commerce, we automatically transfer the parent_sku you provided in your file to our Parent SKU field. The Parent SKU is displayed in your Solid Commerce Amazon Market List, making it easy to visually confirm the relationship between the items in your families through our user interface.

 

 

Uploading Your File

The Amazon Description is a Product Level field. We included it with the rest of the product information on the Products & Inventory tab of our downloadable template. If you include the Amazon Description column on your Amazon Flat File worksheet, you need to check the Product update option during upload.

To use our Excel Add-In Tool to upload your modified Flat File, click the Upload Data button. Check only the Update Marketplace box.

rakuten_integration_excel_marketplace_update.png

 

To upload your modified Flat File through our web uploader instead, go to the Products menu -> Import Products and Inventory. Check only the Import Marketplace box. Select Amazon from the Select marketplace drop-down.

amazon_integration_web_uploader.png

 

If the automation is turned on for your item, it will automatically enter the queue to list. For confirmation, search your Amazon Market List and look in the Last Listing Results column.To get fresh listing results, you need to refresh your search.

amazon_new_listing_tool_last_listing_results_ui.png

 

If the automation is turned off, your item will not list until you turn the automation on.

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.

 

Related Articles

 

Back to top

 

The attachment from the top of the article:

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.