Page 1 of 1

Low Inventory Notification and Variants

Posted: Tue May 25, 2010 2:22 pm
by jgreen
The low notification email that gets sent out appears to show quantities for the primary product and not the variants.

The email that I recieved showed the following:
SKU.....Product Name..................Qty in Stock........Re-order Level
1002....Leather Wristband #1002..........43.....................10

and from the Manage Variants screen:

Variant......SKU.......In Stock.....Low Stock
8".........1002-8.0......13.............9
8.5".......1002-8.5......10............18
9".........1002-9.0.......9.............18
9.5".......1002-9.5.......2.............13
10"........1002-10.0.....9...............9

The 43 is the sum of the variants. I'm not sure where the 10 comes from.

What I really want is for the notification e-mail to show each variant that is low on stock. Is there way to do this?

I'm hoping it's as simple as changing some values in the e-mail template to list variants rather than products but I'm not sure what that would be.

From the email template:
#foreach ($product in $products)
<td style="text-align: center;">$product.SKU</td>
<td>$product.Name</td>
<td style="text-align: center;">$product.Instock</td>
<td style="text-align: center;">$product.InstockWarningLevel</td>
</tr>
#end

Thanks for any help,

John

Re: Low Inventory Notification and Variants

Posted: Thu Jun 10, 2010 10:32 pm
by jgreen
anybody??

Re: Low Inventory Notification and Variants

Posted: Fri Jun 11, 2010 5:44 am
by mazhar
I am not sure about following but give it a try and see if it works for you.

Code: Select all

#foreach ($product in $products)
#foreac($variant in $product.Variants)
#if($variant.InStock <= pv.InStockWarningLevel)
<td style="text-align: center;">$product.SKU</td>
<td>$product.Name</td>
<td style="text-align: center;">$variant.Instock</td>
<td style="text-align: center;">$variant.InstockWarningLevel</td>
</tr>
#end
#end
#end


Re: Low Inventory Notification and Variants

Posted: Fri Sep 09, 2011 6:18 pm
by ceckland
I'm having the same issue - did the fix noted work ?

Also, where exactly in the email template should this go? Can you paste in the whole Low Inventory template with this added in?

Thx,
Chris

Re: Low Inventory Notification and Variants

Posted: Fri Mar 30, 2012 5:45 pm
by freeweaver
I have an email template and I've made the changes below, but I also need the VariantName from the variant.
However, when I choose that field the value is blank.
Any idea why that would be and how to fix it?