Search

How to Import Catalog from Amazon?

  • Updated

SmartBiz now offers a streamlined way to import product catalogs from Amazon directly into your SmartBiz account using the Amazon Catalog Template. This new feature enables you to efficiently transfer product data, including details such as title, description, and images, from Amazon into SmartBiz. By using the Catalog Import from Amazon functionality, you can ensure a seamless integration and save valuable time in managing your product listings. You can use this feature for your past catalog, for which you already have am Amazon Template file, or any new listings that you plan to add to Amazon.

Key Benefits:

  • Time-Saving: Automatically import bulk product data from Amazon Catalog file to SmartBiz without having to manually input each product in the SmartBiz format.
  • Accuracy: Ensures that product data, including descriptions, title, and images, are accurately transferred. You also get a chance to review and edit before marking for final upload.
  • Efficient Catalog Management: Allows you to easily import product listings from Amazon to SmartBiz.

Prerequisites:

Before using the Catalog Import feature, ensure you meet the following requirements:

  1. Amazon Seller Account: You must have an active seller account on Amazon with access to the product catalog - to download the catalog file which needs to be filled and uploaded.
  2. SmartBiz Account: You must have an active SmartBiz account to import products.
  3. Amazon Catalog Template: Make sure you have downloaded the correct Amazon Catalog Template to fill data. This template is available in your Amazon Seller Central account. DO NOT download the beta file, uncheck the beta button if selected by default.

Step-by-Step Guide to Import Catalog from Amazon to SmartBiz:

Step 1: Prepare Your Amazon Catalog Template

  1. Log in to your Amazon Seller Central account.
  2. Navigate to Catalog > Add Products via Upload.
  3. Download the Amazon Catalog Template for your product category. The template will be an Excel file that contains various columns for product details like product title, SKU, price, quantity, and more. You can do this by Download Blank Template > Download Product Spreadsheet > Search Product Type > Uncheck the Beta Version > Generate Spreadsheet.

4. Fill out the template with the relevant product information that you want to upload into Amazon (and upload the details to your Amazon seller account).

Step 2: Log in to Your SmartBiz Account

  1. Open your browser and go to the SmartBiz Login Page.
  2. Enter your username and password to access your account.

Step 3: Access the Catalog Import Feature

  1. Once logged in, navigate to the Catalog Management section in your SmartBiz dashboard.
  2. Select Bulk Actions from the right-hand menu.
  3. Choose the option labeled Import from Amazon to start the import process.

Step 4: Upload the Amazon Catalog Template

  1. In the import screen, you’ll find an option to upload a file. Click the Upload File button.
  2. Select the Amazon Catalog Template file that you downloaded and filled out earlier.
  3. Once the file is selected, click Upload to proceed.

Step 5: Column Mappings

  1. SmartBiz will automatically attempt to match the columns from your Amazon Catalog Template with the corresponding fields in SmartBiz.
  2. The mappings (non-beta) are done as per the below table:
S. No. SmartBiz Attribute Name SmartBiz Attribute Type Amazon Attribute Name  
1 Custom SKU Optional Seller SKU / item_sku  
2 Product Name Mandatory Item Name / item_name  
3 MRP Mandatory Maximum Retail Price / maximum_retail_price  
4 Selling Price Optional Your price / standard_price  
5 Business Category Mandatory NA  
6 Product Category Mandatory Product Type / feed_product_type  
7 Product Description Optional Product Description / product_description  
8 Variant Relationship Optional Parentage / parent_child  
9 Parent SKU Optional Parent SKU / parent_sku  
10 Size Optional Size / size_name  
11 Colour Name Optional Colour / color_name  
12 Best Seller Optional External Product Information / external_product_information  
13 Product Image1 Optional Main Image URL / main_image_url  
14 Product Image2 Optional Other Image URL1 / other_image_url1  
15 Product Image3 Optional Other Image URL2 / other_image_url2  
16 Product Image4 Optional Other Image URL3 / other_image_url3  
17 Product Image5 Optional Other Image URL4 / other_image_url4  
18 Product Image6 Optional Other Image URL5 / other_image_url5  

3. In case of any change, download the modified file in the next step and make the necessary changes to the file.

Step 6: Confirm Product Data

After uploading the file, SmartBiz will convert the file and generate a catalog file in SmartBiz format to be imported.

Review the product details such as Title, Custom SKU, price, description, and Variant attributes by clicking Review Catalog to ensure everything is correct.

  1. If everything looks good, click Import Catalog to begin the import process. Else make the changes and upload using Upload Modified File.

Step 7: Monitor the Import for Errors

The import process will begin. Depending on the number of products, the import may take a few minutes.

  1. Once the import is complete, you will receive a confirmation message. If there are any errors (e.g., missing product information), SmartBiz will provide a detailed report so you can address the issues and re-upload the catalog file.

Step 8: Review Imported Products

  1. Go to your Catalog section in SmartBiz to view the newly imported products.
  2. Ensure that all product details are correctly populated and visible.
  3. You can now manage, edit, and update your product listings as needed.

Troubleshooting and FAQ on How to Import Catalog from Amazon?