[Skip to main content](#vessel-content) # Product display with Order Sample ## - **[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")** - [![fabricandfringe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Topic Author - [ Offline](/forum/user/16924-fabricandfringe) Less More - Posts: 8 - Thank you received: 0 - - 10 years 6 months ago [\#236011](#236011) by [fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") *[Product display with Order Sample](/forum/26-product-category-display/883744-product-display-with-order-sample#236011 "The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we...")* was created by *[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")* The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we add variants to the product so the "Order Sample" shows, we have to go to a separate page to select the yards. Why can't both buttons reside intact, on the same layout? Also, I need to add the characteristic and variants to the products that don't have it yet. I've tried various ways to set it up in mass action, but have yet to succeed. The products are unloaded from a POS system (using a custom plugin) every 15 minutes. Would be great to massaction add characteristic AND variants to every product. If this can't be done, please identify database tables which need to be set to do this. Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODM3NDQtcHJvZHVjdC1kaXNwbGF5LXdpdGgtb3JkZXItc2FtcGxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 10 years 6 months ago [\#236046](#236046) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product display with Order Sample](/forum/26-product-category-display/883744-product-display-with-order-sample#236046 "The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we...")* Hi, There is no "order sample" button by default in HikaShop, so I'm not entirely sure of what you're talking about. The system doesn't support characteristics or options selection on the listings of products. In only supports that on the product page. So if you activate the display of add to cart buttons on the listings, it will either display the add to cart button if the product doesn't have characteristics/options, or it will display a "choose options" button which will direct to the product page when it does have characteristics or options. Adding that capability on the listing is not impossible, but it would require a huge resources usage increase on the products listing and thus that's why we don't do it because the listing pages would likely crash due to the limitations of resources on the servers. If you really want it, it's always possible to have a developer add that capability. I've seen it added on a few websites with HikaShop before. It's just not simple as it requires a lot of queries to the database and processing that is done on the product page to be done on the listing, and more importantly, the characteristics/options system don't actually supprot being displayed several times on the same page, so it would require modifications of the HTML ids and javascript handling them. There is no system to add characteristics to products through mass actions. But if you have a custom plugin, you can always add your own actions to the mass actions system. You can look at the code of the different plugins with "massaction" in their name and you'll see all the triggers of the mass actions system to add your own triggers/filters/actions to the system. You can virtually do any kind of processing with that as all the mass action system is build to work with plugins. The tables involved are: - hikashop_characteristic where the characteristics and the values are stored - hikashop_product where the products data and the variants data are stored - hikashop_variant which links products/variants with characteristics/characteristic values There, the product has a link with each characteristic attached to it, and the default value of each of these characteristics. And the vairants have a link to each value of characteristic correspoding to them. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODM3NDQtcHJvZHVjdC1kaXNwbGF5LXdpdGgtb3JkZXItc2FtcGxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")** - [![fabricandfringe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Topic Author - [ Offline](/forum/user/16924-fabricandfringe) Less More - Posts: 8 - Thank you received: 0 - - 10 years 6 months ago [\#236070](#236070) by [fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Replied by *[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")* on topic *[Product display with Order Sample](/forum/26-product-category-display/883744-product-display-with-order-sample#236070 "The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we...")* If you look at the link, I had a programmer add the "Sample" button to the page. But you did answer the question and saved tons of time trying to configure the page to what we want ideally. So I imagine it's just a matter of configuring the product page to spec at this point. The programmer mentioned it would be possible to use a "related product" as a sample and have that for every product, but I believe this would double the size of the database and calls unnecessarily. The site already pulls product info and images from the physical store's POS system using a custom plugin, so I will see if the programmer can add that additional function. I thought I could do it from the admin area using massaction but it's fine if I can't do it that way. I guess I haven't been able to find where the values are located in the product table, which is why my efforts are thwarted when I have attempted to add characteristic/variant to all products through the database. I'll look again and see if I can't locate it, now that I know it's there somewhere. Thank you very much for your help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODM3NDQtcHJvZHVjdC1kaXNwbGF5LXdpdGgtb3JkZXItc2FtcGxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")** - [![fabricandfringe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Topic Author - [ Offline](/forum/user/16924-fabricandfringe) Less More - Posts: 8 - Thank you received: 0 - - 10 years 6 months ago [\#236076](#236076) by [fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Replied by *[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")* on topic *[Product display with Order Sample](/forum/26-product-category-display/883744-product-display-with-order-sample#236076 "The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we...")* I added variants to all products using the database. Now it will show "add sample" on the product page, but it displays > Limit reached. You can't add the product: I went back to the same product, and added variants manually, it now works. I compared the product tables, before and after getting the "add sample" to work. They are identical. I compared the variant table, it is the same, before and after. The "characteristic" table hasn't changed either. Is there some hidden table I am not seeing? it is not exactly feasible to add variants to all 8,000 products manually, so I must find a solution within the database. Thank you in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODM3NDQtcHJvZHVjdC1kaXNwbGF5LXdpdGgtb3JkZXItc2FtcGxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")** - [![fabricandfringe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Topic Author - [ Offline](/forum/user/16924-fabricandfringe) Less More - Posts: 8 - Thank you received: 0 - - 10 years 6 months ago [\#236078](#236078) by [fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile") Replied by *[fabricandfringe](/forum/user/16924-fabricandfringe "View fabricandfringe's Profile")* on topic *[Product display with Order Sample](/forum/26-product-category-display/883744-product-display-with-order-sample#236078 "The product is fabric by the yard. The customer also sells small swatches of the fabric. On the page above, we would like to have "Add to Cart" and "Order Sample" buttons. However, it seems when we...")* Nevermind, just answered my own question. I did not realize variations are treated as separate products. So each variation adds a product to the database. Wow. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODM3NDQtcHJvZHVjdC1kaXNwbGF5LXdpdGgtb3JkZXItc2FtcGxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.070 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)