Resolved Exporting order data with order custom fields

Hello,
The custom field data is stored in the product_attribute field. The value of this field depends on the custom field you are using. CSVI currently don't support more with custom fields other than product_attribute field in order export but improvements to this export is in our todo list of future developments.

Thank you for your help. I have added product_attribute to my export file but it isn't exporting what is in the database field. I've provided an example of what data is in the database field product_attribute below.

>The value of this field depends on the custom field you are using.

Most of the fields are 'Custom Field Text Input'.

{

    "4": {

        "202": {

            "comment": "Homer"

        }

    },

    "5": {

        "201": {

            "comment": "Simpson"

        }

    },

    "6": {

        "200": {

            "comment": "11.05.1991"

        }

    },

    "8": {

        "198": {

            "comment": ""

        }

    },

    "7": {

        "199": {

            "comment": ""

        }

    },

    "10": {

        "203": "Male"

    },

    "11": {

        "204": "Yes"

    },

    "12": {

        "205": {

            "comment": ""

        }

    },

    "16": {

        "206": {

            "customsforall_option": "89"

        }

    }

}

Hello,

but it isn't exporting what is in the database field

What is it exporting in your case? I don't see anything weird at a first glance.

Hi Rolandd,

It's exporting the other fields, whatever I add like order_id but the product_attribute field is exporting nothing, the part of the export file is blank. It's on a localhost server right now but I'll pop it on a dev server and PM you some access details if that is ok with you?

Hello,
Can you apply the attached patch file and see if the product_attribute export values as in database?


patch_vm_order_export_2016-08-16.zip

Hi tharuna,

This does export data, it dumps everything from that field. This is good progress! I would like to export the data in that field in a more formatted manner if possible, for example: Field title: field value~Field title: field value~Field title: field value such that an export might look like

order_id, product_attribute, date_created
17, custom_fname:Homer~custom_lname:Simpson,01/01/2016
18, custom_fname:Marge~custom_lname:Simpson,02/04/2016

Do you think this can be achieved?

Many thanks for your help so far.

Hello,
The custom field you are using seems to be for a 3rd party plugin, currently CSVI don't support it but we can look into adding it to our todo list so it is support in our future version. One other way for now is you can write your own custom code using override import/export routines feature to get it in the formatted way as you want.

Though there is one field that uses the custom fields for all extension (and I have installed your add-on plg_csviext_customfieldsforall_csvi_6.6.3), the main fields are the standard Custom field: textinput

I also wanted to ask, with the patch you provided, will any changes in that patch be overridden by any future updates to my CSVI Pro software?

Hello,

Though there is one field that uses the custom fields for all extension (and I have installed your add-on plg_csviext_customfieldsforall_csvi_6.6.3), the main fields are the standard Custom field: textinput

As already said all of these values will be stored in product_attribute field, you can write overrides to this export to get your output in required format.

I also wanted to ask, with the patch you provided, will any changes in that patch be overridden by any future updates to my CSVI Pro software?

The changes made in the patch file will be included in our next 6.6.4 release. So even with future updates changes will be still there.

Thanks for your help on this.