[Skip to main content](#vessel-content) # Discount grid various codes and % ## - **[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")** - [![info@ifparts.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Topic Author - [ Offline](/forum/user/26733-info-ifparts-com) Less More - Posts: 45 - Thank you received: 0 - - 13 years 2 months ago [\#120204](#120204) by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120204 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* was created by *[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")* Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 2 months ago [\#120215](#120215) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120215 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Hi, We'll need more information to say anything. What is the format of that grid ? Could you give a complete example ? Are the clients in different user groups already ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")** - [![info@ifparts.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Topic Author - [ Offline](/forum/user/26733-info-ifparts-com) Less More - Posts: 45 - Thank you received: 0 - - 13 years 2 months ago [\#120226](#120226) by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Replied by *[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120226 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Hello Nicolas, Thank you very much for your reaction. I have attached an .xls file with in sheet 1 a part of the pricelist and sheet 2 different discount grids. I have no clients yet (new shop) but I want to make 3 groups. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 2 months ago [\#120230](#120230) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120230 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* It seems that the attachment didn't work. Maybe the format or the size of the files ? Can you try to zip them ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")** - [![info@ifparts.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Topic Author - [ Offline](/forum/user/26733-info-ifparts-com) Less More - Posts: 45 - Thank you received: 0 - - 13 years 2 months ago - 13 years 2 months ago [\#120233](#120233) by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Replied by *[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120233 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* See attachment: Last edit: 13 years 2 months ago by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 2 months ago [\#120241](#120241) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120241 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Here is what I would do from what I understood: First I would create one unpublished category per "discount code" and add the corresponding category for each product. the link between the products and the categories can potentially be added automatically with the mass actions system (menu System>Mass actions). I would then create one discount for each user group and each category so that the discounts will apply automatically to the products prices based on the user group of the current user and the "discount code" category of the product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")** - [![info@ifparts.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Topic Author - [ Offline](/forum/user/26733-info-ifparts-com) Less More - Posts: 45 - Thank you received: 0 - - 13 years 2 months ago [\#120246](#120246) by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Replied by *[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120246 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Hello Nicolas, Thank you for your tip. Are you able to tell me if this solution is also able with the import? See attachment for my current import file: Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 2 months ago [\#120251](#120251) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120251 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Sure. You need to add the unpublished category of each product in the "categories" column of the CSV. You can separate the real category from the unpublished category by a semi colon ; or a pipe | The following user(s) said Thank You: [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")** - [![info@ifparts.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Topic Author - [ Offline](/forum/user/26733-info-ifparts-com) Less More - Posts: 45 - Thank you received: 0 - - 13 years 2 months ago [\#120612](#120612) by [info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile") Replied by *[info@ifparts.com](/forum/user/26733-info-ifparts-com "View info@ifparts.com's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120612 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Hello Nicolas, Are you able how to mention the undescriped category into the csv? Underneath I have added the first lines of the import csv: categories_ordering parent_category categories_image categories product category product category filters.jpg FILTERS product category others.jpg OTHERS product category electrics.jpg ELECTRICS product category rebuild parts.jpg REBUILD PARTS product category belts.jpg BELTS product category fuel system.jpg FUEL SYSTEM product category electronics.jpg ELECTRONICS FILTERS FILTERS Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 2 months ago [\#120646](#120646) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Discount grid various codes and %](/forum/46-discount-coupon/861365-discount-grid-various-codes-and#120646 "Hello We are forced to work with discount codes for example: P = 30% Q = 25% Besides thes discount codes we also want to offer a bigger client a higher level than a small client. Is there a possibility (or plugin) to import this grid? (For 25.000 articles) Greetings Kaz")* Hi there, I think that adding a column category_description should do the job. You can also export our categories/product including a description and see the possible column (it's the best example of a csv for Hikashop). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84NjEzNjUtZGlzY291bnQtZ3JpZC12YXJpb3VzLWNvZGVzLWFuZD90bXBsPW1hcmtkb3du) 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.250 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)