Catalog migration

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
  • Member since: 2011

    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
  • 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
  • Member since: 2011

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

    #188204 Feb 14, 2018 13:27