Ghost variant products (?)

[rainers24]

Hi all,

as we are massively using variant products and I exported the instance to copy it to another instance, I saw that there are products which cannot be seen from the UI ?

Is there an endpoint where I could see what is under ProductVariantProductAttributeOption / ProductProductAttributeOption / ProductProductAttribute ?

Because in the .json files there are ton of product_ids which doesn't exist in the system itself.




Thanks in advance,
Rainers

[yuri]

Hi Rainers,

Maybe consider using export-import extension for this purpose? There where a few topics on this extension on the forum.

Product variants can be listed by adding the query parameter: /Product?primaryFilter=allVariants. There was a topic on the forum recently, but I could not find.

[rainers24]

Hey Yuri, yes I'm using the extension here, but the main question is how I can safely delete these "relationships" or what is under there from UI or from API ?

So that the next time I would do the export size of these files is down ? Because now it seems like I have got 0 products and close to 300k ProductVariantProductAttributeOptions.