How to import orders from an XML file

How to import orders from an XML file

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


This feature is available in the Lite, 
Professional, Premium and Managed 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:

http://1stoporders.co.uk/OneStopOrderProcessingOrders.html


    • Related Articles

    • Product Import File Format

      " Import file format The import file is a standard CSV (Comma Separated Value) file. The first line contains the field names separated by a comma (,). Each subsequent line contains values for those fields, each value being separated by a comma (,). ...

    • Order Import file is taking too long to import into One Stop Order Processing.

      Order Import file is taking too long to import into One Stop Order Processing. This feature is available in the Lite, Professional, Premium, and Managed subscriptions of One Stop Order Processing. The following article explains how to speed up the ...

    • Using an AMTU replacement (e.g. EZOrderLink™) to automatically process Amazon orders and products

      One Stop Order Processing (OSOP) provides automated support for Amazon orders and products by using the Amazon software AMTU. AMTU, provides the ability to download and upload Amazon order and product files to its website will stop working at some ...

    • How To Import Products From CSV File into One Stop Order Processing

      The following guide explains how To Import Products From CSV File This feature is available in the Professional, Premium and Managed subscriptions of One Stop Order Processing. To import products from a CSV file you will need to make sure that you ...

    • How to manually import orders from eBay into OSOP (Lite)

      Setting up your import in One Stop Order Processing                                                                           Please note: This process will only need to be done once  1. Open One Stop Order Processing  2. Click the orange downward ...