Export Mapping Columns

Overview

While creating a mapping profile with the Export Mapping Tool, you can map Sellercloud’s standard order, PO, or product columns to custom columns of your choice. This allows you to export preselected Sellercloud data using a custom template. This article lists and describes the Export Mapping Columns.

When you access the Mapping Profile Details Page, there are three columns in the Column Mapping panel:

• Export Column Name: The column header in your template.

• Sellercloud Field: The Sellercloud field you are mapping the column to.

• Custom Value:

  • If you want a static value to be exported for one of the fields, set the Customer Column to _CUSTOM_VALUE_REQUIRED_ and then enter your static data into the Custom Value column.

  • If you want a dynamic value to be exported for one of the fields, set the Customer Column to _CUSTOM_VALUE_REQUIRED_ and then enter a placeholder into the Custom Value column. You can find some example placeholders in these articles: Email Placeholders and Word2PDF Invoices.

You can create and enable Custom Columns, and then use them in the Column Mapping panel. To export a custom column, map to bvc_Order_Property_UserDefined.COLUMN if it’s an Orders column or bvc_Product_Properties_UserDefined.COLUMN for a Products column, where the COLUMN at the end is replaced with the name of your custom column.

Order Columns

Mapping Profiles with the Type Order can only access the columns in the order database table. However, you can reference some fields using placeholders. For example, although the UPC is not part of the order table, you can export the UPC of the ordered item if you set the Sellercloud Field to _CUSTOM_VALUE_REQUIRED and set the Custom Value to the placeholder #?product.UPC?#.

Refer to the list below for some of Sellercloud’s most common order fields. Not all fields are listed here - you can map many others as well.

General

• bvc_Order.ID - The unique Sellercloud order identifying number.
• bvc_Order.OrderSource - The source channel from which the order originated.
• bvc_Order.OrderSourceOrderID - The source channel’s unique identifier for the order.
• bvc_Order.TimeOfOrder- The date when the order was placed.
• bvc_Order.UserName - The customer’s email address.
• bvc_Order.OrderCurrencyCode - The order’s currency.
• bvc_Order.ShippedFromWarehouseName- The name of the shipping warehouse.
• bvc_Order.PaymentDate - The date when the payment for the order was made.
• bvc_Order.PaymentTerm- The payment terms specified for the order.
• bvc_Order.StatusCode - The order’s general status.
• bvc_Order.PaymentStatus - The order’s payment status.
• Payment.checkNumber - The Number provided when receiving an order payment via Check.
• bvc_Order.PickingStatus - The order’s picking status.
• bvc_Order.ShippingStatus - The order’s shipping status.
• bvc_Order.DropShipStatus - The order’s dropship status.
• bvc_Order.CustomerServiceStatus - The order’s customer service status.
• bvc_Order.IsWholeSaleOrder - Indicates whether the order is a Wholesale Order.
• bvc_Order.RushOrder- Indicates whether the order is a Rush Order.
• bvc_Order.BackOrderStatus - Indicates whether the order is a Backorder.
• bvc_Order.IsGiftOrder - Indicates whether the order is a Gift Order.

Order Items

• bvc_OrderItem.ID- The unique Sellercloud identifier (SKU) of a product in the order.
• bvc_OrderItem.DisplayName - The name of a product in the order.
• bvc_OrderItem.DisplayDescription- The description of a product in the order.
• bvc_OrderItem.Qty- The quantity of the purchased product.
• bvc_OrderItem.OriginalBasePrice- The unit price of the product.
• bvc_OrderItem.QtyPerCase - The quantity per case of the product.
• bvc_OrderItem.PricePerCase- The price per case of the product.
• bvc_OrderItem.TotalCases- The quantity of ordered product cases.
• bvc_OrderItem.DiscountAmount - The discount applied to the product.
• bvc_OrderItem.TaxExempt- Indicates whether the product is tax-exempt.
• bvc_OrderItem.IsBackOrder - Indicates whether the product is back-ordered.
• bvc_OrderItem.BackOrderQty - Indicates the product’s backorder quantity.
• bvc_OrderItem.Notes - The notes pertaining to the product.

Shipping and Billing

• address.ShippingFirstName- The first name of the shipping recipient.
• address.ShippingLastName- The last name of the shipping recipient.
• address.ShippingStreet1- The first line of the shipping address.
• address.ShippingStreet2- The second line of the shipping address.
• address.ShippingCity- The city of the shipping address.
• address.ShippingState- The state code of the shipping address.
• address.ShippingZipCode- The ZIP or postal code of the shipping address.
• address.ShippingCountry- The country of the shipping address.
• address.ShippingPhone- The phone number associated with the shipping address.
• address.BillingFirstName- The first name of the billing contact.
• address.BillingLastName- The last name of the billing contact.
• address.BillingStreet1- The first line of the billing address.
• address.BillingStreet2- The second line of the billing address.
• address.BillingCity- The city of the billing address.
• address.BillingState- The state code of the billing address.
• address.BillingZipCode- The ZIP or postal code of the billing address.
• address.BillingCountry- The country of the billing address.
• address.BillingPhone- The phone number associated with the billing address.

Tracking

• bvc_Order.TrackingNumber - The unique identifier assigned to track the shipment.
• bvc_Order.PurchaseOrderID - The purchase order number associated with the order.
• bvc_Order.ShippingCarrier - The carrier responsible for shipping the order.
• bvc_Order.ShippingMethodRequested- The requested shipping method for the order.
• bvc_Order.ShippingMethodSelected - The shipping method used for the order.
• bvc_Order.OrderShippingPromiseDate - The promised date by which the order will be shipped.
• bvc_Order.ShipDate - The order’s shipping date.
• bvc_Order.EstimatedDeliveryDate - The order’s estimated delivery date.
• bvc_Order.DeliveryDate - The order’s delivery date.
• bvc_Order.FinalShippingFee- The cost incurred for shipping the order.
• bvc_Order.CompanyID - The identifier for the company associated with the order.
• bvc_Order.CompanyName - The name of the company associated with the order.
• bvc_OrderItem.PackageID - The unique identifier for the package within the order.
• bvc_Order.DoNotSendShippingToOrderSource - Indicates whether shipping information should be sent to the source channel.

Financial Information

• bvc_Order.SubTotal- The order’s subtotal.
• bvc_Order.PromoCodes - The promo codes applied to the order.
• bvc_Order.OrderLevelDiscountAmount- The order discount.
• bvc_OrderItem.DiscountTotal - The total order items discount.
• bvc_Order.OrderDiscountsTotal - The total discount applied to the order.
• bvc_Order.TaxTotal- The total tax amount associated with the order.
• bvc_Order.ShippingTotal- The total cost of shipping for the order.
• bvc_Order.ShippingDiscountsTotal - The total amount of shipping discount.
• bvc_Order.HandlingFee - The order’s handling fee.
• bvc_Order.InsuranceTotal - The order’s insurance fee.
• bvc_Order.GrandTotal - The order’s grand total.

Purchase Order Columns

Refer to the lists below for some of Sellercloud’s most common Purchase Order (PO) fields. Not all fields are listed here - you can map many others as well.

General

• Purchase.ID - The PO number.
• Purchase.PurchaseTitle- The description of the PO.
• Purchase.VendorName- The name of the vendor associated with the PO.
• Purchase.PaymentTermID- The Payment Terms specified for the PO.
• Purchase.VendorInvoiceNumber- The invoice number provided by the vendor.
• Purchase.InvoiceDate- The date of the invoice.
• Purchase.TrackingNumber - The PO’s tracking number.
• Purchase.DateOrdered- The date when the PO was placed.
• Purchase.ExpectedDeliveryDate- The expected delivery date for the PO.
• Purchase.CancelByDate- The date by which the PO can be cancelled.
• Purchase.CreatedBy - The person who created the PO.
• Purchase.Approved- Indicates whether the PO is approved.
• Purchase.ApprovedBy- The person who approved the PO.
• Purchase.ApprovedOn - The date when the PO was approved.

Shipping

• Purchase.ReceivedBy - The person who received the PO.
• Purchase.ReceivedOn - The date when the PO was received.
• Purchase.ShipToAddress - The address for shipping the PO.
• address.ShippingFirstName - The first name of the shipping recipient.
• address.ShippingCity- The city of the shipping location.
• address.ShippingState- The state of the shipping location.
• address.ShippingCountry - The country of the shipping location.
• address.ShippingZipCode- The ZIP code of the shipping location.
• Purchase.ShippingInstructions- The special instructions for shipping the PO.
• Purchase.ShippedOn- The date when the PO was shipped.
• Purchase.ShippingCarrier - The shipping carrier that delivers the PO.
• Purchase.ShippingService - The shipping service used to deliver the PO.
• Purchase.ShippingStatus - The shipping status of the PO.
• Purchase.ShippingTotal - The total amount paid for shipping of the PO.

Purchase Items

• PurchaseItem.ProductID - The unique Sellercloud identifier (SKU) of the product.
• product.UPC- The Universal Product Code (UPC) associated with the product.
• PurchaseItem.ProductName - The name of the product.
• PurchaseItem.UnitPrice- The unit price of the product.
• PurchaseItem.ExpectedDeliveryDate - The expected delivery date for the product.
• PurchaseItem.AdjustedPrice- The adjusted unit price for the product.
• PurchaseItem.QtyOrdered- The quantity of the product ordered.
• PurchaseItem.QtyPerCase - The quantity per case of the product ordered.
• PurchaseItem.QtyReceived - The quantity of the product received.
• PurchaseItem.QtyReceivedToDate - Total quantity of the product received so far.
• PurchaseItem.CaseQtyOrdered- The quantity of the product ordered in cases.
• PurchaseItem.CostPerCase- The cost per case of the product.
• PurchaseItem.PreSellQuantityEnabled - Indicates if pre-selling of the product is enabled.
• PurchaseItem.PreSellQuantity - The quantity of the product available for pre-selling.
• PurchaseItem.POItemNotes- The notes specific to the purchase order item.
• PurchaseItem.POItemNotesLocal - The localized notes for the purchase order item.
• Purchase.DisableInventoryCount- Indicates whether the product should be counted in inventory.

Financial Information

• Purchase.DropShipFee - The PO’s dropship fee.
• Purchase.DiscountTotal - The total discount applied to the PO.
• PurchaseItem.DiscountType - The discount type applied to an item in the PO.
• PurchaseItem.DiscountValue - The discount amount applied to an item in the PO.
• Purchase.ShippingTotal- The total cost of shipping for the order.
• Purchase.CustomsTotal- The total amount paid for customs clearance for the PO.
• Purchase.TaxTotal- The total amount paid for tax on the PO.
• Purchase.GrandTotal - The grand total amount paid for the PO.

Product Columns

Refer to the lists below for some of Sellercloud’s most common product fields. Note that these are only some of the available fields - there are many others you can use in the mapping. There are also additional channel-specific product property fields that are not included in the lists below.

General

• bvc_Product.ID - The product’s unique Sellercloud identifier (SKU).
• bvc_Product.ProductName - The name of the product.
• bvc_Product.CompanyID - The company of the product.
• bvc_Product.ProductTypeName - The product type.
• bvc_Product.CreatedBy - The product creator.
• bvc_Product.DateCreated - The product creation date.
• bvc_Product.Status - Indicates the current product status.
• bvc_Product.InventoryAvailableQty- The product’s available quantity.
• bvc_Product.KitDefinition - Indicates whether the product is KitParent, KitChild, or export N/A if the SKU is not part of a kit.

Identifiers

• bvc_Product.ProductMasterSKU - The master stock-keeping unit for the product.
• bvc_Product.ManufacturerSKU - The manufacturer's SKU for the product.
• bvc_Product.ASIN - The Amazon Standard Identification Number associated with the product.
• bvc_Product.EAN - The European Article Number associated with the product.
• bvc_Product.GTIN - The Global Trade Item Number associated with the product.
• bvc_Product_Properties_Amazon.UPC- The Universal Product Code of the product.
• #?product.UPC?# - The Universal Product Code of the product. This is a placeholder you can use to pull the product's UPC in Order and PO profiles. Enter this as a Custom Value with the Sellercloud Field set to _CUSTOM_VALUE_REQUIRED_.

Metrics

• bvc_Product.Weight - The weight of the product.
• bvc_Product.PackageWeightLbs - The weight of the product packaging in pounds.
• bvc_Product.PackageWeightOz - The weight of the product packaging in ounces.
• bvc_Product.CaseHeight - The height of the product case.
• bvc_Product.CaseLength- The length of the product case.
• bvc_Product.CaseWeight - The weight of the product case.
• bvc_Product.CaseWidth - The width of the product case.

Details

• bvc_Product.ManufacturerName - The name of the product’s manufacturer.
• bvc_Product.BrandName - The name of the brand associated with the product.
• bvc_Product.ShortDescription - A brief description of the product.
• bvc_Product.LongDescription - A detailed description of the product.
• bvc_Product.Priority - The priority of the product.
• bvc_Product.Rating - The rating of the product.
• bvc_Product.CountryOfOrigin - The origin country of the product.
• bvc_Product.HasProposition65Warning- Indicates whether the product has a warning related to Proposition 65 Compliance.
• bvc_Product.Proposition65WarningMessage - The warning message related to Proposition 65 compliance.
• bvc_Product_Properties.IsExpirable - Indicates whether the product is Expirable.

Purchasing and Costs

• bvc_Product.LastCost - The most recent amount paid to buy the product.
• bvc_Product.AverageCost - The Average Cost of the product.
• bvc_Product.SiteCost - The Product Cost, either on the last PO at the time it is received or based on the Average Cost.
• bvc_Product.GrossCost- The Gross Cost is similar to the Average Cost, but it excludes the quantity from its calculation.
• bvc_Product.SalesManCost- The product’s Salesman Cost.
• bvc_Product.CostPerCase - The cost per case of the product.
• bvc_Product.QtyPerCase - The quantity of the product per case.
• bvc_Product.QtyPerPalet- The quantity of the product per pallet.
• bvc_Product.Purchaser- The person or entity responsible for purchasing the product.

Pricing

• bvc_Product.SitePrice- The default Product Price for all channels.
• bvc_Product.ListPrice- The product’s Manufacturer’s Suggested Retail Price (MSRP) or Strikethrough Price (STP).
• bvc_Product.WholeSalePrice- The wholesale price of the product.
• bvc_Product.MAPPrice- The Minimum Advertised Price (MAP) of the product.
• bvc_Product.StorePrice- The product’s price in local stores.
• bvc_Product.SalePrice- The sale price of the product.
• bvc_Product.SalePriceEndDate - The end date of the sale price.
• bvc_Product.SalePriceStartDate - The start date of the sale price.
• bvc_Product.AmazonPrice - The product’s Amazon Price.
• bvc_Product.TaxExempt - Indicates whether the product is tax-exempt.

Inventory

• bvc_Product.InventoryAvailableQty - The inventory quantity that is currently available for sale.
• bvc_Product_Properties.PhysicalInventoryQty - The total physical inventory quantity, including any reserved and non-sellable quantities.
• bvc_Product.OnOrder - The inventory quantity that is currently on order.
• bvc_Product.AggregateNonSellableQty - The inventory quantity placed in non-sellable warehouses.
• bvc_Product.ReserveQtyTotal - The inventory quantity of a product that has been occupied by created orders or manually reserved for channels.
• bvc_Product.AggregatePhysicalQtyFBA - The total inventory quantity of a product in FBA-type warehouses.
• bvc_Product.AggregatePhysicalQtyFBASellable - The total sellable inventory quantity of a product in FBA-type warehouses.
• bvc_AggregatePhysicalQtyWFS - The total inventory quantity of a product in WFS-type warehouses.
• bvc_AggregatePhysicalQtyWFSSellable - The total sellable inventory quantity of a product in WFS-type warehouses.