Women's Fragrances

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'header_extra_info' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'header_top' ORDER BY sort_order

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '11848' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order

Array
(
    [0] => Array
        (
            [layout_module_id] => 293
            [layout_id] => 3
            [code] => category
            [position] => column_left
            [sort_order] => 0
        )

)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '263531' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

Women's Fragrances

Women's Fragrances

Indulge your senses with a wide selection of exquisite Womens Fragrances. Whether youre looking for a signature scent or a new favorite, our collection offers a variety of captivating aromas to suit every taste and preference.

From floral and fruity notes to exotic and woody undertones, these fragrances are designed to enhance your natural allure and leave a lasting impression wherever you go.

Explore our range of Womens Fragrances under the Health & Beauty > Fragrances category and find the perfect scent to express your unique personality.

There are no products to list in this category.

Continue