Low Inventory Notification and Variants

[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

[jgreen]

anybody??

[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

[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

[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?