Knowledgebase
Trading Software > Help Desk > Knowledgebase

Search help:


Simplified Stock Importer

Solution

2019-09-24: Created


This document describes how to import or update stock records.

Access via the Main Menu:

Import -> Simple Stock Importer

 

IMPORT:

------------

Your source data MUST INCLUDE a unique item reference column that will map to the BMS column [SUPREF]

[SUPREF] can accept an Alpha-Numeric value: Max length = 100 characters.

 

Open your source data in Excel or some other Spread-Sheet application.

Highlight and copy (Ctrl+C) the data you want to import.

Use the Import menu to post your copied data into this interface.

-> Paste 

-> Excel (navigate to an Excel file containing your source data)

 

You can selectively Import or Update:

-- Basic Item Data

-- Attribute Data       (Requires that a basic account record exists)

-- Bar codes             (Requires that a basic account record exists)

-- Inventory             (Requires that a basic account record exists)

-- Split Pricing          (Requires that a basic account record exists)

 

MAPPING:

------------

Mapping configurations can be saved and recalled between imports

You can map your source data columns to:

-- existing BMS columns for Basic ItemData.

-- BMS attributes (overwritten)

-- BMS Alternative Barcodes (overwritten)

-- Inventory (Appended)

-- Split Pricing (overwritten)

 

NOTE:

------------

You can re-import data at any time.

 

 
Was this article helpful? yes / no
Related articles Import Contacts
Data Import: Stock Import File - Data List
Bank Statement Import Functionality
URL File-List Download
Data Import: Attributes
Article details
Article ID: 241
Category: Create Stock Records
Rating (Votes): Article rated 3.4/5.0 (17)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies