Hey! It's me again :)
I’m creating a site where ppl can find an aggregated summary of beauty product reviews and get a recommendation. But I’m first scraping data from other review sites.
I have one database that contains product information (product images, names, overall rating, etc.). I have another database that contains the actual reviews for each product.
When I bulk upload how do I ensure that the reviews in the database are properly connected to the product database? I know when I manually upload it automatically creates a unique review ID when I add a review and connect it to the right product id… but I am not sure how that happens with bulk upload.
Here is an image of the review database
As you can see the reviews database has a "product id" column
Here is an image of the product database
As you can see the product database has a "list of reviews" column, which contains the unique id of each review.
How do I ensure proper review and product mapping in bubble?
Here's the forum: https://forum.bubble.io/t/bulk-uploading-formating/85384