Developer forum

Forum » Integration » EcomPrices not updated in frontend after import

EcomPrices not updated in frontend after import

Andrejs Zavorotnijs
Reply

Hi

When prices, discounts and other data imported, prices not updated in frontend for specific customer groups, unitl save them again

prices

customer group discount with customer number 

also product have 20% discount

If I save Price 


Is it cache issue or do I forget something?


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Andrejs,
it looks like a caching issue. What Data Integration providers do you use for the data import?
Can you try to clear the service caches manually after the import to check if it will help?
It is located in the Settings->Developer->Cache->Service caches, probably it is related to ProductService
BR, Dmitrij

 
Andrejs Zavorotnijs
Reply

Hi Dmitriy

DW provider 

Already tried before to clear that, but no luck

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Andrejs,
I can not get this reproduced. What DW version and templates do you use?
I have used latest 9.15.6 with Swift and simple import of this xml to EcomPrices using DW provider:
<?xml version="1.0" encoding="utf-8"?>
<tables>
  <table tableName="EcomPrices">
    <item table="EcomPrices">
      <column columnName="PriceId"><![CDATA[Pice11]]></column>
      <column columnName="PriceQuantity"><![CDATA[0]]></column>
      <column columnName="PriceProductId"><![CDATA[PROD141]]></column>
      <column columnName="PriceCurrency"><![CDATA[EUR]]></column>
      <column columnName="PriceAmount"><![CDATA[30]]></column>
      <column columnName="PriceUserGroupId"><![CDATA[102]]></column>
    </item>
  </table>
</tables>
The price was updated just fine on the frontend.
BR, Dmitrij

 
Andrejs Zavorotnijs
Reply

Hi Dmitriy

Find issue in PriceUnitId field import, by name in SQL, that should be unit id, but in real life that is stock unit id.

So that issue was because I imported incorrect data in this field and that explains why price work after save.

 

 

You must be logged in to post in the forum