Inventory Import

back to top

Inventory Import lets you convert inventory data from third-party accounting systems or from manufacturers' inventory and pricing data.

Applications	back to top

• Upload initial item or customer data
• Revise existing items or customers
• Set up new items using manufacturer-supplied data
• Enter items for a gift registry
• Process manufacturer price updates
• Convert data from a third-party package
• Mass-modify existing data (example: change all category X items to category Y)
• Import Point of Sale or Order Entryline items

Data Integrity	back to top

During import, each field can be loaded with data from the text file, with a constant, or with a system default value. Math can be performed on numeric fields (add, subtract, multiply, divide), and text manipulation can be performed on alphanumeric fields (concatenation).

Data Interchange can process text files with multiple types of records and can even identify valid new records and valid update-only records. Data Interchange can be run unattended to process multiple text files and extract all required information.

An optional report can show either a complete list of items added and updated, or just errors.

Simple to Use	back to top

• Review the printed data descriptions provided by the manufacturer
• Type in the dictionary that describes the manufacturer's text file
• Look at the Items screen and decide where you want each data field to come from
• Type in the import specification to relate Item fields to dictionary fields
• Run the import

Summary	back to top

Data Interchange saves you time and money.