Import Categories from excel for big site

The “Import Third-Party Reviews” tool pretty basic at the moment. It allows you to import reviews, but not review assignments.

If you are asking if there is a way to import reviews along with their assignments, then this is not currently possible. You would have to import reviews in batches (according to their assignments), and then bulk assign the reviews after each import.

If you are not referring to “importing reviews” but just want to import a bunch of categories, then I would first ask what the purpose of this is for. If each of these categories are representing a product on your website, why not just assign reviews directly to the products themselves?

You can do this dynamically with the assigned_posts="post_id" option. Using post_id as the value will automatically use the Post ID of the current page (or product).

Thank you very much for your reply. You’re amazing! Yes I guess having the review associated with the post is a kind of solution but I’m concerned about the flexibility of that going forward – in case I ever want to put reviews on different posts etc. I guess possibly this can be got round but to me it just makes sense to have a review category for each product. I can also see things getting pretty messy if I don’t label things correctly when I want to make changes of any kind. Just general future-proofing wise I think it makes much more sense to have a category for each product using a standard labelling system.

However, after a bit of trial and error I have realised that it’s not that difficult to do this via sql (importing a csv – being careful to define our own column names and leave out the auto increment field) into wp_terms – and then updating wp_taxonomy.

Thanks once again