1. File Format
Remerge supports a variety of formats and as such the feed can be an XML, CSV or TSV file.
Please note:
- Feed size should not exceed 40 GB.
- The files should be compressed with GZIP (*.gz extension).
- CSV file - Column delimiter should be a comma.
- TSV file - Column delimiter should be a tab.
Please note: Remerge does not support an API feed.
| API Feed Support | XML, CSV or TSV |
2. Encoding
Unicode (UTF-8) should be used as a character set.
| euc-kr, gb2312 | utf8 |
3. Obligatory Header
The file must contain a header with column names.
| 34fx5 | "Amazing Sofa" | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 |
| id | title | description | image_url | deep_link |
| 34fx5 | "Amazing Sofa" | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 |
Below Header Requirements:
Column names should be alphanumeric and begin with an alphabetic character.
| 345 | description |
Column names can be written in a camel or snake case format.
| amazing table | amazing_table |
| Amazing Table | AmazingTable |
Column names should not contain spaces or any other special characters.
| Amazing Table | AmazingTable |
4. Consistency in Number of Columns
Each row must contain the same number of columns.
Please note: Although the number of columns should be identical, some columns may be empty of content.
| id | title | description | image_url | deep_link | category | sales_price |
| 34fx5 | "Amazing Sofa" | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 | "Sofa" | 3209.00 |
| 45fx8 | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 | "Sofa" | 3209.00 |
| id | title | description | image_url | deep_link | category | price | sales_price |
| 34fx5 | "Amazing Sofa" | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 | "Sofa" | 5500.00 | 3209.00 |
| 45fx8 | "Awesome Sofa, Get it Now!" | https://... | myapp://product/view/34fx5 | "Sofa" | 5500.00 | 3209.00 |
5. Quoted Fields
Fields can be quoted in double-quotes only. Example:
| 'Amazing Table' | "Amazing Table" |
6. Quotes in Quotation Marks
Fields containing a comma (in case of comma-separated files) or quotes, must be quoted with double quotation marks. Example:
| Say hi to your new table. | ""Say "hi" to your new table."" |