Supplier stock files and invoice files

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:

1. The file must be in CSV format.
2. There cannot be any blank lines in between each stock line.
3. The file must have at least:
   
1. Barcodes or Supplier Stock codes (See warning below)
   
2. Descriptions
3. One price (other prices can be calculated based on markup settings if not available)
   

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.

Invoice Files - requirements and sample

For suppliers that need a template or sample of the invoice file that can be imported to Retailer, download the sample file at the bottom (Sample Invoice) of this article.

The file contains most of the requirement information:

1. The file must be in CSV format.
   
2. There cannot be any blank lines in between each stock line.
   
3. The file must have at least:
   
1. One invoice number, and one invoice date
   
2. Barcodes or Supplier Stock Codes (See warning below)
   
3. Descriptions
   
4. Cost Price (retail price will be calculated based on markup settings if not available)
   
5. Quantities arrived/received

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.

• Related Articles

• Supplier Stock Listing

  The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing ...

• Invoice Arrivals Due Date

  When arriving a supplier Invoice in Invoice Arrivals, the Due Date field can be set to calculate one of four ways: Number of days after Invoice Date Number of days after the end of the Invoice Month Of the Following Month Of the Current Month The due ...

• Stock Screen - Changing Details on Stock Items

  All aspects of a stock item - its name, prices, barcode, quantity on hand, stock code etc. - can be changed at any time. This is done through the Stock Screen, which is one of the most important screens in Retailer and one you will see a lot. The ...

• Importing A Supplier Stock File

  A supplier stock file or price/product list can be used to quickly and easily bulk import products into the Retailer software, which has barcodes associated with it. This is generally created in Excel and saved as either a spreadsheet or .csv file. ...

• General Stock Listing

  The General Stock Listing Report lists selected stock items by department/category as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing stock with a ...