Welcome to the One Stop Order Processing help desk

How to import orders from an XML file
Posted by Pat Strassen, Last modified by Beth Rose on 31 August 2018 11:52 AM

The following guide explains how to import orders from an XML file-

This feature is available in the Lite, Professional, Premium and Enterprise subscriptions of One Stop Order Processing.

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: