Catalog module links

import { ContainerRegistrationKeys } from "@medusajs/framework/utils"

const query = container.resolve(ContainerRegistrationKeys.QUERY)

​

Product and Seller

• Sides: Product (many) and Seller (many)
• Storage: pivot table product_seller with product_id and seller_id
• Alias on product: sellers
• File: product-seller-link.ts

const { data } = await query.graph({
  entity: "product",
  fields: ["id", "sellers.id", "sellers.name"],
  filters: { id: "prod_01JD8Q1234567" },
})

​

ProductCategory and Seller

• Sides: ProductCategory (many) and Seller (many)
• Storage: pivot table generated by Medusa
• Alias on category: sellers
• File: category-seller-link.ts

const { data } = await query.graph({
  entity: "product_category",
  fields: ["id", "sellers.id"],
  filters: { id: "pcat_01JD8Q1234567" },
})

​

Offer and Product

• Sides: Offer (one) to Product (one)
• Storage: read-only, through offer.product_id
• Alias on offer: product
• File: offer-product-link.ts

const { data } = await query.graph({
  entity: "offer",
  fields: ["id", "product.id", "product.title"],
  filters: { product_id: "prod_01JD8Q1234567" },
})

​

Offer and ProductVariant

• Sides: Offer (one) to ProductVariant (one)
• Storage: read-only, through offer.variant_id
• Alias on offer: product_variant
• File: offer-variant-link.ts

const { data } = await query.graph({
  entity: "offer",
  fields: ["id", "product_variant.title", "product_variant.sku"],
  filters: { variant_id: "variant_01JD8Q1234567" },
})

​

Product and ProductChange

• Sides: Product (one) to ProductChange (many)
• Storage: read-only, through product_change.product_id
• Alias on product: changes
• File: product-change-link.ts

const { data } = await query.graph({
  entity: "product",
  fields: ["id", "changes.status", "changes.created_by"],
  filters: { id: "prod_01JD8Q1234567" },
})

​

Product and ProductAttributeValue

• Sides: Product (many) and ProductAttributeValue (many)
• Storage: pivot table product_attribute_value_link
• Alias on product: product_attribute_values
• File: product-attribute-value-pivot-link.ts

const { data } = await query.graph({
  entity: "product",
  fields: [
    "product_attribute_values.name",
    "product_attribute_values.attribute.handle",
  ],
  filters: { id: "prod_01JD8Q1234567" },
})

​

Product and scoped ProductAttribute

• Sides: Product (one) to ProductAttribute (many)
• Storage: read-only, through product_attribute.product_id
• Alias on product: scoped_attributes
• File: product-attribute-product-link.ts

const { data } = await query.graph({
  entity: "product",
  fields: ["scoped_attributes.name", "scoped_attributes.values.name"],
  filters: { id: "prod_01JD8Q1234567" },
})

​

ProductAttribute and ProductCategory

• Sides: ProductAttribute (many) and ProductCategory (many)
• Storage: pivot table product_category_attribute
• Alias on attribute: categories
• File: product-attribute-category-link.ts

const { data } = await query.graph({
  entity: "product_attribute",
  fields: ["id", "categories.id", "categories.name"],
})

​

Attribute option mirrors

• ProductAttribute to ProductOption: through product_attribute.product_option_id, in product-attribute-option-mirror-link.ts
• ProductAttributeValue to ProductOptionValue: through product_attribute_value.product_option_value_id, in product-attribute-value-option-value-mirror-link.ts

const { data } = await query.graph({
  entity: "product_attribute",
  fields: ["id", "product_option_id", "values.product_option_value_id"],
  filters: { is_variant_axis: true },
})

​

Product and Review

• Sides: Product (one) to Review (many)
• Storage: pivot table generated by Medusa
• Alias on product: reviews
• File: product-review.ts

const { data } = await query.graph({
  entity: "product",
  fields: ["id", "reviews.id"],
  filters: { id: "prod_01JD8Q1234567" },
})

​

ProductCategory and ProductCollection images

• Sides: ProductCategory (one) to MediaImage (many), and ProductCollection (one) to MediaImage (many)
• Alias: media_images on both
• Files: media-product-category-link.ts and media-product-collection-link.ts

const { data } = await query.graph({
  entity: "product_category",
  fields: ["id", "media_images.url", "media_images.is_thumbnail"],
})