Update custom field values via CSV

Hi,

We have custom field type "Single dropdown" and table "Order". We use it for selecting terminal locations/pick up points during checkout.

The issue is that we need to update these terminal locations manually each time our shipping carrier changes/updates it... As example if the location of the terminal has changed or there is a new one...

The carrier provides CSV file, which is updated everyday, with all the current terminal locations.

Now question. Is there a way to update custom field data via CSV file? Maybe with mass action or something.

Any hints are welcome.

Thank you

Hello,

There is no option to do it with mass action, as it will only alter Hikashop elements.
The solution will be to directly develop a CSV file uploader which will update every corresponding Orders using SQL requests.

We wish you a nice day !
Kind regards,
Mohamed Thelji.