Try our conversational search powered by Generative AI!

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 ?

Edited, Feb 13, 2018 15:44

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. 

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))

Feb 13, 2018 16:10

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. 

Feb 13, 2018 16:15

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

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.