FF
This document highlights the data which is migrated by StagingPro as part of the MVP
| Anchor | ||||
|---|---|---|---|---|
|
...
Brands (store/manage/products/brands)
Fields migrated are:
...
Brands
...
Brand Name
...
Search Keywords
...
Page Title
...
Brand Image
...
Meta Keywords
...
Brand URL
...
Meta Description
...
Template Layout File
SOURCE STORE DESTINATION STORE
...
...
2) Categories (store/manage/products/categories)
The following Fields are migrated along with the categories of migration
...
Categories
...
ParentId (Not visible on UI)
...
metadescription
...
Name
...
layout file
...
Description
...
IsVisible (Not visible on UI)
...
Views
...
DefaultProductSort
...
SortOrder
...
ImageUrl
...
PageTitle
...
CustomUrl_Value
...
search keywords
...
CustomUrl_IsCustomized (Not visible on UI)
...
meta keywords
SOURCE STORE DESTINATION STORE
...
...
3) Products (store/manage/products)
Due to a large number of fields as well as the length of the product UI, this section has been broken down into the following subsections:
Basic Information
Categories
Description
Image and Videos
Product Identifiers
Pricing
Inventory
Variations
Modifiers and Rules
Storefront Details
Custom Fields
Related Products
Dimensions and Weights
Shipping Details
Purchasability
Gift Wrapping
Customs Information
SEO and Sharing
...
Basic Information
...
Products - Basic Information
...
Name
...
SKU
...
IsVisible
...
ProductType
...
Price
...
BrandID
...
Weight
SOURCE STORE DESTINATION STORE
...
...
Categories
...
Products - Categories
...
Categories
SOURCE STORE DESTINATION STORE
...
...
Description
...
Products - Description
...
Description
SOURCE STORE DESTINATION STORE
...
...
Images and Videos
...
Products - Images and Videos
...
ImageURL
...
Image Description
...
thumbnail
SOURCE STORE DESTINATION STORE
...
...
Product Identifiers
...
Products - Product Identifiers
...
SKU
...
UPC
...
MPN
...
GTIN
...
Bin Picking Number
SOURCE STORE DESTINATION STORE
...
Pricing
...
Products - Pricing
...
Price
...
Product Tax Code
...
TaxClassId
SOURCE STORE DESTINATION STORE
...
...
Inventory Tracking
...
Products - Inventory
...
inventory tracking
SOURCE STORE DESTINATION STORE
...
Variations
...
Products - Variations
...
BaseVariantId
...
SKU
...
Purchasable
...
Default Price
...
Image
...
Sale Price
...
MSRP
...
Stock
...
Low Stock
...
Weight
...
Width
...
Height
...
Depth
...
Cost
...
UPC
...
Bin Picking Number
...
MPN
SOURCE STORE DESTINATION STORE
Note: Most of the fields mentioned above are only visible when clicking the “Edit Columns” option in the product UI
...
Modifiers and Rules
SOURCE STORE DESTINATION STORE
...
...
Storefront Details
...
Products - Storefront Details
...
Warranty
...
Search Keywords
...
Sort Order
...
Availability Description
...
Is Condition shown
...
Condition
SOURCE STORE DESTINATION STORE
...
Custom Fields
...
Custom Fields
...
id
...
name
...
value
SOURCE STORE DESTINATION STORE
...
Related Products
Note : This section has not yet been completed. (STAG-35)
SOURCE STORE DESTINATION STORE
...
Dimensions and Weight
...
Products - Dimensions and Weight
...
Weight
...
Width
...
Height
...
Depth
SOURCE STORE DESTINATION STORE
...
Shipping Details
...
Products - Shipping Details
...
Fixed Cost Shipping Price
...
Is Free Shipping
SOURCE STORE DESTINATION STORE
...
Purchasability
...
Products - Purchasability
...
availability
SOURCE STORE DESTINATION STORE
...
Gift Wrapping
...
Products - Gift Wrapping
...
Giftwrapping Options
...
Customs Information
...
Products - Customs
SOURCE STORE DESTINATION STORE
...
...
Products - SEO
...
Page Title
...
Meta Keywords
...
Meta Description
SOURCE STORE DESTINATION STORE
...
4) CUSTOMERS (store/manage/customers)
The following customer related fields are migrated with StagingPro
...
Customers
...
Id
...
StoreCredit
...
Company
...
RegistrationIpAddress
...
FirstName
...
CustomerGroupId
...
LastName
...
Notes
...
...
TaxExemptCategory
...
Phone
...
CustomFields
...
DateCreated
...
ResetPassOnLogin
...
DateModified
...
AcceptsMarketing
...
allow (Data Preferences)
SOURCE STORE DESTINATION STORE
...
| Note |
|---|
Please note that Customer Data Preferences are not migrating. A list of known issues can be found here. |
...
...
5) Orders (store/manage/orders)
The following fields are migrated as part of ‘Orders’ however many are not visible on the UI.
...
Orders
...
Id
...
RefundedAmount
...
CustomerId
...
OrderIsDigital
...
DateCreated
...
StoreCreditAmount
...
DateModified
...
GiftCertificateAmount
...
DateShipped
...
IpAddress
...
StatusId
...
GeoipCountry
...
Status
...
GeoipCountryIso2
...
SubtotalExTax
...
CurrencyId
...
SubtotalIncTax
...
CurrencyCode
...
SubtotalTax
...
CurrencyExchangeRate
...
BaseShippingCost
...
DefaultCurrencyId
...
ShippingCostExTax
...
DefaultCurrencyCode
...
ShippingCostIncTax
...
StaffNotes
...
ShippingCostTax
...
CustomerMessage
...
ShippingCostTaxClassId
...
DiscountAmount
...
BaseHandlingCost
...
CouponDiscount
...
HandlingCostExTax
...
ShippingAddressCount
...
HandlingCostIncTax
...
IsDeleted
...
HandlingCostTax
...
EbayOrderId
...
HandlingCostTaxClassId
...
BillingAddress_FirstName
...
BaseWrappingCost
...
BillingAddress_LastName
...
WrappingCostExTax
...
BillingAddress_Company
...
WrappingCostIncTax
...
BillingAddress_Street1
...
WrappingCostTax
...
BillingAddress_Street2
...
WrappingCostTaxClassId
...
BillingAddress_City
...
TotalExTax
...
BillingAddress_State
...
TotalIncTax
...
BillingAddress_Zip
...
TotalTax
...
BillingAddress_Country
...
ItemsTotal
...
BillingAddress_CountryIso2
...
ItemsShipped
...
BillingAddress_Phone
...
PaymentMethod
...
BillingAddress_Email
...
PaymentProvider_id
...
Products
...
PaymentStatus
...
ShippingAddresses
...
OrderSource
SOURCE STORE DESTINATION STORE
...
6) SHIPPING
Shipping shares attributes of orders but specific fields are included here for reference purposes only.
| Note |
|---|
Note: There is a known issue when migrating orders with multiple shipments details of which can be found here. |
...
Shipping
...
DateShipped
...
StatusId
...
BaseShippingCost
...
ShippingCostExTax
...
ShippingCostIncTax
...
ShippingCostTax
...
ShippingCostTaxClassId
...
ItemsShipped
...
ShippingAddresses
...
ShippingAddressCount
SOURCE STORE DESTINATION STORE
NOTE : Image shows that shipping information was NOT migrated.
...
7) PAGES
...
Pages
...
Id
...
MetaTitle
...
Name
...
LayoutFile
...
Type
...
SortOrder
...
Link
...
SearchKeywords
...
Feed
...
MetaKeywords
...
Body
...
ParentId
...
MobileBody
...
Url
...
ContactFields
...
MetaDescription
...
...
ContentType
...
HasMobileVersion
...
IsCustomersOnly
...
IsVisible
...
IsHomepage
SOURCE STORE DESTINATION STORE
...
8) Coupons (store/manage/marketing/coupons)
...
Coupons
...
id
...
applies_to
...
name
...
num_uses
...
type
...
max_uses
...
amount
...
max_uses_per_customer
...
min_purchase
...
restricted_to
...
expires
...
shipping_methods
...
enabled
...
date_created
...
code
SOURCE STORE DESTINATION STORE
...
9) Store Profile (store/manage/settings/store-profile)
...
Store Profile
...
store_phone
...
store_email
...
store_name
...
store_address_type
...
store_address
...
store_country
SOURCE STORE DESTINATION STORE
...
10 Store Settings
The fields for store settings are spread across multiple UI’s and API’s. They have been simplified below and are for reference only. Store settings have further been broken down into their relevant sections as defined by the BigCommerce UI.
Website
Display
Store Locale
Date and Time Zone
URL Structure
Search
Security and Privacy
Miscellaneous
...
Website
SOURCE STORE DESTINATION STORE
...
Store Settings - Website
...
Weight Measurement
...
Length Measurement
...
Decimal Token
...
Thousands Token
...
Decimal Places
...
Factoring Dimension
...
Home Page Title
...
Meta Keywords
...
Meta Description
...
WWWRedirect
...
Display
...
Store Settings - Display
...
Show Quantity Box For Products
...
Auto Approve Reviews
...
Enable Search Suggest
...
Enable Wishlist
...
Enable Product Comparisons
...
Enable Account Creation
...
Enable WYSIWYG editor
...
Show Thumbnails
...
Default Product Sort
...
Menu Display Depth
...
Show Product Price
...
Show Product Sku
...
Show Product Weight
...
Show Product Brand
...
Show Product Shipping Cost
...
Show Products Rating
...
Show Add To Cart Link
...
Preorder message
SOURCE STORE DESTINATION STORE
...
...
Inventory Settings
...
Inventory Settings
...
low_stock_notification_addresses
...
out_of_stock_notification_addresses
SOURCE STORE DESTINATION STORE
...
Store Locale
...
Store locale
...
default_shopper_language
...
shopper_language_selection_method
SOURCE STORE DESTINATION STORE
...
...
Date and Timezone
| Note |
|---|
Note : This is a known issue. A complete list of known issues can be found here. |
...
Date and Timezone
...
default timezone
...
Enable DST Correction
...
Display Date Format
...
Extended Date Format
SOURCE STORE DESTINATION STORE
...
...
Search
...
Custom Fields
...
content_product_sort
...
default_product_sort
...
product_filtering_enabled
SOURCE STORE DESTINATION STORE
...
...
Product Settings
...
Product Settings
...
default_preorder_message
...
show_add_to_cart_link
...
show_add_to_cart_qty_box
...
show_add_to_wishlist
...
show_breadcrumbs_product_pages
...
show_product_brand
...
show_product_price
...
show_product_rating
...
show_product_shipping
...
show_product_sku
...
show_product_weight
SOURCE STORE DESTINATION STORE
...
...
Currencies
...
Currencies
...
is_default
...
country_iso2
...
currency_code
...
currency_exchange_rate
...
auto_update
...
token_location
...
token
...
decimal_token
...
thousands_token
...
decimal_places
...
name
...
enabled
...
is_transactional
...
id
...
last_updated
SOURCE STORE DESTINATION STORE
...
Category Settings
...
Category Settings
...
category_tree_depth
...
default_product_sort
...
listing_mode
SOURCE STORE DESTINATION STORE
...
...
Channels
...
Channels
...
config_meta
...
id
...
external_id
...
is_listable_from_ui
...
is_visible
...
is_enabled
...
status
...
name
...
type
...
platform
...
date_created
...
date_modified
| Note |
|---|
Some channel data is Multistore functionality and is in the roadmap for completion |
SOURCE STORE DESTINATION STORE
...
...
12) Blog Posts
...
Blog Posts
...
id
...
title
...
url
...
preview_url
...
body
...
tags
...
summary
...
is_published
...
published_date
...
meta_description
...
meta_keywords
...
author
...
thumbnail_path
SOURCE STORE DESTINATION STORE
...
13) Gift Certificates
| Note |
|---|
There is currently a known issue with gift certificate settings. For a complete list of known issues please click here. |
...
Gift Certificates
...
to_name
...
to_email
...
from_name
...
from_email
...
amount
...
id
...
customer_id
...
order_id
...
balance
...
purchase_date
...
expiry_date
...
template
...
message
...
status
SOURCE STORE DESTINATION STORE
...
14) Shipping Zones
...
Shipping Zones
...
id
...
name
...
type
...
locations
...
free_shipping
...
handling_fees
...
enabled
SOURCE STORE DESTINATION STORE
...
15) Shipping Methods
...
Shipping Methods
...
id
...
name
...
type
...
settings
...
enabled
...
handling_fees
...
is_fallback
| Note |
|---|
There is a known error with duplicating shipping methods. This is in the process of being corrected. |
SOURCE STORE DESTINATION STORE
...
...
16) Robots.txt
...
Robots
...
robots_txt_ssl
SOURCE STORE DESTINATION STORE
...
...
17) Storefront SEO
...
Storefront SEO
...
meta_description
...
meta_keywords
...
page_title
...
www_redirect
SOURCE STORE DESTINATION STORE
...
18) Banners
SOURCE STORE DESTINATION STORE
...
| Note |
|---|
Banner migration is successful on a complete migration however there is a dependency between some banners and brand / category pages. For this reason you should include Brands and Categories when migrating banners. |
...
19) EMail Template Statuses
...
EMail Template Status
...
abandoned_cart_email
...
account_details_changed_email
...
combined_order_status_email
...
create_account_email
...
create_guest_account_email
...
gift_certificate_email
...
invoice_email
...
order_message_notification_email
...
product_review_email
...
return_confirmation_email
...
return_statuschange_email
SOURCE STORE DESTINATION STORE
...
...
...
20) Abandoned Cart eMails
SOURCE STORE DESTINATION STORE
...
...
21) EMail Templates
SOURCE STORE DESTINATION STORE
...