It's crucial to use the correct data types when filling in product feed fields to ensure that the information is accurately processed by the Daisycon system. Each field in our product feed has a specific data type requirement (e.g., text, number, date), and using the wrong format may lead to errors or prevent your products from being correctly listed. By following the product feed-field types, you ensure your data is validated and processed without issues, making it easier for the system and for the publishers to understand and use the information correctly. For example, numeric fields should not contain text, and dates must follow the correct format.
For more detailed information about SQL data types, click here.
Daisycon product feed field type guide
| Type | Type description |
| BOOLEAN | Only valid input: true, false or <empty> |
| DATE | Date formatted as: YYYY-MM-DD |
| DATETIME | Date formatted as: YYYY-MM-DD HH:MM:SS |
| DECIMAL |
Numerical value with decimals seperated by a point, without other characters. |
| INT |
Numerical value without other characters, "Unlimited" valued should be submitted as 99999 (5 times 9) |
| LIST |
Textual value, one of the predefined options. |
| TEXT | Textual value, all characters allowed, long text. |
| TIME | Time formatted as: HH:MM:SS |
| VARCHAR |
Textual value, all characters allowed, short text, a maximum of 255 bytes. |