# Shophouzz Product

## Overview

| Property | Value |
|----------|-------|
| **Status** | active |
| **Method** | `GET` |
| **Endpoint** | `/v2/shophouzz/product` |
| **Base URL** | `https://api.piloterr.com` |
| **Credit Cost** | 1 credit per call |
| **Documentation** | https://www.piloterr.com/library/shophouzz-product |

## Description

Retrieve full product details from Shophouzz, including title, price, variants, images, vendor, and structured metadata.

## Authentication

- **Key Name:** `x-api-key`
- **Location:** HTTP Header
- **Get an API key:** https://app.piloterr.com/register

## Example Request

```bash
curl --location --request GET 'https://api.piloterr.com/v2/shophouzz/product' \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: YOUR_API_KEY'
```

## Example Response

### Product lookup by URL (Burke Counter Stool)

```json
{
  "id": 9992209793336,
  "tags": "assembly_required, best-seller, black, black faux leather, black faux leather straps, comfortable, compliance:cal-prop-65, contemporary, elegant, furniture, matte black metal frame, modern, soft black faux leather, vendor-type:direct, white oak veneer metal dowel, YGroup_857-Parent",
  "image": {
    "id": 51424882983224,
    "alt": null,
    "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/d428cade-7856-43a2-b0ab-ad6d1fa4c68d.jpg?v=1770873702",
    "width": 478,
    "height": 990,
    "position": 1,
    "created_at": "2025-06-27T23:07:28-07:00",
    "product_id": 9992209793336,
    "updated_at": "2026-02-11T21:21:42-08:00",
    "variant_ids": []
  },
  "title": "Burke Counter Stool, Cognac, Vegan Leather, White Oak Veneer Metal Dowel",
  "handle": "burke-counter-stool-cognac-vegan-leather-white-oak-veneer-metal-dowel-prvw-vr-186041078",
  "images": [
    {
      "id": 51424882983224,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/d428cade-7856-43a2-b0ab-ad6d1fa4c68d.jpg?v=1770873702",
      "width": 478,
      "height": 990,
      "position": 1,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    },
    {
      "id": 51424882852152,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/9f98d8da-988d-4d34-b3ff-90ddc25486cf.jpg?v=1770873702",
      "width": 990,
      "height": 990,
      "position": 2,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    },
    {
      "id": 51424883114296,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/31ba4089-8a92-40b2-8b04-c7a3f02c4849.jpg?v=1770873702",
      "width": 624,
      "height": 990,
      "position": 3,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    },
    {
      "id": 51424882950456,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/673c4606-170e-4568-bd23-7d9e4a56a5b5.jpg?v=1770873702",
      "width": 690,
      "height": 990,
      "position": 4,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    },
    {
      "id": 51424883048760,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/f3267b6e-3bd2-4fe3-aed7-0fae3e1f183c.jpg?v=1770873702",
      "width": 990,
      "height": 660,
      "position": 5,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    },
    {
      "id": 51424882884920,
      "alt": null,
      "src": "https://cdn.shopify.com/s/files/1/0941/8535/7624/files/e01a9298-c313-44e9-b47c-94009ee0fbde.jpg?v=1770873702",
      "width": 990,
      "height": 738,
      "position": 6,
      "created_at": "2025-06-27T23:07:28-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-02-11T21:21:42-08:00",
      "variant_ids": []
    }
  ],
  "vendor": "Meridian Furniture",
  "options": [
    {
      "id": 12575493423416,
      "name": "Color",
      "values": [
        "Cognac"
      ],
      "position": 1,
      "product_id": 9992209793336
    },
    {
      "id": 12575493456184,
      "name": "Configuration",
      "values": [
        "White Oak Veneer Metal Dowel"
      ],
      "position": 2,
      "product_id": 9992209793336
    },
    {
      "id": 12575493488952,
      "name": "Design",
      "values": [
        "Vegan Leather"
      ],
      "position": 3,
      "product_id": 9992209793336
    }
  ],
  "variants": [
    {
      "id": 50554338476344,
      "sku": "857Cognac-C",
      "grams": 14061,
      "price": "237.99",
      "title": "Cognac / White Oak Veneer Metal Dowel / Vegan Leather",
      "weight": 31,
      "barcode": "94308268583",
      "option1": "Cognac",
      "option2": "White Oak Veneer Metal Dowel",
      "option3": "Vegan Leather",
      "taxable": true,
      "image_id": null,
      "position": 1,
      "created_at": "2025-06-27T23:07:26-07:00",
      "product_id": 9992209793336,
      "updated_at": "2026-04-27T08:03:33-07:00",
      "weight_unit": "lb",
      "quantity_rule": {
        "max": null,
        "min": 1,
        "increment": 1
      },
      "price_currency": "USD",
      "compare_at_price": "",
      "requires_shipping": true,
      "fulfillment_service": "manual",
      "inventory_management": "shopify",
      "quantity_price_breaks": [],
      "compare_at_price_currency": ""
    }
  ],
  "body_html": "<p>Kick back and relax with a drink in your hand with this Burke cognac vegan leather counter stool. Featuring soft cognac vegan leather upholstery and cognac vegan leather straps, this counter stool is cozy and stylish. Its matte cognac metal frame provides sturdy support so you can enjoy this stool for years to come. A white oak veneer metal dowel is tucked firmly in place beneath the front of the stool, providing extra support and added style.</p>\n\n<p>Overall Product Dimensions: 18\" W x 24\" D x 37.5\" H\n<br>Soft Cognac Vegan Leather\n<br>Black Vegan Leather Straps\n<br>Matte Black Metal Frame\n<br>White Oak Veneer Metal Dowel\n<br>Counter Height Stool\n<br>Contemporary Design</p>\n\n<p>Seat Dimensions: \n<br>Seat Width: 18\"\n<br>Seat Height: 26.4\"\n<br>Seat Depth: 16\"\n<br>Back Height: 11.25\"</p>",
  "created_at": "2025-06-27T23:07:26-07:00",
  "updated_at": "2026-04-27T08:03:33-07:00",
  "product_type": "Product",
  "published_at": "2025-06-27T23:07:27-07:00",
  "published_scope": "web",
  "template_suffix": null
}
```

## Documentation

## Overview
Retrieve complete product data from a Shophouzz product page URL. Returns structured information including title, vendor, pricing, product variants, all images, options (color, size, configuration), inventory management details, and the full HTML product description.

## Quickstart
```
GET https://api.piloterr.com/v2/shophouzz/product?query=https://shophouzz.com/products/burke-counter-stool-cognac-vegan-leather-white-oak-veneer-metal-dowel-prvw-vr-186041078
```

## Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| `query` | string | yes | Full URL of the Shophouzz product page |

## Response fields
| Field | Type | Description |
|---|---|---|
| `id` | number | Unique product identifier |
| `title` | string | Full product title |
| `handle` | string | URL-friendly product handle (slug) |
| `vendor` | string | Brand or vendor name |
| `tags` | string | Comma-separated list of product tags |
| `product_type` | string | Product category type |
| `body_html` | string | Full HTML product description with dimensions and specs |
| `image` | object | Primary product image with id, src, width, height, and position |
| `images` | array | All product images with full metadata |
| `options` | array | Product options such as color, configuration, and design |
| `variants` | array | All product variants with price, SKU, barcode, weight, and inventory details |
| `created_at` | string | Product creation timestamp (ISO 8601) |
| `updated_at` | string | Last update timestamp (ISO 8601) |
| `published_at` | string | Publication date (ISO 8601) |
| `published_scope` | string | Publication scope (e.g. `web`) |
| `template_suffix` | string | Shopify template suffix, if any |

## Notes
- The `query` parameter must be a full Shophouzz product page URL starting with `https://shophouzz.com/products/`.
- Variants contain complete pricing, weight, barcode, and inventory management data.
- Images include width and height metadata for all available product photos.

## Main use cases
- Monitor competitor furniture pricing by scraping Shophouzz product data at scale
- Enrich product catalogs with structured metadata, images, and variants from Shophouzz
- Track inventory and stock changes across Shophouzz product variants over time
- Build price comparison tools for home furniture using live Shophouzz data
- Automate product data collection for e-commerce sourcing or interior design platforms