☰

Amazon Wishlist Exporter (Nov 2024)

Export Amazon Wishlist as JSON or CSV

// ==UserScript==
// @name         Amazon Wishlist Exporter (Nov 2024)
// @namespace    ShadyThGod
// @version      1.01
// @description  Export Amazon Wishlist as JSON or CSV
// @author       ShadyThGod
// @author       m1m1k (improvements)
// @author       jaamulberry (small update)
// @include      http*://*.amazon.*/hz/wishlist/ls*
// @include      http*://*.amazon.*/gp/registry/wishlist*
// @grant        none
// @license      MIT
// ==/UserScript==

(function() {
    'use strict';


    function CreateAmazonButton() {
        var button = document.createElement("span");
        button.id = "amWEx";
        button.className = "a-button a-button-primary";
        button.setAttribute("style","cursor: pointer; float: right; margin-top: 1em;");
        button.innerHTML = '<span class="a-button-inner"><span class="a-button-text">Export wishlist</span></span>'
        var topOfList = document.getElementById("wl-list-info");
        topOfList.insertBefore(button, topOfList.firstChild);
        return button;
    }
    var button = CreateAmazonButton();


    function AddButtonOnClickSpinner(button) {
        button.addEventListener("click", function() {
            button.className += " a-button-disabled";
            var spinner = document.createElement("img");
            spinner.src = "https://images-na.ssl-images-amazon.com/images/G/01/amazonui/loading/loading-2x-gray._V1_.gif";
            spinner.id = "gm-spinner";
            spinner.setAttribute("style","float: right;")
            button.parentNode.insertBefore(spinner, button.nextSibling);
            GetWishlistItems();
        });
    }
    AddButtonOnClickSpinner(button);


    function CreateLoadingModal() {
        var alreadyExists = document.getElementById('amWExModalContainer');
        if (!alreadyExists) {
            var amWExModal = document.createRange().createContextualFragment(`<div id="amWExModalContainer">
<div id="amWExModalBg" style="background: #111111aa; width: 100%; height: 100%; position: fixed; top: 0; left: 0; z-index: 200"></div>
<div id="amWExModal" style="text-align: center; background: #FFFFFF; width: 50vw; position: fixed; top: 50%; left: 50%; transform: translateX(-50%) translateY(-50%); padding: 10px; z-index: 210;">
<h1>Loading...</h1>
</div>
</div>`); //Adds a modal containing text "Loading..."
            document.body.appendChild(amWExModal); //Adds a modal containing text "Loading..."
        }
    }

    function GetWishlistItems() {
        var wishlist = document.getElementById('g-items'); //Gets the node containing the wishlist items
        if (!document.getElementById('endOfListMarker')) {
            CreateLoadingModal();
            window.scrollTo(0, document.body.scrollHeight); //Scrolls to the bottom of the page to load all the items in the wishlist
            requestAnimationFrame(GetWishlistItems); //Runs the main callback function after 2.5 seconds
        } else { //Runs if there are less than 10 items in the wishlist
            Callback(); // Directly runs the callback function without waiting.
        }
    }


    function Callback() { //The main callback function
        if (document.getElementById('amWExModalContainer')) {
            document.getElementById('amWExModalContainer').remove(); //Removes the "Loading..." modal
        }
        var wishlist_name = document.getElementById('profile-list-name').innerHTML.replace(/(\'|\.)/ig, ''); //Gets the name of the wishlist
        wishlist_name = wishlist_name.replace(/\s/ig, '-'); //Replaces spaces in the wishlist name with '-'
        var wishlist_items = document.querySelectorAll('.g-item-sortable'); //Gets all the items in the wishlist
        var wishlistJSON = []; //Defining an empty array to generate our JSON in
        for (var item of wishlist_items) { //Looping through all the items
            var item_details = item.querySelector('.g-item-details > .a-row > .a-column'); //Gets the node containing the details of the item
            var item_asin = JSON.parse(item.getAttribute('data-reposition-action-params')).itemExternalId.replace('ASIN:', '').replace(/\|.*/ig, ''); //Gets the ASIN of the item
            var item_note = item.querySelector('.a-fixed-right-grid-inner *[id*="itemComment"] *[id*="itemComment"');
            var item_name = item_details.querySelector('*[id*="itemName"]')
            var item_name_string = item_name.innerHTML.toString().trim(); //Gets the name of the item & make sure to remove weird returns and formatting
            var item_link = item_name.href; //Gets URL of item
            if(item_link != null)
            {
                item_link = item_name.href.toString();
            }
            else
            {
                try {
                    console.warn("Item Link Failed. Trying Backup"); //I know of one other place to grab the link
                    var item_link_button = item.querySelector('.a-fixed-right-grid-inner > .a-col-right > .a-button-stack [data-action="leave-amazon"'); //Grab the button html
                    var urlRegex = /url&quot;:&quot;(https?:\/\/[^&]+)&quot;/; //Regex to grab URL
                    item_link = item_link_button.outerHTML.match(urlRegex)[1];
                    console.log("Backup Success");
                }
                catch {
                    item_link = null;
                    console.log(item_link_button); //No link. Continue the grab additional Items
                    console.warn("Item link not found. Skipping");
                    continue;
                }
            }

            var item_images = item.querySelectorAll('img');
            var item_image = item_images[1].getAttribute('src');
            var item_price = item_details.querySelector('.a-price'); //Gets the price of the item
            var item_dateAdded = item.querySelector('.dateAddedText span').innerText; //Gets the date when the item was added to the list
            var item_price_int, item_price_float, item_prime, item_note_string; //Initializing the various price variables & comment
            if (item_price != null) { // Runs if a price is defined on Amazon
                item_price_int = parseInt(item.getAttribute('data-price')); //Gets an integer value of the price
                item_price_float = parseFloat(item.getAttribute('data-price')); //Gets a floating point value of the price
                item_prime = Boolean(item_price.getElementsByClassName('.a-icon-prime') != null || item_price.getElementsByClassName('.a-icon-prime') != undefined); //Gets a boolean whether the prime service is available for the item
                item_price = item.getAttribute('data-price').toString(); //Gets a string value of the price
            } else { //Runs if no price is defined on Amazon
                item_price_int = null;
                item_price_float = null;
                item_price = 'N/A';
                item_prime = false;
            }
            if (item_note != null) { //Runs if a comment is defined on Amazon
                item_note_string = item_note.innerHTML.toString().trim();
            }
            else { // runs if no comment is on Amazon.
                item_note_string = null
            }
            var itemJSON = {
                name: item_name_string,
                image: item_image,
                link: item_link,
                note: item_note_string,
                price: item_price,
                priceInt: item_price_int,
                priceFloat: item_price_float,
                hasPrime: item_prime,
                ASIN: item_asin,
                dateAdded: item_dateAdded,
                dateAddedISO: (new Date(item_dateAdded)).toJSON()
            }; //Generating a JSON Object for the item
            wishlistJSON.push(itemJSON); //Adding the item's JSON object to the wishlist's JSON
        }
        wishlistJSON = JSON.stringify(wishlistJSON, null, ' '); //Stringifying the wishlist's JSON
        var wishlistCSV = convertJSONTOCSV(wishlistJSON);
        var amWExModal = document.createRange().createContextualFragment(`<div id="amWExModalContainer">
<div id="amWExModalBg" style="background: #111111aa; width: 100%; height: 100%; position: fixed; top: 0; left: 0; z-index: 200"></div>
<div id="amWExModal" style="background: #FFFFFF; width: 70vw; height: 80vh; position: fixed; top: 10%; left: 15%; padding: 10px; z-index: 210">
<h1 style="display: inline">${wishlist_name.replace('-', ' ')}</h1>
<a href="" id="amWExModalClose" style="font-family: sans-serif; font-weight: 600; font-size: 2.2rem; text-decoration: none; float: right; margin: 10px;">&times;</a>
<textarea id="amWExJSONText" style="height: 85%; font-size: 1rem; font-family: 'Inconsolata', 'Monaco', monospace, sans-serif"></textarea>
<div id="amWExSaveDialog" style="margin: 5px">
<span>Save As:</span>
<input type="text" id="amWExSaveFileName" value="${wishlist_name}">
<a id="amWExSave" class="a-button"><span class="a-button-inner"><span class="a-button-text">Save JSON</span></span></a>
<a id="amWExSaveCSV" class="a-button"><span class="a-button-inner"><span class="a-button-text">Save CSV</span></span></a>
<a id="amWExSave" class="a-button" href="https://konklone.io/json/" target="_blank"><span class="a-button-inner"><span class="a-button-text">
Convert to Excel or CSV</span></span></a>
</div>
</div>
</div>`); //Defining the final output modal
        document.body.appendChild(amWExModal); //Adding the output modal to the screen
        document.getElementById('amWExJSONText').innerHTML = wishlistJSON; //Setting the text of the textarea to the wishlist's JSON
        document.getElementById('amWExSave').href = window.URL.createObjectURL(new Blob([wishlistJSON], { 'type': 'application/json'})); //Setting the href of the save button to the wishlist's JSON for downloading capabilities
        document.getElementById('amWExSaveCSV').href = window.URL.createObjectURL(new Blob([wishlistCSV], {'type': 'text/csv' }));
        document.getElementById('amWExSave').download = '_' + wishlist_name + '.json'; //Sets the json filename for the download
        document.getElementById('amWExSaveCSV').download = '_' + wishlist_name + '.csv'; //Sets the csv filename for the download
        document.getElementById('amWExSaveFileName').addEventListener('change', function() {
            document.getElementById('amWExSave').download = document.getElementById('amWExSaveFileName').value + ".json"; //Sets the filename for the download
            document.getElementById('amWExSaveCSV').download = document.getElementById('amWExSaveFileName').value + ".csv";
        });

    }


    function convertJSONTOCSV(jsonArray) {
        const csvRows = [];
        const parsedJson = JSON.parse(jsonArray);

        const headers = Object.keys(parsedJson[0]);
        csvRows.push(headers.join(","));

        for (const jItem of parsedJson) {
            const values = headers.map(header => {
                let value = jItem[header] || '';
                value = value.toString().replace(/"/g, '""'); // Escape double quotes
                return `"${value}"`;
            });
            csvRows.push(values.join(','));
        }

        return csvRows.join('\n'); //Join rows with newline
    }

    function RemoveJSONContainer(e) {
        if (e.target.id == "amWExModalBg") {
            document.getElementById('amWExModalContainer').remove(); //Removes the modal
        } else if (e.target.id == "amWExModalClose") {
            e.preventDefault();
            document.getElementById('amWExModalContainer').remove(); //Removes the modal
        }
        window.scrollTo(0, 0); //top,left
    }

    document.body.addEventListener('click', RemoveJSONContainer);
})();