Export Order Mapping Tool

Updated 1 year ago

The Export Order Mapping tool enables you to customize an order 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 order exports.

Configure the export template

  1. Go to Settings > Export Mapping Tool. 
  2. Click  Create New Mapping.
  3. Enter a Profile Name, and use Orders for the Profile Type.
  4. Choose the  export  format (xls, tab delimited, csv) from the Export File Type dropdown.
  5. Enable other options as applicable. The Export one line per order option should only be enabled for exports that are not supplying order-Item-level (or “product”) information. 
  6. Click Choose File and select a sample file of the export you are trying to map.
  8. 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 orders), select "_CUSTOM_VALUE_REQUIRED_" from the SellerCloud Field dropdown, then enter the static value in the Custom Value Column.
    • You can reference an product field using a placeholder. For example, although the UPC is not part of the order table, you can export the UPC of the ordered item by choosing "custom_value_required" and in custom value format a placeholder like this: #?product.UPC?#
    • With a multi-item order, you can map all items in the order by using a placeholder. Choose "custom_value_required" and in custom value, enter placeholder #?ROW_COUNTER?#
  9. Press Save Mapping.

Export orders using a mapped template

  1. On the Manage Orders page, select the orders.
  2. From the Action menu, select Export Orders > 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.

How did we do?

Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter
Powered by HelpDocs (opens in a new tab)