X-Cart forums

[tartaglia]

We have a music store where about 2/3 of all products are sheet music. Each piece of sheet music has been sucessfully set up in X-cart 4.4.5 with extra fields for things like Orchestration, Publisher, etc. I need the ability to display some of these extra fields on the invoice (with each sheet music product ordered) so that the Admin can print it and that the customer can see it. I have gotten very close on my own but can't seem to get it to work.

Here is what I have done....

Modified: skin/common_files/mail/html/order_data.tpl to add the following lines...(inside the foreach loop that displays the product lines for each ordered product)

{*BEGIN display extra field data DAC*}
{if $active_modules.Extra_Fields}
{include file="modules/Extra_Fields/product_orchestration_invoice.tpl"}
{/if}
{*END display extra field data DAC*}

Obviously I created the file: skin/common_files/modules/Extra_Fields/product_orchestration_invoice.tpl which looks like.

{foreach from=$product.extra_fields item=v}
{*{if $v.field eq "Orchestration" and $v.active eq "Y" and $v.field_value}*}
<div>
<span>{$v.field}:{$v.field_value}</span>
</div>
{*{/if}*}
{/foreach}

Notice that I commented out the {if} statement because I was getting nothing output. Now at least I get all the Extra Field names (Orchestration, Publisher, Genre, etc.) showing under each line item of the invoice, but the field values don't display (see screenshot XC8635.pdf). (yes, I have confirmed that the products on the example invoice have values for these extra fields)

Can someone please help, I'm guessing that for some reason the names are available but not the values.

David Coggan
Carolyn Nussbaum Music Company
(getting ready to launch X-cart 4.4.5 or 4.5.0)

[cherie]

Maybe "active" isn't set? Do a dump of the array and see if everything is as you expect it.

I like to key off service_name since it usually never changes but the name of the field could be changed at any time.

[tartaglia]

Cherie,

Thanks for responding, but I'm afraid you are speaking a bit over my head. Did I mention I not really a programmer, just a logical thinker.

Can you explain how to "do a dump of the array"?

And I'm sorry, but I have no idea what you are talking about in your second comment " ..keep off service_name..". Sorry for my ignorance, can you explain a little more?

Thanks
David

[cherie]

Whoops, that should have been "key" instead. I edited it.

Did you look to see if "active" is actually set?

You can use something like this to see what is in $product to see if all of the extra_fields stuff is like you are expecting:

<pre>{$product|@print_r}</pre>

[tartaglia]

Cherie, you are being most patient with me. In which .tpl file do I put the code:

<pre>{$product|@print_r}</pre>

and...(even after your edit) I do not understand what you mean by " I like to key off service_name..."
David

[cherie]

You would put it in the new tpl you created where you are doing the "if" statement that is commented.

You are currently keying off "field" with $v.field eq "Orchestration" where I would use the service_name (see your Extra Fields list).

[tartaglia]

Cherie,

Your help and patience were amazing. I was able to use your guidance to display extra fleid data on both the invoice (mail/html/order_data.tpl) and on the product listings (customer/main/product_list.tpl) by calling modified versions of the /modules/Extra_Fields/product.tpl file. The calls determined the extra fields value to be displayed by passing the service_name.

The only that would make this better would be if I didn't make the call for "ORCHESTRATION" for example unless the product being displayed to the customer was a piece of sheet music. (If its a T-shirt, looking for orcehstartion wouldn't make sense) So basically I would love to wrap the include statement inside an IF condition based on the category of the product being displayed. Is there a way to determine the category of a product that is being displayed to the customer and use it in a IF condition? Somthing like (pseudocode)...

LOOP EachProductToBeDisplayed
Display ProductInfo
IF (Product is in CategoryA)
Display ExtraFieldA
ENDIF
END LOOP

Thanks,
David

[cherie]

You would have to dig into the php to get the list of categories the product is in so you could compare (if).

I think you already have a good test by looking for Orchestration since it sounds like that would never be assigned to a t-shirt.

[tartaglia]

Right, it works good now (thanks to you) I was just trying to be efficient in the code so it didn't look through all my extra fields on every product that was displayed every time. Seemed like a waste of computing resources. But good enough for now. Thanks again.

[tartaglia]

So here is an update to this ticket for all who want to be able to display extra fields on the Invoice. This is currently working on X-Cart 4.5.4 and I have more than a few people ask me how to do it. My thanks to Qualiteam and the other posters on this thread for their assistance.

Create a NEW file: /skin/<yourskin>/modules/Extra_Fields/product_extra_fields_invoice.tpl

 
{foreach from=$product.extra_fields item=v}
  {if $v.service_name eq $xtrafieldservicename and $v.active eq "Y" and $v.value}
    <div>
      <span style="font-style: italic;">{$v.field}:&nbsp;{$v.value}</span>
    </div>
  {/if}
{/foreach}

Then MODIFY the file: /skin/<yourskin>/mail/html/order_data.tpl
by placing the following new if statement code inside the loop:

 
{foreach from=$products item=product}

and after the if statement:

{if $active_modules.Gift_Registry}
          {include file="modules/Gift_Registry/product_event_invoice.tpl"}
        {/if}

Here is the code to be added.

 
        {if $active_modules.Extra_Fields}
          {include file="modules/Extra_Fields/product_extra_fields_invoice.tpl" xtrafieldservicename="xfieldservicename1"}
          {include file="modules/Extra_Fields/product_extra_fields_invoice.tpl" xtrafieldservicename="xfieldservicename2"}
          {include file="modules/Extra_Fields/product_extra_fields_invoice.tpl" xtrafieldservicename="xfieldservicename3"}
        {/if}

Obviously you will need to replace the values "xfieldservicename1","xfieldservicename2","xfields ervicename2" with teh actual xtrafieldservicename from your database.

Hope this helps lots of folks, being able to add extra field data easily to lots of places inside X-cart would be a great built in feature for QT to add in the future. Examples include Cart page, Invoice (shown here), WishList page, New Arrivals Page, Product listing page, etc. Maybe if this post gets lots of attention "thanks", they will consider it.