Developer forum

Forum » Development » Adding products directly to EcomProducts in DW8

Adding products directly to EcomProducts in DW8

E-mail notifications
Lars Bruun
Reply
Posted on 05/09/2012 16:24:12

I have at problem in DW8 adding products in multiple languages directly not usng the API.

All products are written directly into the EcomProducts table using SQL INSERT and it all seems ok in the table with correct ProductLanguageID.

But in the Dynamicweb eCommerce adiminstration, the products added at still shaded in ALL language layers an dth ecustomer has to sort of activate then with an edit - save from the backend.

After that the products ar all non-shaded and showing ok in frontend also.

But i cannot se any change to the Products in question when i look into the eComProducts table, so I suspect something has changed ? Are there any dependies/tables or otherwise to be handled for a product to show up correctly in the eCommerce module ?

I have used this way of doing it before, so what may have changed ?


Replies

 
Morten Bengtson
Posted on 06/09/2012 17:19:57
Reply

Hi Lars,

 

Do you set ProductActive = 1 on import? If yes, then its probably a caching issue. You might need to clear the cache and re-index after import.

 

Is there any particular reason for not using the Data Integration module to import products? If you import directly to Ecom tables using SQL, you can end up with all sorts of problems - now and in the future.

 

Using the API for importing is painfully slow, but Data Integration is very fast. I have set up an import job that imports more than 20.000 products in less than two minutes...

 

05-09-2012 13:56:02: Starting batch
05-09-2012 13:56:03: Starting job - NAV_Import.
05-09-2012 13:56:05: reading configuration
05-09-2012 13:56:13: Starting import to temporary table for EcomProductsRelated.
05-09-2012 13:56:13: Added 4643rows to temporary table for EcomProductsRelated.
05-09-2012 13:56:13: Finished import to temporary table for EcomProductsRelated.
05-09-2012 13:56:13: Starting import to temporary table for EcomGroupRelations.
05-09-2012 13:56:13: Added 140rows to temporary table for EcomGroupRelations.
05-09-2012 13:56:13: Finished import to temporary table for EcomGroupRelations.
05-09-2012 13:56:13: Starting import to temporary table for EcomGroupProductRelation.
05-09-2012 13:56:44: Added 6906rows to temporary table for EcomGroupProductRelation.
05-09-2012 13:56:44: Finished import to temporary table for EcomGroupProductRelation.
05-09-2012 13:56:44: Starting import to temporary table for EcomProducts.
05-09-2012 13:56:45: Added 10000 rows to temporary table for EcomProducts.
05-09-2012 13:56:46: Added 20000 rows to temporary table for EcomProducts.
05-09-2012 13:56:46: Added 20898rows to temporary table for EcomProducts.
05-09-2012 13:56:46: Finished import to temporary table for EcomProducts.
05-09-2012 13:56:46: Starting import to temporary table for EcomGroups.
05-09-2012 13:56:47: Added 450rows to temporary table for EcomGroups.
05-09-2012 13:56:47: Finished import to temporary table for EcomGroups.
05-09-2012 13:56:47: Starting import to temporary table for AccessUser.
05-09-2012 13:56:47: Added 2rows to temporary table for AccessUser.
05-09-2012 13:56:47: Finished import to temporary table for AccessUser.
05-09-2012 13:56:47: Starting import to temporary table for EcomShopGroupRelation.
05-09-2012 13:56:47: Added 150rows to temporary table for EcomShopGroupRelation.
05-09-2012 13:56:47: Finished import to temporary table for EcomShopGroupRelation.
05-09-2012 13:57:49: Finished job - NAV_Import.

 

/Morten

 
Lars Bruun
Posted on 07/09/2012 14:38:21
Reply

It's a repetitve update base on handmade csv files with conditional update of selected fields eg. have not been able to make any standard module in DW do that yet ;o)

ProductActive is = 1 - then we are probably into the cache issue eg the database is OK, but DW administration has not fully understood that..

Hmm, interesting..

 

You must be logged in to post in the forum