[Skip to main content](#vessel-content) # Profile for wozzie ## [![wozzie's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26495-wozzie "View wozzie's Profile") **[ Offline](/forum/user/26495-wozzie)** - **User Type:** User - **Register Date:** 11 Aug 2013 - **Last login:** 11 years 4 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 06:38 - **Posts:** 28 - **Profile views:** 151 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # wozzie's recent posts (28 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/25-install-update/877727-import-based-on-mysql#205887) | [Import based on MySQL](/forum/25-install-update/877727-import-based-on-mysql#205887 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 2.5 Hi, We have a seperate MySQL database with > 1000 products inside. Now, we would like to update/import changes made in this database into our Hikashop installation. What would be the best way to accomplish this? Is there an example insert query available to properly populate all the right fields at once? How to insert the correct pricing, link to categories (based on e.g. custom field custom_category). INSERT INTO jos_hikashop_product (product_code, product_name, product_description, product_created, product_type, product_published) SELECT id, naam, omschrijving, UNIX_TIMESTAMP(), 'main', '1' FROM `artikelenlijst` ON DUPLICATE KEY UPDATE product_code = VALUES(product_code), product_name = VALUES(product_name), product_description = VALUES(product_description), Or is there a better approach?") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 4 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/25-install-update/877727-import-based-on-mysql#205956 "Hi, Having a few queries is the most efficient way, especially if you can write them. We don't have examples for that however. prices should be added in the hikashop_price table with the price_product_id containing the id of the product for each price categories should be added in the hikashop_category table, and the links between products and categories should be added in the hikashop_product_category table.") 11 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:665 | [Last Post](/forum/25-install-update/877727-import-based-on-mysql#205956 "Hi, Having a few queries is the most efficient way, especially if you can write them. We don't have examples for that however. prices should be added in the hikashop_price table with the price_product_id containing the id of the product for each price categories should be added in the hikashop_category table, and the links between products and categories should be added in the hikashop_product_category table.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 4 months ago | | [](/forum/2-general-talk-about-hikashop/868557-show-custom-field-in-product-list#157701) | [Show custom field in product list](/forum/2-general-talk-about-hikashop/868557-show-custom-field-in-product-list#157701 "I have created a couple of custom fields, those fields are listed in the product detail page. Now, I would like to show a custom field also in the product list view?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 5 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/2-general-talk-about-hikashop/868557-show-custom-field-in-product-list#157707 "Hello, The solution will probably be to set the "Display custom item fields" option to YES through your Hikashop product listing content menu/module configuration page.") 12 years 5 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:1042 | [Last Post](/forum/2-general-talk-about-hikashop/868557-show-custom-field-in-product-list#157707 "Hello, The solution will probably be to set the "Display custom item fields" option to YES through your Hikashop product listing content menu/module configuration page.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 5 months ago | | [](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157698) | ['Agree with terms' on place product in cart](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157698 "For a few products we would like a customer to agree with additional terms of use. Is there a way we can display an additional terms of use page, popup (or whatever) for specific products? E.g. at the...") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 6 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157710 "Hi, The best solution will be as Nicolas said, to add your 'user has to agree' products in a category, and restrict the display of your 2 other custom fields to this category.") 12 years 5 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:3 Views:1103 | [Last Post](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157710 "Hi, The best solution will be as Nicolas said, to add your 'user has to agree' products in a category, and restrict the display of your 2 other custom fields to this category.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 5 months ago | | [](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153139) | [Only show product or categorie as a filter result](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153139 "The following categorie structure is in place: - A +-- B +-- C +-- D By default we would like to show e.g. only the products listed in A (subcategorie disabled); When a user selects a filter, all products (subcategories included) may be displayed. Is there a possibility we can only display products as a search result instead of default listed?") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 6 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153151 "There is no option to that. You could try to add the code: before: to: in the file "filter" of the view "product" via the menu Display>Views in order to deactivate the dynamicity of the filters when not on the menu item XXX which should be the id of the menu item you configured in your filters module.") 12 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1102 | [Last Post](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153151 "There is no option to that. You could try to add the code: before: to: in the file "filter" of the view "product" via the menu Display>Views in order to deactivate the dynamicity of the filters when not on the menu item XXX which should be the id of the menu item you configured in your filters module.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#152817) | ['Agree with terms' on place product in cart](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#152817 "For a few products we would like a customer to agree with additional terms of use. Is there a way we can display an additional terms of use page, popup (or whatever) for specific products? E.g. at the...") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 6 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157710 "Hi, The best solution will be as Nicolas said, to add your 'user has to agree' products in a category, and restrict the display of your 2 other custom fields to this category.") 12 years 5 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:3 Views:1103 | [Last Post](/forum/2-general-talk-about-hikashop/867553-agree-with-terms-on-place-product-in-cart#157710 "Hi, The best solution will be as Nicolas said, to add your 'user has to agree' products in a category, and restrict the display of your 2 other custom fields to this category.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 5 months ago | | [](/forum/37-import-export-csv-xls/867552-export-to-csv-both-confirmed-and-send#152815) | [Export to csv both 'confirmed' and 'send'](/forum/37-import-export-csv-xls/867552-export-to-csv-both-confirmed-and-send#152815 "When you try to export order history to CSV, you have the ability to apply a filter. Within this filter you can only select 'AND'. We would like to export all orders with status 'Confirmed' or status 'Send'. Can this field be changed to e.g. a multi select?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 6 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/37-import-export-csv-xls/867552-export-to-csv-both-confirmed-and-send#152841 "Hi, that's an interesting idea. We'll change that for next version as that requires several modifications in several files and it definitely not straight forward to apply.") 12 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:826 | [Last Post](/forum/37-import-export-csv-xls/867552-export-to-csv-both-confirmed-and-send#152841 "Hi, that's an interesting idea. We'll change that for next version as that requires several modifications in several files and it definitely not straight forward to apply.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 6 months ago | | [](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#152814) | [Only show product or categorie as a filter result](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#152814 "The following categorie structure is in place: - A +-- B +-- C +-- D By default we would like to show e.g. only the products listed in A (subcategorie disabled); When a user selects a filter, all products (subcategories included) may be displayed. Is there a possibility we can only display products as a search result instead of default listed?") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 6 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153151 "There is no option to that. You could try to add the code: before: to: in the file "filter" of the view "product" via the menu Display>Views in order to deactivate the dynamicity of the filters when not on the menu item XXX which should be the id of the menu item you configured in your filters module.") 12 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1102 | [Last Post](/forum/45-filters-search/867551-only-show-product-or-categorie-as-a-filter-result#153151 "There is no option to that. You could try to add the code: before: to: in the file "filter" of the view "product" via the menu Display>Views in order to deactivate the dynamicity of the filters when not on the menu item XXX which should be the id of the menu item you configured in your filters module.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 6 months ago | | [](/forum/26-product-category-display/865637-only-dispay-product-between-available-from-until#142775) | [Only dispay product between available from / until](/forum/26-product-category-display/865637-only-dispay-product-between-available-from-until#142775 "To make a product available only between date x and date y you can select the ' product available from' and/or 'product available until' option. Outside this period, the product is visible but not selectable. I would like to make the product invisible outside this period. Or, the other way around, the product may only be visible inside the shop between date x and date y. Is this possible?") 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 9 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/26-product-category-display/865637-only-dispay-product-between-available-from-until#142811 "Hi, You'll probably find your answer through this :).") 12 years 9 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:663 | [Last Post](/forum/26-product-category-display/865637-only-dispay-product-between-available-from-until#142811 "Hi, You'll probably find your answer through this :).") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 9 months ago | | [](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#138467) | [Redeem coupon at order create](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#138467 "We would like to redeem a coupon once the order is created or payed, instead of order has been send. A third party application is changing the order status from payed into send, using an mysql query directly; Therefore HikaShop does not redeem the coupon. Or perhaps there is a better solution? (Do we need to use the HikaSerial coupon or the HikaShop coupon during checkout?) Using HikaShop en HikaSerial") Category: [Discount & Coupon](/forum/46-discount-coupon "Increase your sales with our coupon/discount feature") Topic started 12 years 10 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#147229 "Hi, If your problem is not solved, thanks to update HikaShop, some changes have been made regarding the coupons. That will probably help you.") 12 years 8 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:13 Views:1424 | [Last Post](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#147229 "Hi, If your problem is not solved, thanks to update HikaShop, some changes have been made regarding the coupons. That will probably help you.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 8 months ago | | [](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#138261) | [Redeem coupon at order create](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#138261 "We would like to redeem a coupon once the order is created or payed, instead of order has been send. A third party application is changing the order status from payed into send, using an mysql query directly; Therefore HikaShop does not redeem the coupon. Or perhaps there is a better solution? (Do we need to use the HikaSerial coupon or the HikaShop coupon during checkout?) Using HikaShop en HikaSerial") Category: [Discount & Coupon](/forum/46-discount-coupon "Increase your sales with our coupon/discount feature") Topic started 12 years 10 months ago, by [wozzie](/forum/user/26495-wozzie "View wozzie's Profile") [Last Post](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#147229 "Hi, If your problem is not solved, thanks to update HikaShop, some changes have been made regarding the coupons. That will probably help you.") 12 years 8 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:13 Views:1424 | [Last Post](/forum/46-discount-coupon/864538-redeem-coupon-at-order-create#147229 "Hi, If your problem is not solved, thanks to update HikaShop, some changes have been made regarding the coupons. That will probably help you.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 12 years 8 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)