Order Email Text (Seller) fields

geppogiappo
Phoca Member
Phoca Member
Posts: 19
Joined: 23 May 2018, 16:26

Order Email Text (Seller) fields

Post by geppogiappo » 17 Jul 2018, 00:01

Hello,

I would like to add in seller order received email, some other fields.

I actually see in email body only order id, date, payment and delivery info.

I for example would like to add customer phone number and delivery notes.

I investigated in order.php file and it seems it is ready to write other field, for example "COM_PHOCACART_DELIVERY_NOTE", but if I query the database, I can't retrieve so much data:
SELECT `id`, `order_token`, `user_id`, `group_id`, `invoice_id`, `status_id`, `shipping_id`, `payment_id`, `coupon_id`, `discount_id`, `currency_id`, `tax_calculation`, `currency_code`, `currency_exchange_rate`, `unit_weight`, `unit_volume`, `title`, `alias`, `comment`, `ip`, `user_agent`, `tracking_id`, `tracking_title`, `tracking_description_custom`, `tracking_link_custom`, `tracking_number`, `tracking_date_shipped`, `published`, `checked_out`, `checked_out_time`, `ordering`, `date`, `modified`, `params`, `type`, `vendor_id`, `ticket_id`, `unit_id`, `section_id`, `loyalty_card_number`, `reference_field1`, `reference_field2`, `reference_data`, `order_number`, `receipt_number`, `invoice_number`, `invoice_prn`, `invoice_date`, `invoice_due_date`, `invoice_spec_top_desc`, `invoice_spec_middle_desc`, `invoice_spec_bottom_desc`, `privacy` FROM `jos3_phocacart_orders` WHERE id=19;
(19, 'f563a5ee0a1d452b2d6fb857b22dc0cbc5b9bd55f24262a4238853474164fd5d', 603, 0, 0, 2, 1, 1, 0, 0, 1, 0, 'EUR', '1.00000000', 'g', 'ml', '', '', '', '62.10.64.32', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0', 0, '', NULL, '', '', '0000-00-00 00:00:00', 1, 0, '0000-00-00 00:00:00', 0, '2018-07-16 21:16:15', '2018-07-16 21:18:20', NULL, 1, 0, 0, 0, 0, '', '', '', '', '20180000000019', '20180000000019', '{orderdate}0000000019', '20180000000019', '2018-07-16 21:16:15', '2018-08-15 09:08:15', '', '', '', 0);

Do you think the issue is in inserting data or do I have to add the field I desire to have written in email body in such a different way?

Thank you very much for your help.

Regards,

Alex


geppogiappo
Phoca Member
Phoca Member
Posts: 19
Joined: 23 May 2018, 16:26

Re: Order Email Text (Seller) fields

Post by geppogiappo » 17 Jul 2018, 22:36

I successfully add customer phone number ({b_phone_1} and {s_phone_1}) in email body, but it seems that the following field:

<textarea class="form-control" name="phcomment" rows="3"></textarea>

related to customer comments (in order checkout) is not inserted into database.


Regards,

Alex

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Order Email Text (Seller) fields

Post by Jan » 18 Jul 2018, 00:32

Hi, regarding phpcomment, see:
viewtopic.php?f=44&t=58956&p=151764#p151764

will be fixed in next version.

Jan
If you find Phoca extensions useful, please support the project

geppogiappo
Phoca Member
Phoca Member
Posts: 19
Joined: 23 May 2018, 16:26

Re: Order Email Text (Seller) fields

Post by geppogiappo » 18 Jul 2018, 12:25

Jan wrote:
18 Jul 2018, 00:32
Hi, regarding phpcomment, see:
viewtopic.php?f=44&t=58956&p=151764#p151764

will be fixed in next version.

Jan
Hi Jan,

that's fantastic! Thank you very much for the solution :twisted:


Regards,

Alex.

geppogiappo
Phoca Member
Phoca Member
Posts: 19
Joined: 23 May 2018, 16:26

Re: Order Email Text (Seller) fields

Post by geppogiappo » 18 Jul 2018, 12:35

Everything is now working, but I saw comments are returned to blank value after order status is changed into administration console.....

Alex

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40262
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Order Email Text (Seller) fields

Post by Jan » 19 Jul 2018, 14:36

Hi, thank you for the info, I have fixed it (blank value in comments), so it will be Ok in new version.

Jan
If you find Phoca extensions useful, please support the project

Post Reply