Logo
การ Query ข้อมูลปลั๊กอิน
การ Query ข้อมูลปลั๊กอินWooCommerce

WooCommerce

ตัวอย่าง queries สำหรับดึงข้อมูลจากปลั๊กอิน WooCommerce

สินค้า (ทั้งหมด)

query นี้ดึงสินค้าทั้งหมดพร้อมข้อมูลพื้นฐาน:

query FetchAllProducts {
  woocommerceProducts {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    ...on WooCommercePriceableProductOrProductVariation {
      price
      priceFormatted
      regularPrice
      regularPriceFormatted
      salePrice
      salePriceFormatted
      onSale
    }
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
  }
  woocommerceProductsCount
}

query นี้ดึงสินค้าเดียวด้วย ID:

query FetchProduct($productId: ID!) {
  woocommerceProduct(by: { id: $productId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    ...on WooCommercePriceableProductOrProductVariation {
      price
      priceFormatted
      regularPrice
      regularPriceFormatted
      salePrice
      salePriceFormatted
      onSale
    }
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    galleryImages {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    attributes {
      name
      options
      position
      isVisible
      isVariation
    }
  }
}

query นี้ดึงสินค้าด้วย slug:

query FetchProductBySlug($slug: String!) {
  productBySlug: woocommerceProduct(by: { slug: $slug }) {
    __typename
    id
    name
    slug
    url
    sku
  }
}

query นี้ดึงสินค้าด้วย SKU:

query FetchProductBySku($sku: String!) {
  productBySku: woocommerceProduct(by: { sku: $sku }) {
    __typename
    id
    name
    slug
    url
    sku
  }
}

หมวดหมู่ แท็ก และแบรนด์ของสินค้า

query นี้ดึงหมวดหมู่สินค้าทั้งหมด:

query FetchProductCategories {
  woocommerceProductCategories {
    __typename
    id
    url
    urlPath
    slug
    name
    description
    count
    slugPath
    parentID
    parent {
      id
      name
      slug
    }
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    displayType
    menuOrder
    ancestors {
      id
      name
      slug
    }
    children {
      id
      name
      slug
      parent {
        id
        name
        slug
      }
    }
    childrenCount
    descendants {
      id
      name
      slug
      ancestors {
        id
        name
        slug
      }
    }
    descendantsCount
  }
  woocommerceProductCategoriesCount
}

query นี้ดึงหมวดหมู่สินค้าเดียวด้วย ID:

query FetchProductCategory($categoryId: ID!) {
  woocommerceProductCategory(by: { id: $categoryId }) {
    __typename
    id
    url
    urlPath
    slug
    name
    description
    count
    slugPath
    parentID
    parent {
      id
      name
      slug
    }
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    displayType
    menuOrder
    ancestors {
      id
      name
      slug
    }
    children {
      id
      name
      slug
      parent {
        id
        name
        slug
      }
    }
    childrenCount
    descendants {
      id
      name
      slug
      ancestors {
        id
        name
        slug
      }
    }
    descendantsCount
  }
}

query นี้ดึงแท็กสินค้าทั้งหมด:

query FetchProductTags {
  woocommerceProductTags {
    __typename
    id
    name
    slug
    url
    urlPath
    description
    count
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    menuOrder
  }
  woocommerceProductTagsCount
}

query นี้ดึงแท็กสินค้าเดียวด้วย ID:

query FetchProductTag($tagId: ID!) {
  woocommerceProductTag(by: { id: $tagId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    description
    count
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    menuOrder
  }
}

query นี้ดึงแบรนด์สินค้าทั้งหมด:

query FetchProductBrands {
  woocommerceProductBrands {
    __typename
    id
    url
    urlPath
    slug
    slugPath
    name
    description
    count
    parentID
    parent {
      id
      name
      slug
    }
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    menuOrder
    ancestors {
      id
      name
      slug
    }
    children {
      id
      name
      slug
      parent {
        id
        name
        slug
      }
    }
    childrenCount
    descendants {
      id
      name
      slug
      ancestors {
        id
        name
        slug
      }
    }
    descendantsCount
  }
  woocommerceProductBrandsCount
}

query นี้ดึงแบรนด์สินค้าเดียวด้วย ID:

query FetchProductBrand($brandId: ID!) {
  woocommerceProductBrand(by: { id: $brandId }) {
    __typename
    id
    url
    urlPath
    slug
    slugPath
    name
    description
    count
    parentID
    parent {
      id
      name
      slug
    }
    thumbnail {
      id
      src
      altText
      title
      caption
    }
    menuOrder
    ancestors {
      id
      name
      slug
    }
    children {
      id
      name
      slug
      parent {
        id
        name
        slug
      }
    }
    childrenCount
    descendants {
      id
      name
      slug
      ancestors {
        id
        name
        slug
      }
    }
    descendantsCount
  }
}

แอตทริบิวต์และ Taxonomy ของแอตทริบิวต์

query นี้ดึง taxonomy ของแอตทริบิวต์ทั้งหมด:

query FetchAttributeTaxonomies {
  woocommerceAttributeTaxonomies {
    __typename
    id
    name
    slug
    type
    orderBy
    taxonomy
    hasArchives
    public
  }
}

query นี้ดึง taxonomy ของแอตทริบิวต์เดียวด้วย ID:

query FetchAttributeTaxonomy($taxonomyId: ID!) {
  woocommerceAttributeTaxonomy(by: { id: $taxonomyId }) {
    __typename
    id
    name
    slug
    type
    orderBy
    taxonomy
    hasArchives
    public
  }
}

query นี้ดึง taxonomy ของแอตทริบิวต์ด้วยชื่อ:

query FetchAttributeTaxonomyByName($taxonomyName: String!) {
  attributeTaxonomyByName: woocommerceAttributeTaxonomy(by: { taxonomyName: $taxonomyName }) {
    __typename
    id
    name
    slug
    type
    orderBy
    taxonomy
    hasArchives
    public
  }
}

query นี้ดึงแอตทริบิวต์สินค้าทั้งหมด:

query FetchProductAttributes {
  woocommerceAttributes {
    __typename
    id
    url
    urlPath
    slug
    name
    description
    count
    menuOrder
    termGroup
    termTaxonomyID
    taxonomy
    taxonomyObject {
      id
      name
      slug
      type
      orderBy
      taxonomy
      hasArchives
      public
    }
  }
  woocommerceAttributesCount
}

query นี้ดึงแอตทริบิวต์สินค้าเดียวด้วย ID:

query FetchProductAttribute($attributeId: ID!) {
  woocommerceAttribute(by: { id: $attributeId }) {
    __typename
    id
    url
    urlPath
    slug
    name
    description
    count
    menuOrder
    termGroup
    termTaxonomyID
    taxonomy
    taxonomyObject {
      id
      name
      slug
      type
      orderBy
      taxonomy
      hasArchives
      public
    }
  }
}

query นี้ดึงแอตทริบิวต์สินค้าด้วย slug และ taxonomy:

query FetchProductAttributeBySlug($slug: String!, $taxonomy: String!) {
  attributeBySlug: woocommerceAttribute(by: { slug: $slug }, taxonomy: $taxonomy) {
    __typename
    id
    url
    urlPath
    slug
    name
    description
    count
    menuOrder
    termGroup
    termTaxonomyID
    taxonomy
    taxonomyObject {
      id
      name
      slug
      type
      orderBy
      taxonomy
      hasArchives
      public
    }
  }
}

สินค้าแยกตามประเภท

สินค้าแบบเดี่ยว (Simple Products)

query นี้ดึงสินค้าแบบเดี่ยวทั้งหมด:

query FetchSimpleProducts {
  woocommerceSimpleProducts {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Stock management fields
    manageStock
    stockQuantity
    stockStatus
    backorders
    backordersAllowed
    backordered
    soldIndividually
    lowStockThreshold
    # Shipping fields
    isVirtual
    weight
    length
    width
    height
    dimensions
    shippingClassID
    shippingClass {
      id
      name
      slug
      description
      count
    }
    # Downloadable fields
    isDownloadable
    downloadLimit
    downloadExpiry
    downloads
    downloadsCount
    # Tax fields
    taxStatus
    taxClass
    # Cross-sell fields
    crossSellIDs
    crossSells {
      id
      name
      slug
      sku
    }
  }
  woocommerceSimpleProductsCount
}

query นี้ดึงสินค้าแบบเดี่ยวเดียวด้วย ID:

query FetchSimpleProduct($productId: ID!) {
  woocommerceSimpleProduct(by: { id: $productId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    galleryImages {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Stock management fields
    manageStock
    stockQuantity
    stockStatus
    backorders
    backordersAllowed
    backordered
    soldIndividually
    lowStockThreshold
    # Shipping fields
    isVirtual
    weight
    length
    width
    height
    dimensions
    shippingClassID
    shippingClass {
      id
      name
      slug
      description
      count
    }
    # Downloadable fields
    isDownloadable
    downloadLimit
    downloadExpiry
    downloads
    downloadsCount
    # Tax fields
    taxStatus
    taxClass
    # Cross-sell fields
    crossSellIDs
    crossSells {
      id
      name
      slug
      sku
    }
  }
}

สินค้าภายนอก (External Products)

query นี้ดึงสินค้าภายนอกทั้งหมด:

query FetchExternalProducts {
  woocommerceExternalProducts {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # External product specific fields
    externalURL
    buttonText
    # Tax fields
    taxStatus
    taxClass
  }
  woocommerceExternalProductsCount
}

query นี้ดึงสินค้าภายนอกเดียวด้วย ID:

query FetchExternalProduct($productId: ID!) {
  woocommerceExternalProduct(by: { id: $productId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    galleryImages {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # External product specific fields
    externalURL
    buttonText
    # Tax fields
    taxStatus
    taxClass
  }
}

สินค้าแบบกลุ่ม (Group Products)

query นี้ดึงสินค้าแบบกลุ่มทั้งหมด:

query FetchGroupProducts {
  woocommerceGroupProducts {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Group product specific fields
    hasChildren
    childrenCount
    minPrice
    maxPrice
    minPriceFormatted
    maxPriceFormatted
    children {
      id
      name
      slug
      sku
    }
  }
  woocommerceGroupProductsCount
}

query นี้ดึงสินค้าแบบกลุ่มเดียวด้วย ID:

query FetchGroupProduct($productId: ID!) {
  woocommerceGroupProduct(by: { id: $productId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    galleryImages {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Group product specific fields
    hasChildren
    childrenCount
    minPrice
    maxPrice
    minPriceFormatted
    maxPriceFormatted
    children {
      id
      name
      slug
      sku
    }
  }
}

สินค้าแบบมีตัวเลือก (Variable Products)

query นี้ดึงสินค้าแบบมีตัวเลือกทั้งหมด:

query FetchVariableProducts {
  woocommerceVariableProducts {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Variable product specific fields
    hasVariations
    variationsCount
    minPrice
    maxPrice
    minRegularPrice
    maxRegularPrice
    minSalePrice
    maxSalePrice
    priceRange
    variations {
      id
      name
      slug
      sku
    }
    defaultAttributes {
      taxonomy
      termSlug
      termObject {
        id
        name
        slug
      }
    }
    # Cross-sell fields
    crossSellIDs
    crossSells {
      id
      name
      slug
      sku
    }
    # Tax fields
    taxStatus
    taxClass
  }
  woocommerceVariableProductsCount
}

query นี้ดึงสินค้าแบบมีตัวเลือกเดียวด้วย ID:

query FetchVariableProduct($productId: ID!) {
  woocommerceVariableProduct(by: { id: $productId }) {
    __typename
    id
    name
    slug
    url
    urlPath
    sku
    description
    shortDescription
    status
    type
    featured
    totalSales
    averageRating
    ratingCount
    image {
      id
      src
      altText
      title
      caption
    }
    galleryImages {
      id
      src
      altText
      title
      caption
    }
    categories {
      id
      name
      slug
    }
    tags {
      id
      name
      slug
    }
    brands {
      id
      name
      slug
    }
    # Variable product specific fields
    hasVariations
    variationsCount
    minPrice
    maxPrice
    minRegularPrice
    maxRegularPrice
    minSalePrice
    maxSalePrice
    priceRange
    variations {
      id
      name
      slug
      sku
    }
    defaultAttributes {
      taxonomy
      termSlug
      termObject {
        id
        name
        slug
      }
    }
    # Cross-sell fields
    crossSellIDs
    crossSells {
      id
      name
      slug
      sku
    }
    # Tax fields
    taxStatus
    taxClass
  }
}

ตัวเลือกของสินค้า (Product Variations)

query นี้ดึงตัวเลือกของสินค้าทั้งหมด:

query FetchProductVariations {
  woocommerceProductVariations {
    __typename
    id
    name
    slug
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    image {
      id
      src
      altText
      title
      caption
    }
    # Product variation specific fields
    parentID
    parent {
      id
      name
      slug
      sku
    }
    taxClass
    attributes {
      taxonomy
      termSlug
      termObject {
        id
        name
        slug
      }
    }
    # Stock management fields
    manageStock
    stockQuantity
    stockStatus
    backorders
    backordersAllowed
    backordered
    soldIndividually
    lowStockThreshold
    # Shipping fields
    isVirtual
    weight
    length
    width
    height
    dimensions
    shippingClassID
    shippingClass {
      id
      name
      slug
      description
      count
    }
    # Downloadable fields
    isDownloadable
    downloadLimit
    downloadExpiry
    downloads
    downloadsCount
  }
  woocommerceProductVariationsCount
}

query นี้ดึงตัวเลือกของสินค้าเดียวด้วย ID:

query FetchProductVariation($variationId: ID!) {
  woocommerceProductVariation(by: { id: $variationId }) {
    __typename
    id
    name
    slug
    sku
    description
    shortDescription
    price
    priceFormatted
    regularPrice
    regularPriceFormatted
    salePrice
    salePriceFormatted
    onSale
    status
    image {
      id
      src
      altText
      title
      caption
    }
    # Product variation specific fields
    parentID
    parent {
      id
      name
      slug
      sku
    }
    taxClass
    attributes {
      taxonomy
      termSlug
      termObject {
        id
        name
        slug
      }
    }
    # Stock management fields
    manageStock
    stockQuantity
    stockStatus
    backorders
    backordersAllowed
    backordered
    soldIndividually
    lowStockThreshold
    # Shipping fields
    isVirtual
    weight
    length
    width
    height
    dimensions
    shippingClassID
    shippingClass {
      id
      name
      slug
      description
      count
    }
    # Downloadable fields
    isDownloadable
    downloadLimit
    downloadExpiry
    downloads
    downloadsCount
  }
}

ลูกค้า

query นี้ดึงลูกค้าทั้งหมด:

query FetchCustomers {
  woocommerceCustomers {
    __typename
    id
    username
    email
    firstName
    lastName
    displayName
    description
    createdDate
    createdDateStr
    formattedCreatedDateStr: createdDateStr(format: "d/m/Y H:i:s")
    modifiedDate
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    role
    billing
    shipping
    isPayingCustomer
    avatarURL
    totalSpent
    totalSpentFormatted
    orderCount
    lastOrderID
    lastOrder {
      id
      orderNumber
      status
      total
      date
    }
    orders {
      id
      orderNumber
      status
      total
      date
    }
    ordersCount
  }
  woocommerceCustomersCount
}

query นี้ดึงลูกค้าเดียวด้วย ID:

query FetchCustomer($customerId: ID!) {
  woocommerceCustomer(by: { id: $customerId }) {
    __typename
    id
    username
    email
    firstName
    lastName
    displayName
    description
    createdDate
    createdDateStr
    formattedCreatedDateStr: createdDateStr(format: "d/m/Y H:i:s")
    modifiedDate
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    role
    billing
    shipping
    isPayingCustomer
    avatarURL
    totalSpent
    totalSpentFormatted
    orderCount
    lastOrderID
    lastOrder {
      id
      orderNumber
      status
      total
      date
    }
    orders {
      id
      orderNumber
      status
      total
      date
    }
    ordersCount
  }
}

คำสั่งซื้อ

query นี้ดึงคำสั่งซื้อทั้งหมด:

query FetchOrders {
  woocommerceOrders {
    __typename
    id
    orderNumber
    orderKey
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedStr: modifiedDateStr(format: "d/m/Y H:i:s")
    status
    isPaid
    currency
    total
    totalFormatted
    subtotal
    subtotalFormatted
    totalTax
    totalTaxFormatted
    totalShipping
    totalShippingFormatted
    totalDiscount
    totalDiscountFormatted
    totalDiscountTax
    totalDiscountTaxFormatted
    shippingTotal
    shippingTotalFormatted
    shippingTax
    shippingTaxFormatted
    cartTax
    cartTaxFormatted
    totalFee
    totalFeeFormatted
    customerID
    customer {
      id
      username
      email
      firstName
      lastName
      displayName
    }
    customerNote
    billingAddress
    shippingAddress
    hasCompletedStatus: hasStatus(status: "completed")
    hasPendingStatus: hasStatus(status: "pending")
    hasProcessingStatus: hasStatus(status: "processing")
    hasOnHoldStatus: hasStatus(status: "on-hold")
    hasCancelledStatus: hasStatus(status: "cancelled")
    hasRefundedStatus: hasStatus(status: "refunded")
    hasFailedStatus: hasStatus(status: "failed")
    hasAnyCompletedOrProcessingStatus: hasAnyStatus(statuses: ["completed", "processing"])
    hasAnyPendingOrOnHoldStatus: hasAnyStatus(statuses: ["pending", "on-hold"])
    paymentMethod
    paymentMethodTitle
    transactionID
    datePaid
    datePaidStr
    formattedDatePaidStr: datePaidStr(format: "d/m/Y H:i:s")
    dateCompleted
    dateCompletedStr
    formattedDateCompletedStr: dateCompletedStr(format: "d/m/Y H:i:s")
    cartHash
    newOrderEmailSent
    orderCurrency
    orderVersion
    pricesIncludeTax
    discountTotal
    discountTax
    refunded
    remainingRefundAmount
    itemCount
    items {
      id
      name
      quantity
      subtotal
      subtotalFormatted
      total
      totalFormatted
      totalTax
      totalTaxFormatted
      productID
      variationID
      reducedStockNumber
      product {
        id
        name
        slug
        sku
      }
      variation {
        id
        name
        slug
        sku
      }
    }
    refunds {
      id
      amount
      amountFormatted
      reason
      status
    }
    downloadPermissionsGranted
    needsPayment
    needsProcessing
    isDownloadPermitted
    hasDownloadableItem
  }
  woocommerceOrdersCount
}

query นี้ดึงคำสั่งซื้อเดียวด้วย ID:

query FetchOrder($orderId: ID!) {
  woocommerceOrder(by: { id: $orderId }) {
    __typename
    id
    orderNumber
    orderKey
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedStr: modifiedDateStr(format: "d/m/Y H:i:s")
    status
    isPaid
    currency
    total
    totalFormatted
    subtotal
    subtotalFormatted
    totalTax
    totalTaxFormatted
    totalShipping
    totalShippingFormatted
    totalDiscount
    totalDiscountFormatted
    totalDiscountTax
    totalDiscountTaxFormatted
    shippingTotal
    shippingTotalFormatted
    shippingTax
    shippingTaxFormatted
    cartTax
    cartTaxFormatted
    totalFee
    totalFeeFormatted
    customerID
    customer {
      id
      username
      email
      firstName
      lastName
      displayName
    }
    customerNote
    billingAddress
    shippingAddress
    hasCompletedStatus: hasStatus(status: "completed")
    hasPendingStatus: hasStatus(status: "pending")
    hasProcessingStatus: hasStatus(status: "processing")
    hasOnHoldStatus: hasStatus(status: "on-hold")
    hasCancelledStatus: hasStatus(status: "cancelled")
    hasRefundedStatus: hasStatus(status: "refunded")
    hasFailedStatus: hasStatus(status: "failed")
    hasAnyCompletedOrProcessingStatus: hasAnyStatus(statuses: ["completed", "processing"])
    hasAnyPendingOrOnHoldStatus: hasAnyStatus(statuses: ["pending", "on-hold"])
    paymentMethod
    paymentMethodTitle
    transactionID
    datePaid
    datePaidStr
    formattedDatePaidStr: datePaidStr(format: "d/m/Y H:i:s")
    dateCompleted
    dateCompletedStr
    formattedDateCompletedStr: dateCompletedStr(format: "d/m/Y H:i:s")
    cartHash
    newOrderEmailSent
    orderCurrency
    orderVersion
    pricesIncludeTax
    discountTotal
    discountTax
    refunded
    remainingRefundAmount
    itemCount
    items {
      id
      name
      quantity
      subtotal
      subtotalFormatted
      total
      totalFormatted
      totalTax
      totalTaxFormatted
      productID
      variationID
      reducedStockNumber
      product {
        id
        name
        slug
        sku
      }
      variation {
        id
        name
        slug
        sku
      }
    }
    refunds {
      id
      amount
      amountFormatted
      reason
      status
    }
    downloadPermissionsGranted
    needsPayment
    needsProcessing
    isDownloadPermitted
    hasDownloadableItem
  }
}

query นี้ดึงคำสั่งซื้อด้วย order key:

query FetchOrderByKey($orderKey: String!) {
  orderByKey: woocommerceOrder(by: { orderKey: $orderKey }) {
    id
    orderKey
    orderNumber
    total
    totalFormatted
    status
    date
    customer {
      id
      username
      email
      firstName
      lastName
    }
  }
}

การคืนเงิน

query นี้ดึงการคืนเงินทั้งหมด:

query FetchRefunds {
  woocommerceRefunds {
    __typename
    id
    orderID
    order {
      id
      orderNumber
      status
    }
    amount
    amountFormatted
    reason
    refundedBy {
      id
      name
      email
    }
    isPaymentRefundedViaAPI
    refundType
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    status
  }
  woocommerceRefundsCount
}

query นี้ดึงการคืนเงินเดียวด้วย ID:

query FetchRefund($refundId: ID!) {
  woocommerceRefund(by: { id: $refundId }) {
    __typename
    id
    orderID
    order {
      id
      orderNumber
      status
    }
    amount
    amountFormatted
    reason
    refundedBy {
      id
      name
      email
    }
    isPaymentRefundedViaAPI
    refundType
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    status
  }
}

รีวิว

query นี้ดึงรีวิวสินค้าทั้งหมด:

query FetchProductReviews {
  woocommerceReviews {
    __typename
    id
    content
    author
    authorEmail
    rating
    verified
    approved
    date
    dateStr
    productID
    product {
      id
      name
    }
  }
  woocommerceReviewsCount
}

query นี้ดึงรีวิวสินค้าเดียวด้วย ID:

query FetchProductReview($reviewId: ID!) {
  woocommerceReview(by: { id: $reviewId }) {
    __typename
    id
    content
    author
    authorEmail
    rating
    verified
    approved
    date
    dateStr
    productID
    product {
      id
      name
    }
  }
}

คูปอง

query นี้ดึงคูปองทั้งหมด:

query FetchCoupons {
  woocommerceCoupons {
    __typename
    id
    code
    amount
    amountFormatted
    dateExpires
    dateExpiresStr
    formattedDateExpiresStr: dateExpiresStr(format: "d/m/Y H:i:s")
    discountType
    description
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    usageCount
    individualUse
    productIDs
    products {
      id
      name
      slug
    }
    productsCount
    excludedProductIDs
    excludedProducts {
      id
      name
      slug
    }
    excludedProductsCount
    usageLimit
    usageLimitPerUser
    limitUsageToXItems
    freeShipping
    productCategoryIDs
    productCategories {
      id
      name
      slug
    }
    productCategoriesCount
    excludedProductCategoryIDs
    excludedProductCategories {
      id
      name
      slug
    }
    excludedProductCategoriesCount
    productBrandIDs
    productBrands {
      id
      name
      slug
    }
    productBrandsCount
    excludedProductBrandIDs
    excludedProductBrands {
      id
      name
      slug
    }
    excludedProductBrandsCount
    excludeSaleItems
    minimumAmount
    minimumAmountFormatted
    maximumAmount
    maximumAmountFormatted
    emailRestrictions
    usedByCustomerIDs
    usedByCustomers {
      id
      username
      email
      firstName
      lastName
      displayName
    }
    usedByCustomersCount
  }
  woocommerceCouponsCount
}

query นี้ดึงคูปองด้วยรหัส:

query FetchCouponByCode($code: String!) {
  couponByCode: woocommerceCoupon(by: { code: $code }) {
    __typename
    id
    code
    amount
    amountFormatted
    dateExpires
    dateExpiresStr
    formattedDateExpiresStr: dateExpiresStr(format: "d/m/Y H:i:s")
    discountType
    description
    date
    modifiedDate
    dateStr
    formattedDateStr: dateStr(format: "d/m/Y H:i:s")
    modifiedDateStr
    formattedModifiedDateStr: modifiedDateStr(format: "d/m/Y H:i:s")
    usageCount
    individualUse
    productIDs
    products {
      id
      name
      slug
    }
    productsCount
    excludedProductIDs
    excludedProducts {
      id
      name
      slug
    }
    excludedProductsCount
    usageLimit
    usageLimitPerUser
    limitUsageToXItems
    freeShipping
    productCategoryIDs
    productCategories {
      id
      name
      slug
    }
    productCategoriesCount
    excludedProductCategoryIDs
    excludedProductCategories {
      id
      name
      slug
    }
    excludedProductCategoriesCount
    productBrandIDs
    productBrands {
      id
      name
      slug
    }
    productBrandsCount
    excludedProductBrandIDs
    excludedProductBrands {
      id
      name
      slug
    }
    excludedProductBrandsCount
    excludeSaleItems
    minimumAmount
    minimumAmountFormatted
    maximumAmount
    maximumAmountFormatted
    emailRestrictions
    usedByCustomerIDs
    usedByCustomers {
      id
      username
      email
      firstName
      lastName
      displayName
    }
    usedByCustomersCount
  }
}

query นี้ดึงคูปองด้วย ID:

query FetchCouponById($couponId: ID!) {
  couponByID: woocommerceCoupon(by: { id: $couponId }) {
    id
    code
    amount
    amountFormatted
    discountType
    description
    usageCount
    individualUse
    usageLimit
    usageLimitPerUser
    freeShipping
    excludeSaleItems
    minimumAmount
    minimumAmountFormatted
    maximumAmount
    maximumAmountFormatted
  }
}

คลาสการจัดส่ง

query นี้ดึงคลาสการจัดส่งทั้งหมด:

query FetchShippingClasses {
  woocommerceShippingClasses {
    __typename
    id
    name
    slug
    description
    count
  }
  woocommerceShippingClassesCount
}

query นี้ดึงคลาสการจัดส่งเดียวด้วย ID:

query FetchShippingClassById($shippingClassId: ID!) {
  woocommerceShippingClassByID: woocommerceShippingClass(by: { id: $shippingClassId }) {
    __typename
    id
    name
    slug
    description
    count
  }
}

query นี้ดึงคลาสการจัดส่งเดียวด้วย slug:

query FetchShippingClassBySlug($slug: String!) {
  woocommerceShippingClassBySlug: woocommerceShippingClass(by: { slug: $slug }) {
    __typename
    id
    name
    slug
    description
    count
  }
}

อัตราภาษี

query นี้ดึงอัตราภาษีทั้งหมด:

query FetchTaxRates {
  woocommerceTaxRates {
    __typename
    id
    country
    state
    postcode
    city
    rate
    name
    priority
    compound
    shipping
    order
    class
  }
}

query นี้ดึงอัตราภาษีเดียวด้วย ID:

query FetchTaxRate($taxRateId: ID!) {
  woocommerceTaxRate(by: { id: $taxRateId }) {
    __typename
    id
    country
    state
    postcode
    city
    rate
    name
    priority
    compound
    shipping
    order
    class
  }
}

ช่องทางการชำระเงิน

query นี้ดึงช่องทางการชำระเงินทั้งหมด:

query FetchPaymentGateways {
  woocommercePaymentGateways {
    __typename
    id
    title
    description
    enabled
    methodID
    methodTitle
    methodDescription
    icon
    isAvailable
    isActive
  }
}