TABLE OF CONTENTS
File Format
Auto
The File Format is default set as Auto, and Stock Sync will auto-detect the file format.
If the file is encrypted in .zip or .gz, the auto-detect won't work. Please specify the file format.CSV
If the file format is CSV, the Column Separator selection list is as below:
| , | ; | \t | @ | ~ | | | * | < | > |
| ^ | # |
If the file's column separator not as listed above, you can add your own on the Column Separator field.File Encoding
| Auto | UTF-8 | UTF-16 | UTF-16le | Windows-1252 | ISO-8859-1 | Windows-1250 |
XML
Based on the example above, the Parent Node is item
If the XML file has a nested node, you must enter the Variant Node.
XLS/XLSX
Input the Sheet Name of the file location. Stock Sync supports multiple sheets separated by commas. eg. Sheet1, Sheet2
JSON
"Products": [
{
"Id": 297,
"Name": "Jeans",
"Type": 1,
"Features": [],
"Variants": [
{
"Id": "2123207144",
"Price": 250.00,
"Color": "Classic Black",
"Size": "S",
"Usage": "",
"Discontinued": false,
"ShowInShop": true,
"Barcode": "123456789",
"Images": [
{
"Path": "https://images.adidasshoe.jpg",
"SkuId": "25347",
}
]
...
]
}
...
]Based on the example above, the JSON Data Key is Products and the Variant Node is Variants.
.TXT
If the file format is .TXT, the Column Separator selection list is as below:
| , | ; | \t | @ | ~ | | | * | < | > |
| ^ | # |
If the file's column separator not as listed above, you can add your own on the Column Separator field.TSV
If the file format is TSV, the Column Separator selection list is as below:
| , | ; | \t | @ | ~ | | | * | < | > |
| ^ | # |
If the file's column separator not as listed above, you can add your own on the Column Separator field.File Encoding
| Auto | UTF-8 | UTF-16 | UTF-16le | Windows-1252 | ISO-8859-1 | Windows-1250 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article