Update old orders product's reference

[juanmlg]

Hello, I have a question.

We have been using our store without producs references, now we have update all the products with a reference, but we have noticed that the old orders dont have the reference (when we download the delivery slip the reference loks --- ) so seems that $order_detail.product_reference is empty.

How we can update the $order_detail.product_reference with all the references for all old orders?

Regards

[musicmaster]

The only way is to write your own php/mysql routine. In pseudo code that would be something like:
 

select * from ps_product

foreach(product)

   update ps_order_detail set reference = product.reference where id_product=product.id_product

 

[juanmlg]

1 hour ago, musicmaster said:

The only way is to write your own php/mysql routine. In pseudo code that would be something like:
 

select * from ps_product

foreach(product)

   update ps_order_detail set reference = product.reference where id_product=product.id_product

 

Thanks for your reply! That sound so good, my sql skills are limited so would be amazing if someone can give me the exact sql sentence.

Regards!