How to Import Amazon Reviews (CSV)

This guide explains how to fetch real reviews from Amazon and import them into your WordPress Book Showcase using our Amazon Review Scraper Bookmarklet.

This is a two-part process:

1. Scraping: Using our Bookmarklet tool to collect reviews from Amazon.
2. Importing: Uploading the collected data (CSV) into your website.

---

🛠️ Phase 1: Getting the Scraper Tool

Before you can scrape reviews, you need to set up the Bookmarklet in your browser.

Step 1: Download the Script

1. Purchase and log in to your account on the RS WP Themes website.
2. Go to your Downloads page.
3. Download the file named: amazon-product-reviews-scrapper-bookmarklet.zip.
4. Unzip the file on your computer. Inside, you will find a JavaScript file (e.g., amazon-product-reviews-scrapper-bookmarklet.js).

Step 2: Copy the Code

1. Open the .js file using any text editor (Notepad, TextEdit, or VS Code) or simply drag and drop it into your browser tab.
2. Select All content (Ctrl+A or Cmd+A) and Copy it.

---

🔖 Phase 2: Installing the Bookmarklet

You need to add this code as a “Bookmark” in your browser (Chrome, Firefox, Edge, or Safari).

1. Make sure your Bookmarks Bar is visible. (In Chrome: Press Ctrl + Shift + B).
2. Right-click on the Bookmarks Bar and select “Add Page” (or “Add Bookmark”).
3. Name: Give it a name like Amazon Scraper.
4. URL: In the URL field, Paste the JavaScript code you copied in Phase 1.
5. Click Save.

Congratulations! Your scraping tool is now installed in your browser.

---

🛒 Phase 3: Scraping Reviews from Amazon

Now, let’s collect some reviews.

1. Go to Amazon.com and open the product page of the book you want to scrape.
2. Scroll down to the customer reviews section or click “See all reviews”.
3. Click the “Amazon Scraper” bookmark you created in Phase 2.
4. A Control Panel will appear on the top-right corner of the screen with buttons like “Select Reviews” and “Download CSV”.
5. Click “Select Reviews”.
6. Now, click on the reviews you want to copy. When you click a review, it will turn Yellow to indicate it is selected.
7. Once you have selected all the reviews you want, click the “Download CSV” button on the panel.
8. A file named amazon_reviews.csv will automatically download to your computer.

---

📥 Phase 4: Importing Reviews to WordPress

Now that you have the CSV file, it’s time to import it into your website.

1. Log in to your WordPress Dashboard.
2. Navigate to Book Reviews > Import Reviews From Amazon.
3. Select Book: From the dropdown menu, choose the book to which these reviews belong.
4. Upload CSV File: Click “Choose File” and select the amazon_reviews.csv file you just downloaded.
5. Click the “Import Reviews” button.

---

✅ Result

• The system will process the file and verify the headers (Reviewer Name, Review Title, Review Rating, etc.).
• If successful, you will see a success message: “Successfully imported X reviews.”.
• The reviews will be created as “Book Reviews” posts and automatically linked to the book you selected.
• You can view them under Book Reviews > All Book Reviews.

---

⚠️ Troubleshooting Tips

• Invalid CSV Error: Ensure you are using the CSV file generated by our specific Bookmarklet. Other CSV formats will not work because the system checks for specific headers.
• No Reviews Imported: Make sure the reviews on Amazon had valid content and ratings. The importer skips empty or invalid rows.
• Bookmarklet Not Working: Ensure you copied the entire JavaScript code starting with javascript:(function(){....

---