API : store/manage/orders
| Anchor | ||||
|---|---|---|---|---|
|
Due to the potentially high numbers of orders and customers which may exist in a production environment, neither are migrated on store creation. Instead, you will need to use the “Content Migration” screen to confirm that you want to move this data. See “Understanding the Content Migration Screen”
Order IDs in BigCommerce are incremental and so StagingPro does not keep the original order number. It will still migrate the order but it will have a different order numberincrementally assigned each time an order is created. Hence the original order number cannot always be retained. It is also because of this incremental behavior that records in the destination store cannot be deleted thus having the effect of the destination store continually growing with each migration that occurs. It is therefore recommended not to migrate orders unless it is absolutely necessary.
All orders which are migrated have their status changed to “Pending” as keeping the original status may trigger emails to be sent out to clients.
The following fields are migrated as part of ‘Orders’ however many are not visible on the UI.
| Anchor | ||||
|---|---|---|---|---|
|
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 |
|
| Anchor | ||||
|---|---|---|---|---|
|
Order Details
SOURCE STORE DESTINATION STORE
...
| Anchor | ||||
|---|---|---|---|---|
|
Anonymising Data
While difficult to identify due to the order IDs AND customer names having been changed, StagingPro successfully anonymizes data for GDPR and stops your developers from getting access to personal information.
...
SOURCE STORE DESTINATION STORE
...
| Anchor | ||||
|---|---|---|---|---|
|
Order Shipments
All orders which are migrated have their status changed to “Pending” as keeping the original status may trigger emails to be sent out to clients and because of this, it is assumed that these orders have not been shipped thus shipments are not migrated along with order data.