[Skip to main content](#vessel-content) # Profile for ondrejhajnik ## [![ondrejhajnik's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") **[ Offline](/forum/user/12477-ondrejhajnik)** - **User Type:** User - **Register Date:** 21 Dec 2012 - **Last login:** 2 years 3 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 09:07 - **Posts:** 6 - **Profile views:** 49 - **Thank you received:** 1 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # ondrejhajnik's recent posts (6 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/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881) | [An importing problem - product codes and variants](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "I really could use some help/advice about this problem. Here is a snippet showing some product codes from the very small company I'm working with ASU-W60601,salad bowl ,14 cm,,$8.95,White ASU-W60602,salad bowl ,17 cm,,$11.95,White ASU-W60603,salad bowl ,20 cm,,$13.95,White ASU-W60604,salad bowl ,25 cm,,$22.95,White ASU-B60601,salad bowl ,14 cm,,$8.95,Blue ASU-B60602,salad bowl ,17 cm,,$11.95,Blue ASU-B60603,salad bowl ,20 cm,,$13.95,Blue ASU-B60604,salad bowl ,25 cm,,$22.95,Blue The variants are coded in the existing product code - size (last char) and colour (5th char) When I import the products, new product codes are created for the variants which are different from the product codes currently in use. My reason for including the variants in the product file is that I wanted to include images for each of the variants like this. How do I get around this problem? The company is looking for an on-line catalog and, maybe eventually, on-line sales. Jim PS A further question. I don't understand product_parent_codes. They seem to imply that an item with a product_parent_code is an item that cannot be purchased with the product_parent code, just used internally in the program? For example, on your demo site, there are two product codes pink_shoes and pink_shoes_5_22, for the same item. I feel I must be missing something here.") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 15 years 4 months ago, by [Jims](/forum/user/2963-jims "View Jims's Profile") [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") 13 years 1 month ago by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") - [1](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=0 "Page:1") - [2](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20 "Page:2") | Replies:27 Views:2708 | [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") 13 years 1 month ago | | [](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123673) | [An importing problem - product codes and variants](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123673 "I really could use some help/advice about this problem. Here is a snippet showing some product codes from the very small company I'm working with ASU-W60601,salad bowl ,14 cm,,$8.95,White ASU-W60602,salad bowl ,17 cm,,$11.95,White ASU-W60603,salad bowl ,20 cm,,$13.95,White ASU-W60604,salad bowl ,25 cm,,$22.95,White ASU-B60601,salad bowl ,14 cm,,$8.95,Blue ASU-B60602,salad bowl ,17 cm,,$11.95,Blue ASU-B60603,salad bowl ,20 cm,,$13.95,Blue ASU-B60604,salad bowl ,25 cm,,$22.95,Blue The variants are coded in the existing product code - size (last char) and colour (5th char) When I import the products, new product codes are created for the variants which are different from the product codes currently in use. My reason for including the variants in the product file is that I wanted to include images for each of the variants like this. How do I get around this problem? The company is looking for an on-line catalog and, maybe eventually, on-line sales. Jim PS A further question. I don't understand product_parent_codes. They seem to imply that an item with a product_parent_code is an item that cannot be purchased with the product_parent code, just used internally in the program? For example, on your demo site, there are two product codes pink_shoes and pink_shoes_5_22, for the same item. I feel I must be missing something here.") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 15 years 4 months ago, by [Jims](/forum/user/2963-jims "View Jims's Profile") [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") 13 years 1 month ago by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") - [1](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=0 "Page:1") - [2](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20 "Page:2") | Replies:27 Views:2708 | [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") 13 years 1 month ago | | [](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123114) | [An importing problem - product codes and variants](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123114 "I really could use some help/advice about this problem. Here is a snippet showing some product codes from the very small company I'm working with ASU-W60601,salad bowl ,14 cm,,$8.95,White ASU-W60602,salad bowl ,17 cm,,$11.95,White ASU-W60603,salad bowl ,20 cm,,$13.95,White ASU-W60604,salad bowl ,25 cm,,$22.95,White ASU-B60601,salad bowl ,14 cm,,$8.95,Blue ASU-B60602,salad bowl ,17 cm,,$11.95,Blue ASU-B60603,salad bowl ,20 cm,,$13.95,Blue ASU-B60604,salad bowl ,25 cm,,$22.95,Blue The variants are coded in the existing product code - size (last char) and colour (5th char) When I import the products, new product codes are created for the variants which are different from the product codes currently in use. My reason for including the variants in the product file is that I wanted to include images for each of the variants like this. How do I get around this problem? The company is looking for an on-line catalog and, maybe eventually, on-line sales. Jim PS A further question. I don't understand product_parent_codes. They seem to imply that an item with a product_parent_code is an item that cannot be purchased with the product_parent code, just used internally in the program? For example, on your demo site, there are two product codes pink_shoes and pink_shoes_5_22, for the same item. I feel I must be missing something here.") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 15 years 4 months ago, by [Jims](/forum/user/2963-jims "View Jims's Profile") [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") 13 years 1 month ago by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") - [1](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=0 "Page:1") - [2](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20 "Page:2") | Replies:27 Views:2708 | [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") 13 years 1 month ago | | [](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123112) | [An importing problem - product codes and variants](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123112 "I really could use some help/advice about this problem. Here is a snippet showing some product codes from the very small company I'm working with ASU-W60601,salad bowl ,14 cm,,$8.95,White ASU-W60602,salad bowl ,17 cm,,$11.95,White ASU-W60603,salad bowl ,20 cm,,$13.95,White ASU-W60604,salad bowl ,25 cm,,$22.95,White ASU-B60601,salad bowl ,14 cm,,$8.95,Blue ASU-B60602,salad bowl ,17 cm,,$11.95,Blue ASU-B60603,salad bowl ,20 cm,,$13.95,Blue ASU-B60604,salad bowl ,25 cm,,$22.95,Blue The variants are coded in the existing product code - size (last char) and colour (5th char) When I import the products, new product codes are created for the variants which are different from the product codes currently in use. My reason for including the variants in the product file is that I wanted to include images for each of the variants like this. How do I get around this problem? The company is looking for an on-line catalog and, maybe eventually, on-line sales. Jim PS A further question. I don't understand product_parent_codes. They seem to imply that an item with a product_parent_code is an item that cannot be purchased with the product_parent code, just used internally in the program? For example, on your demo site, there are two product codes pink_shoes and pink_shoes_5_22, for the same item. I feel I must be missing something here.") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 15 years 4 months ago, by [Jims](/forum/user/2963-jims "View Jims's Profile") [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") 13 years 1 month ago by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") - [1](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=0 "Page:1") - [2](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20 "Page:2") | Replies:27 Views:2708 | [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") 13 years 1 month ago | | [](/forum/26-product-category-display/861886-cant-see-items-in-a-category#122953) | [can't see items in a category](/forum/26-product-category-display/861886-cant-see-items-in-a-category#122953 "Although i have items in category "accessories" when i clic i see nothing. Here is the link to check it. i send a screenshot too. Sorry for all these posts but i m trying to make it work! :blush:") 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 13 years 1 month ago, by [mpourkos](/forum/user/27156-mpourkos "View mpourkos's Profile") [Last Post](/forum/26-product-category-display/861886-cant-see-items-in-a-category#122972 "Hi, Basically, you need only one "product listing module" that you can assign to several "category listing menus" with any problem. There is an option in the product listing module which allow to synchronize with the current browing menu (so in your case, the browsing category). A category menu allow you to list all sub categories of one category. The user can change the category, selecting a sub-category, seeing the products in the selected category thanks to the product listing module. You can take a look at our demo website too. demo.hikashop.com/index.php?option=com_h...ng&Itemid=89&lang=en In the backend, you can check the different configuration of the category listing menu, seeing the attached modules, etc. Regards,") 13 years 1 month ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:3 Views:324 | [Last Post](/forum/26-product-category-display/861886-cant-see-items-in-a-category#122972 "Hi, Basically, you need only one "product listing module" that you can assign to several "category listing menus" with any problem. There is an option in the product listing module which allow to synchronize with the current browing menu (so in your case, the browsing category). A category menu allow you to list all sub categories of one category. The user can change the category, selecting a sub-category, seeing the products in the selected category thanks to the product listing module. You can take a look at our demo website too. demo.hikashop.com/index.php?option=com_h...ng&Itemid=89&lang=en In the backend, you can check the different configuration of the category listing menu, seeing the attached modules, etc. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 13 years 1 month ago | | [](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#122793) | [An importing problem - product codes and variants](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#122793 "I really could use some help/advice about this problem. Here is a snippet showing some product codes from the very small company I'm working with ASU-W60601,salad bowl ,14 cm,,$8.95,White ASU-W60602,salad bowl ,17 cm,,$11.95,White ASU-W60603,salad bowl ,20 cm,,$13.95,White ASU-W60604,salad bowl ,25 cm,,$22.95,White ASU-B60601,salad bowl ,14 cm,,$8.95,Blue ASU-B60602,salad bowl ,17 cm,,$11.95,Blue ASU-B60603,salad bowl ,20 cm,,$13.95,Blue ASU-B60604,salad bowl ,25 cm,,$22.95,Blue The variants are coded in the existing product code - size (last char) and colour (5th char) When I import the products, new product codes are created for the variants which are different from the product codes currently in use. My reason for including the variants in the product file is that I wanted to include images for each of the variants like this. How do I get around this problem? The company is looking for an on-line catalog and, maybe eventually, on-line sales. Jim PS A further question. I don't understand product_parent_codes. They seem to imply that an item with a product_parent_code is an item that cannot be purchased with the product_parent code, just used internally in the program? For example, on your demo site, there are two product codes pink_shoes and pink_shoes_5_22, for the same item. I feel I must be missing something here.") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 15 years 4 months ago, by [Jims](/forum/user/2963-jims "View Jims's Profile") [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") 13 years 1 month ago by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") - [1](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=0 "Page:1") - [2](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20 "Page:2") | Replies:27 Views:2708 | [Last Post](/forum/4-how-to/19885-an-importing-problem-product-codes-and-variants?start=20#123881 "Hi Jerome, thank you very much for your answer. I am sure I am missing something during data upload to the tables. When I add category of product via back end everything works just fine. When I upload the products via sql query, I do not get them displayed on the front end untill I approach them via back end and click on save button on product page (yes, products are displayed only on back end after sql upload). The tables I use for upload are: hikashop_category hikashop_product hikashop_product_category hikashop_file (for image files) Do I miss any table which I should also alter for proper product display on front end? Thank you, Ondrej Hi Jerome, I found the reason of above behaviour. For proper products listing on front end it is vital to have also the columns "product_created" and "product_modified" load with data. Otherwise the product is only accessible (visible) on back end but not front - end. I believe the same reason applies for categories in breadcrumb. Thank you once again for your help, Ondrej") by [ondrejhajnik](/forum/user/12477-ondrejhajnik "View ondrejhajnik's Profile") 13 years 1 month ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.087 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)