Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Picardías Lavanda Alice - Seducción romántica y refinamiento a la antigua usanza
Doble clic para ampliar
SKU: SFBA3650
Picardías Lavanda Alice - Seducción romántica y refinamiento a la antigua usanza
Stock:

Déjate hechizar por nuestra chemise Alice, una creación que combina suavidad y seducción. Su delicado tono lavanda, sus bordados tono sobre tono y sus lazos en contraste evocan el romanticismo de otra época.

Con copas con aros para una sujeción perfecta y ligueros desmontables, esta pieza realza tu figura al tiempo que te transporta a un mundo de gracia y feminidad atemporal.

Puntos destacados

  • Un delicado tono lavanda que ilumina la piel y crea una atmósfera irresistiblemente romántica
  • El bordado tono sobre tono finamente trabajado evoca los preciosos adornos de antaño
  • Copas con aros para una sujeción ideal y un realce armonioso del busto
  • Pequeños lazos en contraste en la parte delantera añaden un toque de distinguida coquetería
  • Ligueros ajustables y desmontables para que puedas llevar tus medias favoritas con estilo
Talla:

¿No sabe qué talla elegir? Consulte nuestra guía de tallas

Color:
Cantidad:
69.95 €
Ayuda y consejos
por chat, facebook o correo electrónico
Devoluciones gratuitas
en un plazo de 15 días *

Talla grande de liguero romántico de lavanda

Descripción del producto

La chemise Alice le invita a un mundo de suavidad y romanticismo atemporal. Su delicado tono lavanda evoca los jardines ingleses y los refinados interiores de las casas históricas, creando una atmósfera de nostalgia y feminidad.


Un fino bordado tono sobre tono adorna las copas y el cuerpo de esta pieza con notable delicadeza. Estos motivos florales evocan los preciosos ornamentos de los ajuares de antaño, añadiendo una dimensión táctil y visual que invita a la contemplación y al tacto.


Las copas con aros son la combinación perfecta de sujeción y estética. Estructuran su busto con elegancia al tiempo que ofrecen un confort óptimo. Este cuidado diseño refleja un enfoque en el que la belleza nunca excluye el bienestar.


Los pequeños lazos a contraste de la parte delantera añaden un toque de distinguida coquetería al conjunto. Estos detalles, inspirados en las galas de época, llaman sutilmente la atención preservando la armonía cromática general.


Los ligueros ajustables y desmontables le permiten completar su conjunto con sus medias favoritas, disponibles por separado en nuestro sitio. Se ajustan perfectamente a la forma de su cuerpo para una sujeción ideal y una comodidad duradera durante toda la velada.


Los tirantes regulables y el ajuste de la espalda le permiten personalizar el ajuste de este picardías según sus preferencias, garantizando un ajuste perfecto que realzará su figura al máximo. Esta atención a la comodidad y el ajuste refleja una artesanía al servicio de una estética atemporal.

Detalles técnicos

  • Composición: Tejido suave y ligero con bordados
  • Estilo: Picardías romántico con bordados y ligueros
  • Copas: Con aros para una sujeción óptima
  • Detalles distintivos : Bordado tono sobre tono, lazos en contraste, ligueros desmontables
  • Color: Lavanda delicado
  • Ajuste : Tirantes ajustables y cierre en la espalda
  • Accesorios incluidos: Tanga a juego y ligueros desmontables

Tallas disponibles

Disponible de XL a 3X

Color disponible

Malva claro

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
  • Sombrero
XL
  • 98-107
  • 79-86
  • 104-112
  • B-D
1X
  • 102-112
  • 90-95
  • 109-117
  • C-E
2XL
  • 112-119
  • 95-102
  • 117-124
  • D-F
3X
  • 119-127
  • 102-108
  • 124-129
  • E-G

Consejos de cuidado

  • Se recomienda lavar a mano en agua fría
  • Utilizar un jabón suave especialmente formulado para lencería fina
  • Aclarar abundantemente y centrifugar suavemente sin escurrir
  • Secar en plano a la sombra para preservar la delicadeza del bordado
  • evite el contacto con perfumes o lociones que puedan alterar el tono lavanda

Consejos de uso

Para sacar el máximo partido a este picardías, ajusta los tirantes a la forma de tu cuerpo para una sujeción ideal del busto. Las copas con aros están diseñadas para proporcionar un sujetador óptimo y realzar el escote.

Para completar su conjunto, fije sus medias favoritas a los ligueros ajustables. Las medias de color nude o blanco disponibles en nuestra web combinarán a la perfección con esta prenda. El tanga a juego completa el look para una silueta seductora.

Consejos de estilo

Para una velada íntima inspirada en los romances de antaño, combine esta camisa con nuestras finas medias de gasa o encaje disponibles en nuestra web.

Perfume ligeramente su piel con notas de lavanda o flores blancas para prolongar el ambiente romántico. Prepare su dormitorio con algunas velas perfumadas y sábanas de algodón de calidad para crear un ambiente digno de las más bellas residencias históricas.

Como toque final, unas gotas de aceite esencial de lavanda en la almohada transportarán a su pareja a un mundo donde la seducción es un arte sutil y refinado.

To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number-1
brand
stringicollection
brandcode
stringiexk
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringIcollection
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.babydoll,divasboudoir.lingerie.sexylingerie.bustier
category
stringsexylingerie
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string368
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/babydoll.jpg
type
stringimg
width
string800
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.694 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'whisperpurple') > 0
and product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1whisperpurplecolorwpurwhisperpurplepurple#E1D6E4-10
colorrange
stringpurple
colors
stringwhisperpurple
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-01-04 14:03:56'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number58.2917
itempromo
string
key
stringmesh--lace-chemise-wkeyhole---7697x
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-05-31 19:30:43'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.606 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','es')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('7ed8b851-30a8-47d9-86a3c6ef02715b3d',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.34 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','es')
and product_categories.language in ('all','es')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SFBA3650'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string586
isprivate
string0
rating
stringall
src
string/photobank/products/iexk/sfba3650/guepiere-grande-taille-lavande-romantique1.jpg
type
stringimg
width
string405
back
Struct
height
string922
isprivate
string0
rating
stringall
src
string/photobank/products/iexk/sfba3650/guepiere-grande-taille-lavande-romantique-dos.jpg
type
stringimg
width
string638
default
Struct
height
string922
isprivate
string0
rating
stringall
src
string/photobank/products/iexk/sfba3650/guepiere-grande-taille-lavande-romantique.jpg
type
stringimg
width
string638
variations
Struct
colors
Struct
whisperpurple
Struct
height
string922
isprivate
string0
rating
stringall
src
string/photobank/products/iexk/sfba3650/guepiere-grande-taille-lavande-romantique.jpg
type
stringimg
width
string638
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser empfohlen.</li> <li>Verwenden Sie eine milde Seife speziell für feine Dessous</li> <li>Gründlich spülen und sanft auswringen, ohne zu wringen</li> <li>Flach im Schatten trocknen, um die Zartheit der Stickereien zu bewahren</li> <li>vermeiden Sie den Kontakt mit Parfums oder Lotionen, die den Lavendelfarbton beeinträchtigen könnten</li> </ul>
description
string<p>Das <strong>Alice Chemise-W&ecirc;pi&egrave;re</strong> lädt Sie in eine Welt voller Sanftheit und zeitloser Romantik ein. Ihr zarter Lavendelton erinnert an englische Gärten und die raffinierten Innenräume historischer Herrenhäuser und schafft eine Atmosphäre, die von Nostalgie und Weiblichkeit geprägt ist.</p> <p><br>Die fein gearbeiteten Ton-in-Ton-Stickereien schmücken die Cups und den Körper dieses Stücks mit bemerkenswerter Zartheit. Diese Blumenmotive erinnern an die kostbaren Ornamente der Aussteuer früherer Zeiten und fügen eine taktile und visuelle Dimension hinzu, die zum Betrachten und Berühren einlädt.</p> <p><br>Die Bügel-Cups sind die perfekte Kombination aus Halt und Ästhetik. Sie strukturieren Ihre Brust auf elegante Weise und bieten gleichzeitig optimalen Tragekomfort. Dieses sorgfältige Design zeugt von einem Ansatz, bei dem Schönheit niemals das Wohlbefinden ausschließt.</p> <p><br>Die kontrastierenden <strong>kleinen Schleifen</strong> auf der Vorderseite verleihen dem Ganzen einen Hauch von distinguierter Koketterie. Diese Details, die sich an historischen Schmuckstücken orientieren, sind ein subtiler Blickfang und bewahren gleichzeitig die chromatische Harmonie des Ganzen.</p> <p><br>Die verstellbaren und abnehmbaren Strumpfbänder ermöglichen es Ihnen, Ihr Outfit mit Ihren Lieblingsstrümpfen zu vervollständigen, die Sie separat auf unserer Website erwerben können. Sie passen sich perfekt an Ihre Morphologie an und sorgen so für idealen Halt und dauerhaften Komfort während des ganzen Abends.</p> <p><br>Mit den <strong>verstellbaren Trägern</strong> und der Verstellbarkeit im Rücken können Sie das Tragen dieses Babydolls/Wedges an Ihre Vorlieben anpassen und so für einen perfekten Fall sorgen, der Ihre Silhouette ideal betont. Diese Aufmerksamkeit für <strong>Komfort und Passform</strong> spiegelt unsere Handwerkskunst im Dienste einer zeitlosen Ästhetik wider.</p>
guid
stringhttps://dev.divasboudoir.com/de/babydoll-helles-mauve/sfba3650.htm
highlights
string<ul> <li>Zarter Lavendelfarbton, der Ihre Haut zum Strahlen bringt und eine unwiderstehliche romantische Atmosphäre schafft</li> <li>Fein gearbeitete Ton-in-Ton-Stickereien, die an die kostbaren Ornamente vergangener Zeiten erinnern</li> <li>Bügel-Cups bieten idealen Halt und betonen Ihren Busen harmonisch</li> <li>Kleine Kontrastschleifen auf der Vorderseite sorgen für einen Hauch von distinguierter Koketterie</li> <li>Verstellbare und abnehmbare Strumpfbänder, um Ihre Lieblingsstrümpfe elegant zu tragen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser Alice Babydoll-Wêêpière in großen Größen in Lavendel mit Stickereien und abnehmbaren Strumpfbändern. Romantischer Stil für eine raffinierte Weiblichkeit. Diskrete Lieferung!
keywords
string
title
stringNegligé-Guêpière Grande Taille Romantique Lavendel | Diva's Boudoir
seotitle
stringNegligé-Wêpière große Größe romantisch Lavendel Strumpfbänder
seouri
stringbabydoll-helles-mauve
specifications
string<ul> <li>Zusammensetzung: Weiches, leichtes Material mit Stickereien</li> <li>Stil: Romantisches Gu&ecirc;pi&egrave;re-Negligé mit Stickereien und Strumpfbändern</li> <li>Cups: Mit Bügeln für optimalen Halt</li> <li>Unterscheidende Details : Ton-in-Ton-Stickereien, kontrastierende Schleifen, abnehmbare Strumpfbänder</li> <li>Farbe: Zartes Lavendel</li> <li>Passform: Verstellbare Träger und Verschluss im Rücken</li> <li>Inklusive Zubehör: Passender String und abnehmbare Strumpfbänder</li> </ul>
stylingtips
string<p>Für einen Abend voller Intimität, inspiriert von den Romanzen vergangener Zeiten, kombinieren Sie dieses Babydoll-G&ecirc;pi&egrave;re mit unseren Strümpfen aus feinem Voile oder Spitze, die auf unserer Website erhältlich sind.</p> <p>Parfümieren Sie Ihre Haut leicht mit Noten von Lavendel oder weißen Blumen, um die romantische Atmosphäre zu verlängern. Bereiten Sie Ihr Schlafzimmer mit einigen Duftkerzen und hochwertiger Baumwollbettwäsche vor, um ein Ambiente zu schaffen, das den schönsten historischen Häusern würdig ist.</p> <p>Ein paar Tropfen ätherisches Lavendelöl auf Ihrem Kopfkissen versetzen Ihren Partner in eine Welt, in der die Verführung eine subtile und raffinierte Kunst ist.</p>
summary
string<p>Lassen Sie sich von unserem zarten und verführerischen Alice Chemise-W&ecirc;pi&egrave;re verzaubern. Der zarte Lavendelton, die Ton-in-Ton-Stickereien und die kontrastierenden Schleifchen erinnern an die Romantik einer anderen Epoche.</p> <p>Mit seinen Bügel-Cups für perfekten Halt und den abnehmbaren Strumpfbändern verleiht dieses Stück Ihrer Silhouette einen Hauch von Anmut und zeitloser Weiblichkeit.</p>
title
stringAlice Lavendel Negligé-Guêpière - Romantische Verführung und Raffinesse vergangener Zeiten
usageinstructions
string<p>Um dieses Gu&ecirc;pi&egrave;re-Nachthemd zu veredeln, stellen Sie die Träger auf Ihre Morphologie ein, um der Brust idealen Halt zu geben. Die Bügel-Cups sind so konzipiert, dass sie optimalen BH bieten und gleichzeitig Ihr Dekollet&eacute; betonen.</p> <p>Um Ihr Outfit zu vervollständigen, befestigen Sie Ihre Lieblingsstrümpfe an den verstellbaren Strumpfhaltern - unsere nudefarbenen oder weißen Strümpfe, die auf unserer Website erhältlich sind, passen perfekt zu diesem Stück. Der passende String rundet das Ensemble harmonisch ab und sorgt für eine vollkommen sublimierte Silhouette.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Συνιστάται πλύσιμο στο χέρι με κρύο νερό</li> <li>Χρησιμοποιήστε ένα ήπιο σαπούνι ειδικά σχεδιασμένο για ωραία εσώρουχα</li> <li>Ξεπλύνετε καλά και στύψτε απαλά χωρίς στύψιμο</li> <li>Στεγνώνετε σε επίπεδη θέση στη σκιά για να διατηρήσετε τη λεπτότητα του κεντήματος</li> <li>αποφύγετε την επαφή με αρώματα ή λοσιόν που θα μπορούσαν να αλλοιώσουν την απόχρωση της λεβάντας</li> </ul>
description
string<p>Το <strong>σεμινάριο Alice</strong> σας προσκαλεί σε έναν κόσμο απαλότητας και διαχρονικού ρομαντισμού. Η λεπτή απόχρωση της λεβάντας θυμίζει αγγλικούς κήπους και τους εκλεπτυσμένους εσωτερικούς χώρους ιστορικών σπιτιών, δημιουργώντας μια ατμόσφαιρα νοσταλγίας και θηλυκότητας.</p> <p><br>Το λεπτοδουλεμένο κέντημα τόνο-σε-τόνο κοσμεί τα κύπελλα και το σώμα αυτού του κομματιού με αξιοσημείωτη λεπτότητα. Αυτά τα floral μοτίβα θυμίζουν τα πολύτιμα στολίδια των trousseaux του παρελθόντος, προσθέτοντας μια απτική και οπτική διάσταση που προσκαλεί σε περισυλλογή και άγγιγμα.</p> <p><br>Τα ενισχυμένα κύπελλα αποτελούν τον τέλειο συνδυασμό στήριξης και αισθητικής. Δομούν το μπούστο σας με κομψότητα, ενώ παράλληλα προσφέρουν βέλτιστη άνεση. Αυτός ο σχολαστικός σχεδιασμός αντανακλά μια προσέγγιση όπου η ομορφιά δεν αποκλείει ποτέ την ευεξία.</p> <p><br>Οι <strong>μικροί φιόγκοι</strong> αντίθεσης στο μπροστινό μέρος προσθέτουν μια πινελιά διακεκριμένης κοκεταρίας στο σύνολο. Αυτές οι λεπτομέρειες, εμπνευσμένες από τα κομψοτεχνήματα της εποχής, τραβούν διακριτικά τα βλέμματα, διατηρώντας παράλληλα τη συνολική χρωματική αρμονία.</p> <p><br>Οι ρυθμιζόμενες, αποσπώμενες καλτσοδέτες σας επιτρέπουν να ολοκληρώσετε το ντύσιμό σας με τις αγαπημένες σας κάλτσες, που διατίθενται ξεχωριστά στην ιστοσελίδα μας. Προσαρμόζονται τέλεια στο σχήμα του σώματός σας για ιδανική στήριξη και διαρκή άνεση καθ' όλη τη διάρκεια της βραδιάς.</p> <p><br>Οι <strong>ρυθμιζόμενες τιράντες</strong> και η ρύθμιση της πλάτης σας επιτρέπουν να προσαρμόσετε την εφαρμογή αυτού του σεμινιού στις προτιμήσεις σας, εξασφαλίζοντας τέλεια εφαρμογή που θα αναδείξει με τον καλύτερο τρόπο τη σιλουέτα σας. Αυτή η προσοχή στην <strong>άνεση και την εφαρμογή</strong> αντανακλά μια δεξιοτεχνία που υπηρετεί μια διαχρονική αισθητική.</p>
guid
stringhttps://dev.divasboudoir.com/el/babydoll-anoichto-mov/sfba3650.htm
highlights
string<ul> <li>Μια λεπτή απόχρωση λεβάντας που φωτίζει το δέρμα σας και δημιουργεί μια ακαταμάχητα ρομαντική ατμόσφαιρα</li> <li>Το λεπτοδουλεμένο κέντημα τόνο-σε-τόνο θυμίζει τα πολύτιμα στολίδια του παρελθόντος</li> <li>Κούπες με μπανέλα για ιδανική στήριξη και αρμονική ενίσχυση του στήθους</li> <li>Μικροί φιόγκοι αντίθεσης στο μπροστινό μέρος προσθέτουν μια πινελιά διακριτικής φινέτσας</li> <li>Ρυθμιζόμενες, αποσπώμενες καλτσοδέτες για να μπορείτε να φοράτε τις αγαπημένες σας κάλτσες με στυλ</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το μεγάλο μας σεμινάριο Alice σε λεβάντα με κεντήματα και αποσπώμενες καλτσοδέτες. Ρομαντικό στυλ για εκλεπτυσμένη θηλυκότητα. Διακριτική παράδοση!
keywords
string
title
stringΡομαντικό babydoll μεγάλο μέγεθος λεβάντα | Diva's Boudoir
seotitle
stringΜεγάλη ρομαντική ζαρτιέρα λεβάντας
seouri
stringbabydoll-anoichto-mov
specifications
string<ul> <li>Σύνθεση: Μαλακό, ελαφρύ ύφασμα με κεντήματα</li> <li>Στυλ: Ρομαντικό babydoll με κεντήματα και καλτσοδέτες</li> <li>Κύπελλα: Με μπανέλα για βέλτιστη στήριξη</li> <li>Χαρακτηριστικές λεπτομέρειες: Διαθέτει ένα πολύ μεγάλο μέγεθος: Κεντήματα τόνο-σε-τόνο, φιόγκοι σε αντίθεση, αποσπώμενες καλτσοδέτες</li> <li>Χρώμα: Ντελικάτη λεβάντα</li> <li>Εφαρμογή: Κοστούμι: Κίτρινο, λεβάντα Ρυθμιζόμενοι ιμάντες και κλείσιμο στην πλάτη</li> <li>Περιλαμβάνονται αξεσουάρ: Ασορτί στρινγκ και αποσπώμενες καλτσοδέτες</li> </ul>
stylingtips
string<p>Για μια οικεία βραδιά εμπνευσμένη από τους ρομαντισμούς του παρελθόντος, συνδυάστε αυτό το σεμινάριο με τις ωραίες κάλτσες μας από voile ή δαντέλα που διατίθενται στην ιστοσελίδα μας.</p> <p>Αρωματίστε ελαφρά το δέρμα σας με νότες λεβάντας ή λευκών λουλουδιών για να παρατείνετε τη ρομαντική ατμόσφαιρα. Ετοιμάστε την κρεβατοκάμαρά σας με μερικά αρωματικά κεριά και ποιοτικά βαμβακερά σεντόνια για να δημιουργήσετε ένα σκηνικό αντάξιο των πιο όμορφων ιστορικών κατοικιών.</p> <p>Για μια τελευταία πινελιά, μερικές σταγόνες αιθέριου ελαίου λεβάντας στο μαξιλάρι σας θα μεταφέρουν τον σύντροφό σας σε έναν κόσμο όπου η αποπλάνηση είναι μια λεπτή και εκλεπτυσμένη τέχνη.</p>
summary
string<p>Αφήστε τον εαυτό σας να μαγευτεί από το σεμινάριο Alice, μια δημιουργία που συνδυάζει την απαλότητα και την αποπλάνηση. Η απαλή λεβαντίνη απόχρωση, τα κεντήματα τόνο-σε-τόνο και οι φιόγκοι σε αντίθεση θυμίζουν τον ρομαντισμό μιας άλλης εποχής.</p> <p>Με ενισχυμένα κυπελάκια για τέλεια στήριξη και αποσπώμενες καλτσοδέτες, αυτό το κομμάτι αναδεικνύει τη σιλουέτα σας, ενώ σας μεταφέρει σε έναν κόσμο χάρης και διαχρονικής θηλυκότητας.</p>
title
stringΛεβάντα Alice chemise - Ρομαντική αποπλάνηση και παλιομοδίτικη φινέτσα
usageinstructions
string<p>Για να αξιοποιήσετε στο έπακρο αυτό το σεμινάριο, προσαρμόστε τους ιμάντες στο σχήμα του σώματός σας για ιδανική στήριξη του στήθους. Τα κυπελάκια με μπανέλα έχουν σχεδιαστεί για να παρέχουν βέλτιστη στήριξη, ενώ παράλληλα αναδεικνύουν το ντεκολτέ σας.</p> <p>Για να ολοκληρώσετε το ντύσιμό σας, συνδέστε τις αγαπημένες σας κάλτσες στις ρυθμιζόμενες καλτσοδέτες - οι γυμνές ή λευκές κάλτσες που διατίθενται στην ιστοσελίδα μας θα ταιριάξουν τέλεια με αυτό το κομμάτι. Το ασορτί στρινγκ ολοκληρώνει την εμφάνιση για μια σαγηνευτική σιλουέτα.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water recommended</li> <li>Use a mild soap specially formulated for fine lingerie</li> <li>Rinse thoroughly and spin gently without wringing</li> <li>Dry flat in the shade to preserve the delicacy of the embroidery</li> <li>avoid contact with perfumes or lotions that could alter the lavender hue</li> </ul>
description
string<p>The <strong>Alice chemise</strong> invites you into a world of softness and timeless romance. Its delicate lavender hue evokes English gardens and the refined interiors of historic homes, creating an atmosphere imbued with nostalgia and femininity.</p> <p><br>Finely crafted, tone-on-tone embroidery adorns the cups and body of this piece with remarkable delicacy. These floral motifs evoke the precious ornaments of the trousseaux of yesteryear, adding a tactile and visual dimension that invites contemplation and touch.</p> <p><br>Underwired cups are the perfect combination of support and aesthetics. They structure your breasts with elegance while offering optimum comfort. This meticulous design reflects an approach in which beauty never excludes well-being.</p> <p><br><strong>Small</strong> contrasting <strong>bows</strong> on the front add a touch of distinguished coquetry to the ensemble. These details, inspired by period finery, subtly draw the eye while preserving the overall chromatic harmony.</p> <p><br>Adjustable, detachable garters let you complete your outfit with your favorite stockings, available separately on our site. They adjust perfectly to your body shape for ideal support and lasting comfort throughout the evening.</p> <p><br><strong>Adjustable straps</strong> and back adjustment let you personalize the fit of this chemise to your preferences, ensuring a perfect fit that will ideally enhance your silhouette. This attention to <strong>comfort and fit</strong> reflects craftsmanship at the service of a timeless aesthetic.</p>
guid
stringhttps://dev.divasboudoir.com/en/babydoll-light-mauve/sfba3650.htm
highlights
string<ul> <li>Delicate lavender hue illuminates your skin and creates an irresistibly romantic atmosphere</li> <li>Finely crafted tone-on-tone embroidery evokes the precious ornaments of yesteryear</li> <li>Underwired cups for ideal support and harmonious bust enhancement</li> <li>Small contrasting bows on the front add a touch of distinguished coquetry</li> <li>Adjustable, detachable garters to wear your favorite stockings with elegance</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our plus size Alice chemise in lavender with embroidery and detachable garters. Romantic styling for refined femininity. Discreet delivery!
keywords
string
title
stringBabydoll Plus Size Romantic Lavender | Diva's Boudoir
seotitle
stringRomantic lavender garters plus size babydoll
seouri
stringbabydoll-light-mauve
specifications
string<ul> <li>Composition: Soft, light material with embroidery</li> <li>Style: Romantic babydoll with embroidery and garters</li> <li>Cups: Underwired for optimum support</li> <li>Distinctive details: Tone-on-tone embroidery, contrasting bows, detachable garters</li> <li>Color: Delicate lavender</li> <li>Fit: Adjustable straps and back closure</li> <li>Accessories included: Matching thong and detachable garters</li> </ul>
stylingtips
string<p>For an evening of intimacy inspired by period romances, pair this chemise with our fine voile or lace stockings available on our site.</p> <p>Lightly perfume your skin with notes of lavender or white flowers to prolong the romantic atmosphere. Prepare your bedroom with a few scented candles and quality cotton sheets to create a setting worthy of the most beautiful historic residences.</p> <p>For a final touch, a few drops of lavender essential oil on your pillow will transport your partner to a world where seduction becomes a subtle and refined art.</p>
summary
string<p>Let yourself be enchanted by our Alice chemise, a creation that combines softness and seduction. Its delicate lavender hue, tone-on-tone embroidery and contrasting bows evoke the romance of another era.</p> <p>With underwired cups for perfect support and detachable garters, this piece enhances your silhouette while transporting you to a world of grace and timeless femininity.</p>
title
stringNuisette-Guêpière Alice Lavande - Romantic seduction and old-fashioned refinement
usageinstructions
string<p>To enhance this chemise-gu&ecirc;pi&egrave;re, adjust the straps to your body shape for ideal bust support. The underwired cups are designed to offer optimum bra while enhancing your cleavage.</p> <p>To complete your outfit, attach your favorite stockings to the adjustable garters - our nude or white stockings available on our site will pair perfectly with this piece. The matching g-string completes the ensemble for a totally sublimated silhouette.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Se recomienda lavar a mano en agua fría</li> <li>Utilizar un jabón suave especialmente formulado para lencería fina</li> <li>Aclarar abundantemente y centrifugar suavemente sin escurrir</li> <li>Secar en plano a la sombra para preservar la delicadeza del bordado</li> <li>evite el contacto con perfumes o lociones que puedan alterar el tono lavanda</li> </ul>
description
string<p>La <strong>chemise Alice</strong> le invita a un mundo de suavidad y romanticismo atemporal. Su delicado tono lavanda evoca los jardines ingleses y los refinados interiores de las casas históricas, creando una atmósfera de nostalgia y feminidad.</p> <p><br>Un fino bordado tono sobre tono adorna las copas y el cuerpo de esta pieza con notable delicadeza. Estos motivos florales evocan los preciosos ornamentos de los ajuares de antaño, añadiendo una dimensión táctil y visual que invita a la contemplación y al tacto.</p> <p><br>Las copas con aros son la combinación perfecta de sujeción y estética. Estructuran su busto con elegancia al tiempo que ofrecen un confort óptimo. Este cuidado diseño refleja un enfoque en el que la belleza nunca excluye el bienestar.</p> <p><br>Los <strong>pequeños lazos</strong> a contraste de la parte delantera añaden un toque de distinguida coquetería al conjunto. Estos detalles, inspirados en las galas de época, llaman sutilmente la atención preservando la armonía cromática general.</p> <p><br>Los ligueros ajustables y desmontables le permiten completar su conjunto con sus medias favoritas, disponibles por separado en nuestro sitio. Se ajustan perfectamente a la forma de su cuerpo para una sujeción ideal y una comodidad duradera durante toda la velada.</p> <p><br>Los <strong>tirantes regulables</strong> y el ajuste de la espalda le permiten personalizar el ajuste de este picardías según sus preferencias, garantizando un ajuste perfecto que realzará su figura al máximo. Esta atención a la <strong>comodidad y el ajuste</strong> refleja una artesanía al servicio de una estética atemporal.</p>
guid
stringhttps://dev.divasboudoir.com/es/babydoll-malva-claro/sfba3650.htm
highlights
string<ul> <li>Un delicado tono lavanda que ilumina la piel y crea una atmósfera irresistiblemente romántica</li> <li>El bordado tono sobre tono finamente trabajado evoca los preciosos adornos de antaño</li> <li>Copas con aros para una sujeción ideal y un realce armonioso del busto</li> <li>Pequeños lazos en contraste en la parte delantera añaden un toque de distinguida coquetería</li> <li>Ligueros ajustables y desmontables para que puedas llevar tus medias favoritas con estilo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestra talla grande Alice en color lavanda con bordados y ligueros desmontables. Un estilo romántico para una feminidad refinada. ¡Entrega discreta!
keywords
string
title
stringPicardías Romántico Talla grande Lavanda | Diva's Boudoir
seotitle
stringTalla grande de liguero romántico de lavanda
seouri
stringbabydoll-malva-claro
specifications
string<ul> <li>Composición: Tejido suave y ligero con bordados</li> <li>Estilo: Picardías romántico con bordados y ligueros</li> <li>Copas: Con aros para una sujeción óptima</li> <li>Detalles distintivos : Bordado tono sobre tono, lazos en contraste, ligueros desmontables</li> <li>Color: Lavanda delicado</li> <li>Ajuste : Tirantes ajustables y cierre en la espalda</li> <li>Accesorios incluidos: Tanga a juego y ligueros desmontables</li> </ul>
stylingtips
string<p>Para una velada íntima inspirada en los romances de antaño, combine esta camisa con nuestras finas medias de gasa o encaje disponibles en nuestra web.</p> <p>Perfume ligeramente su piel con notas de lavanda o flores blancas para prolongar el ambiente romántico. Prepare su dormitorio con algunas velas perfumadas y sábanas de algodón de calidad para crear un ambiente digno de las más bellas residencias históricas.</p> <p>Como toque final, unas gotas de aceite esencial de lavanda en la almohada transportarán a su pareja a un mundo donde la seducción es un arte sutil y refinado.</p>
summary
string<p>Déjate hechizar por nuestra chemise Alice, una creación que combina suavidad y seducción. Su delicado tono lavanda, sus bordados tono sobre tono y sus lazos en contraste evocan el romanticismo de otra época.</p> <p>Con copas con aros para una sujeción perfecta y ligueros desmontables, esta pieza realza tu figura al tiempo que te transporta a un mundo de gracia y feminidad atemporal.</p>
title
stringPicardías Lavanda Alice - Seducción romántica y refinamiento a la antigua usanza
usageinstructions
string<p>Para sacar el máximo partido a este picardías, ajusta los tirantes a la forma de tu cuerpo para una sujeción ideal del busto. Las copas con aros están diseñadas para proporcionar un sujetador óptimo y realzar el escote.</p> <p>Para completar su conjunto, fije sus medias favoritas a los ligueros ajustables. Las medias de color nude o blanco disponibles en nuestra web combinarán a la perfección con esta prenda. El tanga a juego completa el look para una silueta seductora.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide recommand&eacute;</li> <li>Utiliser un savon doux sp&eacute;cial lingerie fine</li> <li>Rincer abondamment et essorer d&eacute;licatement sans tordre</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre pour pr&eacute;server la d&eacute;licatesse des broderies</li> <li>&Eacute;viter tout contact avec des parfums ou lotions qui pourraient alt&eacute;rer la teinte lavande</li> </ul>
description
string<p>La <strong>nuisette-gu&ecirc;pi&egrave;re Alice</strong> vous invite dans un univers de douceur et de romantisme intemporel. Sa teinte lavande d&eacute;licate &eacute;voque les jardins anglais et les int&eacute;rieurs raffin&eacute;s des demeures historiques, cr&eacute;ant une atmosph&egrave;re empreinte de nostalgie et de f&eacute;minit&eacute;.</p> <p><br>Les broderies ton sur ton, finement travaill&eacute;es, ornent les bonnets et le corps de cette pi&egrave;ce avec une d&eacute;licatesse remarquable. Ces motifs floraux &eacute;voquent les ornements pr&eacute;cieux des trousseaux d'autrefois, ajoutant une dimension tactile et visuelle qui invite &agrave; la contemplation et au toucher.</p> <p><br>Les bonnets &agrave; armatures repr&eacute;sentent l'alliance parfaite entre maintien et esth&eacute;tique. Ils structurent votre poitrine avec &eacute;l&eacute;gance tout en offrant un confort optimal. Cette conception soign&eacute;e t&eacute;moigne d'une approche o&ugrave; la beaut&eacute; n'exclut jamais le bien-&ecirc;tre.</p> <p><br>Les <strong>petits n&oelig;uds</strong> contrastants positionn&eacute;s sur l'avant ajoutent une touche de coquetterie distingu&eacute;e &agrave; l'ensemble. Ces d&eacute;tails, inspir&eacute;s des parures d'&eacute;poque, attirent subtilement le regard tout en pr&eacute;servant l'harmonie chromatique de l'ensemble.</p> <p><br>Les jarreti&egrave;res r&eacute;glables et d&eacute;tachables vous permettent de compl&eacute;ter votre tenue avec vos bas pr&eacute;f&eacute;r&eacute;s, disponibles s&eacute;par&eacute;ment sur notre site. Elles s'ajustent parfaitement &agrave; votre morphologie pour un maintien id&eacute;al et un confort durable tout au long de la soir&eacute;e.</p> <p><br>Les <strong>bretelles r&eacute;glables</strong> et l'ajustement dans le dos vous permettent de personnaliser le port de cette nuisette-gu&ecirc;pi&egrave;re selon vos pr&eacute;f&eacute;rences, assurant un tomb&eacute; parfait qui mettra id&eacute;alement en valeur votre silhouette. Cette attention port&eacute;e au <strong>confort et &agrave; l'ajustement</strong> refl&egrave;te un savoir-faire au service d'une esth&eacute;tique intemporelle.</p>
guid
stringhttps://dev.divasboudoir.com/fr/grande-taille-nuisette-guepiere-romantique-lavande-jarretieres/sfba3650.htm
highlights
string<ul> <li>Teinte lavande d&eacute;licate qui illumine votre peau et cr&eacute;e une atmosph&egrave;re romantique irr&eacute;sistible</li> <li>Broderies ton sur ton finement travaill&eacute;es qui &eacute;voquent les ornements pr&eacute;cieux d'autrefois</li> <li>Bonnets &agrave; armatures offrant un maintien id&eacute;al et une mise en valeur harmonieuse de votre poitrine</li> <li>Petits n&oelig;uds contrastants sur l'avant qui ajoutent une touche de coquetterie distingu&eacute;e</li> <li>Jarreti&egrave;res r&eacute;glables et d&eacute;tachables pour porter vos bas pr&eacute;f&eacute;r&eacute;s avec &eacute;l&eacute;gance</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre nuisette-guêpière grande taille Alice en lavande avec broderies et jarretières détachables. Style romantique pour une féminité raffinée. Livraison discrète !
keywords
string
title
stringNuisette-Guêpière Grande Taille Romantique Lavande | Diva's Boudoir
seotitle
stringNuisette-guêpière grande taille romantique lavande jarretières
seouri
stringgrande-taille-nuisette-guepiere-romantique-lavande-jarretieres
specifications
string<ul> <li>Composition : Mati&egrave;re douce et l&eacute;g&egrave;re avec broderies</li> <li>Style : Nuisette-gu&ecirc;pi&egrave;re romantique avec broderies et jarreti&egrave;res</li> <li>Bonnets : &Agrave; armatures pour un maintien optimal</li> <li>D&eacute;tails distinctifs : Broderies ton sur ton, n&oelig;uds contrastants, jarreti&egrave;res d&eacute;tachables</li> <li>Couleur : Lavande d&eacute;licate</li> <li>Ajustement : Bretelles r&eacute;glables et fermeture dans le dos</li> <li>Accessoires inclus : String assorti et jarreti&egrave;res d&eacute;tachables</li> </ul>
stylingtips
string<p>Pour une soir&eacute;e d'intimit&eacute; inspir&eacute;e des romances d'&eacute;poque, associez cette nuisette-gu&ecirc;pi&egrave;re avec nos bas en voile fin ou en dentelle disponibles sur notre site.</p> <p>Parfumez l&eacute;g&egrave;rement votre peau avec des notes de lavande ou de fleurs blanches pour prolonger l'atmosph&egrave;re romantique. Pr&eacute;parez votre chambre avec quelques bougies parfum&eacute;es et des draps en coton de qualit&eacute; pour cr&eacute;er un &eacute;crin digne des plus belles demeures historiques.&nbsp;</p> <p>Pour une touche finale, quelques gouttes d'huile essentielle de lavande sur votre oreiller transporteront votre partenaire dans un univers o&ugrave; la s&eacute;duction se fait art subtil et raffin&eacute;.</p>
summary
string<p>Laissez-vous envo&ucirc;ter par notre nuisette-gu&ecirc;pi&egrave;re Alice, une cr&eacute;ation qui marie douceur et s&eacute;duction. Sa teinte lavande d&eacute;licate, ses broderies ton sur ton et ses petits n&oelig;uds contrastants &eacute;voquent un romantisme d'une autre &eacute;poque.</p> <p>Avec ses bonnets &agrave; armatures pour un maintien parfait et ses jarreti&egrave;res d&eacute;tachables, cette pi&egrave;ce sublime votre silhouette tout en vous transportant dans un univers de gr&acirc;ce et de f&eacute;minit&eacute; intemporelle.</p>
title
stringNuisette-Guêpière Alice Lavande - Séduction romantique et raffinement d'antan
usageinstructions
string<p>Pour sublimer cette nuisette-gu&ecirc;pi&egrave;re, ajustez les bretelles &agrave; votre morphologie pour un maintien id&eacute;al de la poitrine. Les bonnets &agrave; armatures sont con&ccedil;us pour offrir un soutien optimal tout en mettant en valeur votre d&eacute;collet&eacute;.</p> <p>Pour compl&eacute;ter votre tenue, attachez vos bas pr&eacute;f&eacute;r&eacute;s aux jarreti&egrave;res r&eacute;glables - nos bas nude ou blancs disponibles sur notre site se marieront parfaitement avec cette pi&egrave;ce. Le string assorti compl&egrave;te harmonieusement l'ensemble pour une silhouette enti&egrave;rement sublim&eacute;e.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Si consiglia il lavaggio a mano in acqua fredda</li> <li>Usare un sapone delicato appositamente formulato per la lingerie fine</li> <li>Risciacquare accuratamente e centrifugare delicatamente senza strizzare</li> <li>Asciugare all'ombra per preservare la delicatezza dei ricami</li> <li>evitare il contatto con profumi o lozioni che potrebbero alterare la tonalità della lavanda</li> </ul>
description
string<p>La <strong>chemise Alice</strong> vi invita in un mondo di morbidezza e romanticismo senza tempo. La sua delicata tonalità lavanda evoca i giardini inglesi e gli interni raffinati delle dimore storiche, creando un'atmosfera di nostalgia e femminilità.</p> <p><br>I ricami tono su tono finemente realizzati adornano le coppe e il corpo di questo capo con notevole delicatezza. Questi motivi floreali evocano i preziosi ornamenti dei corredi di un tempo, aggiungendo una dimensione tattile e visiva che invita alla contemplazione e al tatto.</p> <p><br>Le coppe con ferretto sono la combinazione perfetta di sostegno ed estetica. Strutturano il seno con eleganza e offrono un comfort ottimale. Questo design meticoloso riflette un approccio in cui la bellezza non esclude mai il benessere.</p> <p><br>I <strong>piccoli fiocchi</strong> a contrasto sul davanti aggiungono un tocco di raffinata civetteria all'insieme. Questi dettagli, ispirati alla raffinatezza dell'epoca, attirano l'attenzione pur mantenendo l'armonia cromatica complessiva.</p> <p><br>Il reggicalze regolabile e staccabile consente di completare l'outfit con le calze preferite, disponibili separatamente sul nostro sito. Si adattano perfettamente alla forma del corpo per un sostegno ideale e un comfort duraturo per tutta la serata.</p> <p><br>Le <strong>spalline regolabili</strong> e la regolazione della schiena consentono di personalizzare la vestibilità di questa chemise in base alle proprie preferenze, assicurando una vestibilità perfetta che metterà in risalto la vostra figura al meglio. L'attenzione al <strong>comfort e alla vestibilità</strong> riflette un'artigianalità che si traduce in un'estetica senza tempo.</p>
guid
stringhttps://dev.divasboudoir.com/it/babydoll-malva-chiaro/sfba3650.htm
highlights
string<ul> <li>Una delicata tonalità lavanda che illumina la pelle e crea un'atmosfera irresistibilmente romantica</li> <li>I ricami tono su tono finemente lavorati evocano i preziosi ornamenti di un tempo</li> <li>Coppe con ferretto per un sostegno ideale e un'armoniosa valorizzazione del seno</li> <li>Piccoli fiocchi a contrasto sul davanti aggiungono un tocco di distinzione</li> <li>Giarrettiere regolabili e staccabili per indossare con stile le vostre calze preferite</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringScoprite la nostra chemise Alice di taglia grande in lavanda con ricami e giarrettiere staccabili. Stile romantico per una femminilità raffinata. Consegna discreta!
keywords
string
title
stringBabydoll romantico taglia grande Lavanda | Diva's Boudoir
seotitle
stringGrande chemise romantica alla lavanda con giarrettiera
seouri
stringbabydoll-malva-chiaro
specifications
string<ul> <li>Composizione: tessuto morbido e leggero con ricami</li> <li>Stile: babydoll romantico con ricami e giarrettiere</li> <li>Coppe: con ferretto per un sostegno ottimale</li> <li>Dettagli distintivi: Ricami tono su tono, fiocchi a contrasto, giarrettiere staccabili</li> <li>Colore: lavanda delicata</li> <li>Vestibilità : Spalline e chiusura posteriore regolabili</li> <li>Accessori inclusi: Perizoma abbinato e reggicalze staccabile</li> </ul>
stylingtips
string<p>Per una serata intima ispirata alle storie d'amore di un tempo, abbinate questa chemise alle calze di voile o pizzo disponibili sul nostro sito.</p> <p>Profumate leggermente la vostra pelle con note di lavanda o fiori bianchi per prolungare l'atmosfera romantica. Preparate la vostra camera da letto con qualche candela profumata e lenzuola di cotone di qualità per creare un ambiente degno delle più belle dimore storiche.</p> <p>Per un tocco finale, qualche goccia di olio essenziale di lavanda sul cuscino trasporterà il vostro partner in un mondo dove la seduzione è un'arte sottile e raffinata.</p>
summary
string<p>Lasciatevi incantare dalla nostra chemise Alice, una creazione che unisce morbidezza e seduzione. La sua delicata tonalità lavanda, i ricami tono su tono e i fiocchi a contrasto evocano il romanticismo di altri tempi.</p> <p>Con coppe con ferretto per un sostegno perfetto e giarrettiere staccabili, questo capo valorizza la vostra figura trasportandovi in un mondo di grazia e femminilità senza tempo.</p>
title
stringChemise Alice alla lavanda - Seduzione romantica e raffinatezza d'altri tempi
usageinstructions
string<p>Per sfruttare al meglio questa chemise, regolate le spalline in base alla vostra forma del corpo per un sostegno ideale del seno. Le coppe con ferretto sono progettate per offrire un reggiseno ottimale e valorizzare il vostro décolleté.</p> <p>Per completare l'outfit, fissate le vostre calze preferite alle giarrettiere regolabili: le calze bianche o nude disponibili sul nostro sito si abbinano perfettamente a questo capo. Il perizoma abbinato completa il look per una silhouette seducente.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water aanbevolen</li> <li>Gebruik een milde zeep speciaal voor fijne lingerie</li> <li>Grondig spoelen en voorzichtig centrifugeren zonder wringen</li> <li>Plat in de schaduw laten drogen om het fijne borduurwerk te behouden</li> <li>vermijd contact met parfums of lotions die de lavendeltint kunnen veranderen</li> </ul>
description
string<p>De <strong>Alice chemise</strong> nodigt je uit in een wereld van zachtheid en tijdloze romantiek. De delicate lavendeltint doet denken aan Engelse tuinen en de verfijnde interieurs van historische huizen en creëert een sfeer van nostalgie en vrouwelijkheid.</p> <p><br>Fijn bewerkt ton sur ton borduurwerk siert de cups en de body van dit stuk met opmerkelijke delicatesse. Deze bloemmotieven doen denken aan de kostbare ornamenten van de trousseaux van weleer en voegen een tactiele en visuele dimensie toe die uitnodigt tot nadenken en aanraken.</p> <p><br>Beugelcups zijn de perfecte combinatie van ondersteuning en esthetiek. Ze structureren je buste met elegantie en bieden optimaal comfort. Dit zorgvuldige ontwerp weerspiegelt een benadering waarbij schoonheid welzijn nooit uitsluit.</p> <p><br>De <strong>kleine</strong> contrasterende <strong>strikjes</strong> aan de voorkant geven het geheel een vleugje gedistingeerde koketterie. Deze details, geïnspireerd op de verfijning uit die tijd, zijn subtiel opvallend terwijl de algehele chromatische harmonie behouden blijft.</p> <p><br>Met de verstelbare, afneembare kousenbanden kun je je outfit compleet maken met je favoriete kousen, apart verkrijgbaar op onze site. Ze passen zich perfect aan je lichaamsvorm aan voor ideale ondersteuning en blijvend comfort gedurende de hele avond.</p> <p><br>Met de <strong>verstelbare bandjes</strong> en de rugverstelling kun je de pasvorm van deze chemise aanpassen aan jouw voorkeuren, zodat je verzekerd bent van een perfecte pasvorm waarin je figuur het beste tot zijn recht komt. Deze aandacht voor <strong>comfort en pasvorm</strong> weerspiegelt een vakmanschap dat een tijdloze esthetiek dient.</p>
guid
stringhttps://dev.divasboudoir.com/nl/babydoll-licht-mauve/sfba3650.htm
highlights
string<ul> <li>Een delicate lavendeltint die je huid verlicht en een onweerstaanbaar romantische sfeer creëert</li> <li>Fijn bewerkt ton sur ton borduurwerk doet denken aan de kostbare ornamenten van weleer</li> <li>Beugelcups voor ideale ondersteuning en harmonieuze bustevergroting</li> <li>Kleine contrasterende strikjes aan de voorkant voegen een vleugje gedistingeerde koketterie toe</li> <li>Verstelbare, afneembare kousenbanden zodat je je favoriete kousen in stijl kunt dragen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze grote maat Alice chemise in lavendel met borduursel en afneembare kousenbanden. Romantische stijl voor verfijnde vrouwelijkheid. Discrete levering!
keywords
string
title
stringRomantische Babydoll Grote Maat Lavendel | Diva's Boudoir
seotitle
stringGrote romantische lavendel kousenbroek chemise
seouri
stringbabydoll-licht-mauve
specifications
string<ul> <li>Samenstelling: Zachte, lichte stof met borduursel</li> <li>Stijl: Romantische babydoll met borduursel en kousenband</li> <li>Cups: Beugel voor optimale ondersteuning</li> <li>Opvallende details : Tweekleurig borduursel, contrasterende strikjes, afneembare kousenbanden</li> <li>Kleur: Delicaat lavendel</li> <li>Pasvorm : Verstelbare bandjes en rugsluiting</li> <li>Accessoires inbegrepen: Bijpassende string en afneembare kousenbanden</li> </ul>
stylingtips
string<p>Voor een intieme avond geïnspireerd op de romances van weleer, combineer je deze chemise met onze fijne voile of kanten kousen die verkrijgbaar zijn op onze site.</p> <p>Parfumeer je huid lichtjes met noten van lavendel of witte bloemen om de romantische sfeer te verlengen. Bereid je slaapkamer voor met een paar geurkaarsen en katoenen lakens van hoge kwaliteit om een omgeving te creëren die de mooiste historische woningen waardig is.</p> <p>Als finishing touch brengen een paar druppels essentiële lavendelolie op je kussen je partner naar een wereld waar verleiding een subtiele en verfijnde kunst is.</p>
summary
string<p>Laat je betoveren door onze Alice chemise, een creatie die zachtheid en verleiding combineert. De delicate lavendeltint, het ton-sur-ton borduurwerk en de contrasterende strikjes roepen de romantiek van een ander tijdperk op.</p> <p>Met beugelcups voor perfecte ondersteuning en afneembare kousenbanden, verbetert dit stuk je figuur terwijl het je meeneemt naar een wereld van gratie en tijdloze vrouwelijkheid.</p>
title
stringLavendel Alice chemise - Romantische verleiding en ouderwetse verfijning
usageinstructions
string<p>Om optimaal van deze chemise te genieten, pas je de bandjes aan je lichaamsvorm aan voor de ideale ondersteuning van je buste. De beugelcups zijn ontworpen om optimale bh te bieden en je decolleté te accentueren.</p> <p>Om je outfit compleet te maken, maak je je favoriete kousen vast aan de verstelbare kousenbanden - onze nude of witte kousen op onze site passen perfect bij dit stuk. De bijpassende string maakt de look compleet voor een volledig gesublimeerd silhouet.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Recomenda-se a lavagem à mão em água fria</li> <li>Utilizar um sabão suave especialmente formulado para lingerie fina</li> <li>Enxaguar bem e centrifugar suavemente sem torcer</li> <li>Secar à sombra para preservar a delicadeza do bordado</li> <li>evitar o contacto com perfumes ou loções que possam alterar o tom de lavanda</li> </ul>
description
string<p>A <strong>camisa de noite Alice</strong> convida-a para um mundo de suavidade e romance intemporal. A sua delicada tonalidade lavanda evoca os jardins ingleses e os interiores requintados de casas históricas, criando uma atmosfera de nostalgia e feminilidade.</p> <p><br>Os bordados tom sobre tom, finamente trabalhados, adornam as copas e o corpo desta peça com uma delicadeza notável. Estes motivos florais evocam os preciosos ornamentos dos enxovais de outrora, acrescentando uma dimensão tátil e visual que convida à contemplação e ao toque.</p> <p><br>As copas com aros são a combinação perfeita de apoio e estética. Estruturam o busto com elegância e oferecem um conforto ótimo. Este design meticuloso reflecte uma abordagem em que a beleza nunca exclui o bem-estar.</p> <p><br>Os <strong>pequenos laços</strong> contrastantes na frente dão um toque de coquetelaria distinta ao conjunto. Estes pormenores, inspirados na elegância da época, chamam subtilmente a atenção, preservando a harmonia cromática geral.</p> <p><br>As ligas ajustáveis e amovíveis permitem-lhe completar o seu conjunto com as suas meias preferidas, disponíveis separadamente no nosso site. Ajustam-se perfeitamente à forma do seu corpo para um apoio ideal e um conforto duradouro durante toda a noite.</p> <p><br>As <strong>alças ajustáveis</strong> e o ajuste nas costas permitem-lhe personalizar o ajuste desta camisa de noite de acordo com as suas preferências, garantindo um ajuste perfeito que irá mostrar a sua figura da melhor forma. Esta atenção ao <strong>conforto e</strong> ao <strong>ajuste</strong> reflecte um trabalho artesanal que serve uma estética intemporal.</p>
guid
stringhttps://dev.divasboudoir.com/pt/babydoll-lilas-claro/sfba3650.htm
highlights
string<ul> <li>Um delicado tom de lavanda que ilumina a sua pele e cria uma atmosfera irresistivelmente romântica</li> <li>Os bordados tom sobre tom finamente trabalhados evocam os preciosos ornamentos de outrora</li> <li>Copas com aros para um apoio ideal e um realce harmonioso do busto</li> <li>Pequenos laços contrastantes à frente dão um toque de coquetismo distinto</li> <li>Ligas ajustáveis e amovíveis para que possa usar as suas meias preferidas com estilo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra a nossa camisa de noite grande Alice em lavanda com bordados e ligas amovíveis. Estilo romântico para uma feminilidade requintada. Entrega discreta!
keywords
string
title
stringBabydoll romântico tamanho grande Lavanda | Diva's Boudoir
seotitle
stringCamisa de noite romântica de lavanda grande
seouri
stringbabydoll-lilas-claro
specifications
string<ul> <li>Composição: Tecido macio e leve com bordados</li> <li>Estilo: Babydoll romântico com bordados e ligas</li> <li>Copas: Com aros para um apoio ótimo</li> <li>Detalhes distintivos : Bordado tom sobre tom, laços em contraste, ligas amovíveis</li> <li>Cor: Lavanda delicada</li> <li>Ajuste : Alças ajustáveis e fecho nas costas</li> <li>Acessórios incluídos: Tanga a condizer e ligas amovíveis</li> </ul>
stylingtips
string<p>Para uma noite íntima inspirada nos romances de outrora, combine esta camisa de noite com as nossas meias de renda ou de voile fino disponíveis no nosso site.</p> <p>Perfume levemente a sua pele com notas de lavanda ou flores brancas para prolongar a atmosfera romântica. Prepare o seu quarto com algumas velas perfumadas e lençóis de algodão de qualidade para criar um ambiente digno das mais belas residências históricas.</p> <p>Para finalizar, algumas gotas de óleo essencial de lavanda na almofada transportarão o seu parceiro para um mundo onde a sedução é uma arte subtil e refinada.</p>
summary
string<p>Deixe-se encantar pela nossa camisa de noite Alice, uma criação que combina suavidade e sedução. A sua delicada tonalidade lavanda, os bordados tom sobre tom e os laços contrastantes evocam o romance de uma outra época.</p> <p>Com copas com aros para uma sustentação perfeita e ligas amovíveis, esta peça realça a sua figura, transportando-a para um mundo de graça e feminilidade intemporal.</p>
title
stringCamisa de noite Lavender Alice - Sedução romântica e requinte à moda antiga
usageinstructions
string<p>Para tirar o máximo partido desta camisa de noite, ajuste as alças à forma do seu corpo para um apoio ideal do busto. As copas com aros foram concebidas para proporcionar um apoio ótimo enquanto realçam o seu decote.</p> <p>Para completar o seu conjunto, prenda as suas meias preferidas às ligas ajustáveis - as nossas meias nude ou brancas disponíveis no nosso site combinam perfeitamente com esta peça. A tanga a condizer completa o look para uma silhueta completamente sublimada.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-helles-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-anoichto-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-light-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mauve-clair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-malva-chiaro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-licht-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-lilas-claro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringMesh & Lace Chemise W/Keyhole - 7697X
netweight
string
nextshipment
stringtoday
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string7ED8B851-30A8-47D9-86A3C6EF02715B3D
promountil
string
rating
stringnone
recorduid
string7ED8B851-30A8-47D9-86A3C6EF02715B3D
reference
stringSFBA3650
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.41 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1038,414,415,416') > 0
and product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
11038XLintlsizewhisperpurpleXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4298-10779-86104-112B-D
24141Xintlsizewhisperpurple1X1X-19999990wpluslingerie1X1X44-4616-1820-2246-4846-4844-4650-5246-4844-46102-11290-95109-117C-E
34152XLintlsizewhisperpurple2XL2XL-19999990wpluslingerie2X2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50112-11995-102117-124D-F
44163Xintlsizewhisperpurple3X3X-19999990wpluslingerie3X3X50-5220-2224-2852-5452-5450-5256-5852-5450-52119-127102-108124-129E-G
sizeranges
stringplus
sizes
string1038,414,415,416
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.31 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 1038
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 414
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 415
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 416
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
17ED8B851-30A8-47D9-86A3C6EF02715B3D6C28A602-6EB4-4F48-A9C9FDFEE133DF801038whisperpurple#E1D6E4XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieB-DXLintlsize58.29170STOCK01000-10000-10all
27ED8B851-30A8-47D9-86A3C6EF02715B3D61ED6767-C497-43DA-ADF0C7E7A07E6200414whisperpurple#E1D6E41X1X44-4616-1820-2246-4846-4844-4650-5246-4844-46wlingerieC-E1Xintlsize58.29170STOCK01000-10000-10all
37ED8B851-30A8-47D9-86A3C6EF02715B3D506C9692-5DE8-4FE2-BC97845384DF484C415whisperpurple#E1D6E42X2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerieD-F2XLintlsize58.29170STOCK01000-10000-10all
47ED8B851-30A8-47D9-86A3C6EF02715B3D5509D5FE-6CEA-497D-B14E008C4439E2F1416whisperpurple#E1D6E43X3X50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerieE-G3Xintlsize58.29170STOCK01000-10000-10all
subcategory
stringbabydoll
supplier
number-1
supplierreference
string7697X
tags
string
themes
stringspring
totalvariations
string
type
stringdefault
unitprice
number58.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 7.53 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 1038
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 414
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 415
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '7ED8B851-30A8-47D9-86A3C6EF02715B3D'
and product_variations.isactive = 1
and product_sizes.id_size = 416
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
16C28A602-6EB4-4F48-A9C9FDFEE133DF801038whisperpurple#E1D6E4XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieB-DXLintlsize58.29170STOCK01000-10000-10-10-10058.2917all
261ED6767-C497-43DA-ADF0C7E7A07E6200414whisperpurple#E1D6E41X1X44-4616-1820-2246-4846-4844-4650-5246-4844-46wlingerieC-E1Xintlsize58.29170STOCK01000-10000-10-10-10058.2917all
3506C9692-5DE8-4FE2-BC97845384DF484C415whisperpurple#E1D6E42X2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerieD-F2XLintlsize58.29170STOCK01000-10000-10-10-10058.2917all
45509D5FE-6CEA-497D-B14E008C4439E2F1416whisperpurple#E1D6E43X3X50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerieE-G3Xintlsize58.29170STOCK01000-10000-10-10-10058.2917all
vatrate
number20
warehouse
string