Invoice pdf showing custom field of product type

Hi,

That code is correct if you want to display the value of a custom field of the type "product" for your product.
So the problem is elsewhere.
Can you provide a screenshot of your custom field settings ?

Hi,

The column name of your custom field is "metri2" and not "product_metri2".
Thus, your code should be:

$productClass = hikashop_get('class.product');
$productData = $productClass->get($product->product_id);
echo '<br/>m2: '.$productData->metri2;

Hi,

"product_sort_price" is the column name in the database so it's normal that it works for this field.
If you want your custom code with product_metri2 to work, then you should delete your custom product field and recreate it with the column name "product_metri2".

I don't see any other reason than the column name being wrong in your code.
But it's easy to check... Do a var_dump of $productData and you'll see all the variables available for your product. You'll see that you have "metri2" and not "product_metri2" since that's the column name of your custom field.

Hi,

I don't see why calcbuilder would use a custom product field.
Calcbuilder is, as far as I understand, normally used with custom item fields, not custom product fields. And it doesn't require any code customization to display custom fields on the invoice, whether they are custom item fields or custom product fields, just setting the display settings of the custom field properly.
So I'm thinking that there is a problem with the custom field itself not being of the good type or along these lines.
Now, it could also be that the template has view overrides preventing you from seeing the custom fields. Again, it's easy to check. Switch to the default template of Joomla and see if you get the custom fields. If yes, then it comes from the template view overrides. If no, then it's probably a setting issue.

Hi,

When you create a custom product field, the column is added in the hikashop_product table not in hikashop_order_product.
If you have a column "metri2" in hikashop_order_product, then it means that either you added a custom item field with that name, or that calcbuilder added it itself.

When you create a custom item field, HikaShop creates two columns:
- the one in hikashop_order_product
- the one in hikashop_cart_product
When you add a product to the cart with a custom item field value, that value is added to the column of the custom item field in hikashop_cart_product by the add to cart process.
Then, when you create the order at the end of the checkout, HikaShop takes the value from there and set together with the rest of the product data necessary in the custom field column in hikashop_order_product.
So if the column is empty in hikashop_order_product, the first thing to check is whether the column is empty in hikashop_cart_product before finsihing the checkout.
If yes, then the problem is at the step when the product is added to the cart.
If no, then the problem is at creation of the order at the end of the checkout.
If the problem is with the add to cart, the next question is how is the product added to the cart ? By Calcbuilder ? How do they do ?
If the problem is at the end of the checkout, then is the metri2 a custom item field or was it added to the database without a custom field ? If it's added to the database without a custom field, then the system will dismiss it as being a potential hack (with the customer injecting data somehow to the product data). If it's added with a custom field, then the settings of that custom field should be check as there must be something preventing it from being taken into account.