Importing Item Records for Online Web Store

It is easy to import item records into Artisan. The process is the same as posted in the general import article.

Open an Excel Spreadsheet (.XLS or .XLSX) file. Create column headers with the following information.

ITEMCODELeave Blank to have Artisan auto-generate an item code.
HOWEVER, if you leave this field blank, when you repeat the process you will get yet another new item record.
If you want to update existing items, you must include the Item Code field, UPC, or Vendor’s P/N and Vendor.
IDESCItem Description (Required for NEW records)
PRICERetail Price
CATEGORYItem Category Code (Required for NEW records)
VENDORItem’s Vendor Code (Required or use “NONE”)
ONLINEUse Online? This should be a “Y” or “N” or left blank
INSTOREIn-store only?
FEATUREDFeatured product?
SORTORDERCatalog Order
ISLAYOUTInternet Store Layout Template
ISLAYOPTSAdditional Layout Options
XCATCODESAdditional Categories
TAGSProduct Tags
RELPRODSRelated Products
PRODNAMEProduct Name / Title
SHIPWEIGHTThe shipping weight. Not required, but very useful
DETAILDESCDetailed Description
BRIEFDESCBrief Description, mostly used for SEO metadata
FULLIMAGEThe URL to the image on the WEB or LOCAL file path
ALTIMAGE1The first secondary image
ALTIMAGE2The second secondary image
ALTIMAGE3The third secondary image
ALTIMAGE4The fourth secondary image
ALTIMAGE5The fifth secondary image

Once you’re done, navigate to “File” and “Import.”

Select “Item Records.”

Locate your file and select “Open.”

Determine how you want to import your file, otherwise known as the Import Mode. Do you want to update and append your records, update existing records and discard any new records, or append only new records and leave existing records as-is? 

Once you’ve made your selection, Artisan will display if your import was successful, along with the number of items imported.

Check the Item Record(s) to ensure Artisan inputted your data correctly.