The module "Export orders to CSV or XML" helps you quitly export orders data to CSV or XML format. You can control all fields of the destination file, you can also export the predetermined data.
Available section for export:
- Order status
- Payment information
- Delivery information
- Customer information
- Delivery address
- Invoice address
- Product information
Available order fields:
Id address delivery, Id address invoice, Id shop group, Id shop, Id cart, Id currency, Id lang, Id customer, Id carrier, Current state, Secure key, Payment, Module, Conversion rate, Recyclable, Gift, Gift message, Mobile theme, Shipping number, Total discounts, Total discounts tax incl, Total discounts tax excl, Total paid, Total paid tax incl, Total paid tax excl, Total paid real, Total products, Total products wt, Total shipping, Total shipping tax incl, Total shipping tax excl, Carrier tax rate, Total wrapping, Total wrapping tax incl, Total wrapping tax excl, Invoice number, Delivery number, Invoice date, Delivery date, Valid, Date add, Date upd, Reference, Id, Id shop list
Available customer fields:
Id, Id shop, Id shop group, Secure key, Note, Id gender, Id default group, Id lang, Lastname, Firstname, Birthday, Email, Newsletter, Ip registration newsletter, Newsletter date add, Optin, Website, Company, Siret, Ape, Outstanding allow amount, Show public prices, Id risk, Max payment days, Passwd, Last passwd gen, Active, Is guest, Deleted, Date add, Date upd, Years, Days, Months, Geoloc id country, Geoloc id state, Geoloc postcode, Logged, Id guest, GroupBox, Id shop list
Available address fields:
Id customer, Id manufacturer, Id supplier, Id warehouse, Id country, Id state, Country, Alias, Company, Lastname, Firstname, Address1, Address2, Postcode, City, Other, Phone, Phone mobile, Vat number, Dni, Date add, Date upd, Deleted, Id, Id shop list
Available product fields:
Id order detail, Id order, Id order invoice, Id warehouse, Id shop, Product id, Product attribute id, Product name, Product quantity, Product quantity in stock, Product quantity refunded, Product quantity return, Product quantity reinjected, Product price, Reduction percent, Reduction amount, Reduction amount tax incl, Reduction amount tax excl, Group reduction, Product quantity discount, Product ean13, Product upc, Product reference, Product supplier reference, Product weight, Tax computation method, Tax name, Tax rate, Ecotax, Ecotax tax rate, Discount quantity applied, Download hash, Download nb, Download deadline, Total price tax incl, Total price tax excl, Unit price tax incl, Unit price tax excl, Total shipping price tax incl, Total shipping price tax excl, Purchase supplier price, Original product price, Id product, Id supplier, Id manufacturer, Id category default, Id shop default, Id tax rules group, On sale, Online only, Ean13, Upc, Quantity, Minimal quantity, Price, Wholesale price, Unity, Unit price ratio, Additional shipping cost, Reference, Supplier reference, Location, Width, Height, Depth, Weight, Out of stock, Quantity discount, Customizable, Uploadable files, Text fields, Active, Redirect type, Id product redirected, Available for order, Available date, Condition, Show price, Indexed, Visibility, Cache is pack, Cache has attachments, Is virtual, Cache default attribute, Date add, Date upd, Advanced stock management, Image, Image size, Current stock, Tax calculator, Product price wt, Product price wt but ecotax, Total wt, Total price, CustomizedDatas, CustomizationQuantityTotal, Id address delivery