Import into ProductPrices sets the (default) language ID

E-mail notifications

Imar Spaanjaars

Posted on 17/11/2025 14:00:04

Hi there,

I have an import job running on DW 10 that imports prices as follows:

When I run the job, my prices get a language ID (the default one) even though my mapping doesn't supply one. This wasn't the case on DW 9 as far as I know.

How do I allow an empty language ID?

Imar

Replies

Dmitriy Benyuk

Posted on 17/11/2025 14:35:33

Hi Imar,
there were no changes related to inserting the PriceLanguageId column value for the Ecom destination provider in DW10. Can you check if you do not use any other job that can insert the value or any custom table script that can cause this?
BR, Dmitrij

Imar Spaanjaars

Posted on 17/11/2025 16:58:02

I'm using the DynamicwebProvider, if that matters.

The job has no table scripts, and it's the only sub-task in the scheduled task. To reproduce, I did this:

1. Run UPDATE EcomPrices SET PriceProductLanguageId = '' where PriceCurrency = 'GBP'

2. Recyled the site, just in case

3. Ran the import job

That put the default language on the price records that I imported.

Imar

Dmitriy Benyuk

Posted on 17/11/2025 17:49:05

This post has been marked as an answer

Hi Imar,
it is a feature implemented in the Dynamicweb provider (and it also was added even in DW9 in one of the latest versions, maybe not for all the tables).
So it auto adds the *LanguageId mapping at the job execeution and sets it to the default language id constant value if there is no already existing destination language id column mapping in the job.
You can try to use the EcomProvider instead.
BR, Dmitrij

Votes for this answer: 1

Imar Spaanjaars

Posted on 18/11/2025 09:28:26

I see. The old site was on 9.18 so maybe that didn't have it. I've now updated the job and set the language ID myself which solved the issue.

Thanks!

Imar

You must be logged in to post in the forum

Developer forum

Import into ProductPrices sets the (default) language ID

Replies