BigCommerce is the leading e-commerce platform for running an online store.
Data integration: Skyvia supports importing data to and from BigCommerce, exporting BigCommerce data to CSV files, replicating BigCommerce data to relational databases, and synchronizing BigCommerce data with other cloud apps and relational databases.
Backup: Skyvia Backup supports BigCommerce backup.
Query: Skyvia Query supports BigCommerce.
Skyvia has the following limitations for BigCommerce:
|•||Synchronization and Replication with Incremental Updates enabled are not supported for objects without DateCreated and DateModified fields. Both fields must be present for this functionality.|
Skyvia supports connecting to BigCommerce both using legacy basic authentication and OAuth authentication.
To connect to BigCommerce, using basic authentication you need to specify the url to connect to and the user name and authentication token to login.
You need to specify the following parameters for a basic authentication connection:
|•||Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.|
|•||URL - API Path - the path where all XML requests to BigCommerce should be sent.|
|•||User Id - the user name to login with.|
|•||Authentication Token - an automatically generated key that is used that must be included in the API requests to BigCommerce.|
To get the URL, User Id, and Authentication Token, sign in to BigCommerce, point to the Settings link in the bottom left corner of the page, and then in the Advanced Settings column click the Legacy API Settings link. After this, you can find all the necessary parameters in the opened Legacy API Account Details. Copy the Username parameter to the User Id box, API Path parameter to the URL box, and API Token parameter to the Authentication Token box.
To connect to BigCommerce, using OAuth authentication you need to specify the store ID to connect to and access token.
|•||Store Id - API Path - the path where all XML requests to BigCommerce should be sent.|
|•||Access Token - the OAuth access token to login with.|
Optionally, you can also change value for the Metadata Cache connection parameter
|•||Metadata Cache - Determines how often to update cached metadata for the connection. By default, Skyvia caches metadata of available objects for cloud sources. You can configure how often the cache is refreshed automatically or reset in manually on the Connection Details page of the corresponding connection by clicking the Clear link in the Metadata cache parameter in the Parameters pane. The following values are available for this setting:|
|o||Disabled - the metadata cache is not created, and metadata are queried automatically whenever the connection is opened.|
|o||One Hour - the metadata cache expires after one hour since the previous refresh, and it is refreshed after this when the connection is opened.|
|o||One Day - the metadata cache expires after one day since the previous refresh, and it is refreshed after this when the connection is opened.|
|o||One Week - the metadata cache expires after one week since the previous refresh, and it is refreshed after this when the connection is opened.|
|o||One Month - the metadata cache expires after one month since the previous refresh, and it is refreshed after this when the connection is opened.|
|o||Infinite - the cache is never reset automatically. Default value.|