NVN Export Orders – Instructions

(Under construction)

Exported field setting

Selection_419

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

Selection_743

Rename / translate fields name

Selection_689

(3)Edit user defined columns names and (4)Save


Filters setting

Selection_409

Setup required filters


Options setting

Selection_410

Setup options


User defined xml, transformation stylesheet and columns names

Selection_411

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

Selection_412

 


Recent files, extension and setting upload

Selection_413

 


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

Selection_416

Selection_415

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

translate

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

 

12 comments for “NVN Export Orders – Instructions

  1. Rubén
    5.1.2016 at 16.06

    Hello, I find no way to export the field “private note” of the customer.
    Thank you

  2. Jakub
    29.2.2016 at 18.02

    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?

    • kafa
      1.3.2016 at 6.29

      Hello,
      do not use FILTER “Group by” . Then each product will be on new row with quantity for each product.

  3. 29.6.2016 at 17.59

    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.

  4. kafa
    29.6.2016 at 18.43

    Hello,
    yes, You are right. This is my bug in fields tag name. Will be repaired this week.

    • kafa
      30.6.2016 at 9.19

      From version 2.5.8

      totalpaid – total_paid_tax_excl

      Without single quotes. Quoted should be only strings fields, not numbers in formula.

  5. 16.11.2016 at 20.52

    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

    • kafa
      17.11.2016 at 9.25

      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

  6. Eimear Murphy
    20.6.2017 at 13.25

    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

  7. 9.11.2017 at 14.13

    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?

    • ka fa
      9.11.2017 at 14.36

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *