Exporting Product Information Overview

YouTube Video

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. Custom Export columns and their definitions are located here.
  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. 
  6. The saved template can be used as the export format in scheduled tasks

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. Enable client setting  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

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.



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.

Export Missing Channel Attributes.
You can also generate a export file of missing channel attributes. read more about that here

How did we do?