Currencies

Returns data from Currencies table.

Table Specific Information

Select

The cmdlet uses the BigCommerce API to process WHERE clause conditions built with the Id column, which supports the = comparison.

The rest of the filter is executed client-side within the cmdlet.

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

SELECT * FROM Currencies WHERE Id = 1

Insert

To insert a currency, 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

UPDATE Currencies SET Name = 'Testing123' WHERE Id = 2

Delete

DELETE FROM Currencies WHERE Id = 3

Columns


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.
Enabled	Boolean	False		Indicates If the currency is active on the store.
IsTransactional	Boolean	False		Indicates if the currency is set as transactional or not. False means display only currency.
LastUpdated	Date	True		Date the currency was last updated, created or modified.