[Skip to main content](#vessel-content) # Discount - discount\_product\_id DB limitation of length ## - **[PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile")** - [![PortobelloDigital's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile") Topic Author - [ Offline](/forum/user/13368-portobellodigital) Less More - Posts: 32 - Thank you received: 2 - - 8 years 7 months ago [\#290262](#290262) by [PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile") *[Discount - discount\_product\_id DB limitation of length](/forum/2-general-talk-about-hikashop/894241-discount-discount-product-id-db-limitation-of-length#290262 "-- HikaShop version -- : 3.4.0 Hi, When working in a CSV who need to be imported via phmymadmin on the "hikashop_discount" table, i noticed there is a limitation on the "discount_product_id" : varchar, 255 length What do you think about that ? In the backend, are the limitation handled ? On my side, i got for exemple 1 line with 355char length of product id(for "discount_product_id"), for now, i gonna split the line...")* was created by *[PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile")* -- HikaShop version -- : 3.4.0 Hi, When working in a CSV who need to be imported via phmymadmin on the "hikashop_discount" table, i noticed there is a limitation on the "discount_product_id" : varchar, 255 length What do you think about that ? In the backend, are the limitation handled ? On my side, i got for exemple 1 line with 355char length of product id(for "discount_product_id"), for now, i gonna split the line... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5NDI0MS1kaXNjb3VudC1kaXNjb3VudC1wcm9kdWN0LWlkLWRiLWxpbWl0YXRpb24tb2YtbGVuZ3RoP3RtcGw9bWFya2Rvd24=) 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: 86358 - Thank you received: 14290 - - 8 years 7 months ago [\#290264](#290264) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount - discount\_product\_id DB limitation of length](/forum/2-general-talk-about-hikashop/894241-discount-discount-product-id-db-limitation-of-length#290264 "-- HikaShop version -- : 3.4.0 Hi, When working in a CSV who need to be imported via phmymadmin on the "hikashop_discount" table, i noticed there is a limitation on the "discount_product_id" : varchar, 255 length What do you think about that ? In the backend, are the limitation handled ? On my side, i got for exemple 1 line with 355char length of product id(for "discount_product_id"), for now, i gonna split the line...")* Hi, You can just change the type of the column to "text" via phpmyadmin if you need more characters. The PHP code in HikaShop doesn't have the limitation. It's only at the MySQL level. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5NDI0MS1kaXNjb3VudC1kaXNjb3VudC1wcm9kdWN0LWlkLWRiLWxpbWl0YXRpb24tb2YtbGVuZ3RoP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile")** - [![PortobelloDigital's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile") Topic Author - [ Offline](/forum/user/13368-portobellodigital) Less More - Posts: 32 - Thank you received: 2 - - 8 years 7 months ago [\#290300](#290300) by [PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile") Replied by *[PortobelloDigital](/forum/user/13368-portobellodigital "View PortobelloDigital's Profile")* on topic *[Discount - discount\_product\_id DB limitation of length](/forum/2-general-talk-about-hikashop/894241-discount-discount-product-id-db-limitation-of-length#290300 "-- HikaShop version -- : 3.4.0 Hi, When working in a CSV who need to be imported via phmymadmin on the "hikashop_discount" table, i noticed there is a limitation on the "discount_product_id" : varchar, 255 length What do you think about that ? In the backend, are the limitation handled ? On my side, i got for exemple 1 line with 355char length of product id(for "discount_product_id"), for now, i gonna split the line...")* Hi, If i change from varchar to mediumtext, what happen on next hikashop update ? If you dont plan to change in your side for a next update (maybe too complicated), i will stick on another way thx for your feedback Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5NDI0MS1kaXNjb3VudC1kaXNjb3VudC1wcm9kdWN0LWlkLWRiLWxpbWl0YXRpb24tb2YtbGVuZ3RoP3RtcGw9bWFya2Rvd24=) 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: 86358 - Thank you received: 14290 - - 8 years 7 months ago [\#290315](#290315) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount - discount\_product\_id DB limitation of length](/forum/2-general-talk-about-hikashop/894241-discount-discount-product-id-db-limitation-of-length#290315 "-- HikaShop version -- : 3.4.0 Hi, When working in a CSV who need to be imported via phmymadmin on the "hikashop_discount" table, i noticed there is a limitation on the "discount_product_id" : varchar, 255 length What do you think about that ? In the backend, are the limitation handled ? On my side, i got for exemple 1 line with 355char length of product id(for "discount_product_id"), for now, i gonna split the line...")* Hi, There is nothing to do for hte next update. It will stay like that. Updates will only add tables and columns if missing, they won't change the type of the columns. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5NDI0MS1kaXNjb3VudC1kaXNjb3VudC1wcm9kdWN0LWlkLWRiLWxpbWl0YXRpb24tb2YtbGVuZ3RoP3RtcGw9bWFya2Rvd24=) 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.053 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)