Excel Add-In for BigCommerce

Build 23.0.8839


Returns data from Currencies table.

Table Specific Information


The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' comparison.

The rest of the filter is executed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM currencies where Id=1


To insert a new Currencies, you need to specify at least the following columns: Code,Name,ExchangeRate,Token,TokenLocation,DecimalToken,ThousandsToken, and DecimalPlaces.

INSERT INTO Currencies (Code,Name,ExchangeRate,Token,TokenLocation,DecimalToken,ThousandsToken,DecimalPlaces) VALUES ('EUR','Euro', '3.0','$','left','.',',','2')


UPDATE Currencies SET Name='Testing123' where id=2


DELETE FROM Currencies WHERE Id = 3


Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the currency.

IsDefault Boolean True

Specifies whether this is the store's default currency.

Code String False

Three-letter ISO 4217 code for this currency.

Name String False

Name of this currency.

ExchangeRate Double False

Amount of this currency that is equivalent to one U.S. dollar.

CountryIso String False

Two-letter ISO Alpha-2 code.

AutoUpdate Boolean False

Whether to autoupdate currency data.

TokenLocation String False

Symbol for this currency.

Token String False

Name of the currency.

DecimalToken String False

Symbol used as the decimal separator in this currency.

ThousandsToken String False

Symbol used as the thousands separator in this currency.

DecimalPlaces Integer False

Number of decimal places to show for this currency.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839