IRP Admin
Common Tasks (1)
Open
Interventions (1)
Open
Languages (1)
Open
Questions & Answers (1)
Open
Reviews (1)
Open
Site Scripts (1)
Open
Web Services (1)
Open
Training Videos
Peer Support

Import Stock Attributes

You can find this section under Data Imports/Exports > Import Stock Attributes in the IRP Admin left navigation menu.

NOTE: The import process for products, stock attributes, customers, & mailing lists is largely the same; only the columns change. Therefore, you should reference the Import Products video.

You use this section to import stock attributes in bulk to the IRP. This is a useful feature in IRP as it allows you to import large numbers of stock attributes effortlessly. All you need to do is complete a template file and then upload it to the IRP.

Note that some details are required — these are shown as non-selectable, greyed-out columns.

When you have completed the straightforward process of configuring the template, you can stage and upload the data with the click of a button.

The DataImportStockAttributes.aspx page appears as follows (note that this shows a staged data file and your screen will look different if you have not yet uploaded a data file):

Import Stock Attributes

As shown in the screen capture above, there are two tabs:

  • Import Stock Attributes: You use this tab to upload your completed stock attributes file, stage the data and then import it to the IRP.
  • Create Template File: You use this tab to set up and download a template file for importing the stock attributes.

For more details, refer to the How To Import Stock Attributes article in this section.

How To Guides (1)

Close
Close
How To 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 screen 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 screen appears, as follows:
    Import Stock Attributes
  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 screen, 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:
    Import Stock Attributes button

FAQs (1)

Close
How can I export all products that are missing attributes?
You can do this as follows:
  1. Go to Data Imports / Exports > Import Stock Attributes in the IRP Admin left navigation menu.
  2. Select the Create Template File tab.
  3. Under the Download Custom Template File subsection, click the Filter Selection checkbox.
  4. You will see several options for filtering the resultant dataset and then you will be given the chance to select only the columns that you want to see.

For larger datasets, it is recommended that you download the file in flat-file format (i.e. CSV, TSV or Pipe Delimited) as Microsoft Excel can sometimes create bulkier files.

Copyright © 2020 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy

IRP Commerce is a Trading Name of Export Technologies Limited, Concourse 3, Catalyst, Belfast, BT3 9DT, UK. Registered in Northern Ireland, Number: NI 041856. VAT Number: GB 888249658
A Deloitte Fast 50 Company seven times: 2010, 2011, 2012, 2013, 2014, 2018 & 2019