This article describes the process for creating brand new listings on Amazon through Solid Commerce using our Excel Add-In Tool.
If you'd like to add 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.
Just like when you create new listings directly on Amazon, new products listed through Solid Commerce appear on Amazon as fulfilled by merchant. To turn your merchant fulfilled listings into FBA listings, see Amazon's Seller Central help article Listing products for Fulfillment by Amazon.
What we'll cover in this article:
- Downloading a Listing Template From Amazon Seller Central
- Populating Your Template With Products
- Modifying Your Template for Solid Commerce
- Required Fields
- Most Commonly Used Optional Solid Commerce Fields
- Listing Variations
- Uploading Your File
- Updating Your Live Amazon Listings
- Mandatory attributes for select product types (required as of July 05, 2023)
- Downloadable Template With Solid Commerce Columns to Add to Your Amazon Template
- Related Articles
Downloading a Listing Template From Amazon Seller Central
To list through Solid Commerce, you will use Amazon's template as a starting point. Downloading a template from Seller Central is a one-time process. Once you customize the Amazon template to work with Solid Commerce, you can save it and use it the next time you want to list new products.
To download a template from Amazon:
1) Login to Seller Central.
2) Go to the Catalog menu -> Add Products via Upload.
3) Select the "Download Spreadsheet" tab at the top of the page if it isn't already selected.
4) Choose a template to get started:
5) In the "STEP 1: SELECT THE TYPES OF PRODUCTS YOU WANT TO SELL" section, use the "Product Classifier" interface or the search tool to find the end leaf category that you want to list your products to. Click the Select button to add that category to your template.
- If you want to add more categories to your template, continue to select them through Amazon's interface. The categories don't have to be related to each other.
6) In the "STEP 2: SELECT THE TYPE OF TEMPLATE" section, select Advanced.
7) Click the Generate Template button.
8) Your template will download.
Populating Your Template With Products
Follow the requirements in Amazon's template to populate it with some products.
If you've never populated one of Amazon's listing templates before, keep in mind that you don't need to populate most of the columns. Here is some brief info to make filling it out easier:
- The "Data Definitions" and "Example" tabs are extremely helpful. They have the answers to most questions.
- The "Instructions" tab provides some basic guidelines for populating the template.
- The "Images" tab documents Amazon's image requirements.
- The "Template" tab is the sheet that you populate and upload.
Modifying Your Template for Solid Commerce
Once you've populated your Amazon template with some items, you will insert a few columns into your template so that you can also add your items to Solid Commerce.
Amazon includes lots of complex macros in their templates. The macros will keep working if you add the Solid Commerce columns to Amazon's file. Copying Amazon's columns into the Solid Commerce file will also create a valid file, but Amazon's macros won't copy over.
Uploading files into Solid Commerce offers you some flexibility with Amazon's template:
- You can rearrange the columns. The order doesn't matter.
- You can delete or hide any non-required columns.
- Some of Amazon's fields are replaced by Solid Commerce fields. You can delete the corresponding Amazon columns. The fields that you can delete are identified in the tables below.
To add the Solid Commerce columns to your Amazon file:
1) On your Amazon file, select the Review tab in the Excel ribbon menu.
2) Click the Unprotect Sheet button in the "Protect" section.
3) Delete the top two rows from Amazon's template. Row 3 will become your column headers.
4) Download and open the template attached to this article, Solid-Commerce-Columns-for-Amazon-Listing-Templates.xlsx.
5) Select all of the columns that have column headers and copy those columns.
- Don't just select the cells in row 1 that have the column headers in them. To select the entire columns, click on the letter A above the "results" column header. Hold down shift. Click on the letter R above the "amazon sale end date" column header on the right.
6) On the Amazon template file, select column A. Right click and select Insert Copied Cells. Your file should now have all of the Solid Commerce columns on the left and the Amazon columns on the right.
Required Fields
Wherever you see a value in the "Replaces Amazon Field" column of this table, you can delete that Amazon column from your template. Use the Solid Commerce field instead.
| Required Fields | Replaces Amazon Field | Field Descriptions and Valid Values |
| results | Leave this field blank. It will automatically populate when you upload the file using the Solid Commerce Excel Add-In Tool. | |
| product custom sku |
|
The SKU of your product. |
| warehouse id |
item_sku |
The Warehouse ID of your product. |
| amazon title |
item_name (productName in some templates) |
The title for your listing. |
| amazon description | product_description |
The amazon description field allows you to provide a product description that is unique to Amazon. If you don't provide an amazon description, we will submit the description saved in our general description field, which you can find on the "Products & Inventory" tab of the attached template. The general description can also be used for other marketplaces. |
| amazon sell price exp |
standard_price |
This field controls the price of your item on Amazon. You have two options for populating it:
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 through the "by item param" fields). |
| 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 |
quantity |
Enter lq in this field if you want to make your entire inventory available on Amazon. You can also enter formulas if you prefer. For more options, see Using the Listing Quantity Expression to Control the Quantities on Your Listings. |
| 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 catalog |
|
Use the value: Get from 'feed_product_type' Amazon's feed_product_type column determines the category. |
| 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. If Amazon has granted you a UPC exemption, you can leave this field blank. |
| external_product_id_type |
|
Use this field to specify the type of product identifier (UPC, EAN, etc.) you entered in the external_product_id field. |
| amazon condition (required for conditions other than New) |
condition_type |
If you don't provide Solid Commerce with an Amazon Condition, we will submit your item in New condition. If you sell items in conditions other than new, include this column in your file. If you click on the Turn inline help ON button in the Solid Commerce Excel Add-In Tool menu, a drop-down menu with valid values will appear in this column. |
| amazon comments |
condition_note |
You can use this field if you list an item in used, collectible, or refurbished condition. The comment allows you to provide details 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. |
Most Commonly Used Optional Solid Commerce Fields
The table below documents the most commonly used optional fields. A few additional optional fields are available. You can view them by clicking on the Manage Excel Columns button in the Solid Commerce Excel Add-In Tool menu.
Wherever you see a value in the "Replaces Amazon Field" column of this table, you can delete the Amazon column from your template. Use the Solid Commerce field instead.
| Popular Optional Fields | Replaces Amazon Field | Field Descriptions and Valid Values |
| update_delete |
|
You can leave this field blank. We automatically send full updates for items that don't have an ASIN in Solid Commerce yet. If your item is online in Solid Commerce, we automatically submit a partial update containing whatever Amazon data we have. |
| amazon shipping template name |
merchant_shipping_group_name |
Enter the name of one of the shipping templates you created in your Amazon Seller Central account. If you leave this field blank:
|
| amazon leadtime to ship | fulfillment_latency |
Amazon includes handling time as a field in two of their processes:
We manage the handling time for both processes with our amazon leadtime to ship field. If you ever update the amazon leadtime to ship in Solid Commerce, we will automatically submit the new handling time the next time we send an inventory update. If you want to update it faster, select the item in your Amazon Market List and click the Update Listings button. If you leave this field blank, Amazon will use their default value of one to two business days. |
| amazon onsale price exp |
sale_price |
This is a sale price that is lower than the standard price. You have two options for populating this field:
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. In Solid Commerce, you should apply a fixed price rule to items with sale prices, not a repricing rule. |
| amazon sale start date |
sale_from_date |
The date the sale price will begin overriding the product's standard price on Amazon. |
| amazon sale end date |
sale_end_date |
The last date the sale price will be displayed on Amazon. Only the standard price will be displayed after this date. |
Listing Variations
To create variation listings on Amazon, follow Amazon's variation format. The "Data Definitions" tab of their template provides information on how to populate the variation fields. The "Example" tab shows how the fields look when they are populated.
Uploading Your File
Here's how you upload your file:
1) If you are adding new items to Solid Commerce, or updating product data on items that already exist in Solid Commerce, populate the "Product & Inventory" tab of attached template.
- If you're listing items to Amazon that already exist in Solid Commerce, you don't need to populate the "Product & Inventory" tab. You can skip to Step 5 of these upload instructions.
2) Once you populate the "Product & Inventory" tab, select the Solid Commerce menu in Excel.
3) Click the Upload Data button.
- For items you are adding to Solid Commerce for the first time, check both the Upload Product and Upload Inventory options.
- For items that already exist in a Solid Commerce Warehouse, check only the Upload Product option in the pop-up.
4) Click Confirm.
5) Select the Template tab of the Amazon file that you added the Solid Commerce columns to.
6) Click the Upload Data button. Select the Upload Product and Upload Marketplace options and click Confirm.
Updating Your Live Amazon Listings
We automatically submit quantity and price updates to Amazon. You don't need to take any action to trigger quantity and price updates besides making sure that the automation is turned on in Solid Commerce.
If you would like to update listing details such as the title, description, or images, please see our article Updating Listing Details on Live Amazon Listings.
Mandatory attributes for select product types
Amazon requires 25 attributes across these 52 product types. Required as of Jul 23, 2023:
| Product Type | Attributes |
| CELLULAR_PHONE_CASE | color |
| CELLULAR_PHONE_CASE | material |
| CELLULAR_PHONE_CASE | form_factor |
| TOY_FIGURE | is_assembly_required |
| TOY_FIGURE | material |
| RUG | color |
| RUG | material |
| RUG | item_shape |
| DRINKING_CUP | included_components |
| DRINKING_CUP | color |
| DRINKING_CUP | capacity |
| DRINKING_CUP | material |
| TOYS_AND_GAMES | material |
| BACKPACK | material |
| BACKPACK | age_range_description |
| BACKPACK | color |
| WALL_ART | color |
| CURTAIN | pattern |
| CURTAIN | color |
| CURTAIN | material |
| BLANKET | color |
| HEADPHONES | included_components |
| HEADPHONES | model_name |
| HEADPHONES | color |
| HEADPHONES | connectivity_technology |
| CHAIR | material |
| CHAIR | color |
| LAMP | material |
| LAMP | color |
| LIGHT_FIXTURE | color |
| LIGHT_FIXTURE | material |
| STICKER_DECAL | color |
| SKIN_MOISTURIZER | product_benefit |
| SKIN_MOISTURIZER | skin_type |
| WIG | color |
| WIG | hair_type |
| TABLE | color |
| TABLE | item_shape |
| SHELF | material |
| SHELF | item_shape |
| BED_LINEN_SET | pattern |
| BED_LINEN_SET | color |
| BED_LINEN_SET | material |
| BED_FRAME | included_components |
| BED_FRAME | color |
| BED_FRAME | material |
| PET_FOOD | specific_uses_for_product |
| PET_FOOD | age_range_description |
| BEDDING_SET | fabric_type |
| BEDDING_SET | color |
| ELECTRONIC_CABLE | connector_type |
| CABINET | color |
| CABINET | material |
| ARTIFICIAL_PLANT | color |
| ARTIFICIAL_PLANT | material |
| ART_CRAFT_KIT | color |
| SPEAKERS | model_name |
| PERSONAL_FRAGRANCE | scent |
| TABLETOP_GAME | included_components |
| TABLETOP_GAME | material |
| BOTTLE | material |
| SKIN_CLEANING_AGENT | scent |
| SKIN_CLEANING_AGENT | skin_type |
| TOY_BUILDING_BLOCK | material |
| FURNITURE | item_shape |
| FURNITURE | color |
| FURNITURE | is_assembly_required |
| TOWEL | color |
| HAIR_EXTENSION | installation_type |
| HAIR_EXTENSION | material |
| HAIR_EXTENSION | color |
| HAIR_EXTENSION | hair_type |
| COSMETIC_CASE | color |
| NAIL_POLISH | finish_type |
| NAIL_POLISH | color |
| DESK | color |
| DESK | item_shape |
| STORAGE_BOX | material |
| LIP_COLOR | skin_type |
| LIP_COLOR | product_benefit |
| LIP_COLOR | color |
| LIP_COLOR | finish_type |
| LIP_COLOR | skin_type |
| LIP_COLOR | product_benefit |
| LIP_COLOR | color |
| LIP_COLOR | finish_type |
| CELLULAR_PHONE | operating_system |
| CELLULAR_PHONE | color |
| BALLOON | occasion_type |
| NOTEBOOK_COMPUTER | model_name |
| NOTEBOOK_COMPUTER | operating_system |
| NON_RIDING_TOY_VEHICLE | material |
| MEAL_HOLDER | capacity |
| MEAL_HOLDER | material |
| MEAL_HOLDER | color |
| SUGAR_CANDY | flavor |
| SUGAR_CANDY | item_form |
| HOME_MIRROR | item_shape |
| VACUUM_CLEANER | model_name |
| VACUUM_CLEANER | color |
| DECORATIVE_PILLOW_COVER | color |
| FOOD_PREPARATION_MOLD | color |
| FOOD_PREPARATION_MOLD | material |
| FOOD_PREPARATION_MOLD | number_of_pieces |
| DECORATIVE_MAGNET | material |
| DECORATIVE_MAGNET | color |
| DECORATIVE_MAGNET | item_shape |
| PIPING_TIP | color |
| PIPING_TIP | material |
| PIPING_TIP | number_of_pieces |
Downloadable Template With Solid Commerce Columns to Add to Your Amazon Template
This template contains the columns that people most commonly use when reformatting their Amazon templates for Solid Commerce. It also includes a "Products & Inventory" tab for creating new products in Solid Commerce and adding them to a Warehouse.
Related Articles
- Connecting to Amazon Marketplaces, Amazon FBA, and Amazon Webstore
- Creating a Basic Amazon Fixed Price Rule
- Amazon Repricing: Creating an Automated Repricing Rule
- Listing a Product That Exists in Amazon's Catalog Using a Spreadsheet
- Migrating Amazon Listing Details Into Solid Commerce to Update Live Listings
- Using the Listing Quantity Expression to Control the Quantities on Your Listings
Excel file from the Downloadable Template With Solid Commerce Columns to Add to Your Amazon Template section:
Comments
Article is closed for comments.