Universal XML data export from the shop

Order export from FastCentrik online stores

The data from orders received can be easily exported in XML format (Extensible Markup Language) and then imported to your accounting program (assuming it supports XML imports). If you have difficulties importing orders into your accouning system, contact your software producer for assistance.

Settings in FastCentrik administration

First, check that you have correctly set up the Trade Identification Number in the shop administration. Accounting systems are usually multiple-licence (you can run several accounting entities at the same time) and, therefore, the system would then not know to which accouting entity it should assign which order. In the Fastcentrik administration, the Trade Identification Number is entered in "System Settings-> Modules Setting -> Order-> Print order".

List of data exported from FastCentrik orders

Order:

1. Order number
2. Client Identifier
3. Total order price without VAT
4. Total order price with VAT
5. Total order price rounding value
6. Number of items
7. Payment method
8. Delivery method
9. Date of order
10. Delivery price
11. Payment status
12. Order status
13. Order information from customer
14. Order information from administrator
15. Referrer
16. Address of the shop owner
17. Attribute, whether the order should be shipped at once (complete or piecemeal)
18. Delivery date
19. Currency code
20. Payment type matched for accounting
    

Recipient (customer):

1. Customer first name
2. Customer last name
3. Company name
4. Invoice address
5. Invoice city
6. Invoice zipcode
7. Invoice district
8. Ship to address
   

Order items:

1. Product identifier
2. Product code
3. Product type
4. Product name
5. Unit price
6. Quantity
7. Total price
8. VAT value
9. VAT price
10. Total price without VAT
11. Total price with VAT
12. Attribute - Bargain
13. Comment on product
14. Product status
15. Sale
16. Attribute - whether bulk sale applies
17. Unit
18. Product code matched in accounting 
    
    

A procedure when exporting orders from an online store 

1. Log on to your shop administration
2. Use the filter to find all orders you wish to export (Orders section under Administration).
3. In the column with the XML title, click on the Export button for the orders you wish to import.
4. After clicking on the Export button, choose the "Universal XML" option.
5. A generated reference to the XML file will appear.
6. The name of this file is formed from the name of export type and order number.
7. The file(s) can be saved (choose Saved as.....after right clicking the mouse) or the file can be opened by left clicking mouse.

Note: There is also an option to export multiple orders at once. If you wish to use this option, first use the filter under Administration. Then, by clicking on "Export results to XML", the file will generate and you can process it further as described in this article.

How to import your orders to your accounting system

Contact your accounting software provider if you require assistance.

print pagesend article by e-mailbuy shop