{"id":18433,"date":"2023-02-21T15:05:46","date_gmt":"2023-02-21T20:05:46","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=18433"},"modified":"2023-10-02T09:42:21","modified_gmt":"2023-10-02T13:42:21","slug":"item-alternate-codes","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/item-alternate-codes\/","title":{"rendered":"Import Item Alternate Codes"},"content":{"rendered":"\n

IMPORTANT: Before importing any files into Artisan\u2019s database, MAKE A BACKUP of your data in case you did not import what you wanted and want to go back to a previous point in time. Click here<\/a><\/strong> to learn about your backup options. <\/p>\n\n\n\n

Artisan allows importing files for different types of records. Only RAW imports can be done. That is, the user needs to compile a file to meet a specific format we will describe below in this article. Once the file is in one of the recommended formats, then we can use the Raw Import Utility in Artisan to add records to the current database.<\/p>\n

What Are Item Alternate Codes?<\/strong><\/h3>\n

Item alternate codes are useful for products that have more than one UPC code. You can add these manually within the item record, or as we’re doing in this article, by importing them. Once they’re added, they’ll be located in the “Codes and Measures” tab. Whenever any of the alternate codes are scanned, Artisan will recognize this as belonging to the item record.<\/p>\n

\n

<\/a>Steps to Follow<\/h3>\n

1. Like with any other records we will be importing, the first thing we need to do is look at the proper column headers for this type of record. Artisan needs a specific code to identify the data being imported \u2013 and those codes are given to you in this article. If you import a file with column header names different from what is given in this article, Artisan will ignore the data under that column entirely. To avoid this from happening, make sure you use the column headers appropriately.<\/p>\n

2. Then, we work on the file to meet one of these formats. You can use any spreadsheet program \u2013 common programs are Microsoft Excel or Google Sheets. Make sure you save the file as one of these formats:<\/p>\n