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

#   Set price-index to products purchase price

##

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

13 years 11 months ago [\#78982](#78982) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#78982 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")* was created by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")*

Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index?
As it is now I have to change each productprice.
If I got 4000 products it takes long time each time I want to change the price...

**Exampel:** Product 1 = 10 dollar(purchase price)
Product 2 = 20 dollar(purchase price)
Product 3 = 30 dollar(purchase price)
Price-index = 2.0

Product 1 = 2.0*10 dollar = 20 dollar(customers price)
Product 2 = 2.0*20 dollar = 40 dollar("")
Product 3 = 2.0*30 dollar = 60 dollar("")

**I change the price-index to 3.0:** Product 1 = 3.0*10 dollar = 30 dollar(customers price)
Product 2 = 3.0*20 dollar = 60 dollar("")
Product 3 = 3.0*30 dollar = 90 dollar("")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 11 months ago [\#79012](#79012) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#79012 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")*

Hi,

You can create a product custom field, which wouldn't be display to customer (just display in back-end form). The custom field would contain the increase quantity value.

After that, you can use a custom HikaShop plugin with a callable function which would just execute a SQL query.

This query would increase the product quantity by the value contains in the custom field. The query would be quite simple.

So in the backend, you would find a link in the plugin options, by clicking the link, you would execute the SQL query and increase the quantity of all your products.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

13 years 11 months ago [\#79064](#79064) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  Replied by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")* on topic *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#79064 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")*

Thanks for your replay but it´s not the quantity I would like to changes, it´s the price for each product i would like to change just by changing the index-value.
The index-value mayby could be 2.15 and next time it´s 2,27...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 11 months ago [\#79177](#79177) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#79177 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")*

Hi,

I can work too via a plugin, and in this plugin, add a field in which you set the index-value.
Then clicking on the link in the plugin call a function which execute a sql query to update the prices in the database depending on the value of the previous field.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

13 years 11 months ago -  13 years 11 months ago [\#79376](#79376) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  Replied by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")* on topic *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#79376 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")*

Ok, what plug-in should i use?
Is it possible to round the price so there will not be any decimals?

**For example:**
Price-index:2,1

Purchase price: 437:-
Outprice: 2.1*437:- = 917.7:-
Round the price: 918:-(incl. taxes)

Does this update even change to price without taxes and without the round-method?

---

This price-adjustment must be something that is quite common and should be something that is standard in Hikashop.
Choose if you would like to use a price-index, set the purchase-price for each product that is marked to use the price-index and save the product.
Next time just change the price-index to change the price for All products Or just change the productprice to adjust that productprice.
Would this be possible in a future version of Hikahsop?

Last edit: 13 years 11 months ago by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 11 months ago [\#79401](#79401) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Set price-index to products purchase price](/forum/2-general-talk-about-hikashop/76200-set-price-index-to-products-purchase-price#79401 "Is it possible to set a price-index to the products purchase price soo if I want to high/lower the outprice I only have to change the price-index? As it is now I have to change each productprice. If I got 4000 products it takes long time each time I want to change the price...  Exampel: Product 1 = 10 dollar(purchase price) Product 2 = 20 dollar(purchase price) Product 3 = 30 dollar(purchase price) Price-index = 2.0  Product 1 = 2.0&#42;10 dollar = 20 dollar(customers price) Product 2 = 2.0&#42;20 dollar = 40 dollar(&quot;&quot;) Product 3 = 2.0&#42;30 dollar = 60 dollar(&quot;&quot;)  I change the price-index to 3.0: Product 1 = 3.0&#42;10 dollar = 30 dollar(customers price) Product 2 = 3.0&#42;20 dollar = 60 dollar(&quot;&quot;) Product 3 = 3.0&#42;30 dollar = 90 dollar(&quot;&quot;)")*

Hi,

This plugin you have to develop it, or post in the commercial jobs section of this forum or ask to a third developer.

You can round the prices with no problems, it just must be implemented in the function of the plugin.

I add this feature in our TODO list, but it don't think that it will be developed soon because we have a lot of functionalities to develop already.
And this one is not required by a lot of people.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MjAwLXNldC1wcmljZS1pbmRleC10by1wcm9kdWN0cy1wdXJjaGFzZS1wcmljZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.073 seconds

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