Catalog Admin

id: 95354

Column	Value
id	95354
brand	GUESS
name	GUESS Women's Charlotte Short Trench
description	GUESS was established in 1981 by the Marciano brothers, who left the south of France in pursuit of the American dream. Inspired by a European influence, the Marcianos redefined denim. One of their initial designs was a stonewashed, slim-fitting jean, the 3-zip Marilyn. This was the beginning of a long success story. GUESS quickly became a symbol of a young, sexy and adventurous lifestyle. Throughout the decades GUESS invited people to dream with its iconic and timeless advertising campaigns that turned unknown faces into famous models. Today GUESS is a truly global lifestyle brand with a full range of denim, apparel and accessories. Fabric type SHELL: 63% Cotton, 37% Polyester; LINING: 100% Polyester; TRIM: 100% Polyamide; FILL: 100% Polyester Care instructions Machine Wash Origin Imported About this item This double breasted cropped trench features GUESS branded buttons and diamond quilted back panel, front pocket and adjustable cuff details for effortless styling. Notch collar Double breast button closure Two side snap pockets Quilted details; adjustable snap cuffs See more About this item
data	{'dataFacets': []}
categories	['Clothing, Shoes & Jewelry > Women > Clothing > Coats, Jackets & Vests > Trench, Rain & Anoraks > Trench Coats']
gender	Women
market_id	37
remote_code	B0FM1YL884
is_lost	0
variants	[{'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Small', 'price': 90.56, 'author': None, 'colors': ['Herb Tan'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1NWHSP?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Herb Tan; Size: Small', 'remote_code': 'B0FM1NWHSP', 'stock_count': 1, 'origin_color': 'Herb Tan', 'delivery_days': 4, 'additional_upc': 'B0FM1NWHSP', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41pKKIiJCnL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31G4H8q9yeL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Medium', 'price': 79.77, 'author': None, 'colors': ['Herb Tan'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1H8VCV?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Herb Tan; Size: Medium', 'remote_code': 'B0FM1H8VCV', 'stock_count': 1, 'origin_color': 'Herb Tan', 'delivery_days': 4, 'additional_upc': 'B0FM1H8VCV', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41pKKIiJCnL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31G4H8q9yeL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Large', 'price': 64.73, 'author': None, 'colors': ['Herb Tan'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1C64RP?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Herb Tan; Size: Large', 'remote_code': 'B0FM1C64RP', 'stock_count': 1, 'origin_color': 'Herb Tan', 'delivery_days': 4, 'additional_upc': 'B0FM1C64RP', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41pKKIiJCnL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31G4H8q9yeL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'X-Large', 'price': 77.41, 'author': None, 'colors': ['Herb Tan'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1PCFQR?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Herb Tan; Size: X-Large', 'remote_code': 'B0FM1PCFQR', 'stock_count': 1, 'origin_color': 'Herb Tan', 'delivery_days': 4, 'additional_upc': 'B0FM1PCFQR', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/41bgc6VEZ9L._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41pKKIiJCnL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31G4H8q9yeL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Medium', 'price': 88.6, 'author': None, 'colors': ['Silk Blue'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM14BV2B?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Silk Blue; Size: Medium', 'remote_code': 'B0FM14BV2B', 'stock_count': 1, 'origin_color': 'Silk Blue', 'delivery_days': 4, 'additional_upc': 'B0FM14BV2B', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/318CZTU-YXL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/417RbOtgXvL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31QbPUEqqfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31GOaLxA58L._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Large', 'price': 85.18, 'author': None, 'colors': ['Silk Blue'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM16N2CB?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Silk Blue; Size: Large', 'remote_code': 'B0FM16N2CB', 'stock_count': 1, 'origin_color': 'Silk Blue', 'delivery_days': 4, 'additional_upc': 'B0FM16N2CB', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/318CZTU-YXL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/417RbOtgXvL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31QbPUEqqfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31GOaLxA58L._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Small', 'price': 79.4, 'author': None, 'colors': ['Silk Blue'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1BFKQ6?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Silk Blue; Size: Small', 'remote_code': 'B0FM1BFKQ6', 'stock_count': 1, 'origin_color': 'Silk Blue', 'delivery_days': 4, 'additional_upc': 'B0FM1BFKQ6', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/318CZTU-YXL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/417RbOtgXvL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31QbPUEqqfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31GOaLxA58L._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'X-Small', 'price': 86.69, 'author': None, 'colors': ['Silk Blue'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1GQHLH?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Silk Blue; Size: X-Small', 'remote_code': 'B0FM1GQHLH', 'stock_count': 1, 'origin_color': 'Silk Blue', 'delivery_days': 5, 'additional_upc': 'B0FM1GQHLH', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/318CZTU-YXL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/417RbOtgXvL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31QbPUEqqfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31GOaLxA58L._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Medium', 'price': 83.15, 'author': None, 'colors': ['Jet Black'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1WQZ6G?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Jet Black; Size: Medium', 'remote_code': 'B0FM1WQZ6G', 'stock_count': 1, 'origin_color': 'Jet Black', 'delivery_days': 7, 'additional_upc': 'B0FM1WQZ6G', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31B-3he47XL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41ngL7ICojL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31DSuoTwFVL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'X-Large', 'price': 85.21, 'author': None, 'colors': ['Silk Blue'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1LQ8MT?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Silk Blue; Size: X-Large', 'remote_code': 'B0FM1LQ8MT', 'stock_count': 1, 'origin_color': 'Silk Blue', 'delivery_days': 4, 'additional_upc': 'B0FM1LQ8MT', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31c-s+o8GfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/318CZTU-YXL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/417RbOtgXvL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31QbPUEqqfL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31GOaLxA58L._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Small', 'price': 78.09, 'author': None, 'colors': ['Jet Black'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1W8GL4?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Jet Black; Size: Small', 'remote_code': 'B0FM1W8GL4', 'stock_count': 1, 'origin_color': 'Jet Black', 'delivery_days': 4, 'additional_upc': 'B0FM1W8GL4', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31B-3he47XL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41ngL7ICojL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31DSuoTwFVL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'X-Small', 'price': 87.86, 'author': None, 'colors': ['Jet Black'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1F5QY1?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Jet Black; Size: X-Small', 'remote_code': 'B0FM1F5QY1', 'stock_count': 1, 'origin_color': 'Jet Black', 'delivery_days': 5, 'additional_upc': 'B0FM1F5QY1', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31B-3he47XL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41ngL7ICojL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31DSuoTwFVL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'X-Large', 'price': 83.49, 'author': None, 'colors': ['Jet Black'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1QH644?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Jet Black; Size: X-Large', 'remote_code': 'B0FM1QH644', 'stock_count': 1, 'origin_color': 'Jet Black', 'delivery_days': 4, 'additional_upc': 'B0FM1QH644', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31B-3he47XL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41ngL7ICojL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31DSuoTwFVL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}, {'upc': '', 'data': ['transfer'], 'isbn': None, 'name': '', 'size': 'Large', 'price': 82.2, 'author': None, 'colors': ['Jet Black'], 'dosage': None, 'flavor': None, 'weight': 222, 'image_url': 'https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_._AC_SY300.jpg', 'email_meta': None, 'price_full': None, 'remote_url': 'https://www.amazon.com/dp/B0FM1CLB5L?th=1&psc=1', 'sgr_number': None, 'description': 'Color: Jet Black; Size: Large', 'remote_code': 'B0FM1CLB5L', 'stock_count': 1, 'origin_color': 'Jet Black', 'delivery_days': 4, 'additional_upc': 'B0FM1CLB5L', 'expiration_str': None, 'variant_images': ['https://m.media-amazon.com/images/I/31DBSLDoFjL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31B-3he47XL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/41ngL7ICojL._AC_SX679_.jpg', 'https://m.media-amazon.com/images/I/31DSuoTwFVL._AC_SX679_.jpg'], 'expiration_date': None, 'description_front': None}]
date_created	2026-06-11 17:41:46.002339
date_modified	2026-09-04 07:16:20.947802