Differences in order confirm e-mail to vendor

Start
Prev
1
Next
End

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281362

-- url of the page with the problem -- : www.tweedehandjes.com
-- HikaShop version -- : 3.2.0
-- HikaMarket version -- : 1.7.3

Hi,

There is an issue with order confirmation emails being send to 1 of my vendors.

Usually, when an order is confirmed, my vendors get an email that 1 or more of their products have been sold.
The only information they see in that email is the order details (so no addresses or any other customer related private information).

Now the issue is that 1 of my vendors get an order confirmation email including the shipping and invoice address information of the customer. This is not correct. I cannot find the difference in setup between this vendor and the other vendors.

Do you have any idea?

Please see attached the "correct" and "incorrect" order confirmation emails.

Kind regards,
Joyce

Attachments:

Last edit: 6 years 5 months ago by joycehoveling. Reason: attachment private info was not blurred

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281363

Hello,

First please provide more details about your ACL.
I also need to understand what email you're talking about exactly, since we can't see the header image and I can't read the content ; I'm sorry but I do not visualize the context so I'm not able to investigate.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281389

Hi Jerome,

Sorry to be unclear. This is the email that my vendors get when one of their products have been sold: "Market: Order status notification"

<?php
/**
 * @package    HikaMarket for Joomla!
 * @version    1.7.3
 * @author     Obsidev S.A.R.L.
 * @copyright  (C) 2011-2017 OBSIDEV. All rights reserved.
 * @license    GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><style type="text/css">
body.hikashop_mail { background-color:#ffffff; color:#575757; }
.ReadMsgBody{width:100%;}
.ExternalClass{width:100%;}
div, p, a, li, td {-webkit-text-size-adjust:none;}
@media (min-width:600px){
	#hikamarket_mail {width:600px !important;margin:auto !important;}
	.pict img {max-width:500px !important;height:auto !important;}
}
@media (max-width:330px){
	#hikamarket_mail {width:300px !important; margin:auto !important;}
	table[class=w600], td[class=w600], table[class=w598], td[class=w598], table[class=w500], td[class=w500], img[class="w600"]{width:100% !important;}
	td[class="w49"] { width: 10px !important;}
	.pict img {max-width:278px; height:auto !important;}
}
@media (min-width:331px) and (max-width:480px){
	#hikamarket_mail {width:450px !important; margin:auto !important;}
	table[class=w600], td[class=w600], table[class=w598], td[class=w598], table[class=w500], td[class=w500], img[class="w600"]{width:100% !important;}
	td[class="w49"] { width: 20px !important;}
	.pict img {max-width:408px;  height:auto !important;}
}
h1{color:#1c8faf;font-size:16px;font-weight:bold;border-bottom:1px solid #ddd; padding-bottom:10px;}
h2{color:#89a9c1;font-size:14px;font-weight:bold;margin-top:20px;margin-bottom:5px;border-bottom:1px solid #d6d6d6;padding-bottom:4px;}
a:visited{cursor:pointer;color:#2d9cbb;text-decoration:none;border:none;}
</style>

<div id="hikamarket_mail" style="font-family:Arial, Helvetica,sans-serif;font-size:12px;line-height:18px;width:100%;background-color:#ffffff;padding-bottom:20px;color:#5b5b5b;">
	<div class="hikashop_online" style="font-family:Arial, Helvetica,sans-serif;font-size:11px;line-height:18px;color:#6a5c6b;text-decoration:none;margin:10px;text-align:center;">
		<a style="cursor:pointer;color:#2d9cbb;text-decoration:none;border:none;" href="{VAR:URL}">
			<span class="hikashop_online" style="color:#6a5c6b;text-decoration:none;font-size:11px;margin-top:10px;margin-bottom:10px;text-align:center;">
				{TXT:MAIL_HEADER}
			</span>
		</a>
	</div>
	<table class="w600" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;margin:auto;background-color:#ebebeb;" border="0" cellspacing="0" cellpadding="0" width="600" align="center">
		<tr style="line-height: 0px;">
			<td class="w600" style="line-height:0px" width="600" valign="bottom">
				<img class="w600" src="{VAR:LIVE_SITE}media/com_hikamarket/images/mail/header.png" border="0" alt="" />
			</td>
		</tr>
		<tr>
			<td class="w600" style="" width="600" align="center">
				<table class="w600" border="0" cellspacing="0" cellpadding="0" width="600" style="margin:0px;font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;">
					<tr>
						<td class="w20" width="20"></td>
						<td class="w560 pict" style="text-align:left; color:#575757" width="560">
							<div id="title" style="font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;">

<img src="{VAR:LIVE_SITE}media/com_hikashop/images/icons/icon-48-order.png" border="0" alt="" style="float:left;margin-right:4px;"/>
<h1 style="color:#1c8faf !important;font-size:16px;font-weight:bold; border-bottom:1px solid #ddd; padding-bottom:10px">
	{TXT:ORDER_TITLE}
</h1>

<h2 style="color:#1c8faf !important;font-size:12px;font-weight:bold; padding-bottom:10px">
	{TXT:ORDER_CHANGED}
</h2>
							</div>
						</td>
						<td class="w20" width="20"></td>
					</tr>
					<tr>
						<td class="w20" width="20"></td>
						<td style="border:1px solid #adadad;background-color:#ffffff;">
							<div class="w550" width="550" id="content" style="font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;margin-left:5px;margin-right:5px;">
<p>
	<h3 style="color:#393939 !important; font-size:14px; font-weight:normal; font-weight:bold;margin-bottom:0px;padding:0px;">{TXT:HI_VENDOR}</h3>
	{TXT:SALE_BEGIN_MESSAGE}
</p>
<!--{IF:acl.address}-->
<h1 style="color:#1c8faf !important;font-size:16px;font-weight:bold;border-bottom:1px solid #ddd;padding-top:10px;padding-bottom:10px;">
	{TXT:SALE_CUSTOMER}
</h1>

<table class="w550" border="0" cellspacing="0" cellpadding="0" width="550" style="margin-top:10px;font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;">
	<tr>
<!--{IF:acl.billingaddress}-->
		<td style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:BILLING_ADDRESS}</td>
<!--{ENDIF:acl.billingaddress}-->
<!--{IF:acl.shippingaddress}-->
		<td style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:SHIPPING_ADDRESS}</td>
<!--{ENDIF:acl.shippingaddress}-->
	</tr>
	<tr>
<!--{IF:acl.billingaddress}-->
		<td>{VAR:BILLING_ADDRESS}</td>
<!--{ENDIF:acl.billingaddress}-->
<!--{IF:acl.shippingaddress}-->
		<td>{VAR:SHIPPING_ADDRESS}</td>
<!--{ENDIF:acl.shippingaddress}-->
	</tr>
</table>
<!--{ENDIF:acl.address}-->

<h1 style="color:#1c8faf !important;font-size:16px;font-weight:bold;border-bottom:1px solid #ddd;padding-top:10px;padding-bottom:10px;">
	{TXT:SUMMARY_OF_YOUR_SALE}
</h1>

<table class="w550" border="0" cellspacing="0" cellpadding="0" width="550" style="margin-top:10px;margin-bottom:10px;font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;">
	<tr>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:left;color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:PRODUCT_NAME}</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right;color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:PRODUCT_PRICE}</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right;color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:PRODUCT_QUANTITY}</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right;color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:PRODUCT_TOTAL}</td>
	</tr>
<!--{START:PRODUCT_LINE}-->
	<tr>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;">
			{LINEVAR:PRODUCT_IMG}
			{LINEVAR:PRODUCT_NAME}<!--{IF:ORDER_PRODUCT_CODE}--> {LINEVAR:PRODUCT_CODE}<!--{ENDIF:ORDER_PRODUCT_CODE}-->
		</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_PRICE}</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_QUANTIY}</td>
		<td style="border-bottom:1px solid #ddd;padding-bottom:3px;text-align:right">{LINEVAR:PRODUCT_TOTAL}</td>
	</tr>
<!--{END:PRODUCT_LINE}-->
<!--{START:ORDER_FOOTER}-->
	<tr>
		<td colspan="3" style="text-align:right;color:#1c8faf !important;font-size:12px;font-weight:bold;">{LINEVAR:NAME}</td>
		<td style="text-align:right">{LINEVAR:VALUE}</td>
	</tr>
<!--{END:ORDER_FOOTER}-->
</table>
<!--{IF:PAYMENT}-->
<p>
	<span style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:PAYMENT_METHOD} :</span> {VAR:PAYMENT}
</p>
<!--{ENDIF:PAYMENT}-->
<!--{IF:SHIPPING}-->
<p>
	<span style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:HIKASHOP_SHIPPING_METHOD} :</span> {VAR:SHIPPING}
</p>
<!--{ENDIF:SHIPPING}-->
<!--{IF:ORDER_SUMMARY}-->
<h1 style="color:#1c8faf !important;font-size:16px;font-weight:bold;border-bottom:1px solid #ddd;padding-top:10px;padding-bottom:10px;">
	{TXT:ADDITIONAL_INFORMATION}
</h1>
<p style="border-bottom:1px solid #ddd;padding-bottom:10px;">
	{VAR:ORDER_SUMMARY}
</p>
<!--{ENDIF:ORDER_SUMMARY}-->
<p>
	{TXT:SALE_END_MESSAGE}
</p>
							</div>
						</td>
						<td class="w20" width="20"></td>
					</tr>
				</table>
			</td>
		</tr>
		<tr style="line-height: 0px;">
			<td class="w600" style="line-height:0px" width="600" valign="top">
				<img class="w600" src="{VAR:LIVE_SITE}/media/com_hikamarket/images/mail/footer.png" border="0" alt="--" />
			</td>
		</tr>
	</table>
</div>

None of the vendors is able to see the address details of the customers, except 1. She gets the address details, which should not be.
All vendors have the same ACL: "Registered" and "Vendor" (see attached).

Does this help you?

regards,
Joyce

Attachments:

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281411

Hello,

As I wrote :

First please provide more details about your ACL.

But if you want to know why I'm asking you that information :

$vendor_access = hikamarket::getAclVendor($data->vendor);
$acl = array(
	'notify' => hikamarket::aclTest('order/notify', $vendor_access),
	'billingaddress' => hikamarket::aclTest('order/show/billingaddress', $vendor_access),
	'shippingaddress' => hikamarket::aclTest('order/show/shippingaddress', $vendor_access),
	'customfields' => hikamarket::aclTest('order/show/customfields', $vendor_access),
);

So please answer to my question if you want to get forward.

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281490

Hi Jerome,

I put the ACL attached in my former message, below the coding
Or otherwise I do not exactly understand what do you want to see.

Regards,
Joyce

Last edit: 6 years 5 months ago by joycehoveling.

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281491

Hello,

The screenshot indicate that the vendor is configured to be in some groups and that it has inherit ACL.
So it means that you need to provide the default store access from your HikaMarket configuration and also details from the "HikaMarket > Accesses > Vendor access".
With these elements it will be possible to understand.

But since the email is based on the "order / show / shippingaddress" and " order / show / billingaddress " ; I really think that these ACL are set in your HikaMarket configuration.

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281519

Hi Jerome,

Hereby the screenshot of the access levels. My vendors have the default access level and only superusers (like myself) are able to see everything. But could be that setup like this is not what it it meant for...

Kind regards,
Joyce

Attachments:

Last edit: 6 years 5 months ago by joycehoveling.

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281550

Hello,

Do you have configured element via the vendor accesses ?

also details from the "HikaMarket > Accesses > Vendor access".

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281584

Hello Jerome,

No I have nothing configured there.

Regards,
Joyce

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281585

Hello,

Okay.
So I have to admit that I not see what could be the configuration cause for that except maybe the groups (but if you really do not have anything configured for the vendor accesses, it should not impact the display).
Would it be possible to get a backend access (and the ID of the concerned vendor) so we can take a look ?

To send us private information, please use the "contact us" form and include an URL to the forum thread (so the support team will know what to do with the credentials).

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281615

Hi Jerome,

No really, nothing is configured.
I will send the information now.
Thanks in advance.

Regards,
Joyce

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281658

Hello,

Thanks for the credentials.

I cannot explain the reason why one of the email contains more data than it should.
Since the mail indicate the right vendor name, I assume that it contains the rest of the content, including the vendor id and the "vendor access".
If the vendor access is empty, the system automatically fall back on the default store access ; so it would mean that the system did load something else.
I cannot reproduce the issue in my local website and I'm afraid that it's hard to reproduce the problem in your website (since it happen once). So I'm afraid to be in a dead end right now.

If the problem repeat, we might have more elements to understand.
And if you want to be sure that the address is not display ; you can still edit the HikaMarket order status email and remove the part which display the address in the HTML part.

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281677

Hi Jerome,

I did a test on my website by ordering something from her and got the same again. Email included the address info. I also have no clue what could be the issue.

Can you tell me what I exactly need to do in the html email in order to hide it? I'm not the best with programming.

Thanks anyway for your assistance.

Kind regards,
Joyce

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281678

Hello,

Okay, I got into a deeper investigation and checked directly the database content.
I saw that the vendor with the issue had a really strange content for its "vendor_access".
When you display the vendor in the backend the access level tree is fine but, the data in the database got a lot of duplicate groups.
I think that could be the cause of the issue.

So I have force the "vendor_access" of every vendors with the same content (except the main vendor) : @0,@2,@10
Can you please make an extra test in your website ?

If that content was really the issue I think that I could implement an algorithm to detect that kind of content and then clean up the vendor accesses.

Regards,

Please Log in or Create an account to join the conversation.

joycehoveling
Topic Author
Offline

Posts: 115
Thank you received: 0

6 years 5 months ago #281783

Hi Jerome,

Thanks for your deeper investigation.
No good news though. I did the test and still the customer address info is visible in the email to this vendor.
I also did a test for another verndor, and this one was fine.

Do you have more ideas? ))
Is it an option to just fully remove the account of the vendor with the issue and create a new one?
Kind regards,
Joyce

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26000
Thank you received: 4004
MODERATOR

6 years 5 months ago #281785

Hello,

I don't have other idea and since the vendor details is exactly the same than the other vendors, I can't explain the behavior.
It would require a full investigation by adding a lot of debug data during the email processing ; but it would require to reproduce the issue in my local website. And unfortunately I do not duplicate your issue.

So ; In the email you can remove the code

<!--{IF:acl.address}-->
<h1 style="color:#1c8faf !important;font-size:16px;font-weight:bold;border-bottom:1px solid #ddd;padding-top:10px;padding-bottom:10px;">
	{TXT:SALE_CUSTOMER}
</h1>

<table class="w550" border="0" cellspacing="0" cellpadding="0" width="550" style="margin-top:10px;font-family: Arial, Helvetica, sans-serif;font-size:12px;line-height:18px;">
	<tr>
<!--{IF:acl.billingaddress}-->
		<td style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:BILLING_ADDRESS}</td>
<!--{ENDIF:acl.billingaddress}-->
<!--{IF:acl.shippingaddress}-->
		<td style="color:#1c8faf !important;font-size:12px;font-weight:bold;">{TXT:SHIPPING_ADDRESS}</td>
<!--{ENDIF:acl.shippingaddress}-->
	</tr>
	<tr>
<!--{IF:acl.billingaddress}-->
		<td>{VAR:BILLING_ADDRESS}</td>
<!--{ENDIF:acl.billingaddress}-->
<!--{IF:acl.shippingaddress}-->
		<td>{VAR:SHIPPING_ADDRESS}</td>
<!--{ENDIF:acl.shippingaddress}-->
	</tr>
</table>
<!--{ENDIF:acl.address}-->

which is there to display the address details.

Regards,

Please Log in or Create an account to join the conversation.