Retrieves a list of locales for the store.



Table Specific Information

Select

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

• InputChannelId supports the = comparison.

The rest of the filter is executed client-side within the connector. For example, the following queries are processed server-side:

SELECT * FROM Locales;
SELECT * FROM Locales WHERE InputChannelId = '1';

Insert

You can add a new locale to a channel.

INSERT INTO Locales (Code, InputChannelId, Status) VALUES ('fr', '1', 'ACTIVE');

Update

You can update an existing locale. Code and InputChannelId are required in WHERE clause.

UPDATE Locales SET Status = 'INACTIVE' WHERE Code = 'fr' AND InputChannelId = '1';
UPDATE Locales SET IsDefault = true WHERE Code = 'en' AND InputChannelId = '1';

Delete

You can remove a locale from a channel.

DELETE FROM Locales WHERE Code = 'fr' AND InputChannelId = '1';

Columns

Name	Type	ReadOnly	Description
Code [KEY]	String	False	The code of the locale.
InputChannelId [KEY]	String	False	The ID of the channel.
StoreId	String	False	The ID of the object.
Status	String	False	The status of the locale. The allowed values are ACTIVE, INACTIVE.
IsDefault	Bool	False	Indicates whether the locale is the default.