Export, Edit and Import

I have a small problem, i forgot to set the warehouse in 580 products and i dont want to do it manually, so i exported the products in csv, open it in excel and changed the wharehouse to 1 in all the products, save and upload, it seems that all in correct but for the prices wich added 4 ceros so a product worth 15 now worths 1.500.00, i downloaded the file again and each time i open the file in excel the prices are displayed that way

Hi,

It's probably an issue with the formatting of the prices in Excel.
The best though in such cases in not to do an export/edit/import process but to directly modify the products using the mass actions of HikaShop:
www.hikashop.com/support/support/documen...massaction-form.html
That way, modifying the warehouse of all the products at once is really easy and fast. Modifying prices in batch is also possible so you would be able to revert the price issue with a mass action.

I´m really lost with mass actions don´t know even where to start to do the changes

Hi,

Have you read that documentation about the mass actions ?
hikashop.com/support/documentation/167-massaction-form.html

Yes but at least for me its not easy to understand, can you give me the example to change in all products the warehaouse to 1?

You just have to select the value "Update the values" in the "Actions" part.
Then select "product_warehouse_id" = INT and fill the input by the desired warehouse id.

And click on "Process" in the toolbar.

Thanks it worked, in custom field wich i have three options, text, if i want to set the the products wich has none of the three options choosed in one of them, how should i do?
i selected products widthout 24 horas
and products widthout 3-5 dias
the list is 75 products
those i want to set the option 1 sin stock

I'm sorry but I'm not following.
Could you provide a screenshot of the options of the custom field and of the product field value and what you want to change in the product ?

Ok i have thes three options, waht i want to do is that the products wich does not have option 2 or option 3 set, get option 1

Hi,

You have to configure the mass action like on the following screenshot.



Just replace "value1", "value2" and "value3" by your own values.