Developer forum

Forum » Integration » NAV Import B2B prices related to customer numbers

NAV Import B2B prices related to customer numbers

E-mail notifications
Marie Louise Veigert
Reply
Posted on 04/01/2023 11:15:49

Hi,

I would like to know if the provider in DW supports this case:

We are getting products and prices from nav.

Currently on products we are using the DynamicwebService and XML provider.

Every price have a group of customer numbers. Ex the same product have 2 different prices with different groups of customer numbers. 

So we need to import different prices on same product which is different depending on the customer logged in. 

Can this be configurated or should it be done by code?

BR 
Marie Louise Veigert
 


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 04/01/2023 11:29:43
Reply
This post has been marked as an answer

Hi Marie,

Yuu should look into the Price Matrix functionality.

You can import prices in EcomPrices table and you have the ability to specify a CustomerNumber for each price. But please keep in mind the number of lines resulting from this scenario as they can affect the performance.

Usually, if you have this kind of price segmentation, Live Prices from NAV would be a lot more efficient (assuming NAV will return the response with the prices in a decent amount of time).


Adrian

Votes for this answer: 1
 
Marie Louise Veigert
Posted on 04/01/2023 15:18:44
Reply

@Adrian - thanks.

It looks like I will look into Price Matrix.

Do you know if its possible to use the Integration Tester tool to get prices and customers in same call to know which is connected to what? 
I have an example of how data is, but needs to get this in the call as well.

I have tried this but as espected it gets all customers first and then all prices:

<GetEcomData Qty="10" ><tables><ProductPrices type="all" /><Customers type="all"/></tables></GetEcomData>

Marie Louise

 
Michael Knudsen
Posted on 04/01/2023 15:34:32
Reply

Hello Marie,

- you could create two import jobs, one with customers and another with prices:

<GetEcomData Qty="10" ><tables><Customers type="all"/></tables></GetEcomData>

<GetEcomData Qty="10" ><tables><ProductPrices type="all" /></tables></GetEcomData>

Br. Michael Knudsen

 
Marie Louise Veigert
Posted on 05/01/2023 08:46:04
Reply

Thanks Michael, but how would you connect the two? 
The ProductPrices doesn't get any customer id's. Or is it wrong setup in the NAV/BS?

 
Michael Knudsen
Posted on 05/01/2023 09:08:51
Reply
This post has been marked as an answer

Hello Marie,

- sounds like something is wrong in the NAV/BS setup, if you don't get a reference to a specific customer or customer group.

Below is an ex. from a BC response:

<?xml version="1.0" encoding="UTF-8"?>
<tables>
   <table tableName="EcomPrices">
     <item table="EcomPrices">
       <column columnName="PriceId">001560-DKK-1-Stk.-1001</column>
       <column columnName="PriceProductId">001560</column>
       <column columnName="PriceProductVariantId"></column>
       <column columnName="PriceProductLanguageId">LANGx</column>
       <column columnName="PriceCurrency">DKK</column>
       <column columnName="PriceQuantity">1</column>
       <column columnName="PriceAmount">10259,00</column>
       <column columnName="PriceUnitId">Stk.</column>
       <column columnName="PriceValidFrom"></column>
       <column columnName="PriceValidTo"></column>
       <column columnName="PriceIsInformative">false</column>
       <column columnName="PriceUserCustomerNumber">1001</column>
       <column columnName="PriceUserGroupNumber"></column>
       <column columnName="PriceUserGroupName"></column>
       <column columnName="PriceStockLocationID">1</column>
     </item>
  </table>
</tables>

Br. Michael Knudsen

Votes for this answer: 1

 

You must be logged in to post in the forum