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 ?
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.
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))
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.
In commerce db which tables has contains relationship between category and products.please explain that things