When using One Stop Order Processing, you may experience an issue when
using one of the features such as importing orders.
It is likely to look similar to one of the following:
'Unable to run the SQL'
'The error returned by the database is:'
If you experience an issue with the software where these error
messages appear or anything similar, it is likely that your database
will need to be updated to the latest one.
We recommend that you get in contact with our support team...
You can import orders from XML files by using Microsoft Excel to save
the orders as a CSV file. This is described below:
1 Open xml file using Microsoft Excel.
2 When the Open xml dialog is shown select the as an XML list option.
3 When the XML source does not refer to a schema dialog is shown,
just confirm this dialog.
4 Select the Save as ... option and select the CSV (Comma Delimited)
5 When the Selected type does not support multiple workbooks dialog is
shown, just confirm t...
How to map information from your Automatic imports into a specific
The best way to do this is write an Advanced Order Processing Rule
(click on the ... button at the bottom of the screen next to the
What you can is select Shopify orders that do not have Custom Value 20
Select Use custom SQL with a value of :
[sSalesSource] = 'Shopify' AND [TOrder].[nState] 2 AND
[TCustomValues].[C20] = ''
Then set the SQL to use if found to:
When using the automated order import from Amazon, you may experience
the following error:
AmazonSC: Request has expired. Timestamp date: 2016-03-31T011:45:30Z
AmazonSC: Amazon logon error. Run Failed.
This is due to the time on the computer being incorrect, you will need
to update the date on your machine to get it working again correctly.
When importing orders into One Stop Order Processing, you may
experience an issue where foreign characters are not being imported
This is due to order files now being saved as a UTF-8 format which can
cause importing issues such as Sánchez being imported
One Stop Order Processing should now recognise when order files are
saved in this format, but if not you can manually turn on the UTF-8
option to format these correctly when imported.
To turn this option on go to th...