Searching...

Export Product Information


Overview

Sellercloud allows you to export product-related information and gather data for multiple products simultaneously. A common use case for this feature is to Ready your Products for Posting. You can export 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.

Sellercloud offers several 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 and generate your own templates.
  • Plugin – This option lets you utilize plugins to export product data in specific formats. Open a ticket with Sellercloud Support if you require a plugin that exports particular information. Such customizations are billable.
  • Mapping Profile – You can create Export Mapping profiles to export specific product information while using headers different than the standard Selelrcloud filed names. This is useful if the exported information is meant for an external service.
  • Channel Information – You can execute these actions to export channel-specific information such as Attributes and Metadata.

Export Products

To export your products:

  1. Go to Manage Catalog > Select your products from the grid.
  2. Click on the Actions 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) Channel-Specific Images.
    5. Enabled For Channel – Exports information about the channels for which the product is enabled.
    6. Kits – Exports your product’s Kit information. Use this option when exporting Kit Parents.
    7. Listed on Channel – Exports information about the channels on which the product is posted.
    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. Use this option when exporting Kit Components to see which kits they are currently part of. 
    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 per item quantity.
    15. UPC For Channel – Product’s channel-specific UPCs.
    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 update the necessary values and bulk update your products.

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

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

Plugin

Another way to export product data is to use custom Plugins. These can be requested from Sellercloud Support and are more flexible in 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 a profile, 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 information required to post or update products. You can select Export Channel Info, Export Channel Category Suggestions, or 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 Int’l Listings is enabled. 
    4. Walmart Marketplace
      1. Attributes
      2. Attributes (V2 Format) – Exports the API V2 Walmart Marketplace attributes.
      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 must ensure you meet those requirements to Ready Your Products and Post them. You can export channel-missing information to see missing details and prepare your SKUs. 

Once you download the output file, you can fill in the necessary 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 suggest your product category based on the channel you select. We can predict product categories for eBay, Newegg.com, 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 Manual Reserves information: ReserveID, WarehouseName, StartDate, EndDate, ReserveType, CustomeRID, OrderSource, Quantity, RemainingReserved.
    4. Export Replacement SKUS – Exports Replacement SKUs.
    5. Export Product Serial Numbers – Exports the current product Serials.
    6. Export Warehouse Images – Exports ImageID, FileName, and IsPrimary.
    7. 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.
    8. Export Kit Assemblies – Exports Kit Assembly information: 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. On the Scheduled Task Details page, click the Edit button at the top right corner. to specify additional details and enable the task.
  4. Click Save.

The following relevant client setting is 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 product information that has already been populated.

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.
Tagged:

Was this article helpful?

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