London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
Get all strongly typed SKU's
The strong typed catalog content types are per-system, not per catalog, so there're two ways to do this:
- Iterate over all variation contents in your catalog. This is the most accurate way, but should be very slow - avoid if you have a big catalog.
- Use reflection to get all types inherited from VariationContent. As I mentioned above, this might not be entirely accurate if you have content types which do not belong to the catalog - but should be much faster.
Regards.
/Q
Jun 23, 2015 8:37
Hi,
You mean by using the contentrepository.getdescendents and then the contentrepository.getitems?
Jun 23, 2015 8:59
Hi,
Basically yes, you'll need to be recursively.
- Use IContentRepository.GetChildren<NodeContent> to get all the nodes
- For each node, use IContentRepository.GetChildren<VariationContent> to get the variations.
One much faster way but will involve sql script:
- Query CatalogEntry table to get the distinct metaclass Ids of SKUs (ClassTypeId = "Variation" , (remember to filter CatalogId = specific catalog id)
- use reflection to get all all types inherited from VariationContent, then get the content types which have MetaClassId that belong to previous list.
Regards.
/Q
Jun 23, 2015 9:37
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Hi,
What is the best way to get all the strongly typed sku's from a given catalog? I cant use the index.