Importing Your Amazon Listings and Data

Solid Commerce imports your listings by requesting an Active Listings Report from your Amazon Seller Central account. This article details the information we can import from that report.

IMPORTANT!

If you've used custom Leadtime to Ship settings on your listings, you will need to add those to Solid Commerce yourself through a bulk upload. You also need to import your taxability settings. We explain how at the bottom of this article. Before turning on the automatic import, we highly recommend consulting with your Implementation Manager.

 

If you are ready to turn on the auto import function, go to your Amazon Marketplaces Setup. For more info, please see Connecting to Amazon Marketplaces, Amazon FBA, and Amazon Webstore.

 

Downloadable Templates:

 

What we'll cover:

  1. Information Imported From Amazon
  2. Custom Leadtime to Ship Settings
  3. Taxability Settings
  4. Related Articles

 

Information Imported From Amazon

Amazon Field Import Specs
Title

For SKUs that do not exist in Solid Commerce yet, we use the title from Amazon as the Product Name.

For SKUs that already exist in Solid Commerce, we do not modify the saved Product or Inventory information. We ignore the Amazon Title.

Seller SKU

For SKUs that do not exist in Solid Commerce yet, we use your Amazon Seller SKU as the Product Custom SKU and Warehouse ID (Warehouse and Marketplace level SKU).

For SKUs that already exist in Solid Commerce, we do not modify the saved Product Custom SKUs and Warehouse IDs.

Quantity

For SKUs that do not exist in Solid Commerce yet, we use the quantity from Amazon as the quantity (qty).

For SKUs that already exist in Solid Commerce, we do not modify the saved Product or Inventory information. We ignore the quantity from Amazon.

Price

Saved as the Sell Price Expression in Solid Commerce.

If you want to switch to an automated repricer rule after importing your listings, you will need to revise the imported price.

ASIN Saved as your product's ASIN.
Item Condition Saved as the Amazon Condition.
Item Note (Condition Note) Saved into a field we call the Amazon Comment.
Merchant Fulfilled or FBA

We separate Merchant Fulfilled listings from Fulfilled by Amazon listings by importing them into different Market Lists and Warehouses.

There are two separate sets of auto import options in the Marketplaces Setup. The Auto Import Setup is for Merchant Fulfilled. The FBA Auto Import is setup directly below.

Amazon Shipping Template Name

The name of the shipping template you assigned to your listing through Amazon Seller Central.

 

Custom Leadtime to Ship Settings

IMPORTANT!

The Leadtime to Ship field is not included in any report made available by Amazon, so we cannot import it.

However, Amazon requires that we submit the Leadtime to Ship field when we update quantities or you click the Update Listings button. If we leave this field empty in the files we submit, Amazon will automatically set your lead time to their default value of 1-2 days.

If you have established specific lead times on any of your Amazon listings, you will need to add those lead times to Solid Commerce immediately after you import your listings. Otherwise your custom lead times will be reset by Amazon to the default setting of 1-2 days as we update quantities or listing settings.

To add your lead times to Solid Commerce, use the attached Excel template.

1) Populate the product custom sku and warehouse id fields with your SKUs.

  • For a list of all of your Amazon SKUs, download the Active Listings Report from your Amazon Seller Central account. Copy the SKUs and paste them into your Solid Commerce template.

2) In the amazon leadtime to ship column, enter a whole number between 1 and 30. You don't need to create a range or use the word "days."

  • Enter the number representing the maximum number of days between when an order is placed and when it will be shipped.

3) Enter the name of the Amazon Market List from Solid Commerce in the list name column.

amazon_listing_management_update_leadtime_to_ship_excel.png

 

4) Upload your file by clicking the Upload Data button in the Solid Commerce Excel Add-In Tool. Enter your Solid Commerce credentials and select only Update Marketplace.

excel_add-in_tool_update_marketplace_only.png

Taxability Settings

IMPORTANT!

The taxability of items is not included in any report made available by Amazon, so we cannot import it.

Instead, you must add taxability to the listings that have imported into your Solid Commerce account. Once you perform this easy update, items will relist correctly and existing listings will update properly.

To set the taxability in Solid Commerce, use the attached Excel template.

1) Populate the product custom sku and warehouse id fields with your SKUs.

  • For a list of SKUs, download the Active Listings Report from your Amazon Seller Central account. Copy the SKUs and paste them into your Solid Commerce template.

2) If you want buyers to pay taxes according to the tax settings you established in your Amazon account, enter Yes in the taxable column. If your items aren't taxable, enter No.

amazon_listing_management_update_taxability_excel.png

 

3) Upload your file by clicking the Upload Data button in the Solid Commerce Excel Add-In Tool. Enter your Solid Commerce credentials and select only Update Product.

excel_add-in_tool_update_product_only.png

 

Related Articles

 

Back to top

 

The attachments from the top of the article:

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.