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:

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 the 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