Developer forum

Forum » Dynamicweb 10 » Discount Prices Not Syncing

Discount Prices Not Syncing

Annisa Ulfa
Reply

Hi everyone,

I’m currently using DynamicWeb 10.10.8 and have an issue with discount prices not being sent to Business Central. I have already disabled the discount menu in Integrations, and I’m managing discount prices directly in DynamicWeb, but they are still not syncing to BC. Has anyone encountered this issue before? Is there a specific setting or workaround I might be missing?

 

 

 

 

 

 

 

 

 

Any help or insights would be greatly appreciated!

Thanks in advance.


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Annisa,
could you give more details about the issue? I need to look on the request and response xmls that are generating once the order is completed. You can find that in the LiveInegration log file that is located in the Files/System/Log/LiveIntegration folder (logging cheboxes need to be enabled in the Live integration settings)
What kind of a discount is not working: product or order discount? Fixed amount or a percentage disount?
BR, Dmitrij

 
Annisa Ulfa
Reply

Hi Dmitriy,

I've attached the log file as requested.

Regarding your questions:

  • What kind of discount is not working? Order discount.
  • Fixed amount or percentage discount? Both.

Let me know if you need any further details.

 

Thanks,

Annisa Ulfa

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Annisa,

you have wrong xml for the Order discount line int the request xml, it needs to be with this format, see the bold lines that are missed in your xml:
<item table="EcomOrderLines">
      <column columnName="OrderLineId">OL32855</column>
      <column columnName="OrderLineOrderId">ORDER-STA939</column>
      <column columnName="OrderLineParentLineId"></column>
      <column columnName="OrderLineProductId"></column>
      <column columnName="OrderLineProductVariantId"></column>
      <column columnName="OrderLineProductNumber"></column>
      <column columnName="OrderLineProductName">TestTon B2C</column>
      <column columnName="OrderLineProductIdentifier">..</column>
      <column columnName="OrderLineQuantity">1</column>
      <column columnName="OrderLineUnitId"></column>
      <column columnName="OrderLinePriceWithoutVat">-10</column>
      <column columnName="OrderLineUnitPriceWithoutVat">-10</column>
      <column columnName="NetPrice"></column>
      <column columnName="OrderLineType">1</column>
      <column columnName="OrderLineTypeName">Discount</column>
      <column columnName="OrderLineBom">False</column>
      <column columnName="OrderLineBomItemId"></column>
      <column columnName="OrderLineGiftCardCode"></column>
      <column columnName="OrderLineIsGiftCardDiscount" isCustomField="True">False</column>
      <column columnName="OrderLineFieldValues">&lt;OrderLineFieldValueCollection /&gt;</column>
      <column columnName="OrderLineDiscountId">16</column>
      <column columnName="OrderLineDiscountName">TestTon B2C</column>
      <column columnName="OrderLineCampaignName"></column>
      <column columnName="OrderLineDiscountType">Amount</column>
      <column columnName="OrderLineDiscountValue">10</column>

      <column columnName="NAVVariantCode"></column>
    </item>

In your xml you have an OrderLineType=3 which is a product discount but not an Order discount.

Similar question was answered here, so maybe it can also help.

BR, Dmitrij

 

 
Annisa Ulfa
Reply

Hi Dmitriy,

Got it! Thanks for the explanation. I appreciate the reference—I'll check it out and let you know if anything else comes up.

 

Thanks,

Annisa Ulfa

 

You must be logged in to post in the forum