Import to EcomProducts does not finish

E-mail notifications

Adrian Ursu

Posted on 18/03/2016 08:43:43

Hi Guys,

I am trying to import some data into the EcomProducts Table.

I jve a job that used to run very smoothly on 8.7.2.5 but it appears to have issues in 8.7.2.8.

I get everything right except the actual data update. The progress is stuck to "Starting update products information".

I am using Excel provider as source (also tried with csv), I have chisen to update only existing products, I have a column in my file that corresponds to product number and I have set primary key to be Product number and Language. This approach used to work.

The file has about 29000 lines (not sure if it's relevant).

I tried to find a more details log (preferably with errors) but I could only spot the one that is displayed in the interface.

Thanks,

Adrian

Replies

Adrian Ursu

Posted on 18/03/2016 10:14:53

Also, if I try to run the job again, I keep getting the same message: "No log information present"

And I cannot run the job again unless I recycle the App pool

I hope this makes sense.

Thanks,
Adrian

Dmitriy Benyuk

Posted on 18/03/2016 13:32:41

Hi Adrian,
you can read more about the job exection inside the logs folder(using FileManager or directly browsing):
/Files/System/Logs/DataIntegration

You can not start the job second time since the previous jobs is not finished(seems it is stuck on some part).
Can you check if you have the index update settings enabled in the ecom destination provider settings? (Partial or Full update)
If it is enabled - maybe this is the cause of the problem.

Regards, Dmitrij

Dmitriy Benyuk

Posted on 18/03/2016 13:38:33

If this is not connected to index update and you have the mapping to "EcomProductsRelated" or "EcomVariantgroupProductrelation", "EcomVariantOptionsProductRelation" tables in your job

maybe some of those tables are causing problems, so you can remove them from mapping one by one and check on which it stucks.

Maybe upgrade to some of 8.8 versions can solve your problem.

Regards, Dmitrij

Adrian Ursu

Posted on 18/03/2016 14:40:48

Hi Dmitri,

Initially it was connected to a full update (since we are updating product details) but after seeing the problem I have deactivated it.

No connection with variant information. Just plain Custom fields for products.

I cannot upgrade to 8.8. I already had a lot of headaches updating to 8.7.2.8 and I don;t want to start all over again.

Can it be related with table column heading having spaces in column names?

Thanks,
Adrian

Dmitriy Benyuk

Posted on 21/03/2016 11:29:07

Hi Adrian,
It seems it is not connected to the column names. Maybe this is related to partial product index update.
Could you share your job xml file, source excel file and your web site db back-up to reproduce the problem?
My email: dbe@dynamicweb-cms.com
Regards, Dmitrij

You must be logged in to post in the forum

Developer forum

Import to EcomProducts does not finish

Replies