[Skip to main content](#vessel-content) # Pre-Sale Question re Product Options ## - **[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")** - [![shamrockshirts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Topic Author - [ Offline](/forum/user/9674-shamrockshirts) Less More - Posts: 73 - Thank you received: 0 - - 14 years 1 month ago [\#67235](#67235) by [shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") *[Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67235 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* was created by *[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")* I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: [ sictees.com.au/store/green-lantern.html](http://sictees.com.au/store/green-lantern.html) Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 1 month ago [\#67247](#67247) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67247 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* Hi, Yes Hikashop is able to do it by using product's variants, you can for example check this [ web site](http://demo.hikashop.com/) to see what you can do with hikashop. Hope this will help you. The following user(s) said Thank You: [shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")** - [![shamrockshirts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Topic Author - [ Offline](/forum/user/9674-shamrockshirts) Less More - Posts: 73 - Thank you received: 0 - - 14 years 1 month ago - 14 years 1 month ago [\#67466](#67466) by [shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Replied by *[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67466 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* So just having a look at the back end, I want to make sure I understand how this is set up. My design would be the product, then would I set up the Tee, Hoodie & Singlet as options? And within those options, set up the appropriate size and colour as variants? --- Okay, I've just been having a good look through and I think I have my head around it. Does this sound like it is the correct way to set up: Product = Design. Within that product, the Option = T-Shirt. Within that option, the Option = Size. Within that Option the Characteristic = Colour. That way I can set up different size and colour combinations for the original options (ie t-shirt, hoodie, singlet) Is that the right way to do it? Last edit: 14 years 1 month ago by [shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 1 month ago [\#67537](#67537) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67537 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* I didn't really understood but I'll tell you how I think that you should set your product, you should : - Go to "*Hikashop->Products->Characteristics*" - Create 3 new characteristics named T-Shirt Style, Size, Color and add their values - Go to "*Hikashop->Products->Add a product*" - Set your product like you want to - Add your 3 characteristics through your characteristics tab - Then manage your product's variants through the "manage variants" button Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")** - [![shamrockshirts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Topic Author - [ Offline](/forum/user/9674-shamrockshirts) Less More - Posts: 73 - Thank you received: 0 - - 14 years 1 month ago [\#67631](#67631) by [shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile") Replied by *[shamrockshirts](/forum/user/9674-shamrockshirts "View shamrockshirts's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67631 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* No, that wouldn't work because the same sizes and colours are not available for each item. (ie t-shirts have different sizes to hoodies) Also, each item needs to have it's own description. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 1 month ago [\#67704](#67704) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#67704 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* you can manage each variants quantity and description if you want to, then you'll have some variants not available and different descriptions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 8 months ago - 12 years 8 months ago [\#147069](#147069) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#147069 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* Hi i am creat export component and so for me need sample from data base when i go to Hikashop->product->brand_name->product_name in product name have button Manage variants if you click this button turn up table like this |Code | color | shues size | price | Quantity | Published | |code| red | 15 | 10 | 1 | ? | and how i can get this information with sql sample i am try like this $sql = 'SELECT product_code, product_name, product_quantity, characteristic_value FROM i1gmn_hikashop_product, i1gmn_hikashop_variant, i1gmn_hikashop_characteristic WHERE i1gmn_hikashop_product.product_id = i1gmn_hikashop_variant.variant_product_id AND i1gmn_hikashop_variant.variant_characteristic_id = i1gmn_hikashop_characteristic.characteristic_id AND i1gmn_hikashop_product.product_name LIKE "'.$like.'"'; it worked but information shows uncorrect how i can get variant information like this |Code | color | shues size | price | Quantity | Published | |code| red | 15 | 10 | 1 | ? | please can you give me sql code? Last edit: 12 years 8 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 8 months ago [\#147088](#147088) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#147088 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* Hi, What I suggest is to create a massaction via the menu System > Mass action, and create a filter to export the desired content. Then enable the Joomla debug mode, and execute the mass action, you should see the executed requests and that will help you to create your export component. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 8 months ago - 12 years 8 months ago [\#147204](#147204) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#147204 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* Hi thank you i can't creat via menu System > Mass action can you give me just sql code please? Last edit: 12 years 8 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 8 months ago - 12 years 8 months ago [\#147266](#147266) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Pre-Sale Question re Product Options](/forum/2-general-talk-about-hikashop/67235-pre-sale-question-re-product-options#147266 "I am planning on rebuilding my website and am looking for an alternative to Virtuemart. I have several variations of the one product which I need to be able to configure. For example, I need the customer to click on the design they like, which will take then to the product details page. Then I need to have the options in a drop down like, t-shirt, hoodie, singlet, etc. When they click on the t-shirt, I then need them to choose a size and colour (but I only want the sizes and colours that the t-shirt is available in to be displayed). You can see an example of what I mean here: sictees.com.au/store/green-lantern.html Is HikaShop capable of doing this? I'm happy to purchase the business version, but having this capability is absolutely essential. Thanks in advance for your advice.")* Hi, Note that **Mass Actions** are available for all HikaShop versions and available via the menu System>Mass actions. Last edit: 12 years 8 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY3MjM1LXByZS1zYWxlLXF1ZXN0aW9uLXJlLXByb2R1Y3Qtb3B0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)