vendor notification issue, 5 items purchased only 4 show

igavemybest · Post by **igavemybest** » Sat Jul 26, 2008 3:24 pm

Hello. In my vendor notification (packing slip) email, I have the stock HTML code that came with AC7. About a week ago, it left one item out of the 5 different items my customer purchased. So only 4 showed up in the Vendor notification email for some reason. Now, nothing is showing up in the email at all. Just my store name and address, the order number, and order date. Nothing else. I dont know what to do to correct it. I have every after sale trigger checked to see if anything will make it send the info, but nothing works. I would like to add however, the email "order confirmation" works and has all the info. Please help! Here is the code I have in my email template:

<html>
<head>
<style type="text/css">
TABLE.Email {
width: 640px;
padding: 5px;
margin: 0px;
border: 1px solid #5872CB;
}
TABLE.Email TH {
font-weight: bold;
font-size: 12px;
color: #ffffff;
font-family: Arial, Verdana, Sans-Serif;
font-style: strong;
background-color: #304FBA;
text-align: center;
text-decoration: none;
padding: 5px;
}
TABLE.Email TD {
font-weight: normal;
font-size: 12px;
color: #000000;
font-family: Arial, Verdana, Sans-Serif;
background-color: #ffffff;
text-align: left;
text-decoration: none;
padding: 3px;
}
</style>
</head>
<body>
<table class="Email">
<tr>
<td valign="top"><strong>$store.Name</strong><br>
<div style="padding-left:30px;">
$store.DefaultWarehouse.FormatAddress(true)
<BR>Phone: $store.DefaultWarehouse.Phone
<BR>Email: $store.DefaultWarehouse.Email
</div>
</td>
<td align="right">
<H1>Packing Slip</H1>
<strong>Order Number</strong>: $order.OrderId<br>
<strong>Order Date</strong>: ${order.OrderDate}</td>
</tr>
</table>
<table class="Email">
#foreach( $shipment in $VendorShipments )
<tr>
<td>
<strong>Ship To:</strong>
<div style="padding-left:30px;">
<p>$shipment.FormatToAddress(true)
<BR>Phone: $shipment.ShipToPhone
#if ($shipment.ShipMessage.Length > 0) <br>
<strong>Message:</strong> $shipment.ShipMessage
#end</p>
</div>
</td>
</tr>
<tr>
<td>
<table width="100%" border="2" align="center">
<tr>
<th class="Email">SKU</th>
<th class="Email">Product Name</th>
<th class="Email">Options</th>
<th class="Email">Quantity</th>
</tr>
#foreach( $orderItem in $VendorItems )
#if ($orderItem.OrderShipmentId == $shipment.OrderShipmentId)
<tr>
<td style="text-align: center;">$orderItem.Sku</td>
<td>$orderItem.Name<br><font size=2><strong>$orderItem.LineMessage</strong></font></td>
<td>$orderItem.VariantName</td>
<td style="text-align: center;">$orderItem.Quantity</td>
</tr>
#end
#end
</table>
</td>
</tr>
<tr>
<td style="text-align: center;">
<br>
Thank you for your order. If you have any questions, please contact
$store.Name<br></td>
</tr>
#end
</table>
</body>
</html>

Post by **Katie** » Mon Jul 28, 2008 6:42 pm

I updated your CRM case to get login information for your store.

Thanks,
Katie

Post by **Katie** » Wed Jul 30, 2008 12:17 pm

The problem was not with the email itself, but the fact that some products didn't have a vendor association.

Katie

igavemybest · Post by **igavemybest** » Wed Jul 30, 2008 12:31 pm

Does anyone know how to do a database update, so that all items in my database show the same vendor?

Post by **sohaib** » Wed Jul 30, 2008 12:59 pm

If you know the vendor Id for example 1 you can run an SQL query like this on the database

UPDATE ac_Products SET VendorId=1

Warning:Running direct queries on the database is a risky business. Do it at your own risk.

AbleCommerce Shopping Cart Software

vendor notification issue, 5 items purchased only 4 show

vendor notification issue, 5 items purchased only 4 show

Re: vendor notification issue, 5 items purchased only 4 show

Re: vendor notification issue, 5 items purchased only 4 show

Re: vendor notification issue, 5 items purchased only 4 show

Re: vendor notification issue, 5 items purchased only 4 show