Single Store: Import inventory data into a Paladin database

Note: This article applies to single stores only.

This article provides instruction and information on the following:

• How to open an Excel document and retain the leading zeros
• How to correctly format column headers for importing
• How to save a document as a tab delimited file using Excel
• How to import inventory into Paladin

Important

• Before you start this process, you must create a backup of your data and read through this entire article.
• This procedure does not apply to multi-stores.
• This procedure must be done on the computer designated as the store server.
• Paladin offers data import services. If you need help, call Paladin for a quote.
• Do not import inventory data into Paladin until after store hours.
• Microsoft Excel 2007 or later is required for creating and editing files for importing. Note: The instructions for Microsoft Excel vary depending on the version you are running. 
  • You must import either a tab delimited file or an Excel file.
  • Column headers must contain case sensitive, accurate spelling.
  • Importing will fail if you have columns with data but you do not have column headers.
  • Each row can only include one inventory item.

How to open an Excel document and retain the leading zeros

1. Open Excel, create a file name, then save the Excel worksheet.
2. On the File menu, click Open, browse to the Excel file, highlight it, then click Open.
3. In the Text Import Wizard window, check Delimited, then click Next.
4. In the Delimiters Options section, check Tab, then click Next.
5. In the preview window, click the first column displayed, press the Shift key, then click the last column. All of the columns will be highlighted.
6. In the Column data format options, click the Text box.
7. Click Finished.

Back to Top

How to correctly format column headers for importing

1. For instruction on how to retrieve all column headers, refer to the Export inventory data KBA.
2. Once you have exported the file, remove any columns that are not a part of the required column headers (see below).
3. Remove any additional columns that you are not updating. This step helps ensure that you don’t make unintended changes to your database.
4. If you are importing a tab delimited file, refer to the How to save a document as a tab delimited file using Excel section in this article.
5. If you are importing an Excel file, refer to the How to import inventory into Paladin section in this article.

To do this	Required column headers	Recommended column headers
Update existing records	PARTNUMBER Other headers that you want to update Notes: If you want to update the Supplier 2 field, the information for Supplier 1 must be included in the import file. If you want to update the Description 2 field, the information for Description 1 must be included in the import field. If you want to update the Quantity Pricing 2 field, the information for Quantity Pricing 1 must be included in the import field. To prevent an inventory item from being automatically discounted, set NETPRICE from zero to 1.	ALTPARTNUMBER STOCKONHAND MINORDERQTY CLASSID MFGPARTNUMBER SUPPLIER_NUMBER1 NETPRICE
Create new items	Note:  Nine (9) characters or less are recommended. The limit is 14 characters. PARTNUMBER DESCRIPTION1 SUPPLIER_NUMBER1 UNITCOST MKTCOST PLVL_PRICE1 DEPTID	ALTPARTNUMBER (if no set UPC)   MINORDERQTY CLASSID1 MFGPARTNUMBER

Important: Blank columns will not be processed. The ID/Value pairs must exist and be set up in Paladin prior to running the importer. Many columns only hold the reference ID to its corresponding value. For example, if supplier 55 is ACME, then the value of SUPPLIER_NUMBER1 would have a value of 55, not the name ACME.

Back to Top

How to save a document as a tab delimited file using Excel

Important: Only perform this step if you are importing a tab delimited file. Each row in the file must refer to a single inventory item.

1. Open the Excel worksheet that you want to import.
2. On the File menu, click Save As, select Tab Delimited, rename the file, then click Save.
3. Verify that the tab-delimited file that you just created is accurate.

Back to Top

How to import inventory into Paladin

Important: To make sure the import will function as expected, create a test import file with only a few items. If you make a mistake, you can restore the backup.

1. In Paladin, on the top ribbon, select the Backup module.
2. In the Backup window, click Yes.
3. When the backup is finished, go to the shortcut for Backups, then verify the following information.
   • Date of backup
   • Time of backup
   • Size of backup (Note: The size of the new backup should be higher than the previous one.)

4. In Paladin, on the top menu, select Maintain > Data Viewer.
5. Select the Inventory tab, then click the Import tab.
6. Select either Tab Delimited or Excel from the list adjacent to the Load File button.
7. Click Load File.
8. Browse to the file you want to import, select the file, then click Open.
9. In the Import Options pane, in the Inventory Type list, select Active Inventory or Obscure Catalog.
   • Active Inventory: Inventory that is carried in your store.
   • Obscure Catalog: Inventory that is available through your supplier.
10. Check Add New Items or check Update Existing Items.

Important: If you have not already done so, you must create a backup before you click Import.

11. Click Import.
12. When the importing process is completed, click Close.
13. In Paladin, on the top ribbon, select the Inventory module.
14. Enter a part number from the import file, then check all fields for accuracy.

Back to Top