Export Product Mapping Tool

Updated 2 years ago

The Export Product Mapping tool enables you to customize and export to a file format that is different from the standard SellerCloud export format. This is done by creating an export template. You can create many export templates for different product exports.
A more simplified option for export mapping is to to use the "Custom Export with Custom Headers". Read about that here.

Configure Export Template

  1. Go to Settings > Export Mapping Tool. 
  2. Click on Create New Mapping.
  3. Give the profile a name. 
  4. Profile type should be Products.
  5. Choose the file format (xls, tab delimited, csv) from the Export File Type dropdown.
  6. Enable options as applicable
  7. Press the Choose File button and select a sample file of the export you are trying to map. 
  8. Then press Save Profile.
  9. The page will refresh to display a grid with three columns: Export Column Name, SellerCloud Field, and Custom Value. The “Export Column Name” is the column header from the file. The “SellerCloud Field” is the column in SellerCloud. In the dropdown of the SellerCloud Field, you will see options for product fields and product custom columns.
  10. If you want a static value to be exported for one of the fields in the file (For example, the Account Number should always be the same for all of these products), then select "_CUSTOM_VALUE_REQUIRED_" from the SellerCloud Field dropdown. Then enter the static value in the Custom Value Column.
  11. If you'd like to export the vendor-related information of a specific vendor, then you can select the Vendor from the dropdown, and then choose the appropriate VendorProduct fields in the SellerCloud Field. 
  12. Press Save Mapping

Export Products Using Mapped Template

  1. On the Manage Inventory page, select the products.
  2. From the action menu, select Export Products. Press Go. Or press on the export icon above the grid.
  3. From the type dropdown select the mapping template.
  4. Export.
The template will also be available in the scheduled tasks.


Note: Product and Order Custom Columns can be mapped like any other column.
bvc_Product.GalleryImageURL - the default image URL column

MatrixParentSKU - used when exporting a matrix child to define it's parent

More detailed list of column headers can be found here.

How did we do?

Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter