fill custom field with shipping method

Hi,

order_shipping_method only contains the folder name of the shipping plugin.
If you created shipping methods for the "HikaShop manual shipping methods plugin" then it's normal that you only see "manual" in there.
order_shippping_id contains the id of the shipping method.
The name of the shipping method is not stored in the order.
It is only available in the hikashop_shipping table, in the shipping_name column.
That information is not available in the listing of the orders.

What you can do in your mass action is to use an action "run mysql query" and use that query:

UPDATE #__hikashop_order SET verzendmethode = (SELECT shipping_name FROM #__hikashop_shipping WHERE shipping_id = {order_shipping_id}) WHERE order_id={order_id};

Hi,

You must have run the mass action on all the orders and you must have some orders without a shipping method, and thus the query fails.
Add a filter on your mass action on the order column "order_shipping_id" being "not empty".

Also, it could be because you have HikaMarket / warehouses. In that case, the order_shipping_id won't contain just the id of the shipping method but also the vendor id / warehouse id and it cpould even be several shipping method ids (since you can select several shipping methods, one per group of products).
In that case, it would be more complex to fill the shipping name as it would have to be processed with PHP.
However, a simple way to discard these orders and only focus on the simple orders is to change the query to:

UPDATE #__hikashop_order SET verzendmethode = (SELECT shipping_name FROM #__hikashop_shipping WHERE shipping_id = '{order_shipping_id}') WHERE order_id={order_id};