NEW: Creating New Catalog Listings from Solid Commerce to Amazon

General Support

December 17, 2025 17:38

This article describes the process for creating brand new listings on Amazon through Solid Commerce using our Excel Add-In Tool and NEW Amazon Listing Data Uploader.

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 this article

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:

Creating a new product on Solid Commerce
Downloading a Listing Template From Solid Commerce portal
Populating Your Template With Products
Listing Variations
Uploading Your File
Start the listing process
Updating Your Live Amazon Listings
Troubleshooting
Related Articles

NOTE: if you are familiar with the previous process for creating new catalog listings from Solid Commerce to Amazon, there are a few changes with this new process.

Skus must first exist in a Solid Commerce warehouse and your Solid Commerce Amazon Marketlist
Amazon does not currently provide required values for each category.
You will load your Solid Commerce Amazon Marketlist items via the Excel Add in Tool and will upload your Amazon specific data in the NEW Amazon Listing Data Uploader in the UI. You will not combine the data into one file and upload via the Excel Add in Tool as you previously did.
Automation should be turned on as the last step. Either on the UI or via Excel Add in Tool. Many merchants use Product Attributes to help filter out their skus on the UI to turn on automation.

Creating a new products on Solid Commerce

Download and open the template attached to this article: Solid-Commerce-Columns-for-Amazon-Listing-Templates.xlsx
Fill all necessary product information and upload to Solid Commerce using Solid Commerce Excel Add-In plugin

Required Fields

The table below documents the required fields. You can view them by clicking on the Manage Excel Columns button in the Solid Commerce Excel Add-In Tool menu.

Required Fields	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	The Warehouse ID of your product.
amazon title	The title for your listing.
amazon 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	This field controls the price of your item on Amazon. You have two options for populating it: Enter a number with up to two decimal places and no currency symbol. Enter formulas using the word cost, like cost1.5* or cost+10. More complex formulas also work, like ((cost1.2)+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 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	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.
amazon condition (required for conditions other than New)	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	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.

Popular 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, Amazon will keep the current template.
amazon leadtime to ship	Amazon includes handling time as a field in two of their processes: Creating new listings. Updating inventory. 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	This is a sale price that is lower than the standard price. You have two options for populating this field: Enter a number with up to two decimal places and no currency symbol. Enter formulas using the word cost, like cost1.5* or cost+10. More complex formulas also work, like ((cost1.2)+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. In Solid Commerce, you should apply a fixed price rule to items with sale prices, 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.

Downloading a Listing Template From Solid Commerce portal

To list through Solid Commerce, you will need to use a template as a starting point. Downloading a template is a one-time process for each product type. 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 for the selected product type.

To download a template from Solid Commerce portal:

Login to https://channelsmanager.com/
Go to the Inventory -> Inventory Manager
Expand the Marketplaces → Amazon Seller Central and select Amazon marketlist with the locale which you want to select to start listing creation. (ex. AmazonUS, AmazonCA, AmazonMX etc.)
Click on “Upload Amazon Template File“ button

Enter an intended product type name for which you want to generate a template and click on the Orange Magnifying Glass:

6. Select a correct product type from the list and click on “Download Template“ button

You can download a Template Description with description and valid value examples for each column in template. NOTE: Amazon does not provide Required Values

Populating Your Template With Products

After you downloaded an appropriate template, it should be populated with correct values before uploading it and starting the listing process

Required Fields

The table below documents the required fields. You can view them by clicking on the Manage Excel Columns button in the Solid Commerce Excel Add-In Tool menu.

Required Fields	Field Descriptions and Valid Values
ListName	The Market List name
SKU	The SKU of your existing product that was previously created via Excel Add-In tool
Item_name(#1)-Value	The title for your listing.
Brand(#1)-Value	Provide the brand name of the product
Externally_assigned_product_identifier(#1)-Type	Provide the external ID (barcode) type and corresponding value that is being used to identify the product: UPC, EAN, GTIN
Externally_assigned_product_identifier(#1)-Value	Provide the corresponding external product id value based on the type that was selected
Supplier_declared_has_product_identifier_exemption(#1)-Value	Please specify if the product is exempt from supplier declared external product identifiers TRUE or FALSE
Item_type_keyword(#1)-Value	What is the item that you are selling? Provide the specific term that identifies what kind of clothing item this is, such as shirt, dress, pants, jacket, or sweater.
Model_number(#1)-Value	Provide the manufacturer 's model number for the item, an alphanumeric string up to a maximum of 40 characters in length.
Model_name(#1)-Value	Specify the model name of the product as defined by the manufacturer or brand excluding item type, color, brand or size.
List_price(#1)-Value	Provide the list price for the product not including tax. List Price is the suggested retail price of a product as provided by a manufacturer, supplier, or seller. This is not the offering or cost price. If you are unable to provide a value, enter 0.
List_price(#1)-Currency	Select the corresponding currency. Example value: USD.
Manufacturer(#1)-Value	The full name of the publisher who issued the product, provide the company that manufactures the product.
Country_of_origin(#1)-Value	The country in which the product was published. Example value: US
Number_of_items(#1)-Value	Provide the total number of identical items in the selling unit to the customer, Total number of products included. If 1 single shirt, then number_of_items = 1.
Material(#1)-Value	What material is the product made out of?Specify the primary materials used for manufacturing the item.
Product_description(#1)-Value	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.
Bullet_point(#1)-Value	Brief descriptive text, called out via a bullet point, regarding a specific aspect of the product. These display directly under or next to your product photo, it is useful to put interesting information in these fields. Do NOT use all caps or abbreviations. Please do NOT use for fabric content
Condition_type(#1)-Value (required for conditions other than New)	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.
Condition_note(#1)-Value	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

Popular Optional Fields

Field Descriptions and Valid Values

Main_product_image_locator(#1)-Media_location

The attribute indicates the Main Product Image Locator of the product

Merchant_shipping_group(#1)-Value

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, Amazon will keep the current template.

Item_display_dimensions(#1)-Height-Value
Item_display_dimensions(#1)-Lenght-Value
Item_display_dimensions(#1)-Widht-Value

Provide the dimensions of the product, without packaging and fully assembled. Example value: inches

Listing Variations

To create variation listings on Amazon, fill the next fields in template before uploading:

Required Fields	Field Descriptions and Valid Values
Parentage_level(#1)-Value	Specify whether a SKU is a parent or child, Values: Parent, Child
Child_parent_sku_relationship(#1)-Child_relationship_type	The relationship that the child has to the parent. Values: Variation. Fill for chils items only, should be empty for Parent
Child_parent_sku_relationship(#1)-Parent_sku	The SKU of the parent item
Variation_theme(#1)-Name	Specify the variation theme that the product will use. The theme's attributes must be populated for all items in the grouping. Example Values: BAND_COLOR, COLOR/SIZE, COLOR (check the full list in description file.)

Uploading Your File

Once you populate listing information in template, return back to Solid Commerce portal and use Amazon Listing Data Uploader to upload your template.

To download a template from Solid Commerce portal:

Login to https://channelsmanager.com/
Go to the Inventory -> Inventory Manager
Expand the Marketplaces → Amazon Seller Central and select Amazon marketplist with locale which you want to select to start listing creation. (ex. AmazonUS, AmazonCA, AmazonMX etc.)
Click on “Upload Amazon Template File“ button

5. Click on Upload file section and select a filled template from your PC

Click on “Upload“ button
When upload will be completed you will be automatically redirected to “Recent Uploads“ tab where status of you upload will be indicated

You will be prompted if upload attempt was unsuccessful, detailed error report will be available by the next link:

Start the Listing Process

When your template successfully uploads to Solid commerce, you will turn on the Automation for your listing or listings.
You can either do this on the UI one by one, using an attribute, or, using the Excel Add in Tool.

Or turn it ON via Excel Add in Tool by using run amazon column:

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.

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:

1. Please populate necessary changes in template and upload it as described in steps above.

2. Select your listing in Amazon Market List and click on "Update Listings" button and Confirm.

Additional Information:

Updating product data on live Amazon Listings: if you have online Amazon skus that you need to update product data to, and you have originally loaded via the previous Amazon Flat File method, you will need to fill out the NEW Amazon listing templates described above. If any questions, please reach out to support@solidcommerce.com

Troubleshooting

If you see the “Fail (click for details)” text in Last Item Activity column, you can click on it to get more details on about the errors with your listing: