How do I add a product attribute name and value to the order confirmation email

[gunni]

Hi lat9
I do not remember I made any changes to order.php file.

I replaced the code with yours but that did not change anything...
Then I changed the attribute value from Hebrew the English...
but still got the strange letters/numbers attribute description.
The interesting thing is that the letters/numbers of the same attribute value is not
the same letters/numbers of the same attribute value of other product.
What could this means?
I use "dropdown" attribute.

Another interesting thing - all above is a part of Shipping_By_Quote module
meaning to say that the email that is sent by the customer is not a complete order
but a step before the order when the customer is asking for a shipping quote.
So now I continued to the final order stage (with Request for quote module) and the order by
email arrived good! (with the English attribute value).
So....what does it means?
Do you have any idea why in the first email it is with letters/numbers but in the final order
email it is ok?

[lat9]

I've just looked at the Shipping by Quote module (v2.3, the latest), but I don't see where it is gathering the product attributes information for the email message.

[mc12345678]

The full text information, ie. #254:e644e250cbc7557651e1dc4ad7d8f3ab is the non-sanitized products_id. Normally to provide just the products_id, the line of code would either be:

(int)products_id

or the more preferred ZC:

zen_get_prid($products_id)

Based on the other review, the fact that the attributes are not "reviewed" means that if an order contained more than one of the same base product, the attribute detail would not be provided and therefore if two or more of the same base product are ordered there is not a legible distinction presented (if modified to only give the sanitized products_id then would see a single number, if left as is, then see a string of text that doesn't mean anything to the human reader other than that there are attributes related to the product for those that know about that detail.)

So, seems a few options: either leave as is, modify to show just the products_id's number, or incorporate additional code to either breakdown or pull out of the database the detail of the attributes for that portion of the email process.

[mc12345678]

The full text information, ie. #254:e644e250cbc7557651e1dc4ad7d8f3ab is the non-sanitized products_id. Normally to provide just the products_id, the line of code would either be:

(int)products_id

or the more preferred ZC:

zen_get_prid($products_id)

Based on the other review, the fact that the attributes are not "reviewed" means that if an order contained more than one of the same base product, the attribute detail would not be provided and therefore if two or more of the same base product are ordered there is not a legible distinction presented (if modified to only give the sanitized products_id then would see a single number, if left as is, then see a string of text that doesn't mean anything to the human reader other than that there are attributes related to the product for those that know about that detail.)

So, seems a few options: either leave as is, modify to show just the products_id's number, or incorporate additional code to either breakdown or pull out of the database the detail of the attributes for that portion of the email process.

Sorry, just noticed a typing error in the first set of code:

(int)$products_id

is how that should read as I missed a dollar sign ($).

[lat9]

Thanks for that, mc12345678. Sometimes I can't see the forest for the trees.

[mc12345678]

Thanks for that, mc12345678. Sometimes I can't see the forest for the trees.

I thought it (explanation I provided) was possibly "between the lines" and I wanted to get it out in the open. The review for attribute handling (lack of by the plugin) sorta sealed the deal.

[gunni]

Thanks mc12345678 and lat9.
I think I will leave it as is.

[Jac Web]

Hello @lat9 and friends,

I am also struggling a bit with the attribute details in the confirmation email.

I am trying to modify the order confirmation email (for purposes of customers and the admin's copy of the email) to include the attribute item price (the rate per each attribute option) beside the name of it.

Right now, the email shows the list of selected attribute option names and quantities, but no price is listed - it only shows the subtotal. The customers and wholesalers really want to see the item price to do their checking against all the subtotals.

This is the format it has right now:

22 x Keep Austin Weird Shirt (5846TSHB) = $176.00
Small 5
Medium 3
Large 7
X-Large 7

But this is what we want to update it to show:

22 x Keep Austin Weird Shirt (5846TSHB) = $176.00
Small 5 at $x each
Medium 3 at $x each
Large 7 at $x each
X-Large 7 at $x each

----

Currently as pointed out previously in this thread, on line 844 the includes/classes/order.php reads:
$this->products_ordered_attributes .= "\n\t" . $attributes_values->fields['products_options_name'] . ' ' .

Can I just modify this line to be:

$this->products_ordered_attributes .= "\n\t" . $attributes_values->fields['products_options_name','options_values_price'] . ' ' .

Will this work or break something? Or will I need to look at more steps?

[mc12345678]

Hello @lat9 and friends,

I am also struggling a bit with the attribute details in the confirmation email.

I am trying to modify the order confirmation email (for purposes of customers and the admin's copy of the email) to include the attribute item price (the rate per each attribute option) beside the name of it.

Right now, the email shows the list of selected attribute option names and quantities, but no price is listed - it only shows the subtotal. The customers and wholesalers really want to see the item price to do their checking against all the subtotals.

This is the format it has right now:

22 x Keep Austin Weird Shirt (5846TSHB) = $176.00
Small 5
Medium 3
Large 7
X-Large 7

But this is what we want to update it to show:

22 x Keep Austin Weird Shirt (5846TSHB) = $176.00
Small 5 at $x each
Medium 3 at $x each
Large 7 at $x each
X-Large 7 at $x each

----

Currently as pointed out previously in this thread, on line 844 the includes/classes/order.php reads:
$this->products_ordered_attributes .= "\n\t" . $attributes_values->fields['products_options_name'] . ' ' .

Can I just modify this line to be:

$this->products_ordered_attributes .= "\n\t" . $attributes_values->fields['products_options_name','options_values_price'] . ' ' .

Will this work or break something? Or will I need to look at more steps?

Oddly the numbers to the right of each attribute added together and multiplied by 8 gives the current total. Any ways, the code as written would cause an error, but assuming that your product is priced by attributes then something similar would/could work.

$this->products_ordered_attributes .= "\n\t" . $attributes_values->fields['products_options_name'] . ' ' . $attributes_values->fields['options_values_price'] . ' '

Though you will probably want some other language based text to give the per attribute of product price.

[lat9]

@Jac Web, since that processing is present within a core-file (/includes/classes/order.php), you'll save yourself a world-of-hurts if you make those changes using an observer-class handler that augments/changes the built-in order-handling without actually changing the base order.php file.

What version of Zen Cart is your store currently built on?

P.S. I've got one of those "Keep Austin Weird" shirts!