Macys.com Dataset — 1.93M records for Price & Product Research
The Macys.com dataset is a clean, structured, analysis-ready database of 1.93M records across 92 data fields, sourced from macys.com and refreshed monthly. Every record is standardised for enrichment, lead generation, market research and competitor analysis — ready to import into your CRM or data pipeline.
What's included
Key fields: url, star rating distribution, quantity sold, views, is promo, seller id, store id, other price options, sales rank history, sku, and 82 more. See the full data dictionary below.
Pricing
This is a pay-per-record dataset with a minimum order of 70,000 records. See the order panel for live pricing in your currency (₹ for India, $ elsewhere) — the total scales with the number of records you choose, so the more you buy, the larger the order.
Common use cases
Enrich your existing e-commerce records with fresh, verified data.
Build targeted outreach and lead-generation campaigns.
Run market, pricing and competitor research at scale.
Feed AI/ML models with structured, deduplicated training data.
url
views
is promo
store id
db source
seller id
https://www.macys.com/shop/product/gemst...
1769471230564
https://www.macys.com/shop/product/journ...
true
1769471230564
https://www.macys.com/shop/product/parle...
1769471230564
https://www.macys.com/shop/product/astr-...
1769471230564
https://www.macys.com/shop/product/karl-...
1769471230564
https://www.macys.com/shop/product/polo-...
1769471230564
https://www.macys.com/shop/product/dkny-...
1769471230564
https://www.macys.com/shop/product/chart...
1769471230564
https://www.macys.com/shop/product/lands...
1769471230564
https://www.macys.com/shop/product/mango...
1769471230564
Sample@if($records) of 1.93M records@endif — 92 fields total. Purchase to unlock the full dataset.
Column
Description
Type
Fill rate
url
Complete product URL link from the website for direct access to the product page
Url
100%
star_rating_distribution
star_rating_distribution
Object
100%
quantity_sold
quantity_sold
Array
0%
views
views
Array
0%
is_promo
is_promo
Boolean
45.51%
seller_id
seller_id
Text
0%
store_id
store_id
Text
0%
other_price_options
other_price_options
Array
0%
sales_rank_history
sales_rank_history
Array
0%
sku
A Unique identifier derived from the url, used in future to be inputted in a template of the url to be able to be used in automation
Text
100%
rootdomain
Extract the domain from the URL (e.g., from https://www.amazon.com/product extract 'amazon.com') no http(s) or www
Text
100%
name
Name of the product as shown on the website
Text
100%
brand
Brand full name as displayed on the website (e.g., 'Nike', 'Adidas', 'Zara')
Text
100%
currency
Currency code as scraped from the website (e.g., 'USD', 'EUR', 'GBP')
Text
100%
price
The current sale price displayed on the website, including any active discounts
Number
100%
uvp
Extract recommended retail price from German sites (look for 'UVP' label). Parse numeric value
Number
0%
image_urls
Collect all image URLs from product gallery in display order. Return as JSON array of URL strings
Array
100%
store_name
Find store or brand storefront name in seller section or page header
Text
0%
shipping_options
Extract all shipping methods with cost and delivery dates. Return as JSON array with objects containing cost, time, and method
Array
0.52%
skus_coupons
skus_coupons
Object
100%
protection_price
protection_price
Number
0%
is_price_range
is_price_range
Boolean
0%
category
The full category tree separated by '>' sign without spaces between for example: "Home & Kitchen>Dining>Dinnerware>Dinnerware Sets"
Text
100%
date
date
Text
100%
time
time
Text
100%
source
source
Text
100%
upc
Find UPC barcode number in product details or specifications section. Usually 12 digits
Text
99.83%
ean
Find EAN barcode in product specifications. Usually 13 digits, common in European markets
Text
0%
mpn
Extract Manufacturer Part Number from product details or technical specifications section
Text
0%
item_number
Find item number or model number in product specifications. May be labeled as 'Item #' or 'Model'
Text
98.85%
store_sku
Extract store's internal SKU if different from main SKU. Look in product details or metadata
Text
0%
availability
Current stock status as an integer (0=Unknown, 1=In Stock, 2=Out of Stock)
Number
100%
average_customer_review
Extract average star rating from reviews section. Usually displayed as X.X out of 5 stars
Number
61.62%
number_of_customer_reviews
Find total review count near rating stars. May show as '1,234 reviews' or 'See all reviews'
Number
61.5%
number_of_customer_ratings
Extract total ratings count if shown separately from reviews. Sometimes identical to review count
Number
61.62%
best_seller_rank_top_level_category
best_seller_rank_top_level_category
Number
0%
best_seller_rank_product_category
best_seller_rank_product_category
Number
0%
department
department
Text
0%
attributes
json: All additional information from the website including materials composition, fit type, care instructions, breadcrumb navigation, sizing information, and technical specifications in a valid json format
Array
0%
description
Full product description as provided on the website, including key features and selling points
Text
100%
features
Extract bullet points or feature list from product details section. Return as JSON array of strings
Text
99.95%
variants
variants
Array
87.5%
parent_sku
parent_sku
Text
0%
redirected_sku
redirected_sku
Text
0%
package_height
package_height
Number
0%
item_width
item_width
Number
0%
item_height
item_height
Number
0%
frequently_bought_together
frequently_bought_together
Array
0%
is_sponsored
is_sponsored
Boolean
0%
model
model
Text
0%
variant_attributes
Extract selected variant options (color, size, style) from product selectors. Return as JSON object
Array
87.54%
variants_attributes
variants_attributes
Array
87.5%
is_official_seller
Check if seller has 'Official', 'Authorized', or brand verification badge. Return 1 if yes, 0 if no
Number
0%
number_of_favorites
Find wishlist or favorite count if displayed (e.g., '1.2K favorites'). Parse to number
Number
0%
manufacturers_id
manufacturers_id
Array
0%
ships_from
ships_from
Text
0%
promo_text
Extract any additional promotional banners or special offer text displayed on the page
Text
34.81%
seller_stats
seller_stats
Array
0%
sku_offer_info
sku_offer_info
Array
0%
list_price
Original price before any discounts
Number
99.95%
price_by_unit
Extract unit price text displayed near main price (e.g., '$2.00 per ounce', '$14.50 per count')
Text
0%
price_per_unit
Parse numeric value from unit price text for comparison. Extract just the number
Number
0%
deal_text
Capture full promotional message or savings text (e.g., 'Save $20 (25% off)')
Text
0%
video_count
Count number of video thumbnails or video players in product media section
Number
11.46%
number_of_payments
Find installment plan option near price (e.g., '4 interest-free payments'). Extract the number
Number
0%
price_per_payment
Extract installment amount from payment plan text (e.g., from '4 payments of $25' extract 25)
Number
0%
total_payments_price
Calculate or extract total cost when using installment plan. May be shown as 'Total: $100'
Number
0%
document_count
Count downloadable files in 'Documents & Manuals' or similar section (PDFs, guides)
Number
0%
is_aplus
Check if enhanced content section exists below product details (Amazon A+). Return 1 if yes, 0 if no
Boolean
0%
aplus_premium
Check if A+ content includes premium modules (interactive images, carousels). Return 1 if yes, 0 if no
Boolean
0%
aplus_faq
Check if A+ content has FAQ or Q&A module. Return 1 if present, 0 if absent
Boolean
0%
aplus_video
Check if A+ content includes embedded videos. Return 1 if video found, 0 if not
Boolean
0%
aplus_comparison
Look for product comparison chart or table in A+ content section. Return 1 if found, 0 if not
Boolean
0%
panorama_count
Count 360-degree view icons or interactive spin images in product gallery
Number
0%
seller_name
Extract seller name from 'Sold by' or 'Ships from' section near buy button
Text
0%
is_missing_variant
is_missing_variant
Boolean
99.83%
zip_code
Extract ZIP code if shown for delivery estimates or location-based pricing
Text
0%
suppressed_buybox_indication
suppressed_buybox_indication
Boolean
0%
best_seller_badge
best_seller_badge
Boolean
100%
amazons_choice_badge
amazons_choice_badge
Boolean
0%
climate_pledge_friendly
climate_pledge_friendly
Boolean
0%
internationally_available
internationally_available
Boolean
0%
pre_coupon_price
pre_coupon_price
Number
1.69%
in_store_only
in_store_only
Boolean
0%
page_title
page_title
Text
100%
variant_id
The product's variant ID
Text
0%
categories
The product's categories
Array
0%
you_may_also_like
you_may_also_like
Array
0%
pair_it_with
Products from "pair it with" section
Array
0%
more_from
Product from "more from" section
Array
0%
discover_more_options
Products from "discovery more options" section
Array
0%
timestamp
Date
—
Frequently asked questions
The Macys.com dataset contains approximately 1.93M records across 92 fields, refreshed monthly.
It is priced per record with a minimum order of 70,000 records. See the order panel on this page for live pricing in your currency (₹ for India, $ elsewhere) — the total scales with the number of records you select.
Fields include url, star rating distribution, quantity sold, views, is promo, seller id, store id, other price options and more — the complete list is in the data dictionary on this page.
It is aggregated from macys.com and other public, compliant sources, then cleaned, standardised and de-duplicated before delivery.
As a structured CSV/Excel export ready for CRM import or BI analysis, delivered after purchase. A free sample is available on this page.
The dataset is refreshed monthly so records stay accurate for outreach and analysis.