Example Flat Files
To get you started off quickly, a ZIP file containing all of the example flat files mentioned in this document is provided here for your convenience:
A SKU is required for every inventory and product update and must match the same SKU provided in earlier updates. If a SKU changes, it is best to discontinue the old SKU and then create the new SKU.
Once a SKU has been added to the system, it will stay there and cannot be removed, although it can be discontinued if no longer needed. Discontinued SKUs are still accessible through the Dsco portal.
If you do create a bad SKU and must have it removed from the system, please contact [email protected]
Supported Delimited File Formats
The Dsco flat-file exchange platform, as well as the Data Mapper tool, supports files delimited by Tab, Pipe, Comma’s and Microsoft Excel .xls format. The default file extensions are ".tab" for Tab delimited files, ".csv" for Comma delimited files, ".psv" for Pipe delimited files and ".xls" for Microsoft Excel files. However, if other file extensions are required, the automation job can be configured to use those as well.
The Dsco flat-file exchange platform requires that a header row be provided in every file. If you are a retailer, this ensures that you always know which fields are included and the location of each field is consistent. If you are a supplier, providing a header row allows flexibility when you don't wish to provide every available field that we support.
For example, if you wanted to update just the wholesale cost of a SKU you can do so by providing a file with just two columns, "sku" and "cost", and Dsco will read the header row, see which fields you want to update, and only update the provided fields.
An FTP account is available for every Dsco account. You can find your FTP account credentials when setting up jobs on the AUTOMATION page within your account. Simply go to AUTOMATION and then select FTP (https://app.dsco.io/automation/ftp). An explanation of the folder structure is also provided on that page.
All incoming files (from you to Dsco ) must be placed within your FTP account in the "/in" folder. As Dsco processes the files, we move the files to the "/in/processing" and "/in/archive" folders for later review if necessary.
All outgoing files (from Dsco to you) should be placed in the "/out" folder. When files in the "/out" directory are downloaded, Dsco detects the download and automatically moves/archives the file to the "/out/archive" folder in case you wish to access it later.
Dsco recommends using the SFTP option whenever possible. Dsco utilizes the standard SFTP port number 22. When using standard FTP, you should use port 21.
All flat files must be UTF-8 encoded. We do not support files saved with a BOM (byte-order-mark).