Stock Import Tool - Examples

WARNING: Before using the Stock Import Tool please see the following page Stock Import Tool

Copy the values provided below into a Notepad and save as a .txt file. Open this file in Excel or similar spreadsheet software for easy editing. Ensure that files are always saved as a Tab Separated Value (TSV) file when saving in Excel or similar.

Update Buy and Sell Prices

To update just the buy and sell prices:

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 BUY_PRICE SELL_PRICE

New Supplier

To add a new supplier, if we get a new supplier for a range of our products:

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 Supplier:COMPANY_CODE Supplier:COMPANY_NAME Supplier:SUPPLIER_REF Supplier:PURCHASE_COST Supplier:DISCOUNT Supplier:REORDER_QTY Supplier:DEFAULT_SUPPLIER

Dimentions and Weights

To populate the dimensions and weights of a product range:

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 AVERAGE_WEIGHT POSTAGE_WEIGHT HEIGHT WIDTH DEPTH

Discontinue a Range of Products

To discontinue a range of products (could also be used with RUN_TO_ZERO should there be active stock):

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 DISCONTINUED

Import SCS Child Items

Import a new SCS child item, if we provide a pre-existing SCS parent Stock Code as the STOCK_CODE then we will add a new SCS Child to that Parent's configuration, if the parent doesn't exist it will be created, the parent should not be provided as a separate line within the import

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 SCS_SK1 SCS_DESC1 SCS_CAPTION1 SCS_SK2 SCS_DESC2 SCS_CAPTION2 SCS_DESC_TEMPLATE SCS_TEMPLATE

Adding Barcodes

Adding multiple barcode types to a Stock Code

STOCK_CODE STOCK_TYPE1 STOCK_TYPE2 Barcode:Type Barcode:Barcode Barcode:Type Barcode:Barcode Barcode:Type Barcode:Barcode

See Also

• System Data overview
• Stock screen