Export Product Information


Overview

Sellercloud allows you to export products and product information so that you can gather data for multiple products at a time. You can export product inventory information, images, kits, shadows, and variations as well as channel-specific information.

Sellercloud offers an array of product export types. The main ones are: General (Standard), Custom, Plugin, Mapping Profile, and Channel Info. Learn about these types of exports below.

Check out this short tutorial showing the many ways to export product info in Sellercloud.


Perform a Product Export

  1. Click Catalog > Manage Catalog > Search and select products to export.
  2. Click on the Action menu.
  3. Select the export type Export Products (Catalog) > Choose a product export type > Export.
    1. Alternatively, select Export Channel Info to export channel-related information such as attributes.
  4. Your Export Products job can be accessed via the notification window that will appear or via Queued Jobs. Once completed, select Download Output File.

Product Export Types

Sellercloud offers multiple types of product exports. imcluding General (Standard), Custom, Plugin, Mapping Profile, and Channel Info.

export types

General Export

This export allows you to gather general information like product images, kits, shadows, variations, groups, and aliases.

To access the General Export:

  1. Go to Catalog > Manage Catalog > Select the desired products > Click on the Action menu > Select Export Products (Catalog).
  2. From the Standard drop-down menu, select your export option.
  3. Press Export.

Custom Export

Sellercloud allows you to run a Custom export. This lets you choose the exact columns you want to export instead of using a predefined template.

Custom Export columns and their definitions are located here.
  1. Go to Catalog > Manage Catalog > Select the desired products > Click on the Action menu > Select Export Products (Catalog).
  2. In the newly opened window, select Custom and press Next.
  3. Move the desired Available Columns to Selected Columns by hovering over them and pressing the + sign. You can also drag and drop.
  4. Here you have various customization options: you can load an existing template, select the file format, or choose how your columns are sorted.
  5. You can also save the template for future use. Type a name into Save Template > Save > Export. The saved template can then be used as the export format in scheduled tasks.
    export custom sellercloud

Use a Plugin

Another way of exporting product data is by using custom Plugins. They can be requested from Sellercloud and are much more flexible in exporting product data to match your needs.

  1. Go to Catalog > Manage Catalog > Select the desired products > Click on the Action menu > Select Export Products (Catalog).
  2. From the Plugin drop-down menu, select a plugin.
  3. Press Export.

Use a Mapping Profile

Users can export product information using a mapping profile as well. Similar to Custom exports, Export Mapping Profiles allow users to customize their templates. However, with Export Mapping Profiles you can customize column headers and use a wide range of product export types.

  1. Go to Catalog > Manage Catalog > Select the desired products > Click on the Action menu > Select Export Products (Catalog).
  2. From the Mapping profile drop-down menu, select a profile.
  3. Press Export.

Export Channel Info

Sellercloud also offers the option to export the channel-related info required to post products.

  1. Go to Catalog > Manage Catalog > Select the desired products > Click on the Action menu > Select Export Channel Info.
  2. Check the desired option and press Export.The image shows the Export Channel Info option.

Overview

Sellercloud offers multiple export types to suit your needs. Learn more about export product options, both standard and custom export, in Sellercloud.
Check out this short tutorial showing the many easy ways to export product info in Sellercloud.


Understand exporting product information

As your business and inventory grow, manually recording product information can be tedious. In Sellercloud, our Export Product Information function makes recording product information fast and efficient.

This is all done from your Manage Inventory page where you can choose one or multiple products to export. Product information that is exported to a file can be edited and imported again using a Bulk Product Update from Import Product Info. Export formats include Excel, CSV, and Tab Delimited.


Regular export

Product information can be exported to a file, edited, and then imported again using the Export Products action on the Manage Inventory page, or by clicking on the green export icon above the inventory grid. Export formats include Excel, CSV, and Tab Delimited.


Custom export

Sellercloud enables custom export as well. It allows you to choose the exact columns you want to export instead of using a predefined template. This is very useful when you want to update custom columns or when you want to update just a few columns out of many.

Specific product level information can be exported from the Manage Inventory page using the Custom Export action.

  1. Follow the steps above.
  2. On the following page, select columns to export from the Available Fields.
  3. Press Add or Remove to manage fields.
  4. You can also save the Custom Export as a template to be easily selected for the next time. Select the fields and click Save Export Fields on the Action Menu. The template will be available from the template drop down and can be used as the export format for scheduled tasks. sellercloud alpha save template custom fields

Clients often export files to upload into systems that are not integrated with Sellercloud for product uploads. Export files can be generated with custom column headers where the user defines the column header and maps it to the Sellercloud column header. For example, you can map the column header ProductID to SKU.

  1. Go to Client Settings > Check Enable Custom Export with Custom Headers.
  2. Continue with the steps outlined above.
  3. The Selected Fields will now have an editable text box that maps to the Sellercloud header. The text box default to the Sellercloud column header can be edited as desired. In the image below the exported file will have column header SKU instead of ProductID.
  4. The Custom headers can be saved as part of the Saved Templates. Select the fields and click Save Export Fields on the Action Menu. The template will be available from the template drop down.
  5. The saved template can be used as the export format in scheduled tasks.sellercloud alpha selected fields custom export
To create mappings with importing sample files use the Export Product Mapping Tool.

If your export needs additional formatting, contact Sellercloud Support to create an export product plug-in that will generate a file with the required headers and formatting. The plug-in will display in the drop down on the Export Products page. Select the appropriate plug-in and click Continue.

There is a one-to-many relationship between a product and these relationships, so they can’t be always included in the regular product export. Be sure to select the parent of the relationship when exporting. With matrices, each each matrix comes out on a separate file.

Was this article helpful?