Audience: Retailers

Example flat files

To get you started off quickly, please see Dsco Data Schema for a zip file with all of the example flat files.

SKUs

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 support@dsco.io.

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. 

Header row

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. 

SFTP

An SFTP account is available for every Dsco account. You can find your SFTP account credentials when setting up jobs on the AUTOMATION page within your account. Simply go to AUTOMATION and then select SFTP (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 SFTP 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.

UTF-8 encoding

All flat files must be UTF-8 encoded. We do not support files saved with a BOM (byte-order-mark).

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.