Custom fields in order variable

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.1

Hi,

I'm modifying the plugin we wrote to send order information to our invoicing platform so that discount information is also sent. To this effect I have created 2 custom fields (flo_discount and flo_originalprice) in the item table (see screenshot attached). I want to save the discount and original price information in these two fileds by setting them on the corresponding products in the order variable passed by the onBeforeOrderCreate function. When I look for these fields, they ar not found in the cart->products array, but only under cart->shipping_groups->products (see variable dump attached). Is this correct? If so, why?

Thanks for clarifying!

Michel

Hi Nicolas,

Thanks for the reply.
I have changed the "frontend" setting to visible and set the access level to none (because I don't want these fields to be displayed on the frontend, they only serve to keep the original price and discount info). I was now able to update the order variable in the onBeforeOrderCreate function (see order_updated_dump.txt). However I can't acces this information in the on AfterOrderUpdate, where the order information is transmitted to our invoicing platform. I get the order information as follows:

$orderClass->loadFullOrder($order->order_id, false, false)

However, here the custom fields are empty (see fullorder_dump.txt) and they are also empty in the DB. So how can I access the values of my custom fields so I can use them for transferring to our invoicing platform?

Thanks
Michel

Hi Nicolas,

yes, the order variable is passed by reference. No I can't see any data stored in the DB
I have attached a code file of the onBeforeOrderCreate function (only 46 lines) and would be very grateful if you could have a look.

Many thanks,
Michel

Hi Nicolas,

I found out, that the custom fields need to be visible on the website to be taken into account. It doesn't work if I set the "frontend" setting to visible and set the access level to none. The access level must be "all", but this causes the fields to show on the frontend and I don't want that. So back to square one... How can I save the discount and original price information for later use in the AfterOrderUpdate function?

Thanks,
Michel

Hi,

Yes, but is the information I need (discount und original price that was applied per product) available in he "onAfterOrderCreate" trigger? That was the whole point, why it had to be done in "onBeforeOrderCreate"...

Thanks,
Michel

Hi,

Thanks, now it works!

Michel