Common eBay Errors - Missing Surname

Channel Listings is not enabled by default.
Training must be completed before using Channel Listings.
Please email Development for more information.
Note: there will be additional costs involved if this option is enabled.

Importing XML files is an Advanced User feature.

The 'Missing Surname' error will be populated when the XML file, which includes the order to be imported, does not include the surname against the order. This is because the surname is a mandatory field and Khaos Control cannot import the order without it. This can usually be found when running the combined import error report which should be stored within your reports section in Khaos Control.

Identifying the error

The error message below will show in the combined import error report:

Invalid address/contact data Missing mandatory contact fields: Surname

Fixing the error

If you have already manually created the sales order you will need to add the relevant associated reference to ensure that Khaos Control does not allow the order to re-imported.

  1. Find the XML import file which includes the sales order which has failed. To do this you will need to run the SQL below in the Data Query section of Khaos Control:
    select * from sorder_import_log where associated_ref = 'EB****-*****'
  2. Replace the associated reference above with the correct one which is relevant to your order. This will give you the file location which is usually K:\keystone software\import\eBay\Failed123.
  3. Open the XML file in notepad and find the <Isurname></Isurname> tag, if you can get the surname from the email address then use that, but generally inputting empty as the surname will suffice.

Importing the file again

  1. Take note of the name of the file for example Failed123.xml.
  2. Open a Web Configuration screen (show me how).
  3. Open the [ Stock | Channel Listings | Listings ] screen.
  4. Click the Operations button in the Channel Listings Listings Tab. button at the bottom of the screen.
  5. Select Import orders from file | Import eBay orders from file from the menu, see the above image.
  6. Find and double click on the Failed123.xml file to import it.
  7. Once the import has been processed Khaos Control will display the message Operation completed.
    Operations menu in the Channel Listings Listing screen

Finding the Sales Order

  1. The Sales Order number can be found by searching for the customer. The quickest method is to use the email address located in the XML file and use the Email filter in the Customer List screen.
  2. Load the customer once you have located them.
  3. Open their [ Customer Service | Sales Orders / Invoices ] screen.
  4. The combined import errors report and the entry for this associated reference will have been removed.

See Also

Did you find this article helpful?