Can i change the custom field data type to numeric

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.8.4
-- PHP version -- : 5.5.30

Hi, I have a question. is there a way I can create a custom field type currently TEXT to numeric so I can add the numbers up. I know that I can change it directly through the database, if it is the only way to do so, which tables should I update assuming I am working on the product table.

Thanks,

Gary

The reason I want is that I want to show travel points for each product using the custom field, each product has different points. I want to have the total points added up and shown to the user during checkout. Can alphauserpoints do the tricks?

Hi,

No, AUP won't help you.
You need to create a custom field of the type "product" via the menu Display>Custom field.
That will allow you to enter the points for each product in the product edition page of the backend (or in the database).
Then, to display the total of the points of the products in the cart on the checkout, you'll have to customize the file "cart" of the view "checkout" via the menu Display>Views in order to add custom code to do the sum and then display it there.

Thank you, can you show me the code to display product custom field on checkout?

Hi,

Well, in the cart file of the checkout view, you can use such code:
echo $row->field_column_name;

where field_column_name is to be replaced with the column name of the custom field.

Hi Nicolas,

Thank you for your reply. I have managed to create a custom field (travel point) for the item table as the picture attachment. Now my question is that can you show me the code so that i can add the points together and display the total in the checkout.

Product1 (points x quality) + Product2 (points x qualty) = Total Points

Regards,

Gary

Hi,

Well, there is nothing complex:
Before the foreach displaying each product in the cart view file:
$total_points = 0;

Then, in the foreach:
$total_points+= $row->travel_points*$row->cart_product_quantity;

And after the foreach:
echo $total_points;

thank you