[Skip to main content](#vessel-content) # how do you change multiple prices ## - **[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")** - [![itye2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8062-itye2012 "View itye2012's Profile") Topic Author - [ Offline](/forum/user/8062-itye2012) Less More - Posts: 115 - Thank you received: 0 - - 14 years 2 months ago [\#61818](#61818) by [itye2012](/forum/user/8062-itye2012 "View itye2012's Profile") *[how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61818 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* was created by *[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")* i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 2 months ago [\#61821](#61821) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61821 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* Export all your products into a CSV file. Hikashop--> Products Menu-->Products --> Export Increase prices in Excel. Import file back into HS. Hikashop--> Products Menu--> Import Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")** - [![itye2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8062-itye2012 "View itye2012's Profile") Topic Author - [ Offline](/forum/user/8062-itye2012) Less More - Posts: 115 - Thank you received: 0 - - 14 years 2 months ago [\#61840](#61840) by [itye2012](/forum/user/8062-itye2012 "View itye2012's Profile") Replied by *[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61840 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* many thanks for your reply Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")** - [![itye2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8062-itye2012 "View itye2012's Profile") Topic Author - [ Offline](/forum/user/8062-itye2012) Less More - Posts: 115 - Thank you received: 0 - - 14 years 2 months ago [\#61841](#61841) by [itye2012](/forum/user/8062-itye2012 "View itye2012's Profile") Replied by *[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61841 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* i tried to open in excel but cant see the prices, also what is the best way to read it in excel as when file opened seems very difficult to read thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 2 months ago [\#61842](#61842) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61842 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* Depends which version of Excel you have. I find it best with 2010 version to name your download file <whatever>.txt and then use the open dialogue. That starts the wizard and you can select whatever character your columns are delimited by. There are many many columns but it shouldn't be hard to read. You are looking for the price column (can't remember exact name). Column headers are in first row. This is the UNTAXED price. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")** - [![itye2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8062-itye2012 "View itye2012's Profile") Topic Author - [ Offline](/forum/user/8062-itye2012) Less More - Posts: 115 - Thank you received: 0 - - 14 years 2 months ago [\#61844](#61844) by [itye2012](/forum/user/8062-itye2012 "View itye2012's Profile") Replied by *[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61844 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* Excellent thanks . It worked. Rather than just double click to let excel open up file I did the following: 1) I launched excel 2007 then clicked Data TAB 2) Clicked "From Text" Icon (3rd from left) 3) Clicked Delimited 4) Selected semicolon as delimiter 5) Selected General as column data format 6) Clicked OK Seemed to work okay Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")** - [![itye2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8062-itye2012 "View itye2012's Profile") Topic Author - [ Offline](/forum/user/8062-itye2012) Less More - Posts: 115 - Thank you received: 0 - - 14 years 2 months ago [\#61845](#61845) by [itye2012](/forum/user/8062-itye2012 "View itye2012's Profile") Replied by *[itye2012](/forum/user/8062-itye2012 "View itye2012's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61845 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* another question...where can you see in hikashop what delimiter is used for the export file? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 2 months ago [\#61953](#61953) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how do you change multiple prices](/forum/2-general-talk-about-hikashop/61818-how-do-you-change-multiple-prices#61953 "i have about 2000 products and i need to increase all the prices by about 5% on each product , Rather than click into each product and do them one by one is there a faster way to do this?")* It's the option "CSV separator" in the tab "Files/Images" of the configuration Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxODE4LWhvdy1kby15b3UtY2hhbmdlLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)