MX Shop Forum :: Simple Email - Order Details?

Hello again,

I have added another Product Property to my MX Shop following the section in the manual titled "Supporting other Product Properties".  I've actually added the product "sku", just as in the example from the manual.  The "sku" property is now being saved to the database, but now I need to be able to retreive the "sku" property for each item and display it in the Simple Email that is sent to the store admin on checkout.

In the manual it says add this line to the krt_functions.inc.php file:

$fields .= ", psku_ode" ;

$values .= ", '" . addslashes($KartFV_RS->fields[$i]['sku']}.

I did add the above code and it works, but when try to add this "sku" column to the krt_CheckoutEmail.class.php file (the simple email sent to the admin):

<td class="valueww" align="right"><?php echo $rs1->Fields($kartProps['Korders']['orderDetails']['sku']); ?></td>

it does not return a value for the SKU property, in that column.

Can you please tell me how to correctly return a value for the "sku" property in the simple email that is sent to the admin upon checkout?

Thanks,

Sirian

Hi Sirian,

So the SKU value is correctly inserted into the orderdetail_ode table?

Please attach here the modified "krt_CheckoutEmail.class.php" page. I will take a look.

Ionut

Try to refer to the order detail table and 'sku' column directly like:

<td class="valueww" align="right"><?php echo $rs1->Fields('sku_column'); ?></td>

where sku_column will be the name of the order detail table column that holds the sku info.

Ionut

Ionut,

I don't think I understand your solution?

  Do you mean I should try to add a recordset to the "krt_CheckoutEmail.class.php" file that contains the order detail table and then call the SKU column (which would be the "sku_column" in your example) from that recordset?

If that is the case, then how do I make sure that it pulls up the correct order details in that recordset?

Also, if you are suggesting pulling "sku_column" from an Order Details table recordset directly, then will the value for "sku_column" also automatically be included in the email that is sent to the store admin upon checkout?

Or is there more code I will need to include somewhere, in order for this information to be sent in the checkout order email?  If so, then what code should I add and where?

Thanks,

Sirian

error

I suggested to just replace:

<td class="valueww" align="right"><?php echo $rs1->Fields($kartProps['Korders']['orderDetails']['sku']); ?></td>

with:

<td class="valueww" align="right"><?php echo $rs1->Fields('sku_column'); ?></td>

and see if it works.

Ionut

Ionut,

It worked!  I didn't understand exactley what you meant at first, but then I realized you meant to just replace the statement with:

<td class="valueww" align="right"><?php echo $rs1->Fields('psku_ode'); ?></td>

Thanks so much, you guys are a lifesavers........

Sirian

Ionut,

I was mistaken.  The solution you gave me only partially worked.  Now the SKU will show up on the order checkout page before the user presses the "Buy Now" button, but the checkout email is sent with the sku field still blank.  Can you please help.  Because the SKU field showing up doesn't really help if it isn't  ALSO sent the store admin after an order is made.  

Please help.  Thank you.

Sirian

Hi,

I apologize for this simple question out of place, but please I do need to solve this issue to be paid for customer, Please !...Question is here

Thanks in advanced,
Fernando Delgado.