Quoting settings specify how your text fields are encapsulated. It's an important part of correctly handling data that includes delimiters.
In this article, we explain your quoting options when importing product data, and why quoting is important.
Contents
Quoting options in Channable
When importing product data from a data file, you'll be prompted to select your Quoting type.
- Automatically detect: Channable will attempt to automatically identify your quoting method.
- Yes: Select this if the text fields in your data file are enclosed in quotation marks (e.g. "product name", "description"). This tells us to treat everything within the quotes as a single field.
- No: Select this if your data fields aren't enclosed in quotation marks.
Why is selecting the right quoting important?
If your quoting is determined incorrectly, it can affect how we interpret your data.
If you import a CSV file and select your delimiter as a comma (,), if your product description is 100% cotton, breathable, and stylish shirt, the comma may be misinterpreted as separating fields. This causes your data to be read incorrectly.
If your your description is closed within quotation marks (e.g. "100% cotton, breathable, and stylish shirt"), the entire text will be treated as a single field.