PRESTASHOP 1.7 Customization ID not added to tables for back office orders

[beamer]

Hi I have been using Prestashop 1,6 for some years as an entry system for a music festival. All the products contain customization fields such as performer's age, performers name plus other info.  I extract the data from the Prestashop database using mysql queries and all has worked great. However I have now migrated to Presashop 1.7.6.4 and the mysql queries to extract the customization data now fail for back office orders. Looking at the issue it turns out that if an order is created by the back office the id_customization is not written into  table ps_order_detail or rather the value is 0. If the order is created by the front office the id_customization is written correctly and can be directly linked to the ps_customized_data. 

The result of this is that when orders are created by the back office I cant extract the customized data.

My question is this a bug or is it intended to work this way? 

Secondly is there a workaround that I could use to extract the customized data for all orders? 

The screen shot shows the issue, id_order 1269 is a front office order with the correct Id_customization.

id_order 1268 is a back office order of the same product and the id_customization is set to 0. 

 

Any suggestions greatly appreciated.

Edited April 4, 2020 by beamer (see edit history)

[Bastien M]

Hi have you find a solution?

[beamer]

1 hour ago, Bastien M said:

Hi have you find a solution?

No I am afraid not.  Its still an issue for me and I would like a solution.

Graham

[Bastien M]

id_customizable is added in table order_detail

Edited November 13, 2020 by Bastien M (see edit history)

[emon1077]

Hi, did you find a solution?

hope so