ProductDiscountPercent in live integration

Søren Bremholm Jakobsen

Posted on 06/05/2019 11:43:26

Hi,

i'm trying to get a product discount displayed on a product template and productlist. I'm using live integration version 2.0 on a Rapido/DW 9.5.5 solution. Product discount is returned in the response: <column columnName="ProductDiscountPercent"><![CDATA[50.00]]></column>. But trying to use GetDouble("Ecom:Product.Discount.Percent") either in the productfeed or directly in the product template returns 0. Am I missing a setting in DW or do I use the wrong tag?

Thanks in advance

Replies

Dmitriy Benyuk

Posted on 06/05/2019 13:39:39

Hi Søren,
there is no support of "ProductDiscountPercent" column in the standard Live integration 2.0 code. So it looks like you have added a new custom field "ProductDiscountPercent" that is retruned from the ERP. If yes, then you need to modify the Live integration code to read the value from that field and store it into some of the order line property like Price or UnitPrice.
File Dynamicweb.Ecommerce.LiveIntegration\OrderHandler.cs
ProcessDiscountOrderLine method.
Or implement your own Ecommerce.Orders.OrderLineTemplateExtender where you can set your custom tag with your value.
Regards, Dmitrij

Søren Bremholm Jakobsen

Posted on 06/05/2019 15:05:54

Thanks Dmitrij,

Is it possible to get the latest liveintegration source code - version 2.0.4? currently the latest version on the download section is 2.0.1

Dmitriy Benyuk

Posted on 06/05/2019 15:33:21

Yes, you can download it from here.
Regards, Dmitrij

Søren Bremholm Jakobsen

Posted on 14/05/2019 16:13:59

Hi Dmitriy,

I have updated the ProcessResponse method in ProductManager.cs in the live integration project to get the 2 customfields from the response. I have added the following code to store values in 2 customfields:

foreach (ProductField pf in ProductField.GetProductFields())
{

if (pf.SystemName == "DiscountPercentage")
{
var productDiscountPercent = item.SelectSingleNode($"column [@columnName='ProductDiscountPercent']").InnerText;
if (productDiscountPercent != null)
{
productInfo[pf.SystemName] = productDiscountPercent;
}
}
if (pf.SystemName == "NetPrice")
{
var productNetPrice = item.SelectSingleNode($"column [@columnName='ProductNetPrice']").InnerText;
if (productNetPrice != null)
{
productInfo[pf.SystemName] = productNetPrice;
}
}
}

and i try to get and display the values in either the productfeed or productlistfeed with:

foreach (LoopItem item in GetLoop("CustomFieldValues"))
{

if (item.GetString("Product.CustomField.System") == "DiscountPercentage")
{
productObject.discountPercent = item.GetString("Product.CustomField.Value.Clean");
}
if (item.GetString("Product.CustomField.System") == "NetPrice")
{
productObject.netPrice = item.GetString("Product.CustomField.Value.Clean");
}
}

but the 2 customfields are empty. Do you have any idears?

best regards

Dmitriy Benyuk

Posted on 15/05/2019 08:14:35

This post has been marked as an answer

Hi Søren,
You probable need to debug and check the Products\ProductProviderBase.cs class FillProductValues method if it is populating the custom fields values into the product.
So try to debug this code and check if it is passed through the first IF statement (as AddProductFieldsToRequest can be OFF or product.ProductFieldValues collection may be empty):
if (Settings.Instance.AddProductFieldsToRequest && product.ProductFieldValues.Count > 0)
            {
                foreach (ProductFieldValue pfv in product.ProductFieldValues)
                {
                    if (productInfo.ContainsKey(pfv.ProductField.SystemName))
                    {
                        pfv.Value = productInfo[pfv.ProductField.SystemName];
                    }
                }
            }
Regards, Dmitrij

Votes for this answer: 1

Søren Bremholm Jakobsen

Posted on 16/05/2019 10:23:10

Thanks. That was just the hint I needed to fix the issue

You must be logged in to post in the forum

Developer forum

ProductDiscountPercent in live integration

Replies