Export Mapping Tool

Understanding the Export Mapping Tool

The Export Mapping Tool is a helpful feature that lets you export information to a file format that is different from the standard Sellercloud format. Exporting information is done in four easy steps:

  1. Access the Mapping Tool
  2. Create a mapping profile
  3. Access the Mapping Profile Details page to map your file headers to Sellercloud columns
  4. Export your information
A simpler option for export mapping is to use the custom export with custom headers.
The steps to create a mapping profile and export your information differ depending on which interface you are using. Click the links above to jump to a step, and then choose the appropriate accordion.

Step #1 – Accessing the Export Mapping Tool

You can easily access the Export Mapping Tool right from your Settings tab. Once you access the the page, you can perform various actions, such as:

Learn how to access the Export Mapping Tool and perform these actions in each interface by clicking the appropriate accordion below.

Alpha

To access the Export Mapping Tool in Alpha, follow these steps:

  • Go to Settings > Export Mapping Tool.

export mapping tool

From the Export Mapping Tools Manage page, you can also perform a variety of different actions. You can:

  • Create a profile
  • Delete a profile: Select the profile you want to delete > Go to the Action menu > Select Delete > Confirm you want to delete by clicking Continue to Delete Export Mapping Profile(s).
  • Clone a profile: Select the profile you want to delete > Go to the Action menu > Select Clone > Enter new Profile Name > Clone Profile.

Delta

To access the Export Mapping Tool in Delta, follow these steps:

  • Go to Settings > Mapping Tools > Manage Export Mapping Profiles.

sellercloud manage export mapping import mapping product orders page accessFrom the Export Mapping Profiles Manage page, you can also perform a variety of different actions. You can:

  • Create a profile
  • Delete a profile: Select the profile you want to delete > Go to the Action icon > Select Delete > Confirm you want to delete by clicking Continue.
  • Clone a profile: Select the profile you want to delete > Go to the Action icon > Select Clone > Enter New Profile Name > Save.


Step #2 – Creating a mapping profile

Before you can begin creating a profile, you should learn how to access the Export Mapping Tool. A mapping profile simply allows you to export information to a file format that is different from the standard Sellercloud format. You can create multiple profiles, like:

  • Orders profile
  • Purchase orders (PO) profiles
  • Product profiles

After you create a new profile, you can visit the Mapping Profile Details page to begin mapping your columns.

Alpha

Click on the appropriate profile type to learn more.

Order profiles
Order profiles
An order profile lets you export order related information from Sellercloud. To create an order profile in Alpha:

  1. Go to Settings > Export Mapping Tool > Create new Mapping.
  2. Enter Profile Name.
  3. Select Orders from the Profile Type dropdown menu.
  4. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  5. If applicable, check:
    • Export File With Headers: Will export with file headers
    • Export Fully Shipped Orders Only: Only export information related to fully shipped orders
    • Export One Line Per Order: Exports every order on a separate line
    • Export Kit Items Instead Of Kit Parent: Only export kit items and not export kit parents
    • Mark Orders As Exported: Will mark orders as exported
    • Create DropShip PO: Will create a dropship PO for the orders exported
  6. Select Vendor.
  7. Upload your Template File.
  8. Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.

PO profiles
PO profile
A purchase order (PO) profile lets you export PO related information from Sellercloud. To create a PO profile in Alpha:

  1. Go to Settings > Export Mapping Tool > Create new Mapping.
  2. Enter Profile Name.
  3. Select PO from the Profile Type dropdown menu.
  4. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  5. If applicable, check:
    • Export File With Headers: Will export with file headers
    • Export Fully Shipped Orders Only: Only export information related to fully shipped orders
    • Export One Line Per Order: Exports every PO on a separate line
    • Export Kit Items Instead Of Kit Parent: Only export kit items and not export kit parents
    • Mark Orders As Exported: Will mark orders as exported
    • Create DropShip PO: Will create a dropship PO for the orders exported
  6. Select Vendor.
  7. Upload your Template File.
  8. Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.

Product profiles
Product profile
A product profile lets you export product related information from Sellercloud. To create a product profile in Alpha:

  1. Go to Settings > Export Mapping Tool > Create new Mapping.
  2. Enter Profile Name.
  3. Select Product from the Profile Type dropdown menu.
  4. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  5. If applicable, check Export File With Headers.
  6. Upload your Template File.
  7. Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.

Delta

Click on the appropriate profile type to learn more.

Order profiles
Orders profiles
An order profile lets you export order related information from Sellercloud. To create an order profile in Delta:

  1. Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
  2. Click the Action icon > Create.
  3. Enter Profile Name.
  4. Select Orders from the Profile Type dropdown menu.
  5. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  6. If applicable, check:
    • Export File With Headers: Will export with file headers
    • Export Fully Shipped Orders Only: Only export information related to fully shipped orders
    • Export One Line Per Order: Exports every order on a separate line
    • Export Kit Items Instead Of Kit Parent: Only export kit items and not export kit parents
    • Mark Orders As Exported: Will mark orders as exported
    • Create DropShip PO: Will create a dropship PO for the orders exported
  7. Select Vendor.
  8. Upload your Template File.
  9. Click Add. A Mapping Profile Details page will be created for you. From there, you can map your columns.

PO profiles
PO profiles
A purchase order (PO) profile lets you export PO related information from Sellercloud. To create a PO profile in Delta:

  1. Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
  2. Click the Action icon > Create.
  3. Enter Profile Name.
  4. Select PO from the Profile Type dropdown menu.
  5. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  6. If applicable, check:
    • Export File With Headers: Will export with file headers
    • Export Fully Shipped Orders Only: Only export information related to fully shipped orders
    • Export One Line Per Order: Exports every PO on a separate line
    • Export Kit Items Instead Of Kit Parent: Only export kit items and not export kit parents
    • Mark Orders As Exported: Will mark orders as exported
    • Create DropShip PO: Will create a dropship PO for the orders exported
  7. Select Vendor.
  8. Upload your Template File.
  9. Click Add.
  10. Mapping Profile Details page will be created for you. From there, you can map your columns.

Product profiles
Product profiles
A product profile lets you export product related information from Sellercloud. To create a product profile in Delta:

  1. Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
  2. Click the Action icon > Create.
  3. Enter Profile Name.
  4. Select Product from the Profile Type dropdown menu.
  5. Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
  6. If applicable, check Export File With Headers.
  7. Select Vendor.
  8. Upload your Template File.
  9. Click Add. A Mapping Profile Details page will be created for you. From there, you can map your columns.


Step #3 – Accessing the Mapping Profile Details page

It is important to note that the Mapping Profile Detail pages are not the same as your Order Details or Product Details page.

After you create a profile, you automatically create a Mapping Profile Details page. This page lets you view information and perform actions related to a specific profile. Some actions and information on the Mapping Profile Details page overlap, but there are a few differences between the profile types.
export mapping profile
Show me a sample page in Alpha.

When creating a scheduled task, you can select a mapping profile to export data. Show me a sample in Alpha.
The Details page also offers a Preview feature. You can enter an order/SKU/PO and download an Excel file to see a sample of how the mapped information will appear when downloaded. Show me where.

To access the Mapping Profile Details page:

Alpha

To access the Mapping Profile Details page in Alpha:

  1. Go to Settings > Export Mapping Tool.
  2. Search for your profile > Click Profile ID.

Delta

To access the Mapping Profile Details page in Delta:

  1. Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
  2. Search for your profile > Click Profile ID.

On certain Mapping Profile Details pages, you can also edit and view Shipping Method Mapping from your Toolbox in Delta. You can access this in Alpha by simply scrolling down your Mapping Profile Details page.

Mapping columns

The Mapping Profile Details page is where you can begin mapping your columns. Column mapping refers to taking Sellercloud headers and “mapping” them to the headers from your file. When you access the Mapping Profile Details page, you will see three columns:

  • Export Column Name: The column headers from your file.
  • Sellercloud Field: The column in Sellercloud (not exactly named).
  • Custom Value: If you want a static value to be imported for one of the fields (for example, the Order_Email should always be the same here), choose _CUSTOM_VALUE_REQUIRED_ from the Customer Column dropdown, and then enter your static data into the Custom Value column.

export mapping profileShow me a sample in Alpha.

Some order related fields export data into digits. Click to view those fields.

Some order related mapped fields export data into digits. The table below explains those fields.

FIELD DIGITS
bvc_Order.PaymentStatus
  • NoPayment = 10
  • Authorized = 20
  • Charged = 30
  • Uncleared = 40
  • PartiallyRefund = 50
  • FullRefund = 60
  • PartialPayment = 70
  • eBayPaid = 80
  • PaymentError = 99
bvc_Order.StatusCode
  • Canceled = -1
  • ShippingCart = 1
  • InProcess = 2
  • Completed = 3
  • ProblemOrder = 100
  • OnHold = 200
  • Quote = 300
  • Void = 999
bvc_Order.PickingStatus
  • None = 0
  • Partially_Picked = 1
  • Fully_Picked = 2
  • Over_Picked = 3
bvc_OrderPayment.PaymentStatus
  • Cleared = 0
  • NotCleared = 1
  • Unknown = 2
bvc_OrderPayment.PaymentType
  • Information = 1
  • Payment = 2
  • Refund = 3

When using the Export Mapping Tool, you may wonder which columns to use. It is helpful to note that:

  • You can find any order related column you’re looking for by viewing the Order Change Log. Show me a sample Order Change Log.
  • You can find any product related column by altering the product information you want to know the column name for, and then viewing the column associated with that change in the Change Log (known as History in Sellercloud’s original interface). To access your Product Change Log:

To begin mapping your columns:

Alpha

To map your columns in Alpha:

  1. Go to the Mapping Profile Details page and scroll to the column mapping.
  2. Input your information > Save Mapping.

Delta

To map your columns in Delta:

  1. Go to the Mapping Profile Details page > Click Edit.
  2. Go to the Column Mapping panel > Input your information > Save.

You can reference a 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?#.

Step #4 – Exporting your information

After you’ve created your profile and mapped your columns, it’s time to use your profile to export information from Sellercloud into a file format that is not in the standard format. The steps to export information using your new profile are different depending on profile type and the interface you’re are using. View the appropriate interface subsection, and then click the appropriate accordion.

Alpha

Click on the appropriate profile type to learn more.

Order profiles
Order profiles
To export order profiles in Alpha:

  1. On the Manage Orders page, select the orders.
  2. Action menu > Select Export Products > Go, or press on the export icon above the grid.
  3. From the Format dropdown, select the newly created mapping profile.
  4. If applicable, check Also mark orders as exported to mark the orders as exported.
  5. Click Export Orders.

PO profiles
PO profiles
To export PO profiles in Alpha:

  1. Go to Inventory > Purchasing > Select your PO.
  2. Action menu > Select Export Go.
  3. From the Export Using dropdown, select the newly created mapping profile.
  4. Click Export POs.

Product profiles
Product profiles
To export product profiles in Alpha:

  1. On the Manage Inventory page, select the products.
  2. Action menu > Select Export Products > Go, or press on the export icon above the grid.
  3. From the Export Type dropdown, select the newly created mapping profile.
  4. Export Products.

Delta

Click on the appropriate profile type to learn more.

Order profiles
Order profiles
To export order profiles in Delta:

  1. On the Manage Orders page, select the orders.
  2. Go to the Action icon > Export Orders.
  3. From the Format dropdown, select the newly created mapping profile.
  4. If applicable, check Also mark orders as exported to mark the orders as exported.
  5. Click Export.

PO profiles
PO profiles
To export PO profiles in Delta:

  1. Go to Purchasing > Manage POs > Select the PO.
  2. Go to the Action icon > Export > Export via Plugin/Profile.
  3. From the Export Using dropdown menu, select the newly created mapping profile > Export.

Product profiles
Product profiles
To export product profiles in Delta:

  1. On the Manage Catalog page, select the products.
  2. Go to the Action icon > Export Products (Catalog).
  3. Click Mapping Profile > Select your the newly created mapping profile from the dropdown.
  4. Click Export.


Was this article helpful?

Related Articles