Supplier Feed Config Detail Tab
It is possible to download a supplier feed, extract a supplier file from an SFTP folder and process the data within Khaos Control. To open this area type SF in the Command Window. Once setup, there are two options for importing your supplier feeds:
- The user can choose to import a single supplier feed manually or import from all supplier feeds in bulk. This can be automated, if you require this please email Support.
- For manually importing supplier feeds, see How To: Import Supplier Feeds.
This screen consists of the following areas:
General
- Supplier: The name of the supplier the feed is for.
- Active: Controls if this supplier has an active feed.
- File Type: This should indicate the delimiter of the file either:
- CSV
- TSV
- Feed Type: The type of feed either Local or FTP.
Local
The following options are available for configuring the Supplier Import from a local file:
- Local File Path: The local file path where the supplier levels can be updated from, for example:
- K:\SupplierImport\Import.csv for a File Type of CSV
- K:\SupplerImport\import.tsv for a File type of TSV.
Columns
These are the columns that the file will match on:
- Stock Code: The column for the stock code.
Note: If the Use supplier Ref checkbox is ticked then the supplier feed will look for the supplier ref set in[ Supplier | Detail | Supplier Summary | Supplier Stock ]and not the stock code. - Qty: This will allow the user to determine the column number which has the supplier's quantity which populate the Qty Avail field in the following screens:
- Buy Price: The column number which has the supplier buy price, which will populate the Supplier's Buy Price in the following screens:
- Lead Time: The column number which includes the supplier lead time, which should then go into the Supplier's Lead Time in the following screens:
Example CSV File
As an example, our Supplier Feed CSV file looks like:
stock_code, stock_qty, buy_price, lead_time
002253,321,1.59, 1234
002254-BAR,421,2.59,2732
019195item3,521,3.59,2733
| Column | Example value for the field |
|---|---|
| Stock Code | 1 (where 1 refers to the first field in the csv) |
| Qty | 2 (where 2 refers to the second field in the csv) |
| Buy Price | 3 (where 3 refers to the third field in the csv) |
| Lead Time | 4 (where 4 refers to the fourth field in the csv) |
FTP
The following options are available for configuring the Supplier Import from an FTP site:
- Host: The URL for the FTP site that Khaos Control will connect to retrieve supplier levels, for example ftp.yourwebsite.co.uk.
- Directory: The directory that Khaos Control will look at on the FTP site, for example SupplierLevels/.
- Filename: The file that contains the supplier stock levels; Khaos Control will look for this file to import the levels. This will expect a complete match and so should include file extension, for example Centaur.csv.
- Username: The username for the FTP site that the supplier levels will be pulled from, for example test_username.
- Password: The password for the FTP site that the supplier levels will be pulled from.