Import Channel Catalog

Overview

When you integrate a channel on which you already have active listings, you can import those listings into Sellercloud, along with their associated product information. This allows for a smooth transition to managing your Catalog from Sellercloud and minimizes the amount of manual work necessary.

The minimum requirements for importing products from your channels to Sellercloud are to have a Product Name and Product ID.

Import Listings from Channels

If you have listings across multiple channels, it’s important to note that you’ll need to import them separately for each channel. However, it’s not necessary to create a different company for each marketplace. You can easily keep track of your listings, while you have all of your integrations under one company.

Some cases that require multiple companies to be created are if you’re selling on international marketplaces or have an Amazon Unified Account. This way, you will have the option to configure the correct currency and country code. Additionally, if you have integrated more than one website channel, you can keep better track of your orders.  Another circumstance in which multiple companies may be required is if you have Channel Plugin Integrations.

There are cases, where you might need to use Shadow Products. For example, Amazon and eBay only allow a single SKU to be listed once, under one category. By creating a Shadow SKU, or multiple shadows, the product can be listed in multiple categories and share inventory across different companies.

Import Amazon Listings

You can import your Amazon Listings to Sellercloud manually or automatically.

Manually 

To import listings from Amazon manually:

  1. Go to Settings > Companies > Manage Companies > Open a company.
  2. From the Toolbox, go to Channels > Amazon Settings > Reports.
  3. Click on the three-dot icon in the grid and select Request New Report to generate the most current Active Listings report.
  4. From the Report Type field, select Merchant Listings Reports.
  5. Select the From Date and To Date of the report and click Request Report.
  6. Contact Sellercloud Support or your onboarding specialist to obtain the output file. Once you have it, you can use it to create a template and bulk-create your Sellercloud products.

Automatically

To automate the reports from Amazon, navigate to:

  1. Settings > Companies > Manage Companies > Open a company.
  2. Toolbox > Channels > Amazon Settings > General Settings.
  3. Navigate to the Control panel.
  4. Click Edit and check Enable Auto Create Products for Amazon. Optionally, you can configure the following subsettings: 
    1. Enable Auto Update Products From Amazon – Enable this to allow Sellercloud to automatically update product fields based on the information received with the Active Listings Reports.
    2. Do Not Enable For Amazon – By default, Sellercloud will automatically enable your Products for Amazon if they are in the latest Active Listings Report. Enable this setting if you would like to keep your products disabled. This is useful if you are not using Sellerlcoud to manage your Inventory on Amazon.
    3. Update Site Price Based On Amazon Price – Enable this to allow Sellercloud to automatically update your Products’ Site Price based on the Amazon Price we receive in the Active Listings Report.
  5. Click Save.
The Merchant Listings Report imports every several hours, and products will be automatically created from it when this setting is enabled. Variation relationships will not be created from the active listing report. They can be imported separately from Amazon. Learn more here.

Import eBay Listings

Before downloading your listings, it’s essential to assign Custom Labels to all your eBay products. Custom Labels serve as SKUs in Sellercloud, even for variation parents and components. Failure to set Custom Labels will result in an error when attempting to download your listings.

To configure the Custom Label field in your eBay settings, you will need a Selling Manager or Selling Manager Pro subscription.

To import eBay Listings, navigate to:

  1. Settings > Company Settings > Select a company.
  2. Toolbox > Import eBay Listings.
  3. Action Menu > Download Listings. This will create a job to import all the active listings from eBay.
  4. Select products from the list > Action Menu > Create Selected Products.
  5. Once the job is complete, the SKUs will all show up in red because they are products that are on eBay but don’t yet exist in Sellercloud.
  6. If the SKU already exists, select the option to Download the eBay properties.
When you’re downloading an eBay listing into Sellercloud, you can choose a primary warehouse for importing the inventory as well as creating the Sellercloud SKU. This is controlled by the Client Setting Set inventory when creating local listing from eBay to warehouse: (choose a warehouse)

Import Walmart Marketplace Listings

To import your listings navigate to:

  1. Go to Settings > Companies > Manage Companies > Select a Company.
  2. Toolbox > Walmart Marketplace > Reports (API).
  3. In the Report Type dropdown choose  Item.
  4. Click Search.
  5. Download the Zip File, open the Excel Document in it, and copy the relevant information from each required column.
  6. Download the Walmart Marketplace Import Template, and paste the copied information under each respective column.
    1. Be sure to mark all products as TRUE in the WalmartAPIEnabled.
  7. Navigate to Catalog > Tools > Bulk Product Update.
  8. Click on Select File and input the document.
  9. Click Upload.

Import Shopify Listings

You can import listings from Shopify either manually or allow Sellercloud to create local products automatically.

Prior to downloading your Shopify listings, navigate to Company > Toolbox > Website > General > enable the Allow Active Listings Download checkbox.

Manually

You can manually create SKUs in Sellercloud based on the Active Listings you currently have on Shopify via a file import. This gives you the flexibility to decide which products you want to bring over. To do that:

  1. Go to Company Settings > Select a company > Toolbox > Website > Sellercloud integrated Website > Shopify General.
  2. In Actions select Download Listings.
  3. Select the dates and click Download.
  4. Go to Queued Jobs > Search > click the Job ID of the most recent job. 
  5. Reload the page until the document is available to download.
  6. Go to Catalog > Tools > Import Product Info > Import Info Via Plugin.
  7. Select the Shopify Import Plugin from the dropdown > attach the file that you downloaded from the Queued Job > click Import.
Contact Sellercloud Support to install the Shopify Product Import plugin on your server.
You may want to import variation products from Shopify. These products can be different sizes of shoes or baseball caps from different teams. Learn more about Importing Matrix from Shopify

Automatically

You also have the option to allow automatic product creation based on your current active listings on Shopify. Variations will also be created via this method. To set this up:

  1. Go to Settings > Open your Shopify-integrated Company.
  2. Open the Toolbox > Website General Settings.
  3. Enable Auto Create Local Products > click Save.

Once the setting is enabled, Sellercloud will periodically download the active listings report and generate a Queued Job which will create the local SKUs. This process will occur overnight in order to prevent server slowness.

Import Other Channel Listings

Each channel has different requirements for listing products. For the majority of the channels, we are not able to automatically pull in the listings report.

You will need to perform the following steps:

  1. Export the list of active SKUs directly from the channel.
  2. Create a file with these three required columns:
    1. ProductID
    2. ProductName
    3. (the channel name)_Enabled
  3. If you would like to add extra information, see the correct column headers for importing.
  4. Upload the file into the Sellercloud system via a Bulk Product UpdateCatalog > Tools > Import Product Info > Bulk Product Update.

Other Important Information

Cost

For units that you already have inventory in the warehouse, the product’s cost needs to be entered before posting these products. This will keep your Profit and Loss Reports accurate. 

When a product has no inventory, we cannot determine its cost until there is available inventory data. We can prime the cost as soon as the product has inventory and the necessary cost information becomes available. You can contact Sellercloud Support to request Customizations that can change the Average Cost calculation.

Price

This is not necessary if you have a repricer that is sending pricing directly to the channels.

If you do not use a repricer, we suggest importing pricing individually or in bulk. Automatic price updates in Sellercloud are not advisable due to the potential risk of pricing errors that could result in financial loss. 

Individually

To update a product’s price individually, navigate to:

  1. Catalog > Manage Catalog > Open a product.
  2. Click Edit in the top right corner.
  3. Navigate to the Pricing panel and adjust the price.
  4. Click Save.

In Bulk

To import pricing information in bulk navigate to:

  1. Catalog > Tools > Import Product info.
  2. Click on Generate Template and create three columns:
    1. ProductID
    2. ProductName
    3. Price
  3. Populate the fields and go back to Sellercloud.
  4. Select the newly created template and click Upload.

Purchasing and Dropshipping (optional)

If you’re importing POs, then the vendor SKU and default vendor need to be set on the product. For products with case quantity, don’t forget to set the vendor SKU on the specific product you’ll add to the purchase order. You can also do this after your product goes live, as purchase orders are saved in Sellercloud. This way, you have the flexibility to manage your inventory efficiently and make adjustments as needed.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support