Shophouzz Product
Retrieve full product details from Shophouzz, including title, price, variants, images, vendor, and structured metadata.
Credit cost: 1 credit per call
Authorization
ApiKeyAuth x-api-key<token>
Your API key. Include it in the x-api-key header for every request.
In: header
Query Parameters
query*string
Full URL of the Shophouzz product page to retrieve details for.
Example:
https://shophouzz.com/products/burke-counter-stool-cognac-vegan-leather-white-oak-veneer-metal-dowel-prvw-vr-186041078Notes:
- Full product URL required: The query must be the complete product page URL, including the product handle.
- Handle-only format not supported: Only full URLs starting with
https://shophouzz.com/products/are accepted.
Response Body
application/json
application/json
application/json
application/json
application/json
application/json
curl -X GET "https://api.piloterr.com/v2/shophouzz/product?query=string"{
"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
}{
"error": "Bad Request"
}{
"error": "Invalid API Key"
}{
"error": "Payment required"
}{
"error": "Rate limit exceeded for the API key: quota monthly"
}{
"error": "Internal Error"
}