[Skip to main content](#vessel-content) Board Categories General Talk about HikaShop ## # [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "View Category 'General Talk about HikaShop'") 5224 topics | Suggest your feature requests and ideas for HikaShop | |---| ## | [ ](#forumbottom) | Subject | Replies / Views | Last Post | |---|---|---|---| | [](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles) | [Structured Data / Rich Snippets for Articles](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles "Hi, As far as I could find out HikaShop does NOT support any strutured data natively (and I also did not find any joomla extension which would work with Hikashop). If this assumption is correct could this feature please be implemented in a future version? The idea is to have google use the various information in the HikaShop and displaying them as rich snippets or in the images links in the search results. Thank you!") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 13 years 2 months ago, by [BlueDragon](/forum/user/26889-bluedragon "View BlueDragon's Profile") [Last Post](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles?start=20#274075 "Hello, That thread is two years old. Since the last message ; HikaShop has changed a lot and now includes directly microdata in product page. So please open a new thread and provide the basis information about your website. Regards,") 9 years 3 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") - [1](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles?start=0 "Page:1") - [2](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles?start=20 "Page:2") | Replies:21 Views:9924 | [Last Post](/forum/2-general-talk-about-hikashop/861266-structured-data-rich-snippets-for-articles?start=20#274075 "Hello, That thread is two years old. Since the last message ; HikaShop has changed a lot and now includes directly microdata in product page. So please open a new thread and provide the basis information about your website. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 3 months ago | | [](/forum/2-general-talk-about-hikashop/78984-quickbooks-integration) | [Quickbooks Integration](/forum/2-general-talk-about-hikashop/78984-quickbooks-integration "Can anyone point me in the direction of how to export orders from HikaShop into Quickbooks? Note to HikaShop developers - not having this module is costing you a huge amount of business!") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 13 years 7 months ago, by [martsoh](/forum/user/14306-martsoh "View martsoh's Profile") [Last Post](/forum/2-general-talk-about-hikashop/78984-quickbooks-integration#273101 "Hello, I fixed the URL in the post #93276 Regards,") 9 years 4 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:16 Views:5709 | [Last Post](/forum/2-general-talk-about-hikashop/78984-quickbooks-integration#273101 "Hello, I fixed the URL in the post #93276 Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 4 months ago | | [](/forum/2-general-talk-about-hikashop/890807-multilanguaje-integration) | [Multilanguaje Integration](/forum/2-general-talk-about-hikashop/890807-multilanguaje-integration "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 -- PHP version -- : 7.019 -- Browser(s) name and version -- : all Hi all, I have done many websites with hikashop and lately with multiidioma and it is a nightmare to do with the falang component, it has many restrictions, like translate de personaliced fields. When do you think including Hikashop with the multi-language support of the Joomla core?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 4 months ago, by [cesarlab69](/forum/user/7417-cesarlab69 "View cesarlab69's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890807-multilanguaje-integration#272343 "Hi, It's already possible to use the multi-language support of the Joomla core with HikaShop. We've answered on that a few times already. For example: www.hikashop.com/forum/10-translation/88...hikashop.html#220892 It's however a lot more nightmarish to use than with Falang and that's why we're usually recommending Falang.") 9 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1330 | [Last Post](/forum/2-general-talk-about-hikashop/890807-multilanguaje-integration#272343 "Hi, It's already possible to use the multi-language support of the Joomla core with HikaShop. We've answered on that a few times already. For example: www.hikashop.com/forum/10-translation/88...hikashop.html#220892 It's however a lot more nightmarish to use than with Falang and that's why we're usually recommending Falang.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 4 months ago | | [](/forum/2-general-talk-about-hikashop/890663-slider-in-checkout-show-page) | [Slider in checkout show page](/forum/2-general-talk-about-hikashop/890663-slider-in-checkout-show-page "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.2 hello i want to display payement in slider zone (for less information) i use nonumber slider {slider title="title"} ... {sliders} in checkout / show_block_payment.php but if user change payement page is reloaed by ajax ... and slider isn't render do you have an idea or a solution to keep slider on ajax reload ? use joomla slider api or other ? regards") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 4 months ago, by [micker](/forum/user/105-micker "View micker's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890663-slider-in-checkout-show-page#271859 "Hi, Yes, I did change the payment method (you can see that I have the radio button checked while it's not the default one selected). I tried with Chrome on my end. If you clear your browser cache, do you still have the issue ?") 9 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8 Views:1309 | [Last Post](/forum/2-general-talk-about-hikashop/890663-slider-in-checkout-show-page#271859 "Hi, Yes, I did change the payment method (you can see that I have the radio button checked while it's not the default one selected). I tried with Chrome on my end. If you clear your browser cache, do you still have the issue ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 4 months ago | | [](/forum/2-general-talk-about-hikashop/8255-sample-data) | [Sample Data](/forum/2-general-talk-about-hikashop/8255-sample-data "Is there any sample data bundle for hikashop (including products, images and categories )? I did some basic search and couldn't find any. I think such sample could really help newcomers with HikaShop. Plus, it wouldn't be that hard for you to simply export the data from www.demo.hikashop.com/ . In my case I don't really mind having a .zip (or tarball) of the images and a .sql for the data. However, it would make more sense to make it so it can be used with the "Import products" feature of HikaShop. Is there plan for such sample, or maybe its already available somewhere? Thank you :)") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 15 years 8 months ago, by [kyrotomia](/forum/user/1086-kyrotomia "View kyrotomia's Profile") [Last Post](/forum/2-general-talk-about-hikashop/8255-sample-data#271381 "It's quite weird, but I didn't get the wizard the first install. Uninstalled and dropped all HikaShop tables, and then tried again and this time I got the wizard and sample data. Thanks for confirming it was still supposed to be there.") 9 years 4 months ago by [PolishedGeek](/forum/user/8378-polishedgeek "View PolishedGeek's Profile") | Replies:16 Views:11.4k | [Last Post](/forum/2-general-talk-about-hikashop/8255-sample-data#271381 "It's quite weird, but I didn't get the wizard the first install. Uninstalled and dropped all HikaShop tables, and then tried again and this time I got the wizard and sample data. Thanks for confirming it was still supposed to be there.") by [PolishedGeek](/forum/user/8378-polishedgeek "View PolishedGeek's Profile") 9 years 4 months ago | | [](/forum/2-general-talk-about-hikashop/52444-guest-checkout) | [Guest checkout](/forum/2-general-talk-about-hikashop/52444-guest-checkout "Is it possible for the user to check out as a guest without "registering" in the started version of Hika Shop? This seems like pretty simple usability as most people do not want to register to buy something from a website?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 14 years 5 months ago, by [amarketing](/forum/user/7699-amarketing "View amarketing's Profile") [Last Post](/forum/2-general-talk-about-hikashop/52444-guest-checkout?start=40#270847 "Hi, All the settings to configure a guest checkout are under the Checkout tab of the HikaShop configuration, even in the 2.6.3. You have the "Registration" setting, where you can select "guest". And you have the "display method for registration" where you can select "switcher" so that you can have both "registration" and "guest" selected in the "Registration" setting. If you don't see these options in the Checkout tab, please provide a screenshot of what you see there.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/2-general-talk-about-hikashop/52444-guest-checkout?start=0 "Page:1") - [2](/forum/2-general-talk-about-hikashop/52444-guest-checkout?start=20 "Page:2") - [3](/forum/2-general-talk-about-hikashop/52444-guest-checkout?start=40 "Page:3") | Replies:52 Views:21.5k | [Last Post](/forum/2-general-talk-about-hikashop/52444-guest-checkout?start=40#270847 "Hi, All the settings to configure a guest checkout are under the Checkout tab of the HikaShop configuration, even in the 2.6.3. You have the "Registration" setting, where you can select "guest". And you have the "display method for registration" where you can select "switcher" so that you can have both "registration" and "guest" selected in the "Registration" setting. If you don't see these options in the Checkout tab, please provide a screenshot of what you see there.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/24377-new-feature) | [New feature](/forum/2-general-talk-about-hikashop/24377-new-feature "Hi, I would like to see the option to set the following per product. selling per piece, per m², per m³, per m, per kg... Koen") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 15 years 2 months ago, by [adoewa](/forum/user/3502-adoewa "View adoewa's Profile") [Last Post](/forum/2-general-talk-about-hikashop/24377-new-feature#270582 "Hi, The input box has to be created via the menu Display>Custom fields by creating one of the table "item". And in the plugin settings, you need to enter the column name of the custom field in the "Weight custom field column name" setting, otherwise, the value entered in the custom field will be ignored by the plugin on the cart to recalculate the price of the product. So please check on that.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:9 Views:4141 | [Last Post](/forum/2-general-talk-about-hikashop/24377-new-feature#270582 "Hi, The input box has to be created via the menu Display>Custom fields by creating one of the table "item". And in the plugin settings, you need to enter the column name of the custom field in the "Weight custom field column name" setting, otherwise, the value entered in the custom field will be ignored by the plugin on the cart to recalculate the price of the product. So please check on that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890326-save-the-configuration-file) | [Save the Configuration file](/forum/2-general-talk-about-hikashop/890326-save-the-configuration-file "Sorry for stupid question: But with the HikaShop Starter I can not even change and save the global configuration? When I try to save an error message: No configuration file found and no installation code available. Exiting ...") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 5 months ago, by [testdrive](/forum/user/50310-testdrive "View testdrive's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890326-save-the-configuration-file#270561 "Solved The provider has put in the white list the Mod_Sec rule Now works perfectly Long life at HikaShop") 9 years 5 months ago by [testdrive](/forum/user/50310-testdrive "View testdrive's Profile") | Replies:11 Views:2837 | [Last Post](/forum/2-general-talk-about-hikashop/890326-save-the-configuration-file#270561 "Solved The provider has put in the white list the Mod_Sec rule Now works perfectly Long life at HikaShop") by [testdrive](/forum/user/50310-testdrive "View testdrive's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/16216-add-to-cart-link-and-custom-product-fields) | [Add to cart link and custom product fields.](/forum/2-general-talk-about-hikashop/16216-add-to-cart-link-and-custom-product-fields "In the product screen there is the Add to Cart button which gives displays the following code: Would it be possible to enhance this add to cart link to accept a custom parameter which then gets passed through the checkout process and stored in the cart_product and order_product tables. The requirement is to be able to associate the ordered product with the context where the Add to Cart button was clicked. This would be used during post order processing. The link would then look something like this:") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 15 years 5 months ago, by [brainforge](/forum/user/423-brainforge "View brainforge's Profile") [Last Post](/forum/2-general-talk-about-hikashop/16216-add-to-cart-link-and-custom-product-fields#270382 "Hi, Yes, exactly.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:14 Views:12.2k | [Last Post](/forum/2-general-talk-about-hikashop/16216-add-to-cart-link-and-custom-product-fields#270382 "Hi, Yes, exactly.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890396-request-to-add-bitcoin-payment-method) | [Request to Add Bitcoin Payment Method](/forum/2-general-talk-about-hikashop/890396-request-to-add-bitcoin-payment-method "Hi Nicholas, I wanted to purchase a new Subscription for Hikashop business but discovered you only offer Paypal & Card Payments. I'll prefer to pay by Bitcoin reason been that there's Foreign Currency Restrictions in my Country & most banks have stopped Foreign transactions on their cards & the ones which still accept it have a $100 limit monthly. Hika business is around $110+ & I won't be able to make payment except there's an Alternative like paying via Bitcoin which I can easily do. Pls look into this because many companies have started accepting Bitcoin. The Bitcoin plugin that comes bundled with Hikashop is top notch. I usually use it on my website & its been working very well. I'll be expecting your reply. Thanks") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 5 months ago, by [Lordtech](/forum/user/36982-lordtech "View Lordtech's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890396-request-to-add-bitcoin-payment-method#270319 "Hi, We don't plan on adding bitcoin payments for now on our website. Thank for your feedback. We'll keep that in mind and if we see more need for it, we might do it in the future.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1470 | [Last Post](/forum/2-general-talk-about-hikashop/890396-request-to-add-bitcoin-payment-method#270319 "Hi, We don't plan on adding bitcoin payments for now on our website. Thank for your feedback. We'll keep that in mind and if we see more need for it, we might do it in the future.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop) | [RSS feed in hikashop](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop "hi there i use HikaShop to a website of my ( ) but i wont to have a RSS feed to my page with the products ...you know ... if some guy want to post to a blog my list of products ..just click the RSS button and bang my list of products in her\she site :D in ninja rss ( plugin of joomla) don't appear the hikashop page also somebody how know this stuff pls respond will be very cool to have a RSS button in hikashop page..many feature will be open .. and just for fun :D google index my products in just 1 week :D so hikashop have a good seo ") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 15 years 9 months ago, by [OCTE](/forum/user/609-octe "View OCTE's Profile") [Last Post](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop?start=20#270279 "Thanks Nicolas, could have sworn I looked there and searched the page for "rss", but yep, there it is! Thanks.") 9 years 5 months ago by [NigelPeck](/forum/user/32534-nigelpeck "View NigelPeck's Profile") - [1](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop?start=0 "Page:1") - [2](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop?start=20 "Page:2") | Replies:24 Views:10.1k | [Last Post](/forum/2-general-talk-about-hikashop/5120-rss-feed-in-hikashop?start=20#270279 "Thanks Nicolas, could have sworn I looked there and searched the page for "rss", but yep, there it is! Thanks.") by [NigelPeck](/forum/user/32534-nigelpeck "View NigelPeck's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890316-must-have-a-matching-product-or-they-get-an-error-message) | [must have a matching product or they get an error message](/forum/2-general-talk-about-hikashop/890316-must-have-a-matching-product-or-they-get-an-error-message "1. Thanks I moved this post from Hikaserial category to here. Can I edit this message to have a link or to say something like "return to products page and add the correct product"?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 5 months ago, by [ktn@keystothenet.com](/forum/user/48952-ktn-keystothenet-com "View ktn@keystothenet.com's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890316-must-have-a-matching-product-or-they-get-an-error-message#269869 "Hi, Sure. All the text of the interface and the messages can be modified with translation overrides: www.hikashop.com/download/languages.html#modify Translations can contain links. However, if you want the link to be different based on the product, that would require modifying the code behind it and while it's possible if you're a developer and some free time, there is no easy way to do it.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1255 | [Last Post](/forum/2-general-talk-about-hikashop/890316-must-have-a-matching-product-or-they-get-an-error-message#269869 "Hi, Sure. All the text of the interface and the messages can be modified with translation overrides: www.hikashop.com/download/languages.html#modify Translations can contain links. However, if you want the link to be different based on the product, that would require modifying the code behind it and while it's possible if you're a developer and some free time, there is no easy way to do it.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890058-strange-issue-with-time-out) | [Strange issue with time out...](/forum/2-general-talk-about-hikashop/890058-strange-issue-with-time-out "Hi, I am not 100% sure is it hikashop related but found it mostly happens browsing categories, products or in checkout... The issue is that sometimes when trying to access some page browser stucks with loading. It loads forever and page wont open. It happens for both, front-end and back-end... What helps is to close re-open web browser and go to same page again. It happens randomly. Have searched a lot but cant find the issue. Looked all logs or anything what could help to find the issue. It is not browser related.... Could someone guide me how this can be debugged? Thank you") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 6 months ago, by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890058-strange-issue-with-time-out#269626 "Hi, Yeh, i know... I have updated all components and as for now we had no issues. So it could be fixed i hope. We also had some errors in database.... Thanks for taking your time to replay. Regards") 9 years 5 months ago by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") | Replies:4 Views:1343 | [Last Post](/forum/2-general-talk-about-hikashop/890058-strange-issue-with-time-out#269626 "Hi, Yeh, i know... I have updated all components and as for now we had no issues. So it could be fixed i hope. We also had some errors in database.... Thanks for taking your time to replay. Regards") by [kyratn](/forum/user/38342-kyratn "View kyratn's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890208-is-the-any-rent-modul-to-this-joomla) | [Is the any rent modul to this (joomla)](/forum/2-general-talk-about-hikashop/890208-is-the-any-rent-modul-to-this-joomla "Is the any rent modul to this (joomla)") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 5 months ago, by [knutarn](/forum/user/50168-knutarn "View knutarn's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890208-is-the-any-rent-modul-to-this-joomla#269357 "There isn't.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1581 | [Last Post](/forum/2-general-talk-about-hikashop/890208-is-the-any-rent-modul-to-this-joomla#269357 "There isn't.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/890093-customs-fileds-and-filters-sql-tables) | [Customs fileds and filters, sql tables](/forum/2-general-talk-about-hikashop/890093-customs-fileds-and-filters-sql-tables "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.7.0 -- PHP version -- : 7.1.0 Hi, I got about 50 000 products in my data base and i'm going to add more in future. They are a diffrent group of products and they are have diffrent customs fields to filter data on frontend side Much products means much customs fileds. As i see now all customs fields stored in hikashop_product sql table so as i have a lot of this fields i will got a huge sql hikashop_product table And all product got this fileds but with NULL values - it seems like inconvinient I think it will be better to make speacial customs fileds table in this case So are you going to change something in hikashop architecture or engine to solve this case ?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 5 months ago, by [Bender](/forum/user/38688-bender "View Bender's Profile") [Last Post](/forum/2-general-talk-about-hikashop/890093-customs-fileds-and-filters-sql-tables#268799 "Hi, Thank you for your input. We don't plan on changing that. We're ok with the trade off of having many columns on the product table. It indeed can make the table big when you have a lot of products and a lot of custom product fields, but even in that case, I'm not sure adding a table to store the custom fields will help speed things up as it will add big JOINs between the tables when you want to filter the products on these custom fields (which is the whole point of having custom product fields). I think that there is a much easier way and efficient to improve the database : Make sure that in your custom product fields, you try as much as possible to have integers as values with the text as title. That way, in the database, only the integer number is saved instead of text. Then, in your hikashop_product table, in your database, change the type of these columns to unsigned integer (on even smaller integer types like smallint). You can even add indexes on some of the columns to speed things even further. That will reduce the size of the table a lot since storing an integer way better SQL-wise, and it will also help the filtering queries a lot as conditions on a integer column are much much faster than on a longtext column. Another way you can improve things is to have generic custom fields, so instead of having custom fields like : custom_product_field_for_products_in_category_car and custom_product_field_for_products_in_category_bike, you could have a joint custom field which would be used for both types of products. When you configure filters on the custom fields, you can have the filter configured to be dynamic and limited to one category. So you could create two filters on the same custom field for different categories and have it display different filtering values with a different name. The only issue you're left with there is to change the label of the custom field on the product page to adapt it based on the category but that's only a simple PHP modification in the view. Doing that can reduce a lot the amount of columns you have. With both tricks, that's already a lot you can do without going into complex coding while still keeping the simple architecture we have.") 9 years 5 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1451 | [Last Post](/forum/2-general-talk-about-hikashop/890093-customs-fileds-and-filters-sql-tables#268799 "Hi, Thank you for your input. We don't plan on changing that. We're ok with the trade off of having many columns on the product table. It indeed can make the table big when you have a lot of products and a lot of custom product fields, but even in that case, I'm not sure adding a table to store the custom fields will help speed things up as it will add big JOINs between the tables when you want to filter the products on these custom fields (which is the whole point of having custom product fields). I think that there is a much easier way and efficient to improve the database : Make sure that in your custom product fields, you try as much as possible to have integers as values with the text as title. That way, in the database, only the integer number is saved instead of text. Then, in your hikashop_product table, in your database, change the type of these columns to unsigned integer (on even smaller integer types like smallint). You can even add indexes on some of the columns to speed things even further. That will reduce the size of the table a lot since storing an integer way better SQL-wise, and it will also help the filtering queries a lot as conditions on a integer column are much much faster than on a longtext column. Another way you can improve things is to have generic custom fields, so instead of having custom fields like : custom_product_field_for_products_in_category_car and custom_product_field_for_products_in_category_bike, you could have a joint custom field which would be used for both types of products. When you configure filters on the custom fields, you can have the filter configured to be dynamic and limited to one category. So you could create two filters on the same custom field for different categories and have it display different filtering values with a different name. The only issue you're left with there is to change the label of the custom field on the product page to adapt it based on the category but that's only a simple PHP modification in the view. Doing that can reduce a lot the amount of columns you have. With both tricks, that's already a lot you can do without going into complex coding while still keeping the simple architecture we have.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/72520-custom-field-translation-with-falang) | [Custom Field Translation with Falang](/forum/2-general-talk-about-hikashop/72520-custom-field-translation-with-falang "Hi Nicolas, I translated my site Dutch / English and almost everthing is ok. Translating the custom fields works, but my translated Hikashop Custom Fields do not show in the front end. Must be a small thing I think, but I can't find the solution. Thanks, Roy") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 14 years 6 days ago, by [rockoladeluxe](/forum/user/4009-rockoladeluxe "View rockoladeluxe's Profile") [Last Post](/forum/2-general-talk-about-hikashop/72520-custom-field-translation-with-falang#268540 "Hello, The feature is implemented ; and you should be able to find more recent threads/posts talking about that feature. Regards,") 9 years 6 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:15 Views:6032 | [Last Post](/forum/2-general-talk-about-hikashop/72520-custom-field-translation-with-falang#268540 "Hello, The feature is implemented ; and you should be able to find more recent threads/posts talking about that feature. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 9 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/889988-300-000-products-in-the-database-really) | [300 000 products in the database - really?](/forum/2-general-talk-about-hikashop/889988-300-000-products-in-the-database-really "Hello! To really make the store with 300 000 products on HikaShop?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 6 months ago, by [calebelt](/forum/user/49823-calebelt "View calebelt's Profile") [Last Post](/forum/2-general-talk-about-hikashop/889988-300-000-products-in-the-database-really#268296 "Hi, Sure. I've seen shops made with HikaShop with 10 times than number of products (it was on a big server, and some optimization was required, but in the end, they were able to do it). So 300 000 products is totally possible.") 9 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1032 | [Last Post](/forum/2-general-talk-about-hikashop/889988-300-000-products-in-the-database-really#268296 "Hi, Sure. I've seen shops made with HikaShop with 10 times than number of products (it was on a big server, and some optimization was required, but in the end, they were able to do it). So 300 000 products is totally possible.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/27356-license-questions) | [License questions](/forum/2-general-talk-about-hikashop/27356-license-questions "Hi there, Is there a page to explain the license for Essentials/Business? Do I need a license for each website I set up? If so, what if I have a https area on a http site? Does the license expire? And what if I want to set up a demo site? Would this need another license? Thanks for your help!") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 15 years 2 weeks ago, by [kiwi2b](/forum/user/2098-kiwi2b "View kiwi2b's Profile") [Last Post](/forum/2-general-talk-about-hikashop/27356-license-questions#267939 "OK. Thx.") 9 years 6 months ago by [DCS](/forum/user/49651-dcs "View DCS's Profile") | Replies:10 Views:4429 | [Last Post](/forum/2-general-talk-about-hikashop/27356-license-questions#267939 "OK. Thx.") by [DCS](/forum/user/49651-dcs "View DCS's Profile") 9 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/83985-how-to-change-the-width-of-the-quantity-field) | [How to change the width of the quantity field](/forum/2-general-talk-about-hikashop/83985-how-to-change-the-width-of-the-quantity-field "I have upgraded to the latest HikaShop Business version 2.1.3; is there a way to change the width of the coupon and quantity boxes (they are way too wide)? The site where I am having this problem is: www.rideeasyleather.com/ .") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 13 years 4 months ago, by [turnag](/forum/user/12012-turnag "View turnag's Profile") [Last Post](/forum/2-general-talk-about-hikashop/83985-how-to-change-the-width-of-the-quantity-field#267893 "Yes,your are right and I found that. Thank you very much.") 9 years 6 months ago by [bluetooth](/forum/user/9052-bluetooth "View bluetooth's Profile") | Replies:9 Views:4506 | [Last Post](/forum/2-general-talk-about-hikashop/83985-how-to-change-the-width-of-the-quantity-field#267893 "Yes,your are right and I found that. Thank you very much.") by [bluetooth](/forum/user/9052-bluetooth "View bluetooth's Profile") 9 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server) | [mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 9 years 6 months ago, by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") [Last Post](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267733 "Hi, We got your debug. Here is what we can say out of it: - There are 416 MySQL queries generated for the loading of data on that page. - It only took 0.35 second to run all these MySQL queries. - Out of these 416 queries, HikaShop only accounts for 240 of them. More than 400 queries for one page is a lot. However, they are really fast on your website so the problem with your MySQL server doesn't come from these. So either the problem is on other pages than the one for which you provided the debug, or the slow down isn't MySQL related. Also, a normal page should have about 100 queries provided it's configured properly. Looking at them, it looks like your template (or some other module-related extension) is adding a lot of extra queries on the modules which aren't there normally. And regarding HikaShop, I suppose that it comes from how you configured the listings. There are ways to reduce the number of queries. For example, if you turn off the display of the custom item fields in your listings, the system will remove a lot of the queries on the listings. But even doing all that won't help for your main issue as it apparently comes from something else. Please ask your provider what exactly slows down the server and provide them when the debug file you gave. Because saying it comes from HikaShop without saying what is the problem exactly is like saying there is a bug in Windows without saying where it comes from or how to reproduce it and Microsoft won't be able to do anything in that case. You can even give them the link to this message so that they don't have to analyze the debug file and directly read my conclusions.") 9 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1499 | [Last Post](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267733 "Hi, We got your debug. Here is what we can say out of it: - There are 416 MySQL queries generated for the loading of data on that page. - It only took 0.35 second to run all these MySQL queries. - Out of these 416 queries, HikaShop only accounts for 240 of them. More than 400 queries for one page is a lot. However, they are really fast on your website so the problem with your MySQL server doesn't come from these. So either the problem is on other pages than the one for which you provided the debug, or the slow down isn't MySQL related. Also, a normal page should have about 100 queries provided it's configured properly. Looking at them, it looks like your template (or some other module-related extension) is adding a lot of extra queries on the modules which aren't there normally. And regarding HikaShop, I suppose that it comes from how you configured the listings. There are ways to reduce the number of queries. For example, if you turn off the display of the custom item fields in your listings, the system will remove a lot of the queries on the listings. But even doing all that won't help for your main issue as it apparently comes from something else. Please ask your provider what exactly slows down the server and provide them when the debug file you gave. Because saying it comes from HikaShop without saying what is the problem exactly is like saying there is a bug in Windows without saying where it comes from or how to reproduce it and Microsoft won't be able to do anything in that case. You can even give them the link to this message so that they don't have to analyze the debug file and directly read my conclusions.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 6 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.082 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)