Add Manuf Part Number to XML package

[BabyDirect.com]

How can I add the Man Part Number to the Distributor Email (XML Package) and the Single Product Package?

Thanks

[Rob]

which package in particular? and where on the page?

[BabyDirect.com]

I need it in notification.distributor.xml.config and product.SimpleProduct.xml.config

Somewhere next or close to the product title or name.

Thanks

[George the Great]

The mfg number is not pulled by either of those packages by default. For the simpleproduct package you would either need to write the entire query from scratch to pull all of the information that is already there (in which case you might as well just create a custom package) or modify the aspdnsf_ProductInfo stored procedure to also return the mfg number in the results that it returns.

In the notification.distributor package, you would have to modify the OrderItems query and do a select/join on the variantID and/or productID retrieved from Orders_ShoppingCart to pull the related ManufacturerPartNumber from the Product and/or Variant table.