Exporting Product Information Overview

Click here for information on product exports in Sellercloud’s original interface.
Watch this video on exporting product information.


Understanding export types
Sellercloud offers multiple export types to suite your needs.

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

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

  1. Select products on the Manage Inventory page.
  2. Select Custom Export from the Action Menu and GO.
  3. On the following page select columns to export from the Available Fields.
  4. Press Add or Remove to add to the Selected Fields or to remove them.
  5. 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 regular 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 but can be edited as desired. In the image below the exported file will have column header SKU instead of ProducID.
  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

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.

Tip: To create mappings with importing sample files use the Export Product Mapping Tool.


Export product relationships
Similarly, product relationship information such as shadows, kits, n-matrix, and aliases can be exported directly off of the Manage Inventory page with Export Shadows etc., actions. There is a one-to-many relationship between a product and these relationships, so they can’t be included in the regular product export.Be sure to select the parent of the relationship when exporting. With Matrixes, each each matrix comes out on a separate file.


 

Check out this short tutorial showing the many easy ways to export product info from Sellercloud’s Delta interface!

Watch this video on exporting product information in our original interface.


 

Understanding 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 Catalog 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.

Accessing exports
  1. Click Catalog > Manage Catalog.
  2. Select your products > action menu.
  3. Select your export > Export.
  4. Your Export Product Information job can be accessed via a notification in the top right corner or Queued Jobs. Once completed, select Download Output File.
You can also generate a export file of missing channel attributes. Read more about that here.
sellercloud export product information queued job

 

Standard export

Sellercloud offers multiple options for exporting product information. For a standard export, you have numerous selections for the in information you want exported. You can choose to export product images, groups, or product relationships such as kits, aliases, shadows, and matrices.

When exporting general information, you can choose from a PDF or Excel file. This type of standard export will record product information including:

  • Product ID
  • UPC
  • ManufacturerSKU
  • ProductName
  • Link
  • SiteCost
  • SitePrice
  • Quantity (Qty)
There is a one-to-many relationship between a product and these relationships, so they can’t be included in the regular product export. Be sure to select the parent of the relationship when exporting. With Matrixes, each each matrix comes out on a separate file.
sellercoud export product information general excel example

 

Custom export

Specific product level information can be exported using the Custom Export action. Custom Export columns and their definitions are located here.

  1. Select Custom > Next.
    sellercloud export product information window
  2. From here, you can fully customize your exported information. By hovering over the available columns, a plus will appear. This moves the column over to Selected Columns. Or, drag and drop.
    sellercloud export product catalog information window
    sellercloud export product catalog information window two
  3. As pictured above, you have many other customization options. You can load an existing template, select the file format, or even choose how your columns are sorted.
  4. You can also save the Custom Export as a template for future use. Type a name into Save Template > Save > Export.
    sellercloud export product information custom save template export
The saved template can be used as the export format in scheduled tasks.

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.

To create mappings with importing sample files use the Export Product Mapping Tool. Read about that here.


 

Was this article helpful?

Related Articles