id: 34540

Column Value
id 34540
remote_code 17509112
market_id 4
history [{'data': {'data': {'dataFacets': []}, 'name': "Men's Royal New England Patriots Main Script 9FIFTY Snapback Hat", 'brand': 'New Era', 'gender': 'Men', 'is_lost': 0, 'variants': [{'upc': '197212774864', 'data': ['transfer'], 'size': 'noneSize', 'price': 28.99, 'colors': ['Royal'], 'image_url': 'https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif', 'price_full': 36.99, 'remote_url': 'https://www.macys.com/shop/product/~?ID=17509112&swatchColor=Royal&swatchSize=noneSize', 'description': 'Color: Royal; Size: noneSize', 'remote_code': '8825342_noneSize', 'stock_count': 1, 'origin_color': 'Royal', 'additional_upc': '51974023', 'variant_images': ['https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/2/optimized/26677292_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/3/optimized/26677293_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/6/optimized/26677296_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp']}], 'market_id': 4, 'sales_tag': 'Limited-Time Special Sale ends 6/21/26', 'categories': ['Lifestyle & Interests > Sports Fan Shop > Hat'], 'description': "A solid New England Patriots cap is a stable in any fan's closet. Make yours this Main Script 9FIFTY hat from New Era. Its design is simple but sweet, making for the perfect addition to a New England Patriots tee or jacket. Enhanced by the solid team color, the script and matching logo speak volumes for your fandom.\nOfficially licensed\nStructured fit\nHigh crown\nSnapback\nFlat bill\nSix panels with eyelets\nContrast-color undervisor\nEmbroidered graphics with raised details\nOne size fits most\nSports Fan Shop by LIDS\nThis item purchased online must be returned to the vendor by mail only. This item cannot be returned to Macy's stores.\n100% Polyester\nWipe Clean with a Damp Cloth\nImported", 'remote_code': '17509112', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-16 06:47:34'}, {'data': {'data': {'dataFacets': []}, 'name': "Men's Royal New England Patriots Main Script 9FIFTY Snapback Hat", 'brand': 'New Era', 'gender': 'Men', 'is_lost': 0, 'variants': [{'upc': '197212774864', 'data': ['transfer'], 'size': 'noneSize', 'price': 28.99, 'colors': ['Royal'], 'image_url': 'https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif', 'price_full': 36.99, 'remote_url': 'https://www.macys.com/shop/product/~?ID=17509112&swatchColor=Royal&swatchSize=noneSize', 'description': 'Color: Royal; Size: noneSize', 'remote_code': '8825342_noneSize', 'stock_count': 1, 'origin_color': 'Royal', 'additional_upc': '51974023', 'variant_images': ['https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/2/optimized/26677292_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/3/optimized/26677293_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/6/optimized/26677296_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp']}], 'market_id': 4, 'sales_tag': 'Limited-Time Special Sale ends 6/21/26', 'categories': ['Lifestyle & Interests > Sports Fan Shop > Hat'], 'description': "A solid New England Patriots cap is a stable in any fan's closet. Make yours this Main Script 9FIFTY hat from New Era. Its design is simple but sweet, making for the perfect addition to a New England Patriots tee or jacket. Enhanced by the solid team color, the script and matching logo speak volumes for your fandom.\nOfficially licensed\nStructured fit\nHigh crown\nSnapback\nFlat bill\nSix panels with eyelets\nContrast-color undervisor\nEmbroidered graphics with raised details\nOne size fits most\nSports Fan Shop by LIDS\nThis item purchased online must be returned to the vendor by mail only. This item cannot be returned to Macy's stores.\n100% Polyester\nWipe Clean with a Damp Cloth\nImported", 'remote_code': '17509112', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-15 21:48:16'}, {'data': {'data': {'dataFacets': []}, 'name': "Men's Royal New England Patriots Main Script 9FIFTY Snapback Hat", 'brand': 'New Era', 'gender': 'Men', 'is_lost': 0, 'variants': [{'upc': '197212774864', 'data': ['transfer'], 'size': 'noneSize', 'price': 28.99, 'colors': ['Royal'], 'image_url': 'https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif', 'price_full': 36.99, 'remote_url': 'https://www.macys.com/shop/product/~?ID=17509112&swatchColor=Royal&swatchSize=noneSize', 'description': 'Color: Royal; Size: noneSize', 'remote_code': '8825342_noneSize', 'stock_count': 1, 'origin_color': 'Royal', 'additional_upc': '51974023', 'variant_images': ['https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/2/optimized/26677292_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/3/optimized/26677293_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/6/optimized/26677296_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp']}], 'market_id': 4, 'sales_tag': 'Limited-Time Special Sale ends 6/21/26', 'categories': ['Lifestyle & Interests > Sports Fan Shop > Hat'], 'description': "A solid New England Patriots cap is a stable in any fan's closet. Make yours this Main Script 9FIFTY hat from New Era. Its design is simple but sweet, making for the perfect addition to a New England Patriots tee or jacket. Enhanced by the solid team color, the script and matching logo speak volumes for your fandom.\nOfficially licensed\nStructured fit\nHigh crown\nSnapback\nFlat bill\nSix panels with eyelets\nContrast-color undervisor\nEmbroidered graphics with raised details\nOne size fits most\nSports Fan Shop by LIDS\nThis item purchased online must be returned to the vendor by mail only. This item cannot be returned to Macy's stores.\n100% Polyester\nWipe Clean with a Damp Cloth\nImported", 'remote_code': '17509112', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-15 18:13:29'}, {'data': {'data': {'dataFacets': []}, 'name': "Men's Royal New England Patriots Main Script 9FIFTY Snapback Hat", 'brand': 'New Era', 'gender': 'Men', 'is_lost': 0, 'variants': [{'upc': '197212774864', 'data': ['transfer'], 'size': 'noneSize', 'price': 28.99, 'colors': ['Royal'], 'image_url': 'https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif', 'price_full': 36.99, 'remote_url': 'https://www.macys.com/shop/product/~?ID=17509112&swatchColor=Royal&swatchSize=noneSize', 'description': 'Color: Royal; Size: noneSize', 'remote_code': '8825342_noneSize', 'stock_count': 1, 'origin_color': 'Royal', 'additional_upc': '51974023', 'variant_images': ['https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/2/optimized/26677292_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/3/optimized/26677293_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/6/optimized/26677296_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp']}], 'market_id': 4, 'sales_tag': 'Limited-Time Special Sale ends 6/21/26', 'categories': ['Lifestyle & Interests > Sports Fan Shop > Hat'], 'description': "A solid New England Patriots cap is a stable in any fan's closet. Make yours this Main Script 9FIFTY hat from New Era. Its design is simple but sweet, making for the perfect addition to a New England Patriots tee or jacket. Enhanced by the solid team color, the script and matching logo speak volumes for your fandom.\nOfficially licensed\nStructured fit\nHigh crown\nSnapback\nFlat bill\nSix panels with eyelets\nContrast-color undervisor\nEmbroidered graphics with raised details\nOne size fits most\nSports Fan Shop by LIDS\nThis item purchased online must be returned to the vendor by mail only. This item cannot be returned to Macy's stores.\n100% Polyester\nWipe Clean with a Damp Cloth\nImported", 'remote_code': '17509112', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-15 14:03:25'}, {'data': {'data': {'dataFacets': []}, 'name': "Men's Royal New England Patriots Main Script 9FIFTY Snapback Hat", 'brand': 'New Era', 'gender': 'Men', 'is_lost': 0, 'variants': [{'upc': '197212774864', 'data': ['transfer'], 'size': 'noneSize', 'price': 28.99, 'colors': ['Royal'], 'image_url': 'https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif', 'price_full': 36.99, 'remote_url': 'https://www.macys.com/shop/product/~?ID=17509112&swatchColor=Royal&swatchSize=noneSize', 'description': 'Color: Royal; Size: noneSize', 'remote_code': '8825342_noneSize', 'stock_count': 1, 'origin_color': 'Royal', 'additional_upc': '51974023', 'variant_images': ['https://slimages.macysassets.com/is/image/MCY/products/4/optimized/26677294_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/2/optimized/26677292_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/3/optimized/26677293_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp', 'https://slimages.macysassets.com/is/image/MCY/products/6/optimized/26677296_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp']}], 'market_id': 4, 'sales_tag': 'Limited-Time Special Sale ends 6/21/26', 'categories': ['Lifestyle & Interests > Sports Fan Shop > Hat'], 'description': "A solid New England Patriots cap is a stable in any fan's closet. Make yours this Main Script 9FIFTY hat from New Era. Its design is simple but sweet, making for the perfect addition to a New England Patriots tee or jacket. Enhanced by the solid team color, the script and matching logo speak volumes for your fandom.\nOfficially licensed\nStructured fit\nHigh crown\nSnapback\nFlat bill\nSix panels with eyelets\nContrast-color undervisor\nEmbroidered graphics with raised details\nOne size fits most\nSports Fan Shop by LIDS\nThis item purchased online must be returned to the vendor by mail only. This item cannot be returned to Macy's stores.\n100% Polyester\nWipe Clean with a Damp Cloth\nImported", 'remote_code': '17509112', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-11 14:59:31'}]
date_created 2026-06-11 14:59:32.219107
date_modified 2026-06-16 06:47:35.911394