[Skip to main content](#vessel-content)

#  Profile for rndm

##

[![rndm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40094-rndm "View rndm's Profile")

**[ Offline](/forum/user/40094-rndm)**

- **User Type:** User

- **Register Date:** 21 Dec 2015
- **Last login:** 2 years 1 month ago
- **Time Zone:**  UTC +0:00
- **Local Time:** 23:07

- **Posts:** 40
- **Profile views:** 163
- **Thank you received:** 1

- **Gender:** Unknown
- **Birthdate:** Unknown

- Posts

#  rndm's recent posts  (40 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

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/27-checkout/902761-restrictions-for-custom-fields#333802) | [Restrictions for custom fields](/forum/27-checkout/902761-restrictions-for-custom-fields#333802 "-- HikaShop version -- : HikaShop Business 4.4.3 -- Joomla version -- : 3.9.27 -- PHP version -- : 7  Hello! We sell hardware and optional software products to extend hardware capabilities. When customer buys both hardware and software in one order, we don't need any additional information. But sometimes customer buys software item only (so he already has the hardware). In this case we must prompt him for his hardware serial number in order to prepare the software. So I need to create a custom text field to be shown during checkout. I can restrict it to the software category - it's ok. But at the same time I want it to be hidden if there is also a hardware product in the order. Is there any way to do that?..  Thank you!")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 5 years 4 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/27-checkout/902761-restrictions-for-custom-fields#333803 "Hi,  Maybe you could not have a weight for them ? If the &quot;force shipping regardless of weight&quot; setting is activated in the HikaShop configuration is activated, the customers will still have the shipping method selection on the checkout even if the product in the cart doesn't have a weight. Now if you need the weight as your shipping methods need it to calculate the shipping fee, then I'm out of options without coding a custom plugin. So if you can live with it, that's unnecessary.") 5 years 4 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:668 | [Last Post](/forum/27-checkout/902761-restrictions-for-custom-fields#333803 "Hi,  Maybe you could not have a weight for them ? If the &quot;force shipping regardless of weight&quot; setting is activated in the HikaShop configuration is activated, the customers will still have the shipping method selection on the checkout even if the product in the cart doesn't have a weight. Now if you need the weight as your shipping methods need it to calculate the shipping fee, then I'm out of options without coding a custom plugin. So if you can live with it, that's unnecessary.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 4 months ago |
| [](/forum/27-checkout/902761-restrictions-for-custom-fields#333410) | [Restrictions for custom fields](/forum/27-checkout/902761-restrictions-for-custom-fields#333410 "-- HikaShop version -- : HikaShop Business 4.4.3 -- Joomla version -- : 3.9.27 -- PHP version -- : 7  Hello! We sell hardware and optional software products to extend hardware capabilities. When customer buys both hardware and software in one order, we don't need any additional information. But sometimes customer buys software item only (so he already has the hardware). In this case we must prompt him for his hardware serial number in order to prepare the software. So I need to create a custom text field to be shown during checkout. I can restrict it to the software category - it's ok. But at the same time I want it to be hidden if there is also a hardware product in the order. Is there any way to do that?..  Thank you!")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 5 years 4 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/27-checkout/902761-restrictions-for-custom-fields#333803 "Hi,  Maybe you could not have a weight for them ? If the &quot;force shipping regardless of weight&quot; setting is activated in the HikaShop configuration is activated, the customers will still have the shipping method selection on the checkout even if the product in the cart doesn't have a weight. Now if you need the weight as your shipping methods need it to calculate the shipping fee, then I'm out of options without coding a custom plugin. So if you can live with it, that's unnecessary.") 5 years 4 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3  Views:668 | [Last Post](/forum/27-checkout/902761-restrictions-for-custom-fields#333803 "Hi,  Maybe you could not have a weight for them ? If the &quot;force shipping regardless of weight&quot; setting is activated in the HikaShop configuration is activated, the customers will still have the shipping method selection on the checkout even if the product in the cart doesn't have a weight. Now if you need the weight as your shipping methods need it to calculate the shipping fee, then I'm out of options without coding a custom plugin. So if you can live with it, that's unnecessary.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      5 years 4 months ago |
| [](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784) | [Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "-- HikaShop version -- : HikaShop Business 3.1.0  Hello!  I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1.  The only way I found to get it when importing csv was to make two lines for this product like that:  product&#95;code\|product&#95;name\|price&#95;value\|price&#95;access p-br-1\|Bread\|100\|all p-br-1\|Bread\|70\|,10,  And it looks like everything is ok.  The question is: is this way of importing right? Documentation says: &quot;You never need or should have more than one line of information per product in your CSV&quot;.")         Category: [Import &amp; Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here")     Topic started 9 years 5 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") 9 years 5 months ago     by [rndm](/forum/user/40094-rndm "View rndm's Profile") | Replies:4  Views:1540 | [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") by [rndm](/forum/user/40094-rndm "View rndm's Profile")      9 years 5 months ago |
| [](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270723) | [Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270723 "-- HikaShop version -- : HikaShop Business 3.1.0  Hello!  I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1.  The only way I found to get it when importing csv was to make two lines for this product like that:  product&#95;code\|product&#95;name\|price&#95;value\|price&#95;access p-br-1\|Bread\|100\|all p-br-1\|Bread\|70\|,10,  And it looks like everything is ok.  The question is: is this way of importing right? Documentation says: &quot;You never need or should have more than one line of information per product in your CSV&quot;.")         Category: [Import &amp; Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here")     Topic started 9 years 5 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") 9 years 5 months ago     by [rndm](/forum/user/40094-rndm "View rndm's Profile") | Replies:4  Views:1540 | [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") by [rndm](/forum/user/40094-rndm "View rndm's Profile")      9 years 5 months ago |
| [](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270689) | [Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270689 "-- HikaShop version -- : HikaShop Business 3.1.0  Hello!  I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1.  The only way I found to get it when importing csv was to make two lines for this product like that:  product&#95;code\|product&#95;name\|price&#95;value\|price&#95;access p-br-1\|Bread\|100\|all p-br-1\|Bread\|70\|,10,  And it looks like everything is ok.  The question is: is this way of importing right? Documentation says: &quot;You never need or should have more than one line of information per product in your CSV&quot;.")         Category: [Import &amp; Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here")     Topic started 9 years 5 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") 9 years 5 months ago     by [rndm](/forum/user/40094-rndm "View rndm's Profile") | Replies:4  Views:1540 | [Last Post](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "Thanks! I should have thought about double quotes... I'll try it.") by [rndm](/forum/user/40094-rndm "View rndm's Profile")      9 years 5 months ago |
| [](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#269802) | [SQL error after updating to 3.0.1 from 2.6](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#269802 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : The requested page can't be found. Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value' at line 1 SQL=SELECT a.&#42;,b.&#42; FROM j3tb&#95;hikashop&#95;variant AS a LEFT JOIN j3tb&#95;hikashop&#95;characteristic AS b ON a.variant&#95;characteristic&#95;id=b.characteristic&#95;id WHERE a.variant&#95;product&#95;id IN (,,,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value  Hello!  I installed an update to ver. 3. When I used 2.6 everything was perfect. After a short research I found out that this error is displayed only on those pages where shopping cart module is published (when I unpublish the module, this error vanishes). The same error is also displayed on checkout page. Turning legacy options on also gives nothing.  So, I'm now forced to restore site backup with hikashop 2.6. Looking forward to the sollution.  Thanks!")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 9 years 7 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") 9 years 5 months ago     by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")   - [1](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=0 "Page:1") - [2](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20 "Page:2") | Replies:20  Views:6899 | [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")      9 years 5 months ago |
| [](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816) | [Authorize.net TLS Disablement](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816 "Hello there!  I've just recieved a message from authorize.net via email. I just wonder if authorize.net payment plugin supports tls 1.2. And should anything be done to payment plugin configuration?..  &gt;&gt; As you may be aware, new PCI DSS requirements state that all payment systems must disable early TLS by 2018. Transport Layer Security (TLS), is a technology used to encrypt sensitive information sent via the Internet. TLS is the replacement for Secure Sockets Layer (SSL).  In preparation for this requirement, Authorize.Net plans to disable TLS 1.0 and TLS 1.1 on the following dates:  Sandbox: COMPLETE Production: September 18, 2017  We have disabled the sandbox in advance of production to allow you and your developer time to test your website or payment solution and ensure you are no longer using TLS 1.0 or 1.1 prior to September 18th.  Please contact your web developer or payment solution provider, as well as your web hosting company, to confirm that they can support TLS 1.2 for your API connections.  Thanks!")        Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop")     Topic started 9 years 6 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816 "Thank you!") 9 years 6 months ago     by [rndm](/forum/user/40094-rndm "View rndm's Profile") | Replies:2  Views:1155 | [Last Post](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816 "Thank you!") by [rndm](/forum/user/40094-rndm "View rndm's Profile")      9 years 6 months ago |
| [](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268751) | [Authorize.net TLS Disablement](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268751 "Hello there!  I've just recieved a message from authorize.net via email. I just wonder if authorize.net payment plugin supports tls 1.2. And should anything be done to payment plugin configuration?..  &gt;&gt; As you may be aware, new PCI DSS requirements state that all payment systems must disable early TLS by 2018. Transport Layer Security (TLS), is a technology used to encrypt sensitive information sent via the Internet. TLS is the replacement for Secure Sockets Layer (SSL).  In preparation for this requirement, Authorize.Net plans to disable TLS 1.0 and TLS 1.1 on the following dates:  Sandbox: COMPLETE Production: September 18, 2017  We have disabled the sandbox in advance of production to allow you and your developer time to test your website or payment solution and ensure you are no longer using TLS 1.0 or 1.1 prior to September 18th.  Please contact your web developer or payment solution provider, as well as your web hosting company, to confirm that they can support TLS 1.2 for your API connections.  Thanks!")        Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop")     Topic started 9 years 6 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816 "Thank you!") 9 years 6 months ago     by [rndm](/forum/user/40094-rndm "View rndm's Profile") | Replies:2  Views:1155 | [Last Post](/forum/29-payment-methods/890080-authorize-net-tls-disablement#268816 "Thank you!") by [rndm](/forum/user/40094-rndm "View rndm's Profile")      9 years 6 months ago |
| [](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#268162) | [SQL error after updating to 3.0.1 from 2.6](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#268162 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : The requested page can't be found. Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value' at line 1 SQL=SELECT a.&#42;,b.&#42; FROM j3tb&#95;hikashop&#95;variant AS a LEFT JOIN j3tb&#95;hikashop&#95;characteristic AS b ON a.variant&#95;characteristic&#95;id=b.characteristic&#95;id WHERE a.variant&#95;product&#95;id IN (,,,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value  Hello!  I installed an update to ver. 3. When I used 2.6 everything was perfect. After a short research I found out that this error is displayed only on those pages where shopping cart module is published (when I unpublish the module, this error vanishes). The same error is also displayed on checkout page. Turning legacy options on also gives nothing.  So, I'm now forced to restore site backup with hikashop 2.6. Looking forward to the sollution.  Thanks!")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 9 years 7 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") 9 years 5 months ago     by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")   - [1](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=0 "Page:1") - [2](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20 "Page:2") | Replies:20  Views:6899 | [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")      9 years 5 months ago |
| [](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#267909) | [SQL error after updating to 3.0.1 from 2.6](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6#267909 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : The requested page can't be found. Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value' at line 1 SQL=SELECT a.&#42;,b.&#42; FROM j3tb&#95;hikashop&#95;variant AS a LEFT JOIN j3tb&#95;hikashop&#95;characteristic AS b ON a.variant&#95;characteristic&#95;id=b.characteristic&#95;id WHERE a.variant&#95;product&#95;id IN (,,,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic&#95;value  Hello!  I installed an update to ver. 3. When I used 2.6 everything was perfect. After a short research I found out that this error is displayed only on those pages where shopping cart module is published (when I unpublish the module, this error vanishes). The same error is also displayed on checkout page. Turning legacy options on also gives nothing.  So, I'm now forced to restore site backup with hikashop 2.6. Looking forward to the sollution.  Thanks!")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 9 years 7 months ago, by [rndm](/forum/user/40094-rndm "View rndm's Profile")       [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") 9 years 5 months ago     by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")   - [1](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=0 "Page:1") - [2](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20 "Page:2") | Replies:20  Views:6899 | [Last Post](/forum/25-install-update/889671-sql-error-after-updating-to-3-0-1-from-2-6?start=20#269830 "@rndm THANKS!  It WAS AWOcoupon that was causing this error (probably was causing the initial one as well). I always forget that we even have that installed (I don't 'run' the store and discounts, so I forget about them :-) )  Thanks again for mentioning that updating AWO coupon resolved this error for us.") by [cpaschen](/forum/user/12420-cpaschen "View cpaschen's Profile")      9 years 5 months ago |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.061 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
