Import Fields for Artisan Records
Reference Number: AA-00364 Views: 4062 Created: 2014-01-29 13:28 Last Updated: 2014-08-18 12:00 0 Rating/ Voters

Import Fields for Artisan Records

Artisan POS Users Manual Version 3.0 Chapter 12.

BACKUP YOUR ARTISAN DATA BEFORE IMPORTING ANY RECORDS

Artisan allows you to import different records into the database. By using the import feature in Artisan you can import records for customers, items, item catalogs, vendors, manufacturer/publisher and categories. If you are using the Frame Shop version of Artisan there is the option to subscribe to the Vendor Catalog Service where we create an import for updated pricing from specific framing vendors.

If you look at the records in Artisan it will help you determine the layout required when importing, for example we use separate fields for Street, City & Zip Code, these cannot be combined into one field in the import file. 

Format your import file using the guidelines shown in the images below. Not all these fields are required but it will give you a good idea of the fields available, you can also look in the individual record screens in Artisan it you need help deciding where the information should go when imported.

When creating your file for import please note that the acceptable import formats are  .CSV (Comma delimited); Text (Tab delimited); .TTX (Tagged Text) or DBF (FoxPro & dBase).

Some of the fields you can import to Artisan are:


Active Item Records: Below is a list of all fields available when importing items. The only required fields for importing item records are Item Description, Vendor Code & Category Code. Artisan will automatically generate the item code for imported items if you do not already have an item code in the import file. We would also recommend importing the item Cost & Retail price and optionally the quantity on hand.























































Catalog Item Records: On the main import screen change the option for Import Records As to Catalog Records for Reference or Later Activation.



































































Customer Records: Below is a list of all fields available when importing customers. The only required fields for importing are Last Name or Business Name.




















Vendor Records: Below is a list of all fields available for import for the vendor records. The only required field for importing is the Vendor Name, Artisan will automatically generate the Vendor Code.





















Manufacturer/Publisher Records: Below is a list of all fields available for import for Manufacturer/Publisher. There are no required fields for importing.












Quick Jump Menu