Export Product Information


Overview

Sellercloud allows you to export product-related information and gather data for multiple products simultaneously. The common use case for this feature is to Ready your Products for PostingYou can export information such as inventory levels, Images, Kits, Shadows, and Variations, as well as Channel-specific Information. Additionally, you can automate the process through Scheduled Tasks and set up regular exports to save time.

Sellercloud offers a variety of product export types:

  • Standard – The standard export option covers the essential product information, such as ProductID, UPC, ManufacturerSKU, ProductName, ProductLink, SiteCost, SitePrice, and Qty.
  • Custom – The custom product export lets you select specific product fields tailored to your needs.
  • Plugin – This option lets you utilize plugins to export product data in specific formats. Contact  Sellercloud Support if you require a plugin that exports particular information. Such customizations are billable.
  • Mapping Profile – Similar to plugins, you can create Export Mapping profiles to export specific product information and standardize your formats.
  • Channel Information – You can execute these actions to export channel-specific information according to each channel’s requirements.

Export Products

To export your products:

  1. Go to Manage Catalog > Select your products.
  2. Click on the Action menu and select one of the following export types:
    1. Export Products (Catalog).
    2. Export Product Notes
    3. Export Channel Info
    4. Export Channel Missing Information
    5. Export Channel Category Suggestions
  3. Click Export.
  4. A Queued Job will be generated.
  5. Click on the link and download the Output file

Product Export Types

Sellercloud offers multiple options to export your product catalog information. You can select from Standard, Custom, Plugin, and Mapping Profile.

Standard Export

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

To configure a standard export: 

  1. Go to Manage Catalog and select your products or open the Product Details Page.
  2. Click on the Action menu > Select Export Products (Catalog).
  3. From the Standard drop-down menu, select your export option.
    1. General (Excel) – Exports your product/s in an Excel sheet.
    2. General (PDF) – Generates a pdf document with your product/s information.
    3. Aliases – Exports a file with your product’s Aliases
    4. Channel Specific Product Images – Exports an Excel sheet with your product(s) image information.
    5. Enabled For Channel – Exports information about the channels for which the product is enabled.
    6. Kits – Exports your product’s Kit information. 
    7. Listed on Channel – Exports information about the channels on which the product is listed.
    8. Product Groups – Exports information indicating if the product is part of any product groups.
    9. Product Images – Export product image information.
    10. Rebates – Exports Product Rebates.
    11. Related Kits – Exports related kit information. 
    12. Related Products – Exports Related Products’ information. 
    13. Shadows – Exports your product’s shadow information.
    14. Shipping Preferences for Qty – Exports any configured product’s shipping preferences.
    15. UPC For Channel – Product’s UPC.
    16. Variation Images -Exports product’s variation images.
    17. Variations – Exports Product Variations.
    18. Vendor SKUs – Exports Vendor SKUs related to your product.
  4. Click Export.
  5. A Queued Job will be generated. Click on the link and download the Output file

Custom Export

In Sellercloud, the Custom Export tool lets you tailor the product information to your needs and choose the exact Product Fields or Custom Columns you wish to export, instead of using a predefined template.

Once you download the output file, you can input different values and bulk update your products as needed.

Navigate to our Custom Export article for information on how to configure product custom export.

To see all your custom export templates, go to Settings > Products > Custom Export Templates

Plugin

Another way of exporting product data is by using custom Plugins. They can be requested from Sellercloud Support and are more flexible in terms of exporting specific product data to match your needs. Building a custom plugin is billable. 

  1. Go to Manage Catalog and select your products or open the Product Details Page.
  2. Click on the Action menu > Select Export Products (Catalog).
  3. Select Plugin and choose one from the dropdown menu.
  4. Click Export.

Mapping Profile

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

To export your products using a mapping profile:

  1. Go to Manage Catalog and select your products or open the Product Details Page.
  2. Click on the Action menu > Select Export Products (Catalog).
  3. Select Mapping Profile and choose one from the dropdown menu.
  4. Click Export.

Export Product Notes

To export product notes:

  1. Go to Manage Catalog and select your products.
  2. Click on the Action menu > Select Export Product Notes.
  3. This will generate an Excel Sheet containing the following information:
    1. Product ID
    2. Note
    3. NoteType – Each Note type has a corresponding value. Product notes are associated with the number 2.
    4. DateCreated
    5. UserID
    6. NoteID

Export Channel Information

Sellercloud also offers the option to export the channel-related info required to post or update products. You can select between the following: Export Channel Info, Export Channel Category Suggestions, and Export Channel Missing Information.

Export Channel Info

To export specific channel information:

  1. Go to Manage Catalog and select your products.
  2. Click on the Action menu > Select Export Channel Information.
  3. Select the specific information you want to export for each channel.
    1. Amazon 
      1. Attributes
      2. Hazardous Attributes
      3. BuyBox Pricing
    2. eBay
        1. Specifics
        2. Parts Compatibility
        3. Titles
    3. Newegg
      1. Attributes (Single Format) – Single-format attributes contain a single value.
      2. Attributes (Multi Format) – Multi-format attributes can contain either a single value or multiple values
      3. International Prices – Will export International Prices if the Newegg Company Setting Enable Unt’l Listings is enabled. 
    4. Walmart Marketplace
      1. Attributes
      2. Attributes (V2 Format) – Exports products in V2 price format.
      3. WFS Attributes
    5. Magento Attributes
    6. BonanzaTraits
    7. Sears Attributes
    8. Shopify Meta-Fields
    9. Etsy Attributes
    10. Houzz Attributes
  4. A Queued Job will be generated. Click on the link and download the Output file.

Export Channel Missing Info

Each channel has a set of minimum requirements for posting a product. You need to make sure you meet those requirements to Ready Your Products and Launch them. You can export channel missing information to see what details are missing and prepare your items. 

Once you download the output file, you can input different values and bulk update your products to ready them for posting.

To export channel missing information:

  1. Go to Manage Catalog and select your products.
  2. Click on the Action menu > Select Export Channel Missing Information.
  3. Select the channel from the drop-down menu and click Export
  4. A Queued Job will be generated. Click on the link and download the Output file.

Export Channel Category Suggestions

Sellercloud can predict your product category based on the channel you select. We can predict product categories for eBay, Newegg.com, Tophatter, and Walmart Marketplace. 

To export Channel Category Suggestions:

  1. Go to Manage Catalog and select your products.
  2. Click on the Action menu > Select Export Channel Category Suggestion.
  3. Select the Channel from the drop-down menu.
  4. Enable the Update Product With First Category Suggestion checkbox to update your products with the first category suggestion that Sellercloud predicts.
  5. Click Export and a Queued Job will be generated. Click on the link and download the Output file.

Export Product Inventory

To export your product’s inventory information: 

  1. Go to the Manage Inventory page and select your product/s.
  2. Click on the Action menu and select one of the following options:
    1. Basic Export – Exports ShippingHeight, ShippingLenght, ShippingWidth, CompanyId, SitePrice, InventoryAvailableQty.
    2. Export Inventory Per Warehouse – Exports Warehouse, Qty, PhysicalQty, InventoryDate, LocationNotes.
    3. Export Manual Reserves – Exports ReserveID, WarehouseName, StartDate, EndDate, ReserveType, CustomeRID, OrderSource, Quantity, RemainingReserved
    4. Export Replacement SKUS – Exports Replacement SKUs.
    5. Export Warehouse Images – Exports ImageID, FileName, and IsPrimary.
    6. Export Inventory Per Parent SKU – Exports Parent SKU’s inventory available across all warehouses, as well as product UPC, SiteCost, AverageCost, SitePrice, and Location Notes.
    7. Export Kit Assemblies – Exports AssembledbyUser, AssembledOn, Qty, Mode, Warehouse and FBAShipment#
  3. Select format and Click Export.
  4. A Queued Job will be generated. Click on the link and download the Output file

Automate Product Export

 To create a Scheduled Task that regularly exports your product information: 

  1. Go to Scheduled Tasks and click the green + icon: Create New Scheduled Task.
  2. Complete as follows:
    1. Click Task Type and select Export Products or Export General 
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Job Subtype (only for Export General option)
      1. Customer
      2. Listed on Channel
      3. Product Alias
      4. Product Image Info
      5. Product Manual Reserves
      6. Shipping Containers With Items
      7. Shipping Containers Without Items
      8. Warehouse Inventory Transfer
    6. Click CREATE.
  3. A Success message validates the creation of the task. Click on the hyperlink to Enable it and specify its details.
  4. Click Edit, modify your Scheduled Task, and check the Enable toggle button to make sure the task is running.
  5. Click Save.

The following relevant client settings are available:

  • Export Non-Missing Products In Export Channel Missing Info – By default, when you use the Export Channel Missing Info action, we only export the product fields that do not have values in Sellercloud. If enabled, we will also export the already populated product information.

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?

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