Import Reviews

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: CSV, reviews, upload

Author

Posts
January 17, 2015 at 4:54 pm #27800

alex
Expired Member

Post count: 12

Is it possible to bulk upload reviews for listings via CSV upload?

i have an old site with lots of listings and lots of reviews. dont want to loose all those reviews.

January 17, 2015 at 5:07 pm #27805

Simone
Expired Member

Post count: 3515

Hmm, technically it’s possible, but it isn’t easy.

Reviews have different fields in the database, the most important are:
post_id: this is the ID (numeric) of the Listing, so you should know in advance what’s the ID of the listing you already have on your website

user_id: the id of the author (1 is admin)

post_date, post_city, post_region, post_country (self explanatory)

comment_content (the text of there review)

January 17, 2015 at 5:36 pm #27810

alex
Expired Member

Post count: 12

Ok so just to get this right: i can’t just use the sample csv file provided and modify it a little bit so it would work for uploading bulk reviews? i rather have to create a new csv file and figure out which columns have to be integrated and how they have to be structured right?

looks like i have to hire a capable developer soon because i dont really understand anything about this. 😀

January 17, 2015 at 5:40 pm #27811

Simone
Expired Member

Post count: 3515

The provided sample csv is for the place details (so the data will end in the wp_geodir_place_details table, in the database). You should be doing it via database, (directly via MYSQL) because you need to edit the wp_geodir_post_review table.

February 19, 2015 at 8:46 pm #31481

martinwi
Expired Member

Post count: 34

I’m in the middle of trying to do this too. Do I need to populate the wp_comments table too, for this to work, or is the wp_geodir_post_review sufficient?

I’m concerned that it may look like it works, but I’m missing links somewhere.

Thanks
Martin…

May 28, 2015 at 11:12 pm #40969

Y A
Expired Member

Post count: 156

Did you get an answer to your question @martinwi ?

I’m in the middle of doing the same thing..

May 29, 2015 at 7:58 pm #41049

Y A
Expired Member

Post count: 156

I’ve actually went through the trouble of adding a particular comment to both wp_comments and wp_geodir_post_review, while matching the “comment_id” column in both tables

But it’s not enough.

May 29, 2015 at 8:05 pm #41051

Y A
Expired Member

Post count: 156

Interestingly, the comment added directly through the DB seems to account for the “Overall review”, as can be seen in the Details page sidebar (based on 2 reviews)

But only one comment (the one added through the front-end) appears.

May 29, 2015 at 8:08 pm #41054

Simone
Expired Member

Post count: 3515

It could be more complex than expected, have you tried to run the GD tools, especially the task for the ratings?

May 29, 2015 at 8:11 pm #41055

Y A
Expired Member

Post count: 156

Yes, all tools were run. I’ll keep looking and let you know if I figure anything out.

Also, please note that the review is appearing the GD Admin area

May 30, 2015 at 8:43 pm #41100

Y A
Expired Member

Post count: 156

Hey guys,
So here’s what I found.

The problem seems to come from the WP comment functions.

If you inject the comment directly into wp_comments (through PHPmyadmin), it won’t work.
However, if you create a page and use the wp_new_comment() function, it works ! You can then retrieve the comment_id and directly inject the review into wp_geodir_post_review.

Cheers !
YA
Author

Posts