[Skip to main content](#vessel-content) # Profile for khashiz ## [![khashiz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61259-khashiz "View khashiz's Profile") **[ Offline](/forum/user/61259-khashiz)** - **User Type:** User - **Register Date:** 24 Apr 2021 - **Last login:** 1 month 1 week ago - **Time Zone:** UTC +0:00 - **Local Time:** 22:06 - **Posts:** 240 - **Profile views:** 117 - **Thank you received:** 13 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # khashiz recent posts (240 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/26-product-category-display/910789-wrong-related-products#373249) | [Wrong related products](/forum/26-product-category-display/910789-wrong-related-products#373249 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.3 -- PHP version -- : 8.3 Hi my related products module is showing wrong product as you can see in attached filed i have choosed only 2 products as related products ... but the module is showin 5 products and that 2 products are not in this 5 products ! i have also attached my related products module setting what is wrong in my setting?") 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 2 months 3 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") 2 months 1 day ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:397 | [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 1 day ago | | [](/forum/26-product-category-display/910789-wrong-related-products#373234) | [Wrong related products](/forum/26-product-category-display/910789-wrong-related-products#373234 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.3 -- PHP version -- : 8.3 Hi my related products module is showing wrong product as you can see in attached filed i have choosed only 2 products as related products ... but the module is showin 5 products and that 2 products are not in this 5 products ! i have also attached my related products module setting what is wrong in my setting?") 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 2 months 3 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") 2 months 1 day ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:397 | [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 1 day ago | | [](/forum/26-product-category-display/910789-wrong-related-products#373213) | [Wrong related products](/forum/26-product-category-display/910789-wrong-related-products#373213 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.3 -- PHP version -- : 8.3 Hi my related products module is showing wrong product as you can see in attached filed i have choosed only 2 products as related products ... but the module is showin 5 products and that 2 products are not in this 5 products ! i have also attached my related products module setting what is wrong in my setting?") 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 2 months 3 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") 2 months 1 day ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:397 | [Last Post](/forum/26-product-category-display/910789-wrong-related-products#373253 "Hi, Yes, HiakShop allows for selection of unpublished products in the backend. This way, you can prepare products before selling them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 1 day ago | | [](/forum/26-product-category-display/910738-category-display#373030) | [Category display](/forum/26-product-category-display/910738-category-display#373030 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 I have a simple need, i want to have a module to display some categories based on my own selection. isn't it possible in HikaShop ?") 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 3 months 2 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") 2 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:382 | [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 3 weeks ago | | [](/forum/26-product-category-display/910738-category-display#372962) | [Category display](/forum/26-product-category-display/910738-category-display#372962 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 I have a simple need, i want to have a module to display some categories based on my own selection. isn't it possible in HikaShop ?") 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 3 months 2 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") 2 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:382 | [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 3 weeks ago | | [](/forum/26-product-category-display/910738-category-display#372958) | [Category display](/forum/26-product-category-display/910738-category-display#372958 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 I have a simple need, i want to have a module to display some categories based on my own selection. isn't it possible in HikaShop ?") 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 3 months 2 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") 2 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:382 | [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 3 weeks ago | | [](/forum/26-product-category-display/910738-category-display#372955) | [Category display](/forum/26-product-category-display/910738-category-display#372955 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 I have a simple need, i want to have a module to display some categories based on my own selection. isn't it possible in HikaShop ?") 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 3 months 2 days ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") 2 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:382 | [Last Post](/forum/26-product-category-display/910738-category-display#373031 "Hi, The category image is not a column on the category table, which is why your module can read every field except the image. Images are stored in a separate table (hikashop_file), one row per image, linked to the category with file_type = 'category' and file_ref_id = the category id. A category can have several images. So you have two options. 1) Let the category class attach the image for you. When you load the categories through HikaShop's category class, pass its "category_image" argument as true, and each row then carries file_path (plus file_name and file_description): If you hand-pick the categories by id instead of by parent, just load their images yourself and match them on the category id: 2) To display it the way HikaShop does (same resized and cached thumbnail, same img tag), give that file_path to the image helper: That last part is exactly what the default category listing uses (front/views/category/tmpl/listing_img_pane.php), so your module will match the rest of the shop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 2 months 3 weeks ago | | [](/forum/36-reports-statistics/910702-report-with-products#372772) | [Report with products](/forum/36-reports-statistics/910702-report-with-products#372772 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 Hi when i export sales report, i have the information of each order. how can i have the products bought on each order as well ? and is there any way that i can choose which columns to have in csv file ? now the report has all the info which lots of them is not needed. i want to have only the order id, customer namee, price and orders he/she bought for example thank in advance for your help") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 3 months 1 week ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/36-reports-statistics/910702-report-with-products#372776 "Hi, The sales report export is order based and its columns are fixed, so it cannot list the products of each order nor let you pick the columns. For what you want, use a Mass action with a CSV export instead, it lets you choose exactly the columns, and it can output the products of each order. Here is how to set it up: 1) In your HikaShop control panel, open the Mass actions page (System menu, Mass actions) and create a new one. 2) For the area (the table it works on), choose "Order". 3) In the "Actions" area, add an action and choose "Export a csv file". 4) The export action then shows the available columns as checkboxes, grouped by the Order, Order products, Address and User tables. Tick only the ones you need, for example: - Order: order_id (and order_full_price if you want the order total) - Address: address_lastname and address_firstname (the customer name) - Order products: order_product_name, order_product_price, order_product_quantity 5) Tick the "One product per row" option (it appears for the Order area). This is the key part: it exports one line per product of each order, so you get the products bought on each order instead of a single line per order. 6) Choose the format "CSV". You can leave the "Export path" and "To address" fields empty to simply download the file, or fill them to save it on the server and receive it by email. 7) Save the mass action, then run it with the "Process" button to generate and download the CSV. If you only want part of your orders (for instance a date range or a given status), add a filter to the mass action before processing and only the matching orders will be exported.") 3 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:253 | [Last Post](/forum/36-reports-statistics/910702-report-with-products#372776 "Hi, The sales report export is order based and its columns are fixed, so it cannot list the products of each order nor let you pick the columns. For what you want, use a Mass action with a CSV export instead, it lets you choose exactly the columns, and it can output the products of each order. Here is how to set it up: 1) In your HikaShop control panel, open the Mass actions page (System menu, Mass actions) and create a new one. 2) For the area (the table it works on), choose "Order". 3) In the "Actions" area, add an action and choose "Export a csv file". 4) The export action then shows the available columns as checkboxes, grouped by the Order, Order products, Address and User tables. Tick only the ones you need, for example: - Order: order_id (and order_full_price if you want the order total) - Address: address_lastname and address_firstname (the customer name) - Order products: order_product_name, order_product_price, order_product_quantity 5) Tick the "One product per row" option (it appears for the Order area). This is the key part: it exports one line per product of each order, so you get the products bought on each order instead of a single line per order. 6) Choose the format "CSV". You can leave the "Export path" and "To address" fields empty to simply download the file, or fill them to save it on the server and receive it by email. 7) Save the mass action, then run it with the "Process" button to generate and download the CSV. If you only want part of your orders (for instance a date range or a given status), add a filter to the mass action before processing and only the matching orders will be exported.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 months 1 week ago | | [](/forum/25-install-update/910664-custom-field-value-for-variants#372584) | [custom field value for variants](/forum/25-install-update/910664-custom-field-value-for-variants#372584 "-- HikaShop version -- : 6.5.1 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 hi i have several products and variants. I also have a custom field called seller percent celler percent field is filled for all main products, but not for variants. i want to set the value of this field for variants, equal to its parent main product") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 months 3 weeks ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/25-install-update/910664-custom-field-value-for-variants#372587 "Hi, The inheritance I mentioned is only a display-time fallback: when the variant's custom field is empty, HikaShop reads the main product's value on the fly to show it on the frontend. It never writes that value to the variant's own row, so if you read the database directly you'll still find the field empty on the variants. Product custom fields are stored as columns of the hikashop_product table, and variants are rows of that same table (with product_parent_id pointing to the main product). So the column already exists on your variant rows, it's just not filled. Two solutions: 1) A one-time (or scheduled) SQL query copying the value from the parent to the empty variants. Replace seller_percent with the real column name of your field (its "Column name" in the field configuration, not the label): 2) Since your plugin already grabs the products from the database, the cleaner option is to do the fallback there: when a variant's field is empty, read the value from its product_parent_id row. This mirrors what HikaShop does and stays correct even when the main product's value changes later, whereas the SQL copy above is a snapshot that goes stale if you edit the main product afterwards. I would recommend you go for option 2. That's the clean, long-term solution.") 3 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:271 | [Last Post](/forum/25-install-update/910664-custom-field-value-for-variants#372587 "Hi, The inheritance I mentioned is only a display-time fallback: when the variant's custom field is empty, HikaShop reads the main product's value on the fly to show it on the frontend. It never writes that value to the variant's own row, so if you read the database directly you'll still find the field empty on the variants. Product custom fields are stored as columns of the hikashop_product table, and variants are rows of that same table (with product_parent_id pointing to the main product). So the column already exists on your variant rows, it's just not filled. Two solutions: 1) A one-time (or scheduled) SQL query copying the value from the parent to the empty variants. Replace seller_percent with the real column name of your field (its "Column name" in the field configuration, not the label): 2) Since your plugin already grabs the products from the database, the cleaner option is to do the fallback there: when a variant's field is empty, read the value from its product_parent_id row. This mirrors what HikaShop does and stays correct even when the main product's value changes later, whereas the SQL copy above is a snapshot that goes stale if you edit the main product afterwards. I would recommend you go for option 2. That's the clean, long-term solution.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 months 3 weeks ago | | [](/forum/25-install-update/910664-custom-field-value-for-variants#372580) | [custom field value for variants](/forum/25-install-update/910664-custom-field-value-for-variants#372580 "-- HikaShop version -- : 6.5.1 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 hi i have several products and variants. I also have a custom field called seller percent celler percent field is filled for all main products, but not for variants. i want to set the value of this field for variants, equal to its parent main product") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 months 3 weeks ago, by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") [Last Post](/forum/25-install-update/910664-custom-field-value-for-variants#372587 "Hi, The inheritance I mentioned is only a display-time fallback: when the variant's custom field is empty, HikaShop reads the main product's value on the fly to show it on the frontend. It never writes that value to the variant's own row, so if you read the database directly you'll still find the field empty on the variants. Product custom fields are stored as columns of the hikashop_product table, and variants are rows of that same table (with product_parent_id pointing to the main product). So the column already exists on your variant rows, it's just not filled. Two solutions: 1) A one-time (or scheduled) SQL query copying the value from the parent to the empty variants. Replace seller_percent with the real column name of your field (its "Column name" in the field configuration, not the label): 2) Since your plugin already grabs the products from the database, the cleaner option is to do the fallback there: when a variant's field is empty, read the value from its product_parent_id row. This mirrors what HikaShop does and stays correct even when the main product's value changes later, whereas the SQL copy above is a snapshot that goes stale if you edit the main product afterwards. I would recommend you go for option 2. That's the clean, long-term solution.") 3 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:271 | [Last Post](/forum/25-install-update/910664-custom-field-value-for-variants#372587 "Hi, The inheritance I mentioned is only a display-time fallback: when the variant's custom field is empty, HikaShop reads the main product's value on the fly to show it on the frontend. It never writes that value to the variant's own row, so if you read the database directly you'll still find the field empty on the variants. Product custom fields are stored as columns of the hikashop_product table, and variants are rows of that same table (with product_parent_id pointing to the main product). So the column already exists on your variant rows, it's just not filled. Two solutions: 1) A one-time (or scheduled) SQL query copying the value from the parent to the empty variants. Replace seller_percent with the real column name of your field (its "Column name" in the field configuration, not the label): 2) Since your plugin already grabs the products from the database, the cleaner option is to do the fallback there: when a variant's field is empty, read the value from its product_parent_id row. This mirrors what HikaShop does and stays correct even when the main product's value changes later, whereas the SQL copy above is a snapshot that goes stale if you edit the main product afterwards. I would recommend you go for option 2. That's the clean, long-term solution.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 months 3 weeks ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.074 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)