userweb

Hi, I tried to concatenate some columns, I used “&” and I see that the columns all appear together in a single column, but when I import the csv, I see that the products have not been assigned to the respective categories, evidently the single “yes” which marks the category of a product, with the category itself, in practice in the “categories” column I have all the categories separated by a space, but there is no trace of the “yes” which indicates that a product belongs to a certain category, I don’t know much about Excel, but it seems that this thing cannot be done automatically.

Hi, yes I understand, so is it impossible to do it automatically? Do I intend to transform the csv into a csv with correct layout? Doing everything manually for thousands of products is impossible!

The problem is another, the categories are approximately 8/10, but they are in different columns, and then every single row shows the word “yes” to indicate that a product belongs to that category (column) the problem is to combine these data, I not only have to merge the categories into a single column but I have to make sure that all the “yes” match, I don’t know how to explain myself better, from what it seems to me I can only merge the categories into a single column but I don’t understand how to then assign the products using the word “yes” given that the category column will only be one.

Here is an example image, so I can explain myself better

https://ibb.co/YkBp5L7

• This reply was modified 10 months ago by userweb.
• This reply was modified 10 months ago by userweb.
• This reply was modified 10 months ago by userweb.

Hi, thanks for the help! I created the categories corresponding to the csv file in Woocommerce, but when I import the csv the products are not assigned to the corresponding categories, perhaps, I ask you for confirmation, Wordfence asks for only one column for the categories, while in the csv there are several columns, one for each category, if so I think I should “merge” the rows and columns of the categories, in practice now there are 8/10 different categories in the csv and then each row reports “yes” to indicate that that product belongs to that category, there Is there any way to merge the categories into one category? But how do you assign the corresponding “yes” value? Or is there an easier way or automatic tools that do this?

Thank you! I managed to import some products, in the “Product type” column I replaced the value that was there with “simple” and some products were imported, now I try to do the same thing with all the products!
The problem, however, is that I see that despite having set to import the products in separate categories, they were all imported in “uncategorized”

I don’t have any products in Woocommerce, the products are in the csv to be imported, could it be fine if I create a product as a test and then export it?

So should I change the “Product type” field in the csv to import?

Hi, unfortunately it is a csv provided by a platform, so I don’t think I can publicly share something that is not mine, the platform provides it to me as it is used to integrate the platform’s products with my site, we don’t have another way to solve this problem? Thanks for the help.

Hi, thanks for the help, during the installation I thought I understood that it was a trial version for 30 days, thanks.

Ok thanks I installed it but will it only last 30 days?

Ok, thanks for the clarification.

Hi, thanks to you, I ask you something, is it always possible to use the free basic version of wordfence or upon expiration and after a certain period of time do you have to switch to the pro version?
Thank you.

Hi, thanks for the help, the problem wasn’t wordfence but another plugin, which I deactivated and now everything is ok, thanks anyway!

Hi, thanks for the help, there was a problem, an alert showed that WordPress hadn’t updated automatically, I contacted the hosting manager and now the problem is solved, I guess it was server side then, I then started the scan and it completed successfully without reporting anything.
Previously, a yellow triangle appeared with an exclamation mark in the middle.