Creating New Catalog Listings on Amazon Through Solid Commerce

The basic workflow for creating brand new listings on Amazon through Solid Commerce is to download a listing template from Amazon, populate your data, and upload it through our user interface. This article provides all of the steps and includes information about some special fields that add flexibility and reduce effort.

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.

 

What we'll cover:

  1. Downloading Listing Templates From Seller Central
  2. Populating Your Template With Products
  3. Uploading Products You Haven't Added to Solid Commerce Yet vs. Uploading Products You Already Added to Solid Commerce
  4. Managing Prices on Your New Listings
  5. Providing Quantities for Your Listings
  6. Listing Variations
  7. Managing the Handling Time on Your Listings
  8. Uploading Your Template In Solid Commerce
  9. Viewing Progress, Results, and Downloading Recent Uploads
  10. Options for Adding More Products in the Future
  11. Related Articles

 

Downloading Listing Templates From Seller Central

1) Login to your Amazon Seller Central account.

2) Go to the Inventory menu -> Add Products via Upload.

3) 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 a category for your products. Click the Select button to add that category to your template.

  • You can select more than one category, even if they aren't related.

4) In the "STEP 2: SELECT THE TYPE OF TEMPLATE" section, select the type of template you want to download and click the Generate Template button.

  • "Lite" templates don't include columns for additional images, variations, or most of the "offer" fields (like MSRP or MAP prices).
  • Most of our clients download the "Advanced" version of the template, which contains all of the available columns.

5) Your template will download.

 

Populating Your Template With Products

Populate the template according to Amazon's requirements.

We provide some additional options and streamlining for the price and quantity fields, which we explain later in this article.

We also manage parent SKUs slightly differently than Amazon. You will need to provide the parent SKU for the parent item in your file, as documented below. Amazon requirements state that you shouldn't provide a parent SKU for parent items.

Other than these few considerations, you can populate the template just like you would if you were uploading it directly into Seller Central.

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 are some pointers for filling it out:

  • The "Instructions" tab provides some basic guidelines for populating the template.
  • The "Images" tab documents Amazon's image requirements.
  • The "Data Definitions" and "Example" tabs are extremely helpful. Most questions can be answered by reviewing these two tabs. You can refer to them while you are populating the template.
  • The "Template" tab is the sheet that you populate.

 

Uploading Products You Haven't Added to Solid Commerce Yet vs. Uploading Products You Already Added to Solid Commerce

If you haven't added the products in your file to Solid Commerce yet, we will create the products when you upload your template. When we create a product, we apply the product details provided in your template to as many of our standard product fields as possible. We will populate fields like: Manufacturer, UPC, MSRP, main image URL, etc. Any data that doesn't correspond to a stock product field in Solid Commerce will be saved as a product attribute specific to Amazon.

We also add the new product to the Warehouse you select as your inventory source during the upload. As best practice, we recommend only selecting one Warehouse or Vendor Inventory List as your inventory source. The quantity in your Amazon template will be added to that Warehouse. Because the Amazon template doesn't provide a field for acquisition cost, we set the cost in your Solid Commerce Warehouse to zero. You can add a cost later if you like.

If a product already exists in Solid Commerce, we will update the Amazon related data with the data you provide in your upload file. To update your items, set the Update Existing Products toggle to YES during your upload.

 

Managing Prices on Your New Listings

To provide you with total control over your prices, we use a flexible field to manage prices. We call this field the Sell Price Expression. The term expression means that you can populate the field with simple formulas to help you automate price updates.

We will use whatever value you enter in the standard_price field in your Amazon template as the Sell Price Expression in Solid Commerce.

Here are some examples of how you can populate the standard_price field.

Expressions

Expressions use the word cost to help automatically update your prices when your cost changes. For example:

  • cost
  • cost*1.2
  • cost+5

In these expressions, the word cost refers to the acquisition cost you've entered in your Solid Commerce Warehouse. If you pair an expression with a fixed price rule, we will submit a new fixed price to Amazon anytime the cost is updated in Solid Commerce. If you pair an expression with an automated repricing rule, we use the cost expression to calculate your floor, ceiling, and no other sellers prices.

If you use an expression and the cost in Solid Commerce is $0.00, we won't list your item. The cost must be greater than $0.00.

Item-by-Item Prices for Automated Repricing

As an alternative to using an expression, you can set a specific floor, ceiling, and no other sellers price for each item. To control these values on an item-by-item basis, you will need to perform an additional Excel upload using our Excel Add-In Tool or enter numeric values in our user interface. The fields to populate are:

  • In Excel: amazon minimum profit price exp, In the UI: Min Item Price
  • In Excel: amazon maximum profit price exp, In the UI: Max Item Price
  • In Excel: amazon no sellers sale price exp, In the UI: If no Sellers Price

To use these item specific values, you also need to set up your Amazon Pricing Rule accordingly. In the minimum price, no other sellers price, and maximum price ceiling drop-downs, select the By item param option.

Fixed Price Listings

To use a fixed price, enter a number in the standard_price column in your Amazon template and select a fixed price rule during upload.

 

Providing Quantities for Your Listings

For items that already exist in your Solid Commerce Warehouse, leave the quantity column blank in your Amazon template. We will submit the inventory saved in Solid Commerce to Amazon.

For items that you haven't added to Solid Commerce yet, populate the quantity column in Amazon's template with the correct stock level. We will add that quantity to your Solid Commerce Warehouse.

The Listing Quantity Expression

The Listing Quantity Expression field offers you control over the quantity that we submit to Amazon. Most clients use the default of lq, which instructs us to submit the "list quantity" to Amazon - meaning to submit your entire inventory. If you would like to learn more about your other options, such as withholding inventory from Amazon, please see Using the Listing Quantity Expression to Control the Quantities on Your Listings.

 

Listing Variations

To create new variation listings on Amazon, follow Amazon's variation format, as specified in their template.

IMPORTANT!

We break from Amazon's requirements with regards to the parent SKU field. Amazon requires you not to populate the parent_sku field for your parent item. We require that you populate your parent_sku for the parent and child items.

In Solid Commerce, we automatically transfer the parent_sku from Amazon's template to our Parent SKU field. The Parent SKU is displayed in your Solid Commerce Amazon Market List, making it easy to visually confirm variation relationships when viewing items in our user interface.

 

Managing the Handling Time on Your Listings

Amazon uses three different fields to manage the handling time on your listings.

  1. In Seller Central, the field is named handling time.
  2. When you create new listings, the column in the template is named fulfillment_latency.
  3. When we submit inventory updates, the field is named leadtime to ship.

We manage all three fields through one field in Solid Commerce, the Amazon Leadtime to Ship field. When you upload a new listing template, we save the value you enter in the fulfillment_latency column in our Amazon Leadtime to Ship field. This allows us to submit the same handling time for both new listings and inventory updates.

If you ever update the Amazon Leadtime to Ship in Solid Commerce, we will submit the new handling time when we update your inventory or when you push a listing update to Amazon.

 

Uploading Your Template In Solid Commerce

To upload your populated Amazon template:

1) Save the "Template" tab as a Comma Separated Values file (.csv).

2) In your Solid Commerce account, choose the Amazon Market List that you want to upload your products to.

3) Click on the Upload Amazon Template File button.

amazon-new-listing-creation-upload-template-button.png

 

4) The Upload Center flyout panel will open on the right side of the screen. The Upload Center allows you to quickly make selections for several fields without needing to populate them through Excel.

  • Pricing Rule - Select one of your Amazon Pricing Rules from the drop-down menu.
  • Inventory Source - Required - Select a Warehouse or Vendor Inventory List for Solid Commerce to search for your items.
    • As best practice, we recommend selecting only one inventory source for items that don't exist in Solid Commerce yet.
    • For items that already exist in Solid Commerce, you can select more than one inventory source.
  • Listing Quantity Expression - Required - Leave the default of LQ if you want to submit your full inventory to Amazon. If you would like to use an expression, enter it into this field. For more information about the expression options, please see Using the Listing Quantity Expression to Control the Quantities on Your Listings.
  • Turn on Automation? - Set the toggle to Yes if you want us to submit your listings to Amazon. If you leave the toggle set to No, your products won't list until you turn the automation on. You can turn the automation on later through the user interface or a file upload.
  • Update Existing Products? - Set the toggle to Yes if you want to update items that already exist in your Amazon Market List.

amazon-listing-upload-center-flyout-panel-new-upload.png

5) Drag and drop your saved CSV template into the flyout or use the browse feature.

6) Click the CONTINUE button to upload your template.

NOTE:

Any selection that you make in the flyout panel will apply to all items in your upload. If you would like to control some of the fields on an item-by-item basis, such as the Amazon Pricing Rule or the Listing Quantity Expression, you have two options:

  1. Divide your upload into smaller files so that all of the items in each upload file will share the same Amazon Pricing Rule or Listing Quantity Expression.
  2. Prepare a second upload file containing only the few Solid Commerce headers that you need. Once your initial upload finishes processing, you can upload the second file using our Excel Add-In Tool.
    • EXAMPLE: You want to apply different Amazon Pricing Rules to different items in your upload. After your template processes, you can upload a file using the Excel Add-In Tool. Your second upload would only need five columns: results, product custom sku, warehouse id, list name, market auto rule.

 

Viewing Progress, Results, and Downloading Recent Uploads

To view the progress of your upload, select the "Recent Uploads" tab in the Upload Center flyout.

The Recent Uploads tab displays your 10 most recent uploads.

If you experienced errors, you can download the template with the errors. We add a results column to the download which provides an error for each item. You can correct the data in the downloaded file, save it, and upload it again. You don't need to delete the results column or modify any other columns in the downloaded file. It is ready for upload.

amazon-listing-upload-center-recent-uploads.png

 

Options for Adding More Products in the Future

If you want to list more products to a category that you have already listed to before, you don't need to download a new template from Amazon. Downloading a new template is always an option, but you can also:

  • Save your files after you upload them so that when you want to list more products, you open one of your saved templates and use it for the new items.
  • Download a past upload from the "Recent Uploads" tab in the Upload Center flyout panel and populate with your new products.

 

Related Articles

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

Comments

0 comments

Please sign in to leave a comment.