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:
- Access the Mapping Tool
- Create a mapping profile
- Access the Mapping Profile Details page to map your file headers to Sellercloud columns
- Export your information
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:
- Creating a profile
- Deleting a profile
- Cloning a profile
Learn how to access the Export Mapping Tool and perform these actions in each interface by clicking the appropriate accordion below.
To access the Export Mapping Tool in Alpha, follow these steps:
- Go to Settings > 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.
To access the Export Mapping Tool in Delta, follow these steps:
- Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
From 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.
Click on the appropriate profile type to learn more.
An order profile lets you export order related information from Sellercloud. To create an order profile in Alpha:
- Go to Settings > Export Mapping Tool > Create new Mapping.
- Enter Profile Name.
- Select Orders from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- 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
- Select Vendor.
- Upload your Template File.
- Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.
A purchase order (PO) profile lets you export PO related information from Sellercloud. To create a PO profile in Alpha:
- Go to Settings > Export Mapping Tool > Create new Mapping.
- Enter Profile Name.
- Select PO from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- 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
- Select Vendor.
- Upload your Template File.
- Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.
A product profile lets you export product related information from Sellercloud. To create a product profile in Alpha:
- Go to Settings > Export Mapping Tool > Create new Mapping.
- Enter Profile Name.
- Select Product from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- If applicable, check Export File With Headers.
- Upload your Template File.
- Click Save Profile. The page will automatically refresh to you Mapping Profile Details page, where you can begin to map your columns.
Click on the appropriate profile type to learn more.
An order profile lets you export order related information from Sellercloud. To create an order profile in Delta:
- Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
- Click the Action icon > Create.
- Enter Profile Name.
- Select Orders from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- 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
- Select Vendor.
- Upload your Template File.
- Click Add. A Mapping Profile Details page will be created for you. From there, you can map your columns.
A purchase order (PO) profile lets you export PO related information from Sellercloud. To create a PO profile in Delta:
- Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
- Click the Action icon > Create.
- Enter Profile Name.
- Select PO from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- 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
- Select Vendor.
- Upload your Template File.
- Click Add.
- A Mapping Profile Details page will be created for you. From there, you can map your columns.
A product profile lets you export product related information from Sellercloud. To create a product profile in Delta:
- Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
- Click the Action icon > Create.
- Enter Profile Name.
- Select Product from the Profile Type dropdown menu.
- Select your Export File Type from the dropdown menu. You can select Excel, CSV, or Tab Delimited.
- If applicable, check Export File With Headers.
- Select Vendor.
- Upload your Template File.
- 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
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.
Show me a sample page in Alpha.
To access the Mapping Profile Details page:
To access the Mapping Profile Details page in Alpha:
- Go to Settings > Export Mapping Tool.
- Search for your profile > Click Profile ID.
To access the Mapping Profile Details page in Delta:
- Go to Settings > Mapping Tools > Manage Export Mapping Profiles.
- Search for your profile > Click Profile ID.
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.
Some order related mapped fields export data into digits. The table below explains those fields.
FIELD | DIGITS |
bvc_Order.PaymentStatus |
|
bvc_Order.StatusCode |
|
bvc_Order.PickingStatus |
|
bvc_OrderPayment.PaymentStatus |
|
bvc_OrderPayment.PaymentType |
|
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:
- Delta: Go to Product Details page > Toolbox > Change Log.
- Alpha: Go to Product Details page > Toolbox > History > Show Full History.
To begin mapping your columns:
To map your columns in Alpha:
- Go to the Mapping Profile Details page and scroll to the column mapping.
- Input your information > Save Mapping.
To map your columns in Delta:
- Go to the Mapping Profile Details page > Click Edit.
- Go to the Column Mapping panel > Input your information > Save.
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.
Click on the appropriate profile type to learn more.
To export order profiles in Alpha:
- On the Manage Orders page, select the orders.
- Action menu > Select Export Products > Go, or press on the export icon above the grid.
- From the Format dropdown, select the newly created mapping profile.
- If applicable, check Also mark orders as exported to mark the orders as exported.
- Click Export Orders.
To export PO profiles in Alpha:
- Go to Inventory > Purchasing > Select your PO.
- Action menu > Select Export > Go.
- From the Export Using dropdown, select the newly created mapping profile.
- Click Export POs.
To export product profiles in Alpha:
- On the Manage Inventory page, select the products.
- Action menu > Select Export Products > Go, or press on the export icon above the grid.
- From the Export Type dropdown, select the newly created mapping profile.
- Export Products.
Click on the appropriate profile type to learn more.
To export order profiles in Delta:
- On the Manage Orders page, select the orders.
- Go to the Action icon > Export Orders.
- From the Format dropdown, select the newly created mapping profile.
- If applicable, check Also mark orders as exported to mark the orders as exported.
- Click Export.
To export PO profiles in Delta:
- Go to Purchasing > Manage POs > Select the PO.
- Go to the Action icon > Export > Export via Plugin/Profile.
- From the Export Using dropdown menu, select the newly created mapping profile > Export.
To export product profiles in Delta:
- On the Manage Catalog page, select the products.
- Go to the Action icon > Export Products (Catalog).
- Click Mapping Profile > Select your the newly created mapping profile from the dropdown.
- Click Export.