Error when sending orders to Click and Drop, 'Error : The value in column 'Identifier (SKU)' is not unique in the order'
There was a change made to Click and Drop and One Stop Order Processing needs to send the customers information slightly differently, having more detailed order line details.
If you see this error are using an existing view you will need to amend the view. The view will need to be updated. To do this do the following:
1 Open the Click and Drop Courier settings and take note of the file shown in the View to use for Click and Drop
2 Open the file, using Notepad, in the C:\OSOP\Main folder. To run Notepad use the Windows Key and R and type notepad.exe and press enter.
3 Find the block that shows how the definition of the Identifier (SKU). The Field number (in this case Field22) may not match your field number, that is ok. This will be shown as:
[Field22]
Name=Identifier (SKU)
LookupSQL=
NoExport=0
Total=0
ID=53
SortType=3
Edit=0
ListID=0
Change the ID to 53. This maybe shown as (ID=127). This line, shown in bold above, should now show ID=53.
4 Find the Customs description line to use a different description for each line. To do this find the block that shows:
[Field18]
Name=Customs description
LookupSQL=[%ITEM_TITLEn%]
NoExport=0
Total=0
ID=125
SortType=1
Edit=1
ListID=0
5 You should now save the file and close and reopen One Stop Order Processing.
Other Changes
You may want to change other details if you are using more details customs information. If you look in the same export view file and find the following blocks and make sure that the lines in bold match those.
[Field17]
Name=Customs code
LookupSQL=
NoExport=0
Total=0
ID=577
SortType=1
Edit=1
ListID=0
[Field20]
Name=Country of Origin
LookupSQL=UK
NoExport=0
Total=0
ID=230
SortType=1
Edit=1
ListID=0
[Field25]
Name=Name
LookupSQL=
NoExport=0
Total=0
ID=52
SortType=3
Edit=0
ListID=0
This field may not appear, but it can be used when you need to pass the duty value paid.
This field may not appear, but it can be used when you need to pass the duty value paid.
[Field28]
Name=Customs Duty Costs
LookupSQL=[%ORD_FEES%]
NoExport=0
Total=0
ID=999
SortType=3
Edit=0
ListID=0
NOTE : In all LookupSQL fields you can use macros to use different values for different orders.
Related Articles
How to Change the Courier sent to Websites (e.g. change Click and Drop to Royal Mail)
When you send tracking details to Amazon or Ebay you sometimes need to change the courier details setup in OSOP to what is expected by the website (e.g. Amazon). For example, Click and Drop should be sent as Royal Mail. The following article explains ...Royal Mail have told me our customs data is not compliant
The default Click and Drop views contain basic information that should allow your orders to be compliant with the new digital customs information. However, if you have issues the following guide explains how to resolve them. Country of Origin is not ...Can I export Royal Mail Click and Drop Products into One Stop Order Processing?
Can I export Royal Mail Click and Drop Products into One Stop Order Processing? The following article explains how to export products from your Royal Mail Click and Drop account into One Stop Order Processing. This feature is available in the ...Automatically Create Courier labels from Royal Mail Click and Drop within One Stop Order Processing
This guide shows you how to move your Netdespatch integration to work with Click and Drop. In addition, it also shows you how to create a new connection between OSOP and click and drop. To complete the setup you will need to have an account with ...Why do my orders automatically show as despatched in Click and Drop?
Q: Why do my orders automatically show as despatched in Click and Drop? A: This is because the auto despatch function is switched on within Click and Drop, you can turn this off by following the menu option ( within Click and Drop ) Settings -> ...