Product Amendment Import/Export

Product Amendment Import/Export

Product Amendment Import/Export

The import / export utility has been created to allow for easy updating of a products descriptions, department/sub department and min/max level, loyalty redemptions, bar form till .

The program sits under Stock:



Style Details Amendment 



If you wish to update the descriptions or departments of items, you will need to select the "style details" option from the maintain Options section. Then firstly, you will want to select the export Action to update the information. The next step is to select the department and sub department you want to amend. If you want to amend everything simply keep the department option set to All.

Click the Export button and it will produce an Excel spreadsheet with all the details that can be changed.


Make what changes you need to, however please do not amend the column headings and follow the current format of all columns (if you want to separate the web description with a line break start this section with <p> and end it with </p>, and with the third party item, discountable and loyalty redemptions columns use Y or N).

Once you have made the changes you want to make, save the file and go back into the back office program and change the export action to import and you will be given a file browser. Browse for the file you and just edited and click open. Once you have added the file, click import and update this will then update the back office with all the changes you have made.



Min / Max Update

If you wish to update the minimum and maximum stock levels of items, you will need to select the Min/Max option from the Maintain Options section. Then firstly, you will want to select the export Action to update the information. The next step is to select the branch, department and sub department you want to amend. If you want to amend everything simply keep the department option set to All.


Click the Export button and it will produce an Excel spreadsheet with all the details that can be changed, showing the stock code, description/colour/size, the branch you are editing, and the min/max figure.


Update the min/max quantities of any item you want, then save the file.

Then go back to the back office and click the “import” option whilst ensuring the min/max option is still set.

Select the file and then click import and update and any changes made will update to the system.



Attributes, Departments, Sub-Departments Update


    • Related Articles

    • Bulk Min/Max Setup

      **** Before adding Min/Max levels to stock, the branches which require the levels must have "Allow Store Replenishment" ticked within File Maintenance > Branch Maintenance. **** Picking Rules Explained Select one for one if you would like the system ...
    • Suggested Min/Max Reordering Report

      In order to use this report, you would need to set up the Min/Max Levels for the branches or warehouse. Within Stock - Product Amendment Export/Import This file can be narrowed down to a singular location and department and exported. You will get a ...
    • Use Customer Group Import Utility

      Import using a CSV with Client Ref, Name and Email Go to Customer Database > Customer Group Import Utility Click on the Import Season Ticket Holder tab. NOTE: The CSV File needs to have 3 columns and in the following order. The Name column can be ...
    • How to Configure Product Discount Eligibility (Import/Export Guide)

      This guide explains how to set products as eligible or ineligible for discount using the Product Amendment Export/Import tool. This guide is specific to clubs utilising the KORE/Sports Alliance Supporter Role API. This logic also applies for those ...
    • Setting up Attributes

      Attributes add another layer of reporting for you to break down the data. This can be configured by going to File Maintenance > System Configuration > System. and you can rename the attributes to what you want. Once you've created your Atrributes. ...