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

#   How to Export wanted .csv fields and import back?

##

- **[mici](/forum/user/33257-mici "View mici's Profile")**
- [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author
- [ Offline](/forum/user/33257-mici)

Less More

- Posts: 16
- Thank you received: 0
-
-

11 years 9 months ago [\#185650](#185650) by [mici](/forum/user/33257-mici "View mici's Profile")  *[How to Export wanted .csv fields and import back?](/forum/37-import-export-csv-xls/874084-how-to-export-wanted-csv-fields-and-import-back#185650 "-- url of the page with the problem -- :   5.10.105.46/~yamity3c/  -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3 -- PHP version -- : 5.3.28  I would like to change Only the &quot;price&#95;value&quot; of my existing products via .csv.  When I export a .csv of my products a get a big list of all the column heading in my site.  I would like to export only the fields required (as minimum as possible, without the categories ) to change the &quot;price&#95;value&quot;. After Exporting and updating the .csv &quot;price&#95;value&quot; I would like to import it so the changes of the &quot;price&#95;value&quot; is process via the .csv.  I would I be able to to achieve it Thanks M")* was created by *[mici](/forum/user/33257-mici "View mici's Profile")*

-- url of the page with the problem -- : [ 5.10.105.46/~yamity3c/](http://5.10.105.46/~yamity3c/)
-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3
-- PHP version -- : 5.3.28

I would like to change Only the "price_value" of my existing products via .csv.

When I export a .csv of my products a get a big list of all the column heading in my site.

I would like to export only the fields required (as minimum as possible, without the categories ) to change the "price_value".
After Exporting and updating the .csv "price_value" I would like to import it so the changes of the "price_value" is process via the .csv.

I would I be able to to achieve it
Thanks
M

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQwODQtaG93LXRvLWV4cG9ydC13YW50ZWQtY3N2LWZpZWxkcy1hbmQtaW1wb3J0LWJhY2s/dG1wbD1tYXJrZG93bg==) 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)
-

11 years 9 months ago [\#185687](#185687) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How to Export wanted .csv fields and import back?](/forum/37-import-export-csv-xls/874084-how-to-export-wanted-csv-fields-and-import-back#185687 "-- url of the page with the problem -- :   5.10.105.46/~yamity3c/  -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3 -- PHP version -- : 5.3.28  I would like to change Only the &quot;price&#95;value&quot; of my existing products via .csv.  When I export a .csv of my products a get a big list of all the column heading in my site.  I would like to export only the fields required (as minimum as possible, without the categories ) to change the &quot;price&#95;value&quot;. After Exporting and updating the .csv &quot;price&#95;value&quot; I would like to import it so the changes of the &quot;price&#95;value&quot; is process via the .csv.  I would I be able to to achieve it Thanks M")*

Hi,

We recommend to use the mass actions in this case ![;)](/media/kunena/emoticons/11.png ";)")

Via the menu System &gt; Mass actions, create a new action on the data "product" and in the action part, select "export a csv file".
Then check only the desired checkboxes.

Another solution is to select the action "Display the results" this way it will display a dynamic table. And you can edit the values directly in that table.

Or if you want to update all the prices by the same percentace, you can use the action "update the values" and then:
"price_value" = OPERATION "price.price_value*1.10" to increase by 10%.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQwODQtaG93LXRvLWV4cG9ydC13YW50ZWQtY3N2LWZpZWxkcy1hbmQtaW1wb3J0LWJhY2s/dG1wbD1tYXJrZG93bg==) 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.160 seconds

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

[](#top)
