Advanced Export Orders To XML Or JSON For OpenCart V2
Version: 2.0.0.0
Author: woods zhang
Website: http://www.hecart.com
Support: [email protected]
Description:
This extension adds a "Advanced Export Orders To XML Or JSON" to your store.
Filter Condition
Export Format
Export Data
The following data are for reference only. Detail information please view demo.
[code]
<?xml version="1.0" encoding="utf-8"?>
<orders total="1">
<order>
<order_id><![CDATA[31]]></order_id>
<invoice_no><![CDATA[0]]></invoice_no>
<invoice_prefix><![CDATA[INV-2013-00]]></invoice_prefix>
<store_id><![CDATA[0]]></store_id>
<store_name><![CDATA[Your Store]]></store_name>
<store_url><![CDATA[http://w.opcart.com/]]></store_url>
<customer_id><![CDATA[1]]></customer_id>
<customer_group_id><![CDATA[1]]></customer_group_id>
<firstname><![CDATA[zhang]]></firstname>
<lastname><![CDATA[shulin]]></lastname>
<email><![CDATA[[email protected]]]></email>
<telephone><![CDATA[+8613800138000]]></telephone>
<fax><![CDATA[]]></fax>
<payment_firstname><![CDATA[zhang]]></payment_firstname>
<payment_lastname><![CDATA[shulin]]></payment_lastname>
<payment_company><![CDATA[]]></payment_company>
<payment_company_id><![CDATA[]]></payment_company_id>
<payment_tax_id><![CDATA[]]></payment_tax_id>
<payment_address_1><![CDATA[nanshan]]></payment_address_1>
<payment_address_2><![CDATA[]]></payment_address_2>
<payment_city><![CDATA[shenzhen]]></payment_city>
<payment_postcode><![CDATA[43243]]></payment_postcode>
<payment_country><![CDATA[United Kingdom]]></payment_country>
<payment_country_id><![CDATA[222]]></payment_country_id>
<payment_zone><![CDATA[Staffordshire]]></payment_zone>
<payment_zone_id><![CDATA[3595]]></payment_zone_id>
<payment_address_format><![CDATA[]]></payment_address_format>
<payment_method><![CDATA[Bank Transfer]]></payment_method>
<payment_code><![CDATA[bank_transfer]]></payment_code>
<shipping_firstname><![CDATA[zhang]]></shipping_firstname>
<shipping_lastname><![CDATA[shulin]]></shipping_lastname>
<shipping_company><![CDATA[]]></shipping_company>
<shipping_address_1><![CDATA[nanshan]]></shipping_address_1>
<shipping_address_2><![CDATA[]]></shipping_address_2>
<shipping_city><![CDATA[shenzhen]]></shipping_city>
<shipping_postcode><![CDATA[43243]]></shipping_postcode>
<shipping_country><![CDATA[United Kingdom]]></shipping_country>
<shipping_country_id><![CDATA[222]]></shipping_country_id>
<shipping_zone><![CDATA[Staffordshire]]></shipping_zone>
<shipping_zone_id><![CDATA[3595]]></shipping_zone_id>
<shipping_address_format><![CDATA[]]></shipping_address_format>
<shipping_method><![CDATA[Flat Shipping Rate]]></shipping_method>
<shipping_code><![CDATA[flat.flat]]></shipping_code>
<comment><![CDATA[This is order Comments]]></comment>
<total><![CDATA[$1,430.93]]></total>
<order_status_id><![CDATA[7]]></order_status_id>
<affiliate_id><![CDATA[0]]></affiliate_id>
<commission><![CDATA[0.0000]]></commission>
<language_id><![CDATA[1]]></language_id>
<currency_id><![CDATA[2]]></currency_id>
<currency_code><![CDATA[USD]]></currency_code>
<currency_value><![CDATA[1.00000000]]></currency_value>
<ip><![CDATA[127.0.0.1]]></ip>
<forwarded_ip><![CDATA[]]></forwarded_ip>
<user_agent><![CDATA[Mozilla/5.0 (Windows NT 6.1; rv:25.0) Gecko/20100101 Firefox/25.0]]></user_agent>
<accept_language><![CDATA[en-US,en;q=0.5]]></accept_language>
<date_added><![CDATA[2014-03-23 17:59:34]]></date_added>
<date_modified><![CDATA[2014-03-23 17:59:42]]></date_modified>
<customer><![CDATA[zhang shulin]]></customer>
<consignee><![CDATA[zhang shulin]]></consignee>
<postcode><![CDATA[43243]]></postcode>
<address><![CDATA[nanshan shenzhen 43243 Staffordshire United Kingdom]]></address>
<order_status><![CDATA[Canceled]]></order_status>
<sub_total><![CDATA[$1,206.00]]></sub_total>
<shipping><![CDATA[$5.00]]></shipping>
<tax><![CDATA[$211.93]]></tax>
<products total="3">
<product>
<order_product_id><![CDATA[48]]></order_product_id>
<order_id><![CDATA[31]]></order_id>
<product_id><![CDATA[40]]></product_id>
<name><![CDATA[iPhone]]></name>
<model><![CDATA[product 11]]></model>
<quantity><![CDATA[1]]></quantity>
<price><![CDATA[106.0000]]></price>
<total><![CDATA[106.0000]]></total>
<tax><![CDATA[20.5500]]></tax>
<reward><![CDATA[0]]></reward>
<sku><![CDATA[]]></sku>
<manufacturer_id><![CDATA[8]]></manufacturer_id>
<manufacturer_name><![CDATA[Apple]]></manufacturer_name>
<option_val><![CDATA[Color:Green]]></option_val>
<options total="1">
<option>
<order_option_id><![CDATA[27]]></order_option_id>
<order_id><![CDATA[31]]></order_id>
<order_product_id><![CDATA[48]]></order_product_id>
<product_option_id><![CDATA[227]]></product_option_id>
<product_option_value_id><![CDATA[18]]></product_option_value_id>
<name><![CDATA[Color]]></name>
<value><![CDATA[Green]]></value>
<type><![CDATA[select]]></type>
</option>
</options>
</product>
<product>
<order_product_id><![CDATA[50]]></order_product_id>
<order_id><![CDATA[31]]></order_id>
<product_id><![CDATA[44]]></product_id>
<name><![CDATA[MacBook Air]]></name>
<model><![CDATA[Product 17]]></model>
<quantity><![CDATA[1]]></quantity>
<price><![CDATA[1000.0000]]></price>
<total><![CDATA[1000.0000]]></total>
<tax><![CDATA[177.0000]]></tax>
<reward><![CDATA[700]]></reward>
<sku><![CDATA[]]></sku>
<manufacturer_id><![CDATA[8]]></manufacturer_id>
<manufacturer_name><![CDATA[Apple]]></manufacturer_name>
<option_val><![CDATA[]]></option_val>
<options total="0">
</options>
</product>
<product>
<order_product_id><![CDATA[49]]></order_product_id>
<order_id><![CDATA[31]]></order_id>
<product_id><![CDATA[30]]></product_id>
<name><![CDATA[Canon EOS 5D]]></name>
<model><![CDATA[Product 3]]></model>
<quantity><![CDATA[1]]></quantity>
<price><![CDATA[100.0000]]></price>
<total><![CDATA[100.0000]]></total>
<tax><![CDATA[19.5000]]></tax>
<reward><![CDATA[200]]></reward>
<sku><![CDATA[]]></sku>
<manufacturer_id><![CDATA[9]]></manufacturer_id>
<manufacturer_name><![CDATA[Canon]]></manufacturer_name>
<option_val><![CDATA[Color:Blue,Size:Large]]></option_val>
<options total="2">
<option>
<order_option_id><![CDATA[28]]></order_option_id>
<order_id><![CDATA[31]]></order_id>
<order_product_id><![CDATA[49]]></order_product_id>
<product_option_id><![CDATA[226]]></product_option_id>
<product_option_value_id><![CDATA[16]]></product_option_value_id>
<name><![CDATA[Color]]></name>
<value><![CDATA[Blue]]></value>
<type><![CDATA[select]]></type>
</option>
<option>
<order_option_id><![CDATA[29]]></order_option_id>
<order_id><![CDATA[31]]></order_id>
<order_product_id><![CDATA[49]]></order_product_id>
<product_option_id><![CDATA[228]]></product_option_id>
<product_option_value_id><![CDATA[19]]></product_option_value_id>
<name><![CDATA[Size]]></name>
<value><![CDATA[Large]]></value>
<type><![CDATA[select]]></type>
</option>
</options>
</product>
</products>
</order>
</orders>
[/code]
Features:
No files overwritten
You must have vQmod installed to use this addon
Export you orders to xml or json format
Filter condition can multiple choose press ctrl or shift key.
Demo:
Demo admin username & password: demo
Demo store: http://oc2.hecart.com/
Demo admin: http://oc2.hecart.com/sale/export_orders
Installation 1: **vQmod Required**
1) Unzip the downloaded archive.
2) You should have a folder called vqmod. In this folder there is a folder called upload.
3) Upload the contents of the folder called upload to the root directory of your OpenCart installation. These are new files and no files should be overwritten.
4) Proceed to System > Users > User Groups and grant yourself access and modification permission.
5) That is all. Thank you for downloading and using this mod. If you like this mod please provide your star rating for it.
If you have any questions please contact me at [email protected] and I will do what I can to help.