[Skip to main content](#vessel-content) # Profile for cms4biz ## [![cms4biz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34150-cms4biz "View cms4biz's Profile") **[ Offline](/forum/user/34150-cms4biz)** - **User Type:** User - **Register Date:** 12 Sep 2014 - **Last login:** 11 years 10 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 23:51 - **Posts:** 14 - **Profile views:** 52 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # cms4biz recent posts (14 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/35-orders-management/872470-ordernumber#176433) | [Ordernumber](/forum/35-orders-management/872470-ordernumber#176433 "I want to have a ordernumber like this YYYYMMDD[id order] for example : 20141021001 Y = 2014 MM = 10 DD = 21 ID order -= 001") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 6 days ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/35-orders-management/872470-ordernumber#176457 "Hi, Are you using only this code ? Only the date or you have id too ? If only the date, that can't work because many orders will have the same order number. You have to use the id too.") 12 years 5 days ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:482 | [Last Post](/forum/35-orders-management/872470-ordernumber#176457 "Hi, Are you using only this code ? Only the date or you have id too ? If only the date, that can't work because many orders will have the same order number. You have to use the id too.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 5 days ago | | [](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176431) | [Dropdown fields Title and Country too small](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176431 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : FF32.0.3 The dropdown fields "Title" and "Country" are to small to show any values. If you want to give up different shippig in the check-out step you will get a pop-up screen. In this screen the fields Title and Country are too small to see any value. See attachment") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 6 days ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176459 "Hi, If there is an inline declaration, you can force your css property in the css file thanks to: "!important" like: This will override the inline css property.") 12 years 5 days ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:467 | [Last Post](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176459 "Hi, If there is an inline declaration, you can force your css property in the css file thanks to: "!important" like: This will override the inline css property.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 5 days ago | | [](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176354) | [Dropdown fields Title and Country too small](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176354 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : FF32.0.3 The dropdown fields "Title" and "Country" are to small to show any values. If you want to give up different shippig in the check-out step you will get a pop-up screen. In this screen the fields Title and Country are too small to see any value. See attachment") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 6 days ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176459 "Hi, If there is an inline declaration, you can force your css property in the css file thanks to: "!important" like: This will override the inline css property.") 12 years 5 days ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:467 | [Last Post](/forum/25-install-update/872471-dropdown-fields-title-and-country-too-small#176459 "Hi, If there is an inline declaration, you can force your css property in the css file thanks to: "!important" like: This will override the inline css property.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 5 days ago | | [](/forum/35-orders-management/872470-ordernumber#176353) | [Ordernumber](/forum/35-orders-management/872470-ordernumber#176353 "I want to have a ordernumber like this YYYYMMDD[id order] for example : 20141021001 Y = 2014 MM = 10 DD = 21 ID order -= 001") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 6 days ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/35-orders-management/872470-ordernumber#176457 "Hi, Are you using only this code ? Only the date or you have id too ? If only the date, that can't work because many orders will have the same order number. You have to use the id too.") 12 years 5 days ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:482 | [Last Post](/forum/35-orders-management/872470-ordernumber#176457 "Hi, Are you using only this code ? Only the date or you have id too ? If only the date, that can't work because many orders will have the same order number. You have to use the id too.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 5 days ago | | [](/forum/25-install-update/871979-error-when-i-change-the-price-value#173728) | [Error when i change the price value](/forum/25-install-update/871979-error-when-i-change-the-price-value#173728 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : 32.03 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,b.onderwerp, b.leeftijdsfase, b.lichaamsregio, pprice.price_value FROM anat_hikashop_product_category AS a LEFT JOIN (SELECT * FROM anat_hikashop_product AS product1 LEFT JOIN anat_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN anat_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,9,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_id LEFT JOIN anat_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12,13,357,15,280,18,298,279,22,23,24,25,26,27,28,29,30,320,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,347,53,276,55,300,321,277,278,296,282,299,284,285,286,297,291,292,293,294,295,355,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,322,323,324,325,326,327,348,330,328,329,331,332,333,334,343,341,340,339,345,346,349,350,351,352,353,354,362,358,359,360,361,363,364,2) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') AND ( ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.21 when b.price_currency_id = '1' and b.product_tax_id = '56' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '57' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '58' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '59' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '60' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '61' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '62' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '63' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '64' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '65' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '66' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '67' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '68' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '69' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '70' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '71' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '72' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '73' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '74' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74') then b.price_value end ) >= 1 ) AND ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.21 when b.price_currency_id = '1' and b.product_tax_id = '56' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '57' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '58' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '59' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '60' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '61' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '62' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '63' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '64' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '65' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '66' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '67' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '68' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '69' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '70' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '71' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '72' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '73' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '74' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74') then b.price_value end ) BETWEEN 1 AND 25721 ORDER BY RAND() I got an error when I change the Filter Price. Reproduce: Go to: raddtp.nl/anatomie/index.php?option=com_...standaard&Itemid=197 Just change the value in the slider of the Filter Price. The Click on the button "Filter" The Error appear. However this error doesn't appear when I change the other filter values.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 3 weeks ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/25-install-update/871979-error-when-i-change-the-price-value#173743 "Hi, Please try this fix: hikashop.com/forum/filters-search/870210...-unknown-column.html") 12 years 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:382 | [Last Post](/forum/25-install-update/871979-error-when-i-change-the-price-value#173743 "Hi, Please try this fix: hikashop.com/forum/filters-search/870210...-unknown-column.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 3 weeks ago | | [](/forum/45-filters-search/871841-is-it-possible-to-dynamically-set-the-values#172927) | [Is it possible to dynamically set the values](/forum/45-filters-search/871841-is-it-possible-to-dynamically-set-the-values#172927 "I have create a module to show all products properties from a certain category. All the product properties are filters in this modules. If you click on a product property the result page will be shown. For example Go to url: raddtp.nl/anatomie/index.php?option=com_...lexologie&Itemid=201 On the right side of the page. In this section all the product properties are shown of the category. Click on the word "Volwassene". After you click on the link/filter the result page wil be opened. In this result page there is a filter on the left side. The filteroption "Leeftijdsfase" is set to "volwassene". This is send with a form form the previous page. If you click on the other filters, all the filters values will be shown. This inclused all the product properties/field which will yield no result. I don't want this. I want to programm it i such a manner, that it only show the filtervalues of the previous page. I want to be able te set thee filter values dynamically from with a api or the means. Is this possible and how is it possible. Many thanks in advance.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 1 month ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/45-filters-search/871841-is-it-possible-to-dynamically-set-the-values#172966 "Hi, Here is what I see on your website: take.ms/mJdHh There is nothing on the right of the page and thus I'm not sure what you're talking about as I can't reproduce anything.") 12 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:647 | [Last Post](/forum/45-filters-search/871841-is-it-possible-to-dynamically-set-the-values#172966 "Hi, Here is what I see on your website: take.ms/mJdHh There is nothing on the right of the page and thus I'm not sure what you're talking about as I can't reproduce anything.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 1 month ago | | [](/forum/40-taxes/871802-how-to-filter-on-prices-with-tax#172677) | [How to filter on prices with tax](/forum/40-taxes/871802-how-to-filter-on-prices-with-tax#172677 "It is possible to filter on prices with tax?") Category: [Taxes](/forum/40-taxes "Living in Canada and having troubles configuring your taxes? Come and get some help over there") Topic started 12 years 1 month ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/40-taxes/871802-how-to-filter-on-prices-with-tax#172693 "Hello, Sure, I just tested it and price filters are already applied on prices with tax.") 12 years 1 month ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:723 | [Last Post](/forum/40-taxes/871802-how-to-filter-on-prices-with-tax#172693 "Hello, Sure, I just tested it and price filters are already applied on prices with tax.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 1 month ago | | [](/forum/26-product-category-display/871708-sql-error-in-menu-for-product-listing#172137) | [Sql error in menu for product listing](/forum/26-product-category-display/871708-sql-error-in-menu-for-product-listing#172137 "-- url of the page with the problem -- : www.raddtp.nl/anatomie/index.php?option=...t=listing&Itemid=184 -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : FF 31 -- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'b.lichaamssysteem' in 'field list' SQL=SELECT DISTINCT b.product_id,b.onderwerp, b.leeftijdsfase, b.lichaamssysteem, pprice.price_value FROM anat_hikashop_product_category AS a LEFT JOIN anat_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN anat_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (30) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC I have a many menuitem for a productlisting. I have delete and add custom fields for products after the menuitems are created. How can we solve this problem.") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 12 years 1 month ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/26-product-category-display/871708-sql-error-in-menu-for-product-listing#172141 "Hi, Create these columns in the hikashop_product table via your phpmyadmin and the error will disappear.") 12 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:355 | [Last Post](/forum/26-product-category-display/871708-sql-error-in-menu-for-product-listing#172141 "Hi, Create these columns in the hikashop_product table via your phpmyadmin and the error will disappear.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 1 month ago | | [](/forum/26-product-category-display/871663-categories-from-menu-itemid#171920) | [Categories from menu itemid](/forum/26-product-category-display/871663-categories-from-menu-itemid#171920 "-- url of the page with the problem -- : www.raddtp.nl/anatomie/index.php?option=...t=listing&Itemid=168 -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : FF 31 I'm building a module which has to display all the values of customfields after click on a menuitem of hikashop. For instance I have this url raddtp.nl/anatomie/index.php?option=com_...t=listing&Itemid=214 This is an menuitem of hikashop with a product list from a certain categories. If i clicked this link/menuitem, i want to show a listing of alle values of the custom fields linked to all listed products in this view. I want to retreive the category-id's from this menuitem, but i don't know how to do this. How can i retreive these categories. When I have these categories, i want query directly the databse to get alle customfields data of the related product from the categories. Is there a better way to do is. Is it possible to use a object/class to acces this data more easy? Many thanks in advance.") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 12 years 1 month ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/26-product-category-display/871663-categories-from-menu-itemid#171922 "Hi, The modules are calling the views, so editing the view as Nicolas said will allow you to get the $this->element and so do what you want. The view called is based on the settings of your module, but the view "listing" is always called. Module > Listing view > Listing_xxx view") 12 years 1 month ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:656 | [Last Post](/forum/26-product-category-display/871663-categories-from-menu-itemid#171922 "Hi, The modules are calling the views, so editing the view as Nicolas said will allow you to get the $this->element and so do what you want. The view called is based on the settings of your module, but the view "listing" is always called. Module > Listing view > Listing_xxx view") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 1 month ago | | [](/forum/26-product-category-display/871663-categories-from-menu-itemid#171871) | [Categories from menu itemid](/forum/26-product-category-display/871663-categories-from-menu-itemid#171871 "-- url of the page with the problem -- : www.raddtp.nl/anatomie/index.php?option=...t=listing&Itemid=168 -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : FF 31 I'm building a module which has to display all the values of customfields after click on a menuitem of hikashop. For instance I have this url raddtp.nl/anatomie/index.php?option=com_...t=listing&Itemid=214 This is an menuitem of hikashop with a product list from a certain categories. If i clicked this link/menuitem, i want to show a listing of alle values of the custom fields linked to all listed products in this view. I want to retreive the category-id's from this menuitem, but i don't know how to do this. How can i retreive these categories. When I have these categories, i want query directly the databse to get alle customfields data of the related product from the categories. Is there a better way to do is. Is it possible to use a object/class to acces this data more easy? Many thanks in advance.") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 12 years 1 month ago, by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") [Last Post](/forum/26-product-category-display/871663-categories-from-menu-itemid#171922 "Hi, The modules are calling the views, so editing the view as Nicolas said will allow you to get the $this->element and so do what you want. The view called is based on the settings of your module, but the view "listing" is always called. Module > Listing view > Listing_xxx view") 12 years 1 month ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:3 Views:656 | [Last Post](/forum/26-product-category-display/871663-categories-from-menu-itemid#171922 "Hi, The modules are calling the views, so editing the view as Nicolas said will allow you to get the $this->element and so do what you want. The view called is based on the settings of your module, but the view "listing" is always called. Module > Listing view > Listing_xxx view") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 1 month ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.141 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)