John Lewis and partners products dataset

Ecommerce dataset from johnlewis

John lewis partners dataset extracted by crawl feeds team. Dataset have more than 190K+ records.

Last extrated on March 2023

Dataset format CSV


Data points:

name, url, sku, pid, mpn, brand, color, price, currency, availability, description, specifications, images, primary_category, category_1, breadcrumbs, reviews_count, average_rating, uniq_id, scraped_at

Data points count:


Sample dataset:

View Sample (Signin)

Availability or Type:


Delivery time:


name url sku pid mpn brand color price currency availability description specifications images primary_category category_1 breadcrumbs reviews_count average_rating uniq_id scraped_at
A B Davis 9ct Gold Pearl Bracelet, Pink 237016553 3312644 237016553 A B Davis Pink 55.00 GBP OutOfStock <p> Tap into classic jewellery with this pearl stretch bracelet from A B Davis. </p> <p> The elegant and timeless design offers a comfortable stretch fit that will ensure a mark-free wear. The bracelet has beautiful luminous pearls in iridescent natural colours and a single solid gold round bead. </p> <p> Wear with a pearl necklace and matching studs for a complete look. </p> <p> Supplied with a gift box. </p> [] Women Women's Jewellery Women | Women's Jewellery | Women's Bracelets 2 5 84137aca-67e0-5734-bf60-4a269f472f70 03/25/23
French Connection Marley Wool Blend Scarf, Oatmeal 109526172 6402279 109526172 French Connection 50.00 GBP InStock <p>Lending itself to multiple styling options, this scarf from French Connection showcases classic stripes for timeless appeal.</p> [], Women Women's Hats, Gloves & Scarves Women | Women's Hats, Gloves & Scarves f410be1d-3a03-56de-86b2-04f1bfa578ca 03/25/23
Wolford Satin Touch 20 Denier Knee High Socks, Cosmetic 236527307 5117741 236527307 Wolford 20.00 GBP InStock <p> Update your daytime on-duty top drawer with these chic Wolford tights. </p> <p> The design offers a wide, soft comfort band along with a barely visible shadow toe reinforcement. The glamorous brilliance transforms these transparent knee-highs from a daily addition into a sophisticated accessory that lends an individual tone to any outfit. Beautiful when combined with trousers and long skirts. </p> [], Women Women's Socks Women | Women's Socks c712b83b-9984-512c-973b-5261c18b6886 03/25/23
Brora Organic Cotton Frill Collar Shirt, White 109877241 109877464 109877241 Brora 149.00 GBP InStock <p>Updating your workwear collection, this shirt by Brora has a textured effect for a bold look.</p> <p>Structured with a collar and long sleeves, it's made from organic cotton making it naturally soft and breathable and is an easy daytime option.</p> [],,,, Women Women's Shirts & Tops Women | Women's Shirts & Tops 3fa1f6b6-4688-5633-931d-fc42928b7c7e 03/25/23
Triumph Doreen Cotton Non Wired Bra, White 241137667 6249609 241137667 Triumph White 36.00 GBP InStock <p>Launched over 40 years ago, the Doreen by Triumph continues to be an enduring favourite with women everywhere.</p><p>Crafted from a soft and supportive fabric, it is cut in a classic style that provides a secure, comfortable and timeless feel.</p><p>The wide straps reduce the pressure on the shoulders and are set centrally for improved shape and comfort, and the wide underband provides solid and robust support to keep you feeling confident.</p><p>This bra is also suitable for use during pregnancy.</p><div> <h3>Need some advice for when baby arrives?</h3> <p>Getting everything ready for your first baby is an exciting time but it can be hard to know where to start. That’s why we offer a free Nursery Advice service so you can spend one-to-one, dedicated time with one of our Nursery experts, to share impartial advice on all the basics and essentials, tailored to your needs. </p> <p>Please <a href="">click here</a> to find out more and book your free appointment.</p></div> [],, Women Women's Lingerie & Underwear Women | Women's Lingerie & Underwear | Bras 109 4.6 9649e308-213f-55a8-a93c-d47e0327a830 03/25/23
Mint Velvet Kendra Espadrilles, Black 110194484 110194490 110194484 Mint Velvet 99.00 GBP OutOfStock The classic espadrille is a mainstay of the MV warm-weather wardrobe. Designed with a closed almond toe and a subtle flatform sole for a comfortable stride, this beige pair fastens with loose ties that wrap around your ankle for a romantic feel - we love the black toe-cap detail for a playful feel. [],,, Women Women's Shoes Women | Women's Shoes 7b118cf6-6eed-52e1-96a8-a45d7ab6d598 03/25/23
Forever New Bridget Lace Trim Midi Dress, Black 241037067 6194646 241037067 Forever New Black 70.00 GBP InStock <p>Flaring out at the hem for added movement, this midi dress by Forever New is embellished with intricate lace.</p> <p>Framed with a flattering v-neckline and long sleeves, it will see you through your social calendar with ease.</p> [],,, Women Women's Dresses Women | Women's Dresses bb2e1916-260c-5894-a3f9-701c94b7b145 03/25/23
Leitz Cosy Storage Box & Cabinet Set, Yellow 239883206 5391607 239883206 Leitz Yellow 50.00 GBP InStock <p>Set includes: Leitz Cosy MyBox Organiser provides the perfect storage space for pens, office accessories or even food. Additionally, its contemporary design helps brighten up the home or office. Leitz Cosy Two Drawer Cabinet that provides the optimum storage space for your notebooks, pens and cables. Helping you to stay organised in the office and at home.</p> <p>Dimensions (mm):</p> <p>Storage Carry Box 214 x 196 x 367</p> <p>Drawer Cabinet 251 x 143 x 275"</p> <p>Leitz Cosy combines home style comfort with premium quality. Its minimal, versatile design and inviting colours create a positive home environment ensuring you stay relaxed and productive all day.</p> [{'Brand': 'Leitz'}, {'Dimensions': 'Packaged: H41 x W31.5 x D45.5 cm'}, {'Material': 'ABS, Polystyrene'}],,,,,,,, Home & Garden Stationery Home & Garden | Stationery | Desk Storage & Desk Accessories 10 4.5 d61aa533-43c4-532a-9ad5-9e5799d09c56 03/25/23
Rosie Made A Thing Books Exams Good Luck Card 240896867 6031621 240896867 Rosie Made A Thing 2.80 GBP InStock <p>A greetings card from Rosie Made A Thing wishing good luck in academic endeavours.</p><p>Blank inside for you to write your personal message, this card comes with a grey envelope.</p><p>This card is FSC certified meaning you can be assured the material used has come from a forest approved by the Forest Stewardship Council, an international non-profit organisation dedicated to promoting responsible forestry.</p><p>Sourced and made in the United Kingdom.</p> <p>All the cards we sell are made without using glitter and are recyclable.</p> [{'Brand': 'Rosie Made A Thing'}, {'Dimensions': 'H15.5 x W15.5 cm'}, {'Envelope colour': 'grey'}, {'FSC Certified': 'YES'}, {'Made in the UK': 'YES'}, {'Message Inside': 'Blank inside'}, {'Occasion': 'Academic, Good Luck'}, {'Pack Size': 'Single'}, {'Recipient': 'General'}, {'Single/Multi Pack (LHN)': 'Single'}] Home & Garden Gift Wrap, Cards & Party Shop Home & Garden | Gift Wrap, Cards & Party Shop | Greetings Cards 9d9dad5a-347c-5d4d-bcb5-de8351cb9559 03/25/23
Sophie La Giraffe Bath Toy, Assorted 233630833 1455117 233630833 Sophie La Giraffe 9.99 GBP InStock <strong>Please note</strong>: there are several styles available in this range. Unfortunately it's not possible to request a specific one, so please let us choose one on your behalf.<div> </div><div>This floating, squirting, adorable Sophie La Girafe giraffe bath toy will keep your little one occupied in the bath. Easy for little hands to grip, Sophie has a cheerful face and a rubber ring so she is ready for the water.</div> [{'Brand': 'Sophie La Giraffe'}, {'Care instructions': 'Do not sterilise or use in dishwasher'}, {'Dimensions': 'H19x W7 x D9cm'}, {'Material': 'PVC'}, {'Suitable From': '6 months'}, {'Toys Type': 'Bath Toys'}, {'Warning!': 'Adult supervision recommended'}], Baby & Child Bathing & Changing Baby & Child | Bathing & Changing | Baby Bathing 9 3.9 e1d90d91-e2d5-5822-bb04-bcecd84e7d6f 03/25/23