Ghost variant products (?)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rainers24
    Junior Member
    • Mar 2025
    • 6

    #1

    Ghost variant products (?)

    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.


    Click image for larger version

Name:	image.png
Views:	11
Size:	5.8 KB
ID:	121066

    Thanks in advance,
    Rainers​
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9329

    #2
    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.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment


    • rainers24
      rainers24 commented
      Editing a comment
      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.
Working...