Export Product Mapping Tool

Updated 3 weeks ago

SellerCloud's Export Product Mapping tool lets you customize and export to a file format that is different from the standard export format. This is done by creating an export template. You can create many export templates for different product exports.

A simpler option for export mapping is to use the custom export with custom headers.

Configuring an 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. Save Profile. 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.
  9. 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.
  10. If you want to export the vendor-related information of a specific vendor, select the Vendor from the dropdown, and then choose the appropriate VendorProduct fields in the SellerCloud Field. 
  11. Press Save Mapping.

Exporting products using a mapped template

  1. On the Manage Inventory page, select the products.
  2. From the action menu, select Export Products > 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.


Examples

Product and Order Custom Columns can be mapped like any other column.

bvc_Product.GalleryImageURL - 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