Catalog migration

karthik

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

Quan Mai

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

karthik

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

Quan Mai

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

karthik

Vote:

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

#188204

Feb 14, 2018 13:27