Getting Custom Fields to Display in Back End Listing

-- HikaShop version -- : HikaShop Business 4.7.0 [2211181750]
-- Joomla version -- : Joom 3.10

HI,

I am trying to get a custom filed to display in the back end listing. I have created the custom fields and can see the column header in the back end listing. I can also see the custom text when going into an order, but nothing appears in the column in the back end listing,

I have followed other posts such as checking database, adjusting settings, resaving etc.

The custom text we would like should appear when order placed with a certain shipping method, but on all test it does not populate the column. But is on the order additional information.

Please see attached.

Thanks

Mike

Hi,

The type "custom text" is there for you to be able to add custom text on the form where the custom fields are being displayed.
A custom text custom field won't display anything on a listing.

To do what you want, you need to do two things:
- create a custom field of the table "order" and of the type "text".
- create a mass action with a trigger "after an order is created", and a trigger "after an order is updated", a filter on the order_shipping_id column with the value being equal to the id of the shipping method you're targetting, and an action "update the values" on the column of your custom field and the value being the text you want to be displayed on the listing for the orders made with that shipping method.
Note that it will only apply to new orders or orders you'll modify after setting up the mass action. Also, at least 1 order has to have the custom field filled for the column to be displayed on the listing.

That makes sense, and works perfectly. Thank You.