(Under construction)
Exported field setting
Drag and drop to add field into “Fields for export”
Tip: use CTRL+F in your browser to quick fields search – example from Mozilla Firefox
Rename / translate fields name
(3)Edit user defined columns names and (4)Save
Filters setting
Setup required filters
Options setting
Setup options
User defined xml, transformation stylesheet and columns names
This section is used for special formatted export
Transformation sample You can find here: http://www.praotec.com/nvn-export-orders-xslt-transformation-sample/
Transformation step by step tutorial You can find here: http://www.praotec.com/nvn-export-orders-simple-xslt-transformation-sample-step-by-step/
Save settings, export import settings, switch setting, export Order, Cron links
Recent files, extension and setting upload
Calculated fields:
Important – from version 2.3 all text fields should be enclosed in single quotes!!!
Examples:
// invoice number with prefix and six digits
'invoice_prefix'.sprintf('%06d', 'invoice_number')
// export delivery company, if delivery company is empty will be exported first name + last name
('delivery_company' <> '') ? 'delivery_company' : 'first_name last_name'
How to add “Calculated fields” see here:
http://www.praotec.com/nvn-export-orders-calculated-fields/
http://www.praotec.com/nvn-export-orders-module-calculated-fields/
Replacement by map table
In this example all “Order status” fields with value “On backorder” will be changed to “Reserved” in exported file. (If “Target field” is not same as “Source fields”, values in “Target field” will be result of replacement .)
How to change export language
1 – select “Language in export”. This option work for some multi-language fields like produc name, description…
2 – important – for product name translation must be select “Remove combinations from product name”
3 – combinations should be added as extra field into export
4 – optionally can be translated fields columns names
Hello, I find no way to export the field “private note” of the customer.
Thank you
Hi,
this field is not in export field now, but contact me from:
http://netvianet.com/contact-us
It is simple, I will add it for You.
Hello
My report shows the price for the order, then the price for the products and then names of the products. Problem is, I do not see the quantity for each products. For example I see there was 400€ for the order and there were 3 products ordered, then names of the products – product1, product2. But I do not know if there were 2pieces of product1 or product2. How can I do this please?
Hello,
do not use FILTER “Group by” . Then each product will be on new row with quantity for each product.
Hello,
Is it possible that this calculation doesn’t work: ‘total_paid’ – ‘total_paid_tax_excl’
What he does in my opinium is just ‘total_paid’ – ‘total_paid’
I installed the last version 2.5.1
Sorry I didn’t find your email anymore.
Hello,
yes, You are right. This is my bug in fields tag name. Will be repaired this week.
From version 2.5.8
totalpaid – total_paid_tax_excl
Without single quotes. Quoted should be only strings fields, not numbers in formula.
Hello, i have some questions:
1.- it is posible to generate an export for every order to an specific mail?
2.- can you edit the email with the export?
3.- can you add some images to the excel export?
Thank you
Hello,
1.- it is posible to generate an export for every order to an specific mail?
Answer:
depend what You mean.
Is possible configure up to 6 setting. For example:
setting1 to filter Orders by products from supplier1
setting2 to filter Orders by products from supplier2
etc.
Each setting can send filtered Orders to different emails
2.- can you edit the email with the export?
Answer:
in email are only export orders as attachments.
In setting you can change only “Email subject”, but before export. Email is sent automatically after export. If You need edit email before sent, disable sending to email and then you can send manually from your email client and edit before sent.
3.- can you add some images to the excel export?
Answer:
no, only manually. Export can put into excel file only links (URL) of products images
If I Change a supplier reference code for an existing product and then export orders for previous orders, will the new supplier code be in the report or the supplier code which was in existence when the order was processed ? Thanks
Hi,
I would like to export at the same time some order and one file per order but even I click on the options “one order – one file” it export all order in one file. How I have to do it?
Hi,
I’m not sure, if I understand well. But I think will be only something wrong in setting.
I will contact You via email, wait a moment.
Hi is possible test module some day before buy?
Hi,
access to test site sent to email.
In the list of Available Fields i get the category_ID. Is it possible to get the name of the category ?
Hi,
in version 2.x not. But will be in version 3.x
hi i get this error and can’t export
[PrestaShop] Fatal error in module file :/home/ludiworl/www/modules/nvn_export_orders/nvn_export_orders.php(3081) : runtime-created function:
syntax error, unexpected end of file
Hi, maybe it is because you change version of php.
You can try update module to latest version.
I will send you link to your email.