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 > Editing Imports
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...