Is it possible to bulk edit the Listing Site Property ID from imported Reviews

Scott K
Nov 18, 2023 8:16 PM
Joined Oct, 2023 12 posts

Hi there, I imported all of my reviews from 2 separate Airbnb listings.

These all imported with 2 distinct Listing Site Property IDs (great), but only one OwnerRez Property ID.

I only have a direct booking site for listing A at the moment and only want to show the reviews from listing A. I don't see a way to bulk update the OR property ID by filtering on the Listing Site Property ID. I exported them to a CSV thinking I could massage the CSV and re-import, but the CSV doesn't include the Listing Site Property ID field.

Thank you in advance for your help!

BlueMtnCabins
Nov 20, 2023 10:45 AM
Joined Jun, 2016 1133 posts

The CSV does include the properly ID. It is in ListingSitePropertyId column. You can try edit that, but it also has ListingSiteReviewId which is unique for every property/review, may give an error. Try and see. 

Scott K
Nov 20, 2023 11:14 AM
Joined Oct, 2023 12 posts

I'm not seeing the Listing Site Property IDs (different from the Property ID) in my export. Here's the file: https://docs.google.com/spreadsheets/d/1wplhGfqYqQshAQBUX1gKlL_1eqlRzL_mnoQw5zTR_-k/edit?usp=sharing

Maybe there's a bug or I'm grabbing this from the wrong location?

BlueMtnCabins
Nov 20, 2023 12:31 PM
Joined Jun, 2016 1133 posts

I'm not seeing the Listing Site Property IDs (different from the Property ID) in my export. Here's the file: https://docs.google.com/spreadsheets/d/1wplhGfqYqQshAQBUX1gKlL_1eqlRzL_mnoQw5zTR_-k/edit?usp=sharing

Maybe there's a bug or I'm grabbing this from the wrong location?

by Scott K – Nov 20, 2023 4:14 PM (UTC)

I see it 

Scott K
Nov 20, 2023 12:36 PM
Joined Oct, 2023 12 posts

Is this not the ownerrez property ID?

In any case, the IDs are the same for every single line item. Some reviews came from one property the rest came from the other property. But the IDs is in that column are all the same.

BlueMtnCabins
Nov 20, 2023 5:07 PM
Joined Jun, 2016 1133 posts

Is this not the ownerrez property ID?

In any case, the IDs are the same for every single line item. Some reviews came from one property the rest came from the other property. But the IDs is in that column are all the same.

by Scott K – Nov 20, 2023 5:36 PM (UTC)

If those are incorrect, you can edit the values to apply the correct property's ID and try?  Maybe try with 1-2 rows.