ISBN in delivery-slip.product-tab.tpl PDF

[WilliT]

Hi,

I try to explain my needs:

We use the ISBN field in products options for adding packing size information. So far, so good when the order was passed in Prestashop. But when we import orders from Amazon via the module of Common-Services, the value of ISBN in the order-detail table leaves blank, this information is obviously not imported or blocked.

I already made changes to the delivery-slip.product-tap.tpl:

{if empty($order_detail.product_isbn)}
                        ---
                    {else}
                        {$order_detail.product_isbn}
                    {/if}

Like I said, this is perfect for Presatshop orders only.

Right now, I have to acces directly the value of ISBN from the product table instead of the order-detail table but using {$product.isbn} does not work.

Which code do I have to add and where do Ihave to add (I guess in HTMLTemplateDeliverySlip.php)  in order to acces data directly from the products table?

Thank you in advance.

Willi

Edited October 23 by WilliT (see edit history)

[Prestashop Addict]

Please can you specify PS, PHP and theme versions

[WilliT]

Prestashop 1.7.5

PHP 7.1

As far as I know, the PDF function does not depend of a theme, it is in classic theme

[Prestashop Addict]

il y a 38 minutes, WilliT a dit :

As far as I know, the PDF function does not depend of a theme, it is in classic theme

You can override pdf templates like any templates, by creating a pdf folder in your theme 😉 

[WilliT]

Yes but that is not the problem. I want to add a value to my existing delivery slip pdf. But I don't know yet how to access this value. See my original message. Thank you.

[Prestashop Addict]

I confirm you have it in $order_detail.product_isbn (not display on orders slips before enter ISBN in product because info saved in order_detail). If you want to access of original add this in overridden template

		{assign var=pattribute value=Product::getAttributesParams($order_detail.product_id, $order_detail.product_attribute_id)}
		{$pattribute[0].isbn} {*contains actual ISBN*}

 

[WilliT]

Yes, thank you, I know that the ISBN ist stored in order_detail when an order is passed. But in my case ONLY when it it an order directly in Prestashop. But every order imported from Amazon does not have this entry in order_details. That is why I need to access the ISBN stored in the product table.

I already use

{if empty($order_detail.product_isbn)}
                        ---
                    {else}
                        {$order_detail.product_isbn}
                    {/if}

to get the ISBN from the order_detail table. But I have to get the ISBN from products.

[Prestashop Addict]

See my code above it works 😉

[WilliT]

Your code gets the ISBN value from the table $order_detail. Right?

[Prestashop Addict]

il y a 5 minutes, WilliT a dit :

Your code gets the ISBN value from the table $order_detail. Right?

No the ISBN value from product combination

[WilliT]

OK. But I don't have any ISBN in the table ps_product_attribute. All ISBN values are in the table ps_products. That is why I need to get the values from there.

Where do you put this part in? Into HTMLTemplateDeliverySlip.php? Which line? :

{assign var=pattribute value=Product::getAttributesParams($order_detail.product_id, $order_detail.product_attribute_id)}

This part goes into delivery-slip.product-tab.tpl?

{$pattribute[0].isbn} {*contains actual ISBN*}