Import Stock Attributes

To import stock attributes in bulk, follow these steps:

First, create the stock attributes template file:

1. Go to Data Imports/Exports > Import Stock Attributes in the IRP Admin left navigation menu.
2. Click the Create Template File tab.
   
3. The Download Template File page appears - you can download either a standard template file or a custom template file:
• Download Standard Template File: Standard template files contain the key fields. Choose from one of the formats available in the drop-down list.
• Download Custom Template File: These template files contain the key fields associated with IRP stock attribute data. Use the radio buttons to download a template file with your stock attribute data in the columns or without your stock attribute data (blank). Any data will come directly from your IRP. You can download the files in one of the following formats:
  
  • CSV (Comma Delimited Text File)
  • TSV (Tab Delimited Text File)
  • Pipe (Pipe Delimited Text File)
  • XLSX (Microsoft Excel 2007 - ) Note that, for files containing in excess of 20000 rows, it is often more efficient to use a flat file (.tsv, .csv or .txt) rather than a Microsoft Excel file.
• Filter Selection: Check this box to filter the stock attributes template file by:
  
  • Brand: Select a brand with which to specifically filter the template file.
  • Category: Select a category with which to specifically filter the template file.
  • Active Only: Tick this box if you only want Active items, i.e. Stock item, Model, Brand and Category are all Active, to appear in the Template File.
  • Missing Only: Tick this box if you only want missing Attribute Values to appear in the Template File.
  • Attributes: Select an attribute with which to specifically filter the template file.
• Select Columns: You can customise these template files by selecting fields from the database tables. Alternatively you can check the Select All Columns box. You MUST include prerequisite fields in the file. Any data will come directly from your IRP. You can download the files in one of the following formats:
  
  • CSV (Comma Delimited Text File)
  • TSV (Tab Delimited Text File)
  • Pipe (Pipe Delimited Text File)
  • XLSX (Microsoft Excel 2007 - ) Note that, for files containing in excess of 20000 rows, it is often more efficient to use a flat file (.tsv, .csv or .txt) rather than a Microsoft Excel file.
4. Use the 'Date From' and 'Date To' boxes to restrict the file to only include records created during this date range.
5. Click the Download button when you are finished.
6. You can then edit the data in the file, as necessary, and save it for staging and importing.

Next, upload the stock attributes template file and stage the data temporarily before fully importing it:

1. Click the Import Stock Attributes Data tab.
   
2. The Import Stock Attributes page appears, as follows:
   
   
3. In Step 1: Upload and Stage Stock Attributes Import File, click the Browse button to find the file that you created earlier.
4. Click the Upload and Stage button to upload the file to the IRP and stage the data.
5. At the bottom of the page, the Sample of Staged Stock Attributes section shows the details from the staged data set. This includes all of the columns that you selected for the data set when you created the template.
6. Back up at the Stock Attribute Import Options section, click the Import Stock Attributes button to import and display the stock attributes on the IRP: