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

Bulk Updates

You can find this section under Data Imports/Exports > Bulk Updates in the IRP Admin left navigation menu.

You use this section to make updates to a selection of key tables in IRP Admin, including your brands, categories, customers, models, stock, stock location level and translation data.

NOTE: You should NOT use the Bulk Updates section for creating new products. If you want to add new products, use the Import Products section.

This is one of the powerful features in IRP that enable you to create and manage your product catalogue effortlessly. All you need to do is complete a template file and then upload it to the IRP.

Here is an introductory video about the Bulk Updates section
Note: The video is intended only to provide a general overview of the area. Currently IRP videos are not maintained in line with each software release and therefore the features in IRP Admin may work slightly differently from the way they are shown in the video.

NOTE: You can also view a recorded webinar that demonstrates the Bulk Update functionality as part of a Promotions and Emails demo – go to the Promotions help topic to view the video.

DataBulkUpdates.aspx page

The DataBulkUpdates.aspx page appears as follows:

Bulk Updates screen

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

  • Upload File and Stage Update Data: You use this tab to upload your completed data 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 data.

Example Use Case: Updating the Stock Level in a Stock Location

To update the stock level in a Stock Location, use the Bulk Updates function and select ‘Stock Location Levels’ as the table to be updated. The Stock Location Name and ID can be found in the Stock Locations section of IRP Admin. You can create a template file using the Bulk Updates feature and limit it to the relevant Stock Location. Note that a bulk update will potentially affect website stock levels also if you check the Update Website Stock checkbox, otherwise only the local level for the specified Stock Location will be updated. If Update Website Stock is checked, the website stock level will be made to equal the sum of the stock levels across all Stock Locations for every stock ID. Note also that the system checks for duplicate StockID-StockLocationID entries before performing an update (this prevents duplicate rows being returned in the Order Sheets which join onto the Local Stock Levels table in the IRP database for Picking Locations).

For more details, refer to the How to Carry Out Bulk Updates article in this section.

How To Guides (2)

Close
Close
How to Carry Out Bulk Updates

To update IRP Admin tables in bulk, follow these steps:

First, create the data template file:

  1. Go to Data Imports/Exports > Bulk Updates in the IRP Admin left navigation menu.
  2. Click the Create Template File tab.
  3. The following screen appears:

    image

  4. Use the Select Table for Template File drop-down list to select a specific table for creating a template file for the bulk update of data.
    You can select from the following tables:
    • Brands
    • Categories
    • Customers
    • Models
    • Stock
    • Stock Location Levels
    • Attribute Value Translations
    • Brand Translations
    • Category Translations
    • Model Translations
    • Large Translations
    • Small Translations
  5. Use the 'Date From' and 'Date To' boxes to restrict the file to only include records created during this date range.
  6. After you have selected a table, use the Configure Template File section to define the elements that you want to include in the update. Note that this will differ from the screen capture shown below depending on the table that you select:

    Configure Template File section

  7. Use the Configure Template File section to configure the settings for the table that you have selected. The following settings are available:
    • Brands:
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Categories:
      • Category Level: Use this to select the category level for the template file.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Customers:
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Models:
      • Brand: Use this to select the model brand for the template file.
      • Category: Use this to select the model category for the template file.
      • Missing Description: Check this box if you want the models template file to contain only items without descriptions.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Stock:
      • Brand: Use this to select the stock brand for the template file.
      • Category: Use this to select the stock category for the template file.
      • Missing Part Codes: Check this box if you want the stock template file to contain only items without part codes.
      • Missing EANs: Check this box if you want the stock template file to contain only items without EAN 13 part codes.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Stock Location Levels:
      • Brand: Use this to select the brand for the template file.
      • Category: Use this to select the category for the template file.
      • Stock Location: Use this to select a specific stock location for the template file. Alternatively, if you want to display all stock locations, select 'All Stock Locations'.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Attribute Value Translations:
      • Download Language: Use this to select the language for the template file.
      • Field to Translate: Use this to select the translatable Attribute Value field for the template file.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Brand Translations:
      • Download Language: Use this to select the language for the template file.
      • Field to Translate: Use this to select the translatable brand field for the template file.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Category Translations:
      • Download Language: Use this to select the language for the template file.
      • Field to Translate: Use this to select the translatable category field for the template file.
      • Category Level: Use this to select the category level for the template file.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Model Translations:
      • Download Language: Use this to select the language for the template file.
      • Field to Translate: Use this to select the translatable models field for the template file.
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
      Note that you can update English and Foreign values for the following fields:
      • Model
      • Additional Information 1
      • Additional Information 2
      • Additional Information Tab Title 1
      • Additional Information Tab Title 2
      If included in the file, these fields will be updated. The English versions of these will be prefixed with 'English_' (for example, 'English_Model') to allow for the English values to be updatable.
    • Large Translations:
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
    • Small Translations:
      • File Format: Use this to select the format of the template file. You can select from .tsv (tab delimited), .csv (comma delimited), .txt (pipe delimited) or Microsoft Excel format.
  8. To download the template file for your selected table, click the Download Template File button at the bottom of the screen.
  9. You can then edit the data in the file, as necessary, and save it for staging and importing. You can delete any columns that you are not going to use for this update, in fact it is often a good idea to do this in case you update something unintentionally. (If necessary, for reference reasons only, you can add a column with data so long as it has a novel name not used elsewhere, and this will not affect the bulk update.) You can use formulae in the cells in the file to help you calculate, for example prices.

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

  1. Click the Upload File and Stage Update Data tab.
  2. The Bulk Update Data screen appears, as follows (NOTE that only 'Step 1: Select Table to Update' will initially be visible):

    Bulk Update Data screen

  3. In Step 1: Select Table to Update, use the drop-down list to select the table that you want to update (in the same way that you selected the table in the 'Create template' stage previously).
  4. In Step 2: Upload and Stage File, click the Browse button to find the file that you created earlier, then click the Upload and Stage button to upload the file and stage the data temporarily on the IRP. You will be prompted to confirm your decision. If successful, you will see a message stating 'File Successfully Uploaded and Staged'.
  5. The Staged Data section at the bottom of the screen shows the details from the staged data set.
  6. The Fields to Update section allows you to select the fields that you want to Bulk Update, based on what has been uploaded in your template file.
  7. In the Perform Bulk Update section you may see other settings. For example, when updating Stock Location Levels you will see the Update Website Stock checkbox — if you check this box, the website stock level will be made to equal the sum of the stock levels across all Stock Locations for every stock ID. If you are bulk updating Stock, you will see options for Update Model Min Prices (check this to ensure that the Model Min Price is calculated as the minimum Stock Price when 'Auto Update Min Price Based On Stock' is set to true on the Models Edit page) and Update Model RRPs (check this to ensure that the Model RRP is calculated as the maximum Stock RRP when 'Auto Update Min Price Based On Stock' is set to true on the Models Edit page).
    Note that the uploaded template file must have the same columns in the originally downloaded file otherwise the bulk update will fail. When you are ready, click the Perform Bulk Update button in the Perform Bulk Update section to update the table in the IRP:

    Perform Bulk Update button
Open
How to Troubleshoot Bulk Updates and Product Data Uploads

Videos (2)

Close
Bulk Updates
Learn how to use IRP bulk updates to filter and adjust core ecommerce data.
Promotions and Email Campaigns
Learn how to adjust prices, manually or in bulk and via promotions on the IRP. Market your sales and promotions via the IRP Email Marketing suite.

FAQs (1)

Close
Is it possible to split an existing category into a category containing multiple sub-categories?
You can do this using the Data Imports / Exports section in IRP Admin:
1. Go to the Bulk Updates subsection of the Data Imports / Exports section.
2. Download a Model template file.
3. Assign the new Category IDs to the Models in question.
4. Re-upload the completed Model template file through the Bulk Updates subsection.

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