StagingPro Enquiries: +44 20 4547 9292

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

API : store/manage/orders

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.

Order IDs in BigCommerce are incremental and so StagingPro is unable to keep the original order number. It will still migrate the order but it will have a different order number. 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.

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

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.

PLEASE NOTE : Anonymise Data is an option that has to be chosen manually and is not automatically applied.

SOURCE STORE DESTINATION STORE

  • No labels