Suppliers can provide stock files or invoice files for easier data entry of product into Retailer.
Stock files generally contain product information like barcodes, descriptions and prices, and mainly server to add product information to the system without looking at quantities.
Invoice files are used for particular stock arrivals, and contain stock information along with how many quantities are received.
The sections below explain the requirements for the files in more detail.
An attachment at the bottom of the sheet summarises all this information on stock and invoice files (Tower Systems Stock Files EDI Invoicing).
Stock Files - requirements and sample
Suppliers may need a template or sample of what to put into a stock file that can be imported into Retailer.
To download a sample, click the attachment (Sample Stock File) at the bottom of this article.
Not all the information in the file is necessary, so here are some requirements:
- The file must be in CSV format.
- There cannot be any blank lines in between each stock line.
- The file must have at least:
- Barcodes or Supplier Stock codes (See warning below)
- Descriptions
- One price (other prices can be calculated based on markup settings if not available)
- The file can have Header information at the top, and every line after that must be stock lines until the end. It cannot have Header lines, then stock lines, then Header lines, then stock lines, etc.
Supplier Stock Codes can be used in place of barcodes only if the items do not already exist in your system (Retailer will generate barcodes during import). If you are using a stock file to update prices, barcodes are a requirement.