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

#  Profile for Mainzer

##

[![Mainzer's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/splatter_hand.png)](/forum/user/12103-mainzer "View Mainzer's Profile")

**[ Offline](/forum/user/12103-mainzer)**

- **User Type:** User

- **Register Date:** 30 Nov 2012
- **Last login:** 12 years 7 months ago
- **Time Zone:**  UTC +0:00
- **Local Time:** 13:31

- **Posts:** 18
- **Profile views:** 107

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

- Posts

#  Mainzer's recent posts  (18 messages )

All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year     All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/4-how-to/48404-i-need-a-shipping-solution#83375) | [I Need a shipping solution....](/forum/4-how-to/48404-i-need-a-shipping-solution#83375 "OK, I spent hours setting up nearly 80 shipping rules for this client and we still have issues, Nicolas, I need a working solution please! HELP, I'm being driven nuts!! LOL  OK, so the client sells 2 main products, greeting cards and posters.  Greeting cards weigh next to nothing around 25grams on average.  Posters vary in weight from 20g to 100g.  Posters need to be shipped in a tube, these tubes weigh 163g.  Cards, depending on the qty get shipped in a padded envelope or a small box.  Currently, I have the cards weighed in grams, and the posters in KG to separate the shipping rules.  All works perfectly, until you mix products in the cart.  Lets take an example scenario.  2 posters, weighing say 120g (120kg) the freight cost to the USA is $10.50.  Now if they add in say 5 greeting cards, which cannot go into a tube for starters, but really need to be shipped in a package of their own, is probably another shipping cost of maybe $7.50.  There is no way to put cards into a tube, there is no option for the client to start folding posters to go with cards into a large envelope. They JUST have to be separately shipped.  The system is of course calculating the weight based on the massively heavier posters of course, but now she is out of pocket for the postage of the greeting cards.  We also take into account like you have suggested before, the weights of the tubes, and that works fine.  Do you have some sort of shipping solution that can somehow be a happy medium so on the chance that someone buys the two different types of products, she is not always being left out of pocket on freight.  I did tell her when I had finished setting up all the rules for freight, that this would happen, but now that she has tested it herself, she is not happy at all.  HELP!! Put me out of my misery. LOL")        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 14 years 6 months ago, by [bluetonguedesigns](/forum/user/4156-bluetonguedesigns "View bluetonguedesigns's Profile")       [Last Post](/forum/4-how-to/48404-i-need-a-shipping-solution#83515 "Hi,  As I said, it's not possible with the current manual shipping plugin. You have to create a custom plugin, you have to implement it. It would require some development (PHP) skills.  Regards,") 13 years 10 months ago     by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:19  Views:1860 | [Last Post](/forum/4-how-to/48404-i-need-a-shipping-solution#83515 "Hi,  As I said, it's not possible with the current manual shipping plugin. You have to create a custom plugin, you have to implement it. It would require some development (PHP) skills.  Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/48404-i-need-a-shipping-solution#83122) | [I Need a shipping solution....](/forum/4-how-to/48404-i-need-a-shipping-solution#83122 "OK, I spent hours setting up nearly 80 shipping rules for this client and we still have issues, Nicolas, I need a working solution please! HELP, I'm being driven nuts!! LOL  OK, so the client sells 2 main products, greeting cards and posters.  Greeting cards weigh next to nothing around 25grams on average.  Posters vary in weight from 20g to 100g.  Posters need to be shipped in a tube, these tubes weigh 163g.  Cards, depending on the qty get shipped in a padded envelope or a small box.  Currently, I have the cards weighed in grams, and the posters in KG to separate the shipping rules.  All works perfectly, until you mix products in the cart.  Lets take an example scenario.  2 posters, weighing say 120g (120kg) the freight cost to the USA is $10.50.  Now if they add in say 5 greeting cards, which cannot go into a tube for starters, but really need to be shipped in a package of their own, is probably another shipping cost of maybe $7.50.  There is no way to put cards into a tube, there is no option for the client to start folding posters to go with cards into a large envelope. They JUST have to be separately shipped.  The system is of course calculating the weight based on the massively heavier posters of course, but now she is out of pocket for the postage of the greeting cards.  We also take into account like you have suggested before, the weights of the tubes, and that works fine.  Do you have some sort of shipping solution that can somehow be a happy medium so on the chance that someone buys the two different types of products, she is not always being left out of pocket on freight.  I did tell her when I had finished setting up all the rules for freight, that this would happen, but now that she has tested it herself, she is not happy at all.  HELP!! Put me out of my misery. LOL")        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 14 years 6 months ago, by [bluetonguedesigns](/forum/user/4156-bluetonguedesigns "View bluetonguedesigns's Profile")       [Last Post](/forum/4-how-to/48404-i-need-a-shipping-solution#83515 "Hi,  As I said, it's not possible with the current manual shipping plugin. You have to create a custom plugin, you have to implement it. It would require some development (PHP) skills.  Regards,") 13 years 10 months ago     by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:19  Views:1860 | [Last Post](/forum/4-how-to/48404-i-need-a-shipping-solution#83515 "Hi,  As I said, it's not possible with the current manual shipping plugin. You have to create a custom plugin, you have to implement it. It would require some development (PHP) skills.  Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034) | [\[SOLVED\] CSV import - problems with variants](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Hello,  Can anyone help me with this, I don't know what I'm doing wrong. I already read all post related to CSV on this forum but I don't get it.  First I exported csv file from hikashop and start adding products and variants. I use LibreOffice Calc for that. When I made an import it kind of scrambled some variants and prices were not defined. At import is always the message that I have invalid product codes.  After several tries I decided to clean hikashop database and start over again. So I deleted all the products and variants from hikashop backend. In phpmyadmin I deleted the all the rows and Empty the tables (TRUNCATE) of: hikashop&#95;variant, hikashop&#95;product&#95;category, hikashop&#95;product and hikashop&#95;price.  After this I import a new created csv file (please see atached file), with some products and all its variants with prices. I get this notification: &quot;192 products found, 136 products imported, 14 invalid product codes and 42 already existing products.  Why do I have invalid product codes and already existing products? Did I not deleted them all? What do I have to delete more?  Next I export a new csv file (see attachement) and realized it only imports all main products and only the variants of the last main product in the list. Also some cells of the variants have duplicate values:  If you need more info just ask. I'm trying this for 2 days now. Any help is very appreciated.  regards, Mainzer  UPDATE: The &quot;14 invalid product codes&quot; is solved, I found the error. All the other problems remain.")         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 13 years 10 months ago, by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")       [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") 13 years 10 months ago     by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile") | Replies:5  Views:578 | [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83004) | [\[SOLVED\] CSV import - problems with variants](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83004 "Hello,  Can anyone help me with this, I don't know what I'm doing wrong. I already read all post related to CSV on this forum but I don't get it.  First I exported csv file from hikashop and start adding products and variants. I use LibreOffice Calc for that. When I made an import it kind of scrambled some variants and prices were not defined. At import is always the message that I have invalid product codes.  After several tries I decided to clean hikashop database and start over again. So I deleted all the products and variants from hikashop backend. In phpmyadmin I deleted the all the rows and Empty the tables (TRUNCATE) of: hikashop&#95;variant, hikashop&#95;product&#95;category, hikashop&#95;product and hikashop&#95;price.  After this I import a new created csv file (please see atached file), with some products and all its variants with prices. I get this notification: &quot;192 products found, 136 products imported, 14 invalid product codes and 42 already existing products.  Why do I have invalid product codes and already existing products? Did I not deleted them all? What do I have to delete more?  Next I export a new csv file (see attachement) and realized it only imports all main products and only the variants of the last main product in the list. Also some cells of the variants have duplicate values:  If you need more info just ask. I'm trying this for 2 days now. Any help is very appreciated.  regards, Mainzer  UPDATE: The &quot;14 invalid product codes&quot; is solved, I found the error. All the other problems remain.")         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 13 years 10 months ago, by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")       [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") 13 years 10 months ago     by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile") | Replies:5  Views:578 | [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#82995) | [\[SOLVED\] CSV import - problems with variants](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#82995 "Hello,  Can anyone help me with this, I don't know what I'm doing wrong. I already read all post related to CSV on this forum but I don't get it.  First I exported csv file from hikashop and start adding products and variants. I use LibreOffice Calc for that. When I made an import it kind of scrambled some variants and prices were not defined. At import is always the message that I have invalid product codes.  After several tries I decided to clean hikashop database and start over again. So I deleted all the products and variants from hikashop backend. In phpmyadmin I deleted the all the rows and Empty the tables (TRUNCATE) of: hikashop&#95;variant, hikashop&#95;product&#95;category, hikashop&#95;product and hikashop&#95;price.  After this I import a new created csv file (please see atached file), with some products and all its variants with prices. I get this notification: &quot;192 products found, 136 products imported, 14 invalid product codes and 42 already existing products.  Why do I have invalid product codes and already existing products? Did I not deleted them all? What do I have to delete more?  Next I export a new csv file (see attachement) and realized it only imports all main products and only the variants of the last main product in the list. Also some cells of the variants have duplicate values:  If you need more info just ask. I'm trying this for 2 days now. Any help is very appreciated.  regards, Mainzer  UPDATE: The &quot;14 invalid product codes&quot; is solved, I found the error. All the other problems remain.")         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 13 years 10 months ago, by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")       [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") 13 years 10 months ago     by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile") | Replies:5  Views:578 | [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76930-how-to-show-products-on-related-category-under-the#82934) | [How to show products on related category under the](/forum/4-how-to/76930-how-to-show-products-on-related-category-under-the#82934 "How to show products on the same category ONLI under the opened product  1 i have menu which display all the categories 2 click on one of the category 3 click on the product HERE UNDER THE opened PRODUCT i wouldlike to show other products from the same categori  the problem is: i can use menu assigment to show on selected or exept selected sites BUT I DONT HAVE MENU FOR THE PRODUCT THAT I AM IN and if i assign only on the menu that display the category, when i enter the one of categories i have two sets of same products  HOW CAN ASSIGN OTHER PRODUCTS FROM same CATEGORY onli UNDR THE opened PRODUCT THAT I DISPLAY?  SORRY I,M NEW IN THIS  10X")         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 13 years 10 months ago, by [laia](/forum/user/12456-laia "View laia's Profile")       [Last Post](/forum/4-how-to/76930-how-to-show-products-on-related-category-under-the#82934 "Hi,  I'm new at this too, but did you tried in the backend product page the &quot;related product&quot; feature?") 13 years 10 months ago     by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile") | Replies:1  Views:772 | [Last Post](/forum/4-how-to/76930-how-to-show-products-on-related-category-under-the#82934 "Hi,  I'm new at this too, but did you tried in the backend product page the &quot;related product&quot; feature?") by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#82932) | [\[SOLVED\] CSV import - problems with variants](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#82932 "Hello,  Can anyone help me with this, I don't know what I'm doing wrong. I already read all post related to CSV on this forum but I don't get it.  First I exported csv file from hikashop and start adding products and variants. I use LibreOffice Calc for that. When I made an import it kind of scrambled some variants and prices were not defined. At import is always the message that I have invalid product codes.  After several tries I decided to clean hikashop database and start over again. So I deleted all the products and variants from hikashop backend. In phpmyadmin I deleted the all the rows and Empty the tables (TRUNCATE) of: hikashop&#95;variant, hikashop&#95;product&#95;category, hikashop&#95;product and hikashop&#95;price.  After this I import a new created csv file (please see atached file), with some products and all its variants with prices. I get this notification: &quot;192 products found, 136 products imported, 14 invalid product codes and 42 already existing products.  Why do I have invalid product codes and already existing products? Did I not deleted them all? What do I have to delete more?  Next I export a new csv file (see attachement) and realized it only imports all main products and only the variants of the last main product in the list. Also some cells of the variants have duplicate values:  If you need more info just ask. I'm trying this for 2 days now. Any help is very appreciated.  regards, Mainzer  UPDATE: The &quot;14 invalid product codes&quot; is solved, I found the error. All the other problems remain.")         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 13 years 10 months ago, by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")       [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") 13 years 10 months ago     by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile") | Replies:5  Views:578 | [Last Post](/forum/4-how-to/76936-solved-csv-import-problems-with-variants#83034 "Thank you nicolas,  that was exactly what I needed to know :cheer:") by [Mainzer](/forum/user/12103-mainzer "View Mainzer's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76762-filtered-characteristics#82274) | [Filtered Characteristics?](/forum/4-how-to/76762-filtered-characteristics#82274 "Hi,  Today I was using characteristics and variants for the first time, but I ran into a problem. We want to sell mobile computers (hand terminals) on our webshop, but you can get them with different options. So let's say I have 3 characteristics:  &#42; Scan engine: 1D or 2D  &#42; Camera: Yes or no  &#42; Bluetooth: Yes or no  Now, let's say that all the devices that have a 1D scan engine always have a camera. Then from the moment someone picks &quot;1D&quot; for the scan engine, the camera characteristic should no longer display the &quot;no&quot; option because there simply aren't any devices that meet those criteria.  I hope I made myself clear here. The problem now is that people can pick options that don't exist. Some devices have up to 6 or 7 characteristics with different options, and many combinations lead to a device that's not available. I notice that the &quot;add to cart&quot; button disappears when picking a variant that doesn't exist, so that's good, but ideally people should not be able to choose options that aren't available. I don't think there's any feature in Hikashop that allows you to set up &quot;filtered characteristics&quot; or something; it would make my life a lot easier, as I can't use it the way it is now because there are too many combinations that don't exist.")        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 13 years 10 months ago, by [obsolum](/forum/user/5383-obsolum "View obsolum's Profile")       [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") 13 years 10 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:701 | [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76762-filtered-characteristics#82235) | [Filtered Characteristics?](/forum/4-how-to/76762-filtered-characteristics#82235 "Hi,  Today I was using characteristics and variants for the first time, but I ran into a problem. We want to sell mobile computers (hand terminals) on our webshop, but you can get them with different options. So let's say I have 3 characteristics:  &#42; Scan engine: 1D or 2D  &#42; Camera: Yes or no  &#42; Bluetooth: Yes or no  Now, let's say that all the devices that have a 1D scan engine always have a camera. Then from the moment someone picks &quot;1D&quot; for the scan engine, the camera characteristic should no longer display the &quot;no&quot; option because there simply aren't any devices that meet those criteria.  I hope I made myself clear here. The problem now is that people can pick options that don't exist. Some devices have up to 6 or 7 characteristics with different options, and many combinations lead to a device that's not available. I notice that the &quot;add to cart&quot; button disappears when picking a variant that doesn't exist, so that's good, but ideally people should not be able to choose options that aren't available. I don't think there's any feature in Hikashop that allows you to set up &quot;filtered characteristics&quot; or something; it would make my life a lot easier, as I can't use it the way it is now because there are too many combinations that don't exist.")        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 13 years 10 months ago, by [obsolum](/forum/user/5383-obsolum "View obsolum's Profile")       [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") 13 years 10 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:701 | [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      13 years 10 months ago |
| [](/forum/4-how-to/76762-filtered-characteristics#82221) | [Filtered Characteristics?](/forum/4-how-to/76762-filtered-characteristics#82221 "Hi,  Today I was using characteristics and variants for the first time, but I ran into a problem. We want to sell mobile computers (hand terminals) on our webshop, but you can get them with different options. So let's say I have 3 characteristics:  &#42; Scan engine: 1D or 2D  &#42; Camera: Yes or no  &#42; Bluetooth: Yes or no  Now, let's say that all the devices that have a 1D scan engine always have a camera. Then from the moment someone picks &quot;1D&quot; for the scan engine, the camera characteristic should no longer display the &quot;no&quot; option because there simply aren't any devices that meet those criteria.  I hope I made myself clear here. The problem now is that people can pick options that don't exist. Some devices have up to 6 or 7 characteristics with different options, and many combinations lead to a device that's not available. I notice that the &quot;add to cart&quot; button disappears when picking a variant that doesn't exist, so that's good, but ideally people should not be able to choose options that aren't available. I don't think there's any feature in Hikashop that allows you to set up &quot;filtered characteristics&quot; or something; it would make my life a lot easier, as I can't use it the way it is now because there are too many combinations that don't exist.")        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 13 years 10 months ago, by [obsolum](/forum/user/5383-obsolum "View obsolum's Profile")       [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") 13 years 10 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:701 | [Last Post](/forum/4-how-to/76762-filtered-characteristics#82501 "Having the dropdowns auto update their values on the fly based on other dropdown is not possible with the options in HikaShop. That's not impossible though. That would require some dynamic javascript...") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      13 years 10 months ago |

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

Time to create page: 0.096 seconds

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

[](#top)
