How to Export wanted .csv fields and import back?

  • Posts: 16
  • Thank you received: 0
9 years 10 months ago #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 "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 or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 10 months ago #185687

Hi,

We recommend to use the mass actions in this case ;)

Via the menu System > 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 or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum