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

• Creating a Stock Item

  Creating a Stock Item If the stock wizard does not appear when you click the Add button, click HERE. The stock wizard can be accessed through several areas such as: Click the Add button in the Stock Screen. Click the Add button in the Find Stock ...

• Stock History - Orders Maintenance

  When creating a supplier order, you can select an item and look up its sales history. If you need information on how to create and send a supplier order in Orders Maintenance, start by clicking HERE . Click on the item in the grid, and click Stock ...

• 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. ...

• Resending Returns Files

  Retailer is able to resend electronic returns files through XchangeIT if they have not been received by the supplier. Returns can only be resent from the computer that originally sent the files. If the computer has been replaced or formatted, you ...

• [Pre 3.3] Creating a Supplier Order from Quote & Invoice Management

  When you do not have sufficient stock on-hand to fulfil a customer quote/invoice, you can create an order directly from the same screen. Retailer uses the amounts in Quantity on Backorder as the amount to order. Ordering Stock From A Pending Invoice ...