November Happy Hour will be moved to Thursday December 5th.

Catalog migration

Vote:
 

Hi team,

We are using One catalog( included the catagory,products) as a main one(example:akg). The user has option to select the category or product ( checkbox ) for migration.

We Cloned selected categories & products( with the parent ) under New Catalog(example:pkg).

How to compare both catalogs, what are all non migrated items?
Is there any api,SQL query or FIND ?

#188173
Edited, Feb 13, 2018 15:44
Vote:
 

There is no such API, You would have to write something yourself. The way I think would would is to use IContentLoader to load the content recursively and compare. 

#188176
Feb 13, 2018 16:00
Vote:
 

Thanks Quan mai.

we already using icontent loader to compare the both catalogs(dynamically clicked catagory only in UI).Now we need to diaplay only non migrated items with out any recursive comparing.(because its takes too much time , we have more than 500 catagories and 13k products when i compare both catalogs it will double(1000categories & 26k products))

#188177
Feb 13, 2018 16:10
Vote:
 

1k categories and 26k products should not be a problem with IContentLoader. If you just want some kind of report, a scheduled job would probably takes 5 minutes to run and list the not-migrated items. 

#188178
Feb 13, 2018 16:15
Vote:
 

In commerce db which tables has contains relationship between category and products.please explain that things

#188204
Feb 14, 2018 13:27
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.