Developer forum

Forum » Development » RE: Data Integration - Custom + Ecom Provider, Part II

RE: Data Integration - Custom + Ecom Provider, Part II

E-mail notifications
Marco Santos
Reply
Posted on 15/04/2014 13:00:58

Hello.

I am trying to integrate product information, and although I am able to syncronize (create and update) most products, some do not for some reason. Here are the details:

Example records for a product to export (this is one that does not get imported)

Lang        SendysId             Number   Name           EAN                   Weight     Price       Stock     Promotion

LANG2    4012031430004    003143    Sinalizador   3245060031435   0,03745    15,3792    0           0
LANG1    4012031430004    003143    Indicator       3245060031435   0,03745    15,3792    0           0

 

The VAT group is mapped as a constant value in the integration definition and the keys in the mapping between this and EcomProducts is the default (Product Id, Language and Variant).

On the integration provider I have the product number and the language set as the key and those are mapped to the ProductNumber and ProductLanguage in the EcomProducts table.

Can anyone think of anything that could be preventing this product from being imported into the EcomProducts table?

Thanks.

Marco


Replies

 
Morten Snedker
Posted on 22/04/2014 16:28:25
Reply

Hi Marco,

 

Do you get a "Batch completed", but product is not present? Is it not present both in backend of Dynamicweb and when selecting directly on the database?

 

Regards /Snedker

 
Marco Santos
Posted on 22/04/2014 16:49:26
Reply

Hello.

Yes, and yes. Any ideias?

Marco

 
Morten Snedker
Posted on 23/04/2014 10:19:54
Reply

Try creating a new job, stripping the import down to very basics, so that you have have a job with mapping to table EcomProducts ONLY, and then no column mappings other than the three key values. Nothing else. And see if that makes a difference.

 

Which is the version of Dynamicweb you're using?

 

Regards /Snedker

 
Marco Santos
Posted on 23/04/2014 17:39:33
Reply

I don´t map the three key values, the only one that is mapped from those is the LanguageId. If I remove all but that one then all are imported as new records.

I have also tried mapping just the language id and the product number and that worked, in that the products are all imported, but obviously information is missing. If I add another field (ProductName, for example) it stops importing the missing records though. Updating existing records seems to work fine in every case.

The version I am using is 8.3.1.18.

Marco

 
Morten Snedker
Posted on 24/04/2014 09:23:51
Reply

I am a bit confused. You state that the only key value that is mapped is LanguageID. But in your first posting you state

"...and the keys in the mapping between this and EcomProducts is the default (Product Id, Language and Variant)."

So which is it? A screendump of your mapping windows will be of help.

I take that you are using the Ecom Provider for destination. If so I recommend taking a look at http://developer.dynamicweb-cms.com/documentation/for-developers/data-integration/providers/ecom-provider.aspx.

 

Let me know if this helps.

 

Regards /Snedker

 

PS: As the Data Integration module is continously updated, I recommend moving to the latest 8.4.

 

 
Marco Santos
Posted on 24/04/2014 10:45:34
Reply

Ah, sorry. I meant those three fields are selected as keys in the table mapping, not in the column mapping. Below are the mappings as they exist.

In any case, the issue was resolved by having two jobs run, the first to insure that products are imported and the second to update the information. I´ll take a look at the link you sent to see if anything pops out anyway, I would rather have only one job.

Thanks.

Marco

 

You must be logged in to post in the forum