Importing competitor pricing data

  1. First receive your spreadsheet from Head Office.
  2. In the Navigation Panel, go to Import/Export then find the Competitors Pricing definition that Readysell has set up for you.
  3. Click on the Definition to open it. 

     Show me

  4. Check that the category and data type are correct. For example, for a price book import, the category must be Products and the data type must be Price Book.

     Show me an example
    These fields are located at the top right hand corner of the Import/Export display window.
  5. In the Import/Export Format field, select the format of the file you want to import. This can be either CSV, XLS or XLSX.

    Excel must be run in compatibility mode.

     Show me an example
    This field is located in the second row at the top of the Import/Export display window.
  6. In the Sheet field, select the sheet within the import file where the data is located. 

     Show me an example
    The data you want to import is in the second sheet. In this case, you would need to enter 2 in the Sheet field.
  7. In the Start At Row field, enter the number of the row where the data begins. This allows you to skip over any header rows. 

     Show me an example

    In this example, there are three rows of headings, and the data begins in row 4.

     

    In this case, you would need to enter 4 in the Start At Row field.

     

  8. Open your spreadsheet so that you can compare it with the Import/Export definition and check that the columns are correct.  By Left Clicking first and Holding Down the Ctrl Button, highlight the the rows that are not required on the import and Click on 'Delete' or tick the Ignore checkbox on all rows not required. Then Modify/Add any extra Properties that are on the spreadsheets to the Import.
  9. Setting up the fields to import:
    • Column Number is the order in which the columns appear in the import file.
    • Caption is the column heading in the import file.
    • Property is the exact name of the field within Readysell where you want the data to be imported. This is case sensitive and does not include spaces. For example, the Product ID field must be entered as "ProductID"
    • Data Type is the type of data in the field. This will usually be String (for text fields) or Decimal (for currency).
    • Make sure that the 'OB EzCode' column is 'Key'.
     Show me

    In this example, the Status will be set to "Active" for every product that is imported. Because a Static Value has been set, the column number has been set to 0.

    There is no limit to the number of static values you can have for an import, and you can have more than one column with number 0. (You cannot have more than one column for any other number.)

  10. If you want to save your changes for future imports, click Save.
  11. When you have finished, click Import Data to import the data into Readysell.
  12. Windows opens a file dialog box. Select the file you want to Import, then click Open.
  13. Readysell will import the data contained in that file, and then display a confirmation message. Click OK to complete the import.