[Skip to main content](#vessel-content)
# Profile for mydreams
##
[](/forum/user/27087-mydreams "View mydreams's Profile")
**[ Offline](/forum/user/27087-mydreams)**
- **User Type:** User
- **Register Date:** 23 Aug 2013
- **Last login:** 11 months 1 week ago
- **Time Zone:** UTC +0:00
- **Local Time:** 19:59
- **Posts:** 2
- **Profile views:** 25
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# mydreams recent posts (2 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362556) | [Hikashop default variant in database](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362556 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 7.2.24 -- Error-message(debug-mod must be tuned on) -- : Column is_default is not found on table oah2p_hikashop_product Hello, I need some advice on where to find information in the database about whether the variant is the default or not. In the picture I marked what I mean. I need a SQL query that will return 1 if the variant is the default and 0 if the variant is not the default. I can't find that information anywhere in the database, I have searched all the Hikashop database tables. Thanks for advice very much.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 2 years 2 months ago, by [mydreams](/forum/user/27087-mydreams "View mydreams's Profile") [Last Post](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362559 "Hi, As I said, it's not just on MySQL query. If you want to look at what we have to get the default variant, you have two places: - in the backend variants listing we calculate the default variant with the code from the form_variants method of administrator/components/com_hikashop/views/product/view.html.php which loads the data, and the code in the administrator/components/com_hikashop/views/product/tmpl/form_variants.php which calculates the default variant while displaying the table list of variants. - on the product page on the frontend, we load the variants and characteristics data in the show function of components/com_hikashop/views/product/view.html.php and we then call addCharacteristics of administrator/components/com_hikashop/classes/product.php to find the default variant, and order the characteristics and variants properly. It's a lot of code, as we don't just want to know the default variant, but a whole bunch of other things.") 2 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:854 | [Last Post](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362559 "Hi, As I said, it's not just on MySQL query. If you want to look at what we have to get the default variant, you have two places: - in the backend variants listing we calculate the default variant with the code from the form_variants method of administrator/components/com_hikashop/views/product/view.html.php which loads the data, and the code in the administrator/components/com_hikashop/views/product/tmpl/form_variants.php which calculates the default variant while displaying the table list of variants. - on the product page on the frontend, we load the variants and characteristics data in the show function of components/com_hikashop/views/product/view.html.php and we then call addCharacteristics of administrator/components/com_hikashop/classes/product.php to find the default variant, and order the characteristics and variants properly. It's a lot of code, as we don't just want to know the default variant, but a whole bunch of other things.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 2 months ago |
| [](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362548) | [Hikashop default variant in database](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362548 "-- HikaShop version -- : 4.7.0 -- Joomla version -- : 7.2.24 -- Error-message(debug-mod must be tuned on) -- : Column is_default is not found on table oah2p_hikashop_product Hello, I need some advice on where to find information in the database about whether the variant is the default or not. In the picture I marked what I mean. I need a SQL query that will return 1 if the variant is the default and 0 if the variant is not the default. I can't find that information anywhere in the database, I have searched all the Hikashop database tables. Thanks for advice very much.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 2 years 2 months ago, by [mydreams](/forum/user/27087-mydreams "View mydreams's Profile") [Last Post](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362559 "Hi, As I said, it's not just on MySQL query. If you want to look at what we have to get the default variant, you have two places: - in the backend variants listing we calculate the default variant with the code from the form_variants method of administrator/components/com_hikashop/views/product/view.html.php which loads the data, and the code in the administrator/components/com_hikashop/views/product/tmpl/form_variants.php which calculates the default variant while displaying the table list of variants. - on the product page on the frontend, we load the variants and characteristics data in the show function of components/com_hikashop/views/product/view.html.php and we then call addCharacteristics of administrator/components/com_hikashop/classes/product.php to find the default variant, and order the characteristics and variants properly. It's a lot of code, as we don't just want to know the default variant, but a whole bunch of other things.") 2 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:854 | [Last Post](/forum/37-import-export-csv-xls/908479-hikashop-default-variant-in-database#362559 "Hi, As I said, it's not just on MySQL query. If you want to look at what we have to get the default variant, you have two places: - in the backend variants listing we calculate the default variant with the code from the form_variants method of administrator/components/com_hikashop/views/product/view.html.php which loads the data, and the code in the administrator/components/com_hikashop/views/product/tmpl/form_variants.php which calculates the default variant while displaying the table list of variants. - on the product page on the frontend, we load the variants and characteristics data in the show function of components/com_hikashop/views/product/view.html.php and we then call addCharacteristics of administrator/components/com_hikashop/classes/product.php to find the default variant, and order the characteristics and variants properly. It's a lot of code, as we don't just want to know the default variant, but a whole bunch of other things.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 years 2 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.135 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)