Welcome to the One Stop Order Processing help desk
Search the Knowledge Base
RSS Feed
Knowledgebase - Click on the section titles to see more categories and articles : Importing Orders > Troubleshooting
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:' 'ODBC Error' 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) (*.csv) format. 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 fields 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 Advanced button). What you can is select Shopify orders that do not have Custom Value 20 entered, i.e. 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: [TCustomValues].[C20]=[TOr...
When using the automated order import from Amazon, you may experience the following error: AmazonSC: InternetQueryDataAvailable AmazonSC: Request has expired. Timestamp date: 2016-03-31T011:45:30Z [RequestExpired:Sender] 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 correctly. 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 as Sánchez. 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...