UPDATE `oc_product_description` SET `youtube` =  'http://youtu.be/GrKjC5omE4A';

DELETE FROM `oc_option` WHERE `option_id` = 100;
DELETE FROM `oc_option_description` WHERE `option_id` = 100;
DELETE FROM `oc_option_value` WHERE `option_id` = 100;
DELETE FROM `oc_option_value_description` WHERE `option_id` = 100;
DELETE FROM `oc_product_option` WHERE `option_id` = 100;
DELETE FROM `oc_product_option_value` WHERE `option_id` = 100;

INSERT INTO `oc_option` (`option_id`, `type`, `sort_order`) VALUES
(100, 'image', 1);

INSERT INTO `oc_option_description` (`option_id`, `language_id`, `name`) VALUES
(100, 1, 'Colors');

INSERT INTO `oc_option_value` (`option_value_id`, `option_id`, `image`, `sort_order`) VALUES
(49, 100, 'catalog/colors/blue.jpg', 1),
(50, 100, 'catalog/colors/brown.jpg', 2),
(51, 100, 'catalog/colors/green.jpg', 3),
(52, 100, 'catalog/colors/red.jpg', 4),
(53, 100, 'catalog/colors/violet.jpg', 5);

INSERT INTO `oc_option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`) VALUES
(49, 1, 100, 'blue'),
(50, 1, 100, 'brown'),
(51, 1, 100, 'green'),
(52, 1, 100, 'red'),
(53, 1, 100, 'violet');

DELETE FROM `oc_product_option` WHERE `product_id` = 28;
DELETE FROM `oc_product_option` WHERE `product_id` = 59;
DELETE FROM `oc_product_option` WHERE `product_id` = 115;
DELETE FROM `oc_product_option` WHERE `product_id` = 58;

INSERT INTO `oc_product_option` (`product_option_id`, `product_id`, `option_id`, `value`, `required`) VALUES
(250, 28, 100, '', 1),
(251, 59, 100, '', 1),
(252, 58, 100, '', 1),
(253, 115, 100, '', 1);

DELETE FROM `oc_product_option_value` WHERE `product_id` = 28;
DELETE FROM `oc_product_option_value` WHERE `product_id` = 59;
DELETE FROM `oc_product_option_value` WHERE `product_id` = 115;
DELETE FROM `oc_product_option_value` WHERE `product_id` = 58;

INSERT INTO `oc_product_option_value` (`product_option_value_id`, `product_option_id`, `product_id`, `option_id`, `option_value_id`, `quantity`, `subtract`, `price`, `price_prefix`, `points`, `points_prefix`, `weight`, `weight_prefix`) VALUES
(21, 250, 28, 100, 53, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(20, 250, 28, 100, 52, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(19, 250, 28, 100, 51, 10, 1, '0.0000', '-', 0, '+', '0.00000000', '+'),
(18, 250, 28, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(17, 250, 28, 100, 49, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(22, 251, 59, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(23, 251, 59, 100, 49, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(24, 252, 58, 100, 53, 10, 1, '5.00000000', '+', 0, '+', '0.00000000', '+'),
(25, 252, 58, 100, 52, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(26, 252, 58, 100, 51, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+'),
(27, 252, 58, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(28, 253, 115, 100, 53, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(29, 253, 115, 100, 52, 10, 1, '5.00000000', '+', 0, '+', '0.00000000', '+'),
(30, 253, 115, 100, 51, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+'),
(31, 253, 115, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(32, 253, 115, 100, 49, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+');




<!--product custom block-->
<div class="custom_block">
    <h2 class="aligncenter">PRODUCT CUSTOM BLOCK</h2>
    <p class="aligncenter">You can add your content here, like<br> promotions <br>or some additional info </p>
    <div class="promo_box">
        <div class="pull-left">
            <div class="icon-stack"> <i class="icon-circle icon-stack-base">&nbsp;</i> <i class="icon-gift icon-light">&nbsp;</i> </div>
        </div>
        <span><a href="index.php">Special offer: 1+1=3</a> <a href="3"><br>Get a gift!</a></span>
    </div>
    <div class="promo_box">
        <div class="pull-left">
            <div class="icon-stack"> <i class="icon-circle icon-stack-base"></i> <i class="icon-credit-card icon-light">&nbsp;</i> </div>
        </div>
        <span> <a href="index.php">Free Reward Card</a> <a href="3"><br>Worth $10, $50, $100.</a></span>
    </div>
    <div class="promo_box">
        <div class="pull-left">
            <div class="icon-stack"> <i class="icon-circle icon-stack-base">&nbsp;</i> <i class="icon-group icon-light">&nbsp;</i> </div>
        </div>
        <span> <a href="index.php">Join to our Club</a> </span>
    </div>
    <div class="promo_box">
        <div class="pull-left">
            <div class="icon-stack"> <i class="icon-circle icon-stack-base">&nbsp;</i> <i class="icon-truck icon-flip-horizontal icon-light">&nbsp;</i> </div>
        </div>
        <span><a href="index.php">Free shipping</a></span>
    </div>

</div>
<!--end product custom block-->

<!--post description-->
<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec eros tellus, scelerisque nec, rhoncus eget, laoreet sit amet, nunc. Ut sit amet turpis. In est arcu, sollicitudin eu, vehicula venenatis, tempor vitae, est. Praesent vitae dui. Morbi id tellus. Cum sociis non erat. Suspendisse fermentum posuere lectus. Fusce vulputate nibh egestas orci. Aliquam lectus. Morbi eget dolor ullamcorper massa pellentesque sagittis. Morbi sit amet quam. </p>
<div class="blockquote"><i class="icon-quote-left icon-4x "></i>
    <div>
        <p>Fusce eu dui. Integer vel nibh sit amet turpis vulputate aliquet. Phasellus id nisi vitae odio pretium aliquam. Pellentesque a leo. Donec consequat lectus sed felis. Quisque vestibulum massa. Nulla ornare. Nulla libero. Donec et mi eu massa ultrices scelerisque. Nullam ac nisi non eros gravida v, turpis sollicitudin lobortis pellentesque, libero massa dapibus dui, eu dictum justo urna et mi. Integer dictum est vitae sem. </p>
        <p><span class="color-light">– Mauris aliquet ultricies ante, non faucibus </span></p>
    </div>
</div>
<p>Vestibulum justo. Nulla mauris ipsum, convallis ut, vestibulum eu, tincidunt vel, nisi. Curabitur molestie euismod erat. Proin eros odio, mattis rutrum, pulvinar et, egestas vitae, magna. Integer semper, velit ut interdum malesuada, diam dolor pellentesque lacus, vitae commodo orci nisi et sem. Pellentesque adipiscing nisi. Nulla facilisi. Mauris lacinia lectus sit amet felis. Aliquam erat volutpat. Nulla porttitor tortor at nisl. Nam lectus nulla, bibendum pretium, dictum a, mattis nec, dolor. Nullam id justo sed diam aliquam tincidunt. Duis sollicitudin, dui ac commodo iaculis, mi risus sagittis odio, vel ultrices enim sem ut pede. Aenean quam. Nulla neque purus, ullamcorper nec, eleifend at, fermentum ut, turpis. Mauris et ligula quis erat dignissim imperdiet. Integer ligula magna, dictum et, pulvinar non, ultricies ac, nibh. </p>
<!--end post description-->

<!--blog short description-->
Nullam id justo sed diam aliquam commodo iaculis, mi risus sagittis odio, vel ultrices enim sem ut diam imperdiet. Fusce tincidunt, justo congue egestas molestie. Phasellus id nisi vitae odio pretium aliquam. Integer ligula magna, dictum et, pulvinar non

<!--contact info in dropdown Footer-->
<div>
    <h3>CONTACT INFO</h3>
    <p class="clearfix contact_phone">
        <strong>Contact phone:</strong><br>
        321321321,  321321321
    </p>
    <p class="clearfix contact_cell_phone">
        <strong>CELL phone:</strong><br>
        321321321,  321321321
    </p>
    <p class="clearfix contact_addresses">
        <strong>E-mail addresses:</strong><br>
        <a href="mailto:sales@mydomain.com">sales@mydomain.com</a><br>
        <a href="mailto:info@mydomain.com">info@mydomain.com</a>
    </p>
    <p class="clearfix contact_skype">
        <strong>SKYPE:</strong><br>
        test.shop, shop.test
    </p>
</div>
<!--end contact info in dropdown Footer-->

<!--footer copyright-->
&copy; 2015 DRESSCODE. All Rights Reserved.<br> Designed by <a href="index.php">ETHEMEUK.COM</a><br>