Welcome to the One Stop Order Processing help desk
Knowledgebase - Click on the section titles to see more categories and articles: Importing Orders > Troubleshooting
How to import orders from an XML file
Posted by Pat Strassen, Last modified by Zoe Strassen on 10 July 2017 12:49 PM

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 this dialog.
6 When a dialog is shown saying that the Workbook may contain features that are not compatible with CSV files, select Yes.
7 You can then use the OSOP format to import the orders. You will need to setup the Compatible header field to map the OSOP fields name to those used in the file.

More information on this at the following link:


(1 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: