Subversion Repositories munaweb

Rev

Rev 5 | Rev 10 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 - 1
<!DOCTYPE html>
2
<html lang="en">
3
 
4
<head>
5
    <title>eBay Listings Price Check</title>
6
    <meta charset="UTF-8">
7
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
8
    <link rel="shortcut icon" href="favicon.ico" type="image/x-icon">
9
    <link rel="icon" href="favicon.ico" type="image/x-icon">
10
 
11
    <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
12
    <link href="https://fonts.googleapis.com/css?family=Lato" rel="stylesheet">
13
    <link rel="stylesheet" href="css/style.css">
14
    <script src="js/XMLWriter.js"></script>
15
    <script src="js/lodash.min.js"></script>
16
    <script src="js/XMLparse.js"></script>
17
    <script src="js/muna-tools.js"></script>
18
</head>
19
 
20
<body onload="return initConfig();">
21
    <div class="w3-main">
22
        <div class="w3-container w3-padding w3-margin w3-card-4">
23
            <div class="w3-container w3-gray" style="height:100px">
24
                <img class="w3-image" src="images/MUNA%20-%20Logo%20100x100.png" alt="MUNA Trading Logo" style="height:100px">
25
                <p id="connected" class="w3-xxlarge w3-right">eBay Listings Price Check
26
                    <input id="login" type="button" class="w3-btn w3-large w3-green w3-margin w3-round-large w3-ripple w3-right w3-hide" onclick="eBayLogin();" value="Login" />
27
                </p>
28
            </div>
29
 
30
            <div class="w3-row">
31
                <div>
32
                    <form id="searchForm" class="w3-container w3-light-grey w3-padding w3-small" onsubmit="return checkListingPrices();">
33
                        <div class="w3-container w3-card-2 w3-cell w3-padding">
34
                            <input id="startButton" type="button" class="w3-btn w3-large w3-black w3-margin w3-round-large w3-ripple w3-right" onclick="checkListingPrices();" value="Start" />
35
                        </div>
36
                    </form>
37
                </div>
38
                <div id="progressBarDiv" class="w3-container w3-padding w3-margin w3-card-4 w3-hide">
39
                    <h2 id="progressBarHeader"></h2>
40
                    <div class="w3-light-grey">
41
                        <div id="progressBar" class="w3-container w3-green w3-center" style="width:0%">0%</div>
42
                    </div>
43
                </div>
44
                <div id="results" class="w3-container w3-padding w3-card-4 w3-hide"></div>
45
                <div id="logging" class="w3-container w3-padding"></div>
46
            </div>
47
        </div>
48
 
49
        <footer class="w3-container w3-center w3-border-top w3-margin">
50
            Copyright &#169; 2018 MUNA Trading. All rights reserved.
51
        </footer>
52
 
53
    </div>
6 - 54
 
2 - 55
    <script>
56
 
57
// Config
58
var configMinPrice = "5.99";
59
var configDifference = 2.00;
60
var configPercentage = 20.00;
61
var configAbsoluteMinPrice = 5.00;
62
var configAdjMinPrice = 5.48;
63
var configSearchUrl = 'https://ujsoftware.linkpc.net/ebay/search.html?keyword=';
64
var configSearchUrlPart2 = '&hideDuplicateItems=on&locatedIn=WorldWide&sortOrder=PricePlusShippingLowest&results=100';
65
 
66
var pagesToProcess = 0;
67
var maxPagesToProcess = 0;
68
var pagesProcessed = 0;
69
var productIdsToProcess = 0;
70
var maxProductIdsToProcess = 0;
71
var productIdsProcessed = 0;
72
var productsToPrice = 0;
73
var maxProductsToPrice = 0;
74
var productsPriced = 0;
75
var html = [];
76
 
77
// Initialize Configuration Variables
78
function initConfig() {
79
    eBayAuthToken = readCookie();
80
    if (eBayAuthToken.length > 0) {
81
        connected();
82
    }
83
 
84
    if (eBayAuthTokenFlag === false) {
85
        var x = document.getElementById("login");
86
        if (x.className.indexOf("w3-show") == -1) {
87
            x.className += " w3-show";
88
        }
89
    }
90
}
91
 
92
function requireNewLogin() {
93
    // dummy
94
}
95
 
96
function checkListingPrices() {
97
    var x;
98
 
99
    document.getElementById("logging").innerHTML = '';
100
 
101
    x = document.getElementById("results");
102
    if (x.className.indexOf("w3-show") == -1) {
103
        x.className += " w3-show";
104
    }
105
    x.className = x.className.replace(" process-errors", "");
106
    x.innerHTML = '';
107
 
108
    initProgressBar('Retrieving Active Listings (1/3)');
109
 
110
    pagesToProcess = 1;
111
    maxPagesToProcess = 1;
112
    pagesProcessed = 0;
113
    eBaySearch(1);
114
 
115
    function checkpagesToProcess() {
116
        if (pagesToProcess > 0) {
117
            window.setTimeout(checkpagesToProcess, 100); // wait 100 milliseconds
118
        } else {
119
            findMissingProductIds();
120
        }
121
    }
122
 
123
    checkpagesToProcess();
124
}
125
 
126
// item filters for request
127
var filterarray = [];
128
var urlfilter = [];
129
 
130
// Fill the array of item filters from input form
131
function fillFilterArray() {
132
    filterarray = [];
133
    var obj = [];
134
 
135
    obj = {
136
        "name": "Seller",
137
        "value": configeBaySellerName,
138
        "paramName": "",
139
        "paramValue": ""
140
    };
141
    filterarray.push(obj);
142
 
143
    obj = {
144
        "name": "MinPrice",
145
        "value": Number(configMinPrice).toFixed(2),
146
        "paramName": "Currency",
147
        "paramValue": "USD"
148
    };
149
    filterarray.push(obj);
150
 
151
    obj = {
152
        "name": "ListingType",
153
        "value": "FixedPrice",
154
        "paramName": "",
155
        "paramValue": ""
156
    };
157
    filterarray.push(obj);
158
 
159
    urlfilter = "";
160
    // Iterate through each filter in the array
161
    for (var i = 0; i < filterarray.length; i++) {
162
        //Index each item filter in filterarray
163
        var itemfilter = filterarray[i];
164
        // Iterate through each parameter in each item filter
165
        for (var index in itemfilter) {
166
            // Check to see if the paramter has a value (some don't)
167
            if (itemfilter[index] !== "") {
168
                if (itemfilter[index] instanceof Array) {
169
                    for (var r = 0; r < itemfilter[index].length; r++) {
170
                        var value = itemfilter[index][r];
171
                        urlfilter += "&itemFilter\(" + i + "\)." + index + "\(" + r + "\)=" + value;
172
                    }
173
                } else {
174
                    urlfilter += "&itemFilter\(" + i + "\)." + index + "=" + itemfilter[index];
175
                }
176
            }
177
        }
178
    }
179
} // End fillFilterArray() function
180
 
181
var url = "";
182
 
183
function eBaySearch(pageNumber) {
184
    // Fill the filter array from form input
185
    if (pageNumber == 1) {
186
        fillFilterArray();
187
    }
188
 
189
    // Construct the request
190
    url = configeBayFinding + "?";
191
    url += "OPERATION-NAME=findItemsAdvanced";
192
    url += "&SERVICE-VERSION=" + configeBayFindingVersion;
193
    url += "&SECURITY-APPNAME=" + configAppid;
194
    url += "&GLOBAL-ID=EBAY-US";
195
    url += "&RESPONSE-DATA-FORMAT=JSON";
196
    url += "&REST-PAYLOAD";
197
    url += "&paginationInput.entriesPerPage=100";
198
    url += "&paginationInput.pageNumber=";
199
    url += pageNumber;
200
    url += urlfilter;
201
 
202
    var xhttp = new XMLHttpRequest();
203
 
204
    xhttp.onreadystatechange = function() {
205
        if (this.readyState == 4) {
206
            _cb_findItemsAdvanced(JSON.parse(this.responseText));
207
        }
208
    };
209
 
210
    xhttp.open("GET", configProxyUrl, true);
211
    xhttp.setRequestHeader("X-Proxy-Url", encodeURI(url));
212
    xhttp.send();
213
 
214
    return false;
215
}
216
 
4 - 217
function printeBayAPIError(str, root) {
2 - 218
    var x = document.getElementById("results");
219
    x.className += " process-errors";
4 - 220
    x.innerHTML += "<h2>eBay API Error (" + str + ")<h2>";
2 - 221
    x.innerHTML += "<p>Id: " + root.errorMessage[0].error[0].errorId + "<br/>";
222
    x.innerHTML += "<p>Severity: " + root.errorMessage[0].error[0].severity + "<br/>";
223
    x.innerHTML += "<p>Message: " + root.errorMessage[0].error[0].message + "</p>";
224
}
225
 
226
// Parse the response and build an HTML table to display search results
227
function _cb_findItemsAdvanced(root) {
228
    // Error Handling
229
    var response = root.findItemsAdvancedResponse[0];
230
    var ack = response.ack;
231
    if (ack != 'Success') {
4 - 232
        printeBayAPIError('Find Item', response);
2 - 233
 
234
        if (ack == 'Failure' || ack == 'PartialFailure') {
235
            --pagesToProcess;
236
            return;
237
        }
238
    }
239
 
240
    createTable(response.searchResult[0].item || [], Number(response.paginationOutput[0].pageNumber), Number(response.paginationOutput[0].totalPages));
241
 
6 - 242
    if (Number(response.paginationOutput[0].totalPages) > Number(response.paginationOutput[0].pageNumber)) {
243
        ++maxPagesToProcess;
244
        ++pagesToProcess;
245
        eBaySearch(Number(response.paginationOutput[0].pageNumber) + 1);
246
    }
2 - 247
 
248
    document.getElementById("logging").innerHTML = html.join('');
249
    --pagesToProcess;
250
    ++pagesProcessed;
251
    updateProgressBar(maxPagesToProcess, pagesProcessed);
252
} // End _cb_findItemsAdvanced() function
253
 
254
 
255
function createTable(obj, pageNumber, totalPages) {
256
    if (pageNumber == 1) {
257
        document.getElementById("logging").innerHTML = '';
258
        html = [];
259
 
260
        html.push('<h3>Price Validation</h3>');
261
        html.push('<div class="w3-responsive">');
262
        html.push('<table id="itemTable" class="w3-table-all w3-hoverable css-serial">');
263
        html.push('<thead>');
264
        html.push('<tr>');
265
 
266
        html.push(tableHeader('#'));
267
        html.push(tableHeader('Item Id'));
268
        html.push(tableHeader('Thumbnail'));
269
        html.push(tableHeader('Title'));
270
        html.push(tableHeader('Product Id'));
271
        html.push(tableHeader('Price'));
272
        html.push(tableHeader('# Active Listings'));
273
        html.push(tableHeader('# Priced Lower'));
274
        html.push(tableHeader('Lowest Price'));
275
        html.push(tableHeader('Highest Price'));
276
        html.push(tableHeader('Above/Below Lowest'));
277
        html.push(tableHeader('Views'));
278
        html.push(tableHeader('Watchers'));
279
        html.push(tableHeaderHidden('Condition'));
280
        html.push(tableHeaderHidden('# Better Condition'));
281
        html.push(tableHeader('Price Adj.'));
282
        html.push(tableHeaderHidden('Best Offer'));
283
        html.push(tableHeaderHidden('MinBetterCondition'));
284
        html.push(tableHeaderHidden('BetterConditionBreakdown'));
285
        html.push(tableHeaderHidden('SameConditionBreakdown'));
286
 
287
        html.push('</tr>');
288
        html.push('</thead>');
289
        html.push('<tbody>');
290
    }
291
 
292
    for (var entry = 0; entry < obj.length; entry++) {
293
        html.push('<tr>');
294
        html.push(tableCell(''));
295
        html.push(tableCell('<a href="' + obj[entry].viewItemURL + '" target="_blank">' + obj[entry].itemId + '</a>'));
296
        html.push(tableCell('<img src="' + obj[entry].galleryURL[0].replace('http:', 'https:') + '">'));
297
        html.push(tableCell(obj[entry].title));
298
        if (obj[entry].productId !== undefined) {
299
            var str = '<a href="' + configSearchUrl;
300
            str += 'ReferenceID%3A' + obj[entry].productId[0].__value__;
301
            str += configSearchUrlPart2 + '" target="_blank">';
302
            str += obj[entry].productId[0]["@type"] + ' ' + obj[entry].productId[0].__value__;
303
            str += '</a>';
304
            html.push(tableCell(str));
305
        } else {
306
            html.push(tableCellLabel('ProductId' + obj[entry].itemId));
307
        }
308
 
309
        html.push(tableCell('$' + Number(obj[entry].sellingStatus[0].convertedCurrentPrice[0].__value__).toFixed(2)));
310
        html.push(tableCell(1));
311
        html.push(tableCell(0));
312
        html.push(tableCell('$0.00'));
313
        html.push(tableCell('$0.00'));
314
        html.push(tableCell('$0.00 (0.00%)'));
315
 
316
        html.push(tableCell(0));
317
        html.push(tableCell(obj[entry].listingInfo[0].watchCount === undefined ? 0 : Number(obj[entry].listingInfo[0].watchCount)));
318
        html.push(tableCellHidden(obj[entry].condition === undefined ? 4000 : Number(obj[entry].condition[0].conditionId)));
319
        html.push(tableCellHidden(0));
320
        html.push(tableCell('<input id="PriceAdj' + obj[entry].itemId + '" type="text" size="10"><br><input type="button" class="w3-btn w3-large w3-black w3-margin w3-round-large w3-ripple" onclick="changePrice(' + obj[entry].itemId + ');" value="Adjust Price" />'));
321
        html.push(tableCellLabelHidden('BestOffer' + obj[entry].itemId, obj[entry].listingInfo[0].bestOfferEnabled));
322
        html.push(tableCellHidden('0'));
323
        html.push(tableCellHidden('[]'));
324
        html.push(tableCellHidden('[]'));
325
 
326
        html.push('</tr>');
327
    }
328
 
329
    if (pageNumber == totalPages) {
330
        html.push('</tbody>');
331
        html.push('</table>');
332
        html.push('</div>');
333
    }
334
}
335
 
336
function setCellsAttribute(table, row, col, label) {
337
    table.rows[row].cells[col].setAttribute("id", label);
338
}
339
 
340
function sortTableDesc(tableName, column) {
341
    var table, rows, switching, i, x, y, shouldSwitch;
342
    --column; // column parameter starts with 1
343
    table = document.getElementById(tableName);
344
    switching = true;
345
    /*Make a loop that will continue until
346
    no switching has been done:*/
347
    while (switching) {
348
        //start by saying: no switching is done:
349
        switching = false;
350
        rows = table.getElementsByTagName("TR");
351
        /*Loop through all table rows (except the
352
        first, which contains table headers:*/
353
        for (i = 1; i < (rows.length - 1); i++) {
354
            //start by saying there should be no switching:
355
            shouldSwitch = false;
356
            /*Get the two elements you want to compare,
357
            one from current row and one from the next:*/
358
            x = rows[i].getElementsByTagName("TD")[column];
359
            y = rows[i + 1].getElementsByTagName("TD")[column];
360
            //check if the two rows should switch place:
361
            if (x !== undefined && (Number(x.innerHTML.substr(1)) < Number(y.innerHTML.substr(1)))) {
362
                //if so, mark as a switch and break the loop:
363
                shouldSwitch = true;
364
                break;
365
            }
366
        }
367
        if (shouldSwitch) {
368
            /*If a switch has been marked, make the switch
369
            and mark that a switch has been done:*/
370
            rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
371
            switching = true;
372
        }
373
    }
374
}
375
 
376
function findMissingProductIds() {
377
    var i;
378
    var x = document.getElementById("itemTable");
379
    var missingList = [];
380
    var viewList = [];
381
    var maxItems = 20;
382
 
383
    initProgressBar('Retrieving Product Ids (2/3)');
384
 
385
    productIdsToProcess = 0;
386
    maxProductIdsToProcess = 0;
387
    productIdsProcessed = 0;
388
 
389
    for (i = 1; i < x.rows.length; i++) {
390
        if (x.rows[i].cells[4] !== undefined && x.rows[i].cells[4].innerText.length < 1) {
391
            missingList.push(x.rows[i].cells[1].innerText);
392
        } else {
393
            var p = x.rows[i].cells[4].innerText.substr(x.rows[i].cells[4].innerText.indexOf(" ") + 1);
394
            setCellsAttribute(x, i, 5, "Price" + p);
395
            setCellsAttribute(x, i, 6, "Active" + p);
396
            setCellsAttribute(x, i, 7, "Lower" + p);
397
            setCellsAttribute(x, i, 8, "Minimum" + p);
398
            setCellsAttribute(x, i, 9, "Maximum" + p);
399
            setCellsAttribute(x, i, 11, "Views" + x.rows[i].cells[1].innerText);
400
            setCellsAttribute(x, i, 13, "Condition" + p);
401
            setCellsAttribute(x, i, 14, "BetterCondition" + p);
402
            setCellsAttribute(x, i, 17, "MinBetterCondition" + p);
403
            setCellsAttribute(x, i, 18, "BetterConditionBreakdown" + p);
404
            setCellsAttribute(x, i, 19, "SameConditionBreakdown" + p);
405
            viewList.push(x.rows[i].cells[1].innerText);
406
        }
407
    }
408
 
409
    for (i = 0;
410
        (i * maxItems) < missingList.length; i++) {
411
        ++productIdsToProcess;
412
        ++maxProductIdsToProcess;
413
        findMissingProductId(missingList.slice(i * maxItems, (i + 1) * maxItems));
414
    }
415
 
416
    for (i = 0;
417
        (i * maxItems) < viewList.length; i++) {
418
        ++productIdsToProcess;
419
        ++maxProductIdsToProcess;
420
        findViews(viewList.slice(i * maxItems, (i + 1) * maxItems));
421
    }
422
 
423
    function checkproductIdsToProcess() {
424
        if (productIdsToProcess > 0) {
425
            window.setTimeout(checkproductIdsToProcess, 100); // wait 100 milliseconds
426
        } else {
427
            priceProductIds();
428
        }
429
    }
430
 
431
    checkproductIdsToProcess();
432
}
433
 
434
function findMissingProductId(itemIdList) {
435
    var i;
436
    var xml;
437
 
438
    var xw = new XMLWriter('UTF-8', '1.0');
439
    var xhr = new XMLHttpRequest();
440
 
441
    xw.writeStartDocument();
442
    xw.writeStartElement("GetMultipleItemsRequest");
443
    xw.writeAttributeString('xmlns', 'urn:ebay:apis:eBLBaseComponents');
444
 
445
    for (i = 0; i < itemIdList.length; i++) {
446
        xw.writeElementString('ItemID', itemIdList[i]);
447
    }
448
 
449
    xw.writeElementString('IncludeSelector', 'Details');
450
    xw.writeElementString('ErrorLanguage', 'en_US');
451
    xw.writeElementString('Version', configeBayShoppingVersion);
452
    xw.writeElementString('WarningLevel', configWarningLevel);
453
 
454
    xw.writeEndElement(); /* xmlrequest */
455
    xw.writeEndDocument();
456
 
457
    xhr.open('POST', configProxyUrl, true);
458
    xhr.setRequestHeader('Content-Type', 'text/xml');
459
    xhr.setRequestHeader('X-EBAY-API-APP-NAME', configAppid);
460
    xhr.setRequestHeader('X-EBAY-API-VERSION', configeBayShoppingVersion);
461
    xhr.setRequestHeader('X-EBAY-API-CALL-NAME', 'GetMultipleItems');
462
    xhr.setRequestHeader('X-EBAY-API-SITEID', '0');
463
    xhr.setRequestHeader('X-EBAY-API-DEV-NAME', '');
464
    xhr.setRequestHeader('X-EBAY-API-CERT-NAME', '');
465
    xhr.setRequestHeader('X-EBAY-API-REQUEST-ENCODING', 'XML');
466
    xhr.setRequestHeader('X-Proxy-URL', configeBayShopping);
467
 
468
    xml = xw.flush();
469
    xw.close();
470
 
471
    xhr.onload = function() {
472
        var obj = XMLparse(xhr.responseXML);
473
 
474
        var returnCode = obj.Ack;
475
 
476
        var x = document.getElementById("results");
477
 
478
        if (returnCode == 'Success') {
479
            for (i = 0; i < obj.Item.length; i++) {
480
                var ItemID = getJsonValue(obj.Item[i].ItemID);
481
                var SKU = getJsonValue(obj.Item[i].SKU);
482
                var HitCount = getJsonValue(obj.Item[i].HitCount);
483
                var n = (SKU === undefined ? 0 : SKU.indexOf(" - "));
484
                var row;
485
                var str;
486
                var code;
487
 
488
                if (n > 0) {
489
                    code = SKU.substr(n + 3);
490
                    code = code.substr(code.indexOf(" ") + 1);
491
                    str = '<a href="' + configSearchUrl;
492
                    str += code;
493
                    str += configSearchUrlPart2 + '" target="_blank">';
494
                    str += SKU.substr(n + 3);
495
                    str += '</a>';
496
                    document.getElementById('ProductId' + ItemID).innerHTML = str;
497
                    x = document.getElementById("itemTable");
498
                    row = document.getElementById('ProductId' + ItemID).parentNode.rowIndex;
499
                    setCellsAttribute(x, row, 5, "Price" + code);
500
                    setCellsAttribute(x, row, 6, "Active" + code);
501
                    setCellsAttribute(x, row, 7, "Lower" + code);
502
                    setCellsAttribute(x, row, 8, "Minimum" + code);
503
                    setCellsAttribute(x, row, 9, "Maximum" + code);
504
                    x.rows[row].cells[11].innerHTML = HitCount;
505
                    setCellsAttribute(x, row, 13, "Condition" + code);
506
                    setCellsAttribute(x, row, 14, "BetterCondition" + code);
507
                    setCellsAttribute(x, row, 17, "MinBetterCondition" + code);
508
                    setCellsAttribute(x, row, 18, "BetterConditionBreakdown" + code);
509
                    setCellsAttribute(x, row, 19, "SameConditionBreakdown" + code);
510
                } else {
511
                    row = document.getElementById('ProductId' + ItemID).parentNode.rowIndex;
512
                    document.getElementById("itemTable").deleteRow(row);
513
                }
514
            }
515
        } else {
516
            x.className += " process-errors";
517
            x.innerHTML += '<p class="w3-red"><strong>' + returnCode + ':</strong></p>';
518
 
6 - 519
            var errors = getJsonArray(obj.Errors);
2 - 520
            x.innerHTML += "<p>";
6 - 521
            for (i = 0; i < errors.length; i++) {
522
                x.innerHTML += errors[i].SeverityCode + " (" + errors[i].ErrorCode + "): " + escapeHtml(errors[i].LongMessage) + "<br/>";
2 - 523
            }
524
            x.innerHTML += "</p>";
525
        }
526
 
527
        --productIdsToProcess;
528
        ++productIdsProcessed;
529
        updateProgressBar(maxProductIdsToProcess, productIdsProcessed);
530
    };
531
 
532
    xhr.send(xml);
533
}
534
 
535
function findViews(itemIdList) {
536
    var i;
537
    var xml;
538
 
539
    var xw = new XMLWriter('UTF-8', '1.0');
540
    var xhr = new XMLHttpRequest();
541
 
542
    xw.writeStartDocument();
543
    xw.writeStartElement("GetMultipleItemsRequest");
544
    xw.writeAttributeString('xmlns', 'urn:ebay:apis:eBLBaseComponents');
545
 
546
    for (i = 0; i < itemIdList.length; i++) {
547
        xw.writeElementString('ItemID', itemIdList[i]);
548
    }
549
 
550
    xw.writeElementString('ErrorLanguage', 'en_US');
551
    xw.writeElementString('Version', configeBayShoppingVersion);
552
    xw.writeElementString('WarningLevel', configWarningLevel);
553
 
554
    xw.writeEndElement(); /* xmlrequest */
555
    xw.writeEndDocument();
556
 
557
    xhr.open('POST', configProxyUrl, true);
558
    xhr.setRequestHeader('Content-Type', 'text/xml');
559
    xhr.setRequestHeader('X-EBAY-API-APP-NAME', configAppid);
560
    xhr.setRequestHeader('X-EBAY-API-VERSION', configeBayShoppingVersion);
561
    xhr.setRequestHeader('X-EBAY-API-CALL-NAME', 'GetMultipleItems');
562
    xhr.setRequestHeader('X-EBAY-API-SITEID', '0');
563
    xhr.setRequestHeader('X-EBAY-API-DEV-NAME', '');
564
    xhr.setRequestHeader('X-EBAY-API-CERT-NAME', '');
565
    xhr.setRequestHeader('X-EBAY-API-REQUEST-ENCODING', 'XML');
566
    xhr.setRequestHeader('X-Proxy-URL', configeBayShopping);
567
 
568
    xml = xw.flush();
569
    xw.close();
570
 
571
    xhr.onload = function() {
572
        var obj = XMLparse(xhr.responseXML);
573
 
574
        var returnCode = obj.Ack;
575
 
576
        var x = document.getElementById("results");
577
 
578
        if (returnCode == 'Success') {
579
            for (i = 0; i < obj.Item.length; i++) {
580
                var ItemID = getJsonValue(obj.Item[i].ItemID);
581
                var HitCount = getJsonValue(obj.Item[i].HitCount);
582
 
583
                document.getElementById('Views' + ItemID).innerHTML = HitCount;
584
            }
585
        } else {
586
            x.className += " process-errors";
587
            x.innerHTML += '<p class="w3-red"><strong>' + returnCode + ':</strong></p>';
588
 
6 - 589
            var errors = getJsonArray(obj.Errors);
2 - 590
            x.innerHTML += "<p>";
6 - 591
            for (i = 0; i < errors.length; i++) {
592
                x.innerHTML += errors[i].SeverityCode + " (" + errors[i].ErrorCode + "): " + escapeHtml(errors[i].LongMessage) + "<br/>";
2 - 593
            }
594
            x.innerHTML += "</p>";
595
        }
596
 
597
        --productIdsToProcess;
598
        ++productIdsProcessed;
599
        updateProgressBar(maxProductIdsToProcess, productIdsProcessed);
600
    };
601
 
602
    xhr.send(xml);
603
}
604
 
605
function priceProductIds() {
606
    var i;
607
    var price;
608
    var lowest;
609
    var difference;
610
    var percentage;
611
    var noPricedLower;
612
    var noActive;
613
    var noBetterCondition;
614
    var percLower;
615
    var x = document.getElementById("itemTable");
616
 
617
    initProgressBar('Retrieving Prices (3/3)');
618
 
619
    productsToPrice = 0;
620
    maxProductsToPrice = 0;
621
    productsPriced = 0;
622
 
623
    for (i = 1; i < x.rows.length; i++) {
4 - 624
        if (x.rows[i].cells[4].innerText.length > 0) {
625
            ++productsToPrice;
626
            ++maxProductsToPrice;
627
            findProductPrices(x.rows[i].cells[4].innerText, 1);
628
        }
2 - 629
    }
630
 
631
    function checkProductsToPrice() {
632
        if (productsToPrice > 0) {
633
            window.setTimeout(checkProductsToPrice, 100); // wait 100 milliseconds
634
        } else {
635
            /*
636
                xxxxx
637
                Minimum of 5 comparison listings
638
                (Take out lowest and highest price before calculating the average)
639
                (Don't go under $4.98)
640
                (Price items below cheapest item with better condition)
641
                Price within the first 20-25% listing (by number)
642
                (Price below the average price)
643
                adjust BIN (buy it now) when changing the price: No BIN under $10; minimum accepted 65%, auto-accepted 85+%
644
                (disregard certain sellers (for now decluttr and zuber, list could be expanded))
645
            */
646
            for (i = (x.rows.length - 1); i > 0; i--) {
647
                noPricedLower = Number(x.rows[i].cells[7].innerHTML);
648
                noActive = Number(x.rows[i].cells[6].innerHTML);
649
 
650
                if (noActive < 6) {
651
                    document.getElementById("itemTable").deleteRow(i);
652
                    continue;
653
                }
654
 
655
                if (noPricedLower > 0) {
656
                    price = Number(x.rows[i].cells[5].innerHTML.substr(1));
657
                    lowest = Number(x.rows[i].cells[8].innerHTML.substr(1));
658
                    difference = price - lowest;
659
                    percentage = 100.00 - (lowest / price * 100.00);
660
                    x.rows[i].cells[10].innerHTML = "$" + difference.toFixed(2) + " (" + percentage.toFixed(2) + "%)";
661
 
662
                    percLower = (noPricedLower / noActive) * 100.00;
663
                    if (noPricedLower > 24.99) {
664
                        x.rows[i].cells[5].style.color = "red";
665
                        x.rows[i].cells[7].style.color = "red";
666
                    } else {
667
                        document.getElementById("itemTable").deleteRow(i);
668
                        continue;
669
                    }
670
 
671
                    if (difference < configDifference || percentage < configPercentage || price < configAbsoluteMinPrice) {
672
                        document.getElementById("itemTable").deleteRow(i);
673
                        continue;
674
                    } else {
675
                        x.rows[i].cells[5].style.color = "red";
676
                        x.rows[i].cells[10].style.color = "red";
677
                    }
678
                } else if (noPricedLower === 0) {
679
                    noBetterCondition = Number(x.rows[i].cells[14].innerHTML);
680
                    if (noActive == (noBetterCondition + 1)) {
681
                        document.getElementById("itemTable").deleteRow(i);
682
                        continue;
683
                    }
684
 
685
                    price = Number(x.rows[i].cells[5].innerHTML.substr(1));
686
                    lowest = Number(x.rows[i].cells[8].innerHTML.substr(1));
687
                    difference = price - lowest;
688
                    percentage = 100.00 - (lowest / price * 100.00);
689
                    x.rows[i].cells[10].innerHTML = "$" + difference.toFixed(2) + " (" + percentage.toFixed(2) + "%)";
690
 
691
                    if ((difference * -1.00) < configDifference && (percentage * -1.00) < configPercentage) {
692
                        document.getElementById("itemTable").deleteRow(i);
693
                        continue;
694
                    } else {
695
                        x.rows[i].cells[5].style.color = "green";
696
                        x.rows[i].cells[10].style.color = "green";
697
                    }
698
                    continue;
699
                }
700
            }
701
 
702
            endProgressBar();
703
 
704
            x = document.getElementById("results");
705
            x.innerHTML += '<p><strong>Sorting Report.....</strong></p>';
706
 
707
            sortTableDesc("itemTable", 6);
708
 
709
            x.innerHTML += '<p><strong>Report Finished!</strong></p>';
710
            if (!x.className.includes("process-errors")) {
711
                setTimeout(function() {
712
                    x.className = x.className.replace(" w3-show", "");
713
                }, 3000);
714
            }
715
        }
716
    }
717
 
718
    checkProductsToPrice();
719
}
720
 
721
function findProductPrices(productId, pageNumber) {
722
    var n = productId.indexOf(" ");
723
    var productIdType = productId.substr(0, n);
4 - 724
    var keyword = productId.substr(n + 1);
2 - 725
 
726
    url = configeBayFinding + "?";
727
    if (productIdType == 'ReferenceID') {
728
        url += "OPERATION-NAME=findItemsByProduct";
729
    } else {
730
        url += "OPERATION-NAME=findItemsAdvanced";
731
    }
732
    url += "&RESPONSE-DATA-FORMAT=JSON";
733
    url += "&SECURITY-APPNAME=" + configAppid;
734
    url += "&SERVICE-VERSION=" + configeBayFindingVersion;
735
    url += "&GLOBAL-ID=EBAY-US";
736
    url += "&buyerPostalCode=";
737
    url += configZip;
738
    url += "&paginationInput.entriesPerPage=100";
739
    url += "&paginationInput.pageNumber=";
740
    url += pageNumber;
741
 
742
    if (productIdType == 'ReferenceID') {
743
        url += "&productId.@type=";
744
        url += productIdType;
745
        url += "&productId=";
4 - 746
        url += keyword;
2 - 747
    } else {
748
        url += "&keywords=";
4 - 749
        url += keyword;
2 - 750
    }
751
 
752
    url += "&itemFilter(0).name=ExcludeSeller";
753
    url += "&itemFilter(0).value=";
754
    url += configeBaySellerName;
755
 
756
    var xhttp = new XMLHttpRequest();
757
 
758
    xhttp.onreadystatechange = function() {
759
        if (this.readyState == 4) {
760
            _cb_findProductPrices(JSON.parse(this.responseText));
761
        }
762
    };
763
 
764
 
765
    xhttp.open("GET", configProxyUrl, true);
766
    xhttp.setRequestHeader("X-Proxy-Url", encodeURI(url));
767
    xhttp.send();
6 - 768
 
2 - 769
}
770
 
771
function _cb_findProductPrices(root) {
772
    var array;
773
    var response;
774
    var ack;
775
    var productId;
776
    var i;
777
    var currentPrice;
778
    var Title = "";
779
    var noLower;
780
    var noActive;
781
    var minPrice;
782
    var maxPrice;
783
    var conditionId;
784
    var currentConditionId;
785
    var noBetterCondition;
786
    var myPrice;
787
    var currentPriceInt;
788
    var minBetterCondition;
789
    var betterConditionbBreakdown = [];
790
    var sameConditionbBreakdown = [];
791
 
792
    if (root.findItemsAdvancedResponse !== undefined) {
793
        response = root.findItemsAdvancedResponse[0];
794
    } else if (root.findItemsByProductResponse !== undefined) {
795
        response = root.findItemsByProductResponse[0];
796
    } else {
797
        --productsToPrice;
798
        ++productsPriced;
799
        updateProgressBar(maxProductsToPrice, productsPriced);
800
        return;
801
    }
802
 
803
    ack = response.ack;
804
    if (ack != 'Success') {
4 - 805
        printeBayAPIError('Get Prices', response);
2 - 806
 
807
        if (ack == 'Failure' || ack == 'PartialFailure') {
808
            --productsToPrice;
809
            ++productsPriced;
810
            updateProgressBar(maxProductsToPrice, productsPriced);
811
            return;
812
        }
813
    }
814
 
815
    if (root.findItemsAdvancedResponse !== undefined) {
816
        array = typeof root.findItemsAdvancedResponse[0] != 'object' ? JSON.parse(root.findItemsAdvancedResponse[0]) : root.findItemsAdvancedResponse[0].searchResult[0].item;
817
        response = root.findItemsAdvancedResponse[0];
818
        url = new URL(response.itemSearchURL);
819
        productId = url.searchParams.get("_nkw");
820
    } else {
821
        array = typeof root.findItemsByProductResponse[0] != 'object' ? JSON.parse(root.findItemsByProductResponse[0]) : root.findItemsByProductResponse[0].searchResult[0].item;
822
        url = new URL(response.itemSearchURL);
823
        productId = url.searchParams.get("_productid");
824
    }
825
 
826
    var items = response.searchResult[0].item || [];
827
    noActive = Number(document.getElementById('Active' + productId).innerHTML);
828
    noLower = Number(document.getElementById('Lower' + productId).innerHTML);
829
    myPrice = Number(document.getElementById('Price' + productId).innerHTML.substr(1));
830
    minPrice = Number(document.getElementById('Minimum' + productId).innerHTML.substr(1));
831
    maxPrice = Number(document.getElementById('Maximum' + productId).innerHTML.substr(1));
832
    conditionId = Number(document.getElementById('Condition' + productId).innerHTML);
833
    noBetterCondition = Number(document.getElementById('BetterCondition' + productId).innerHTML);
834
    minBetterCondition = Number(document.getElementById('MinBetterCondition' + productId).innerHTML);
835
    betterConditionbBreakdown = JSON.parse(document.getElementById('BetterConditionBreakdown' + productId).innerHTML);
836
    sameConditionbBreakdown = JSON.parse(document.getElementById('SameConditionBreakdown' + productId).innerHTML);
837
 
838
    for (i = 0; i < items.length; i++) {
839
        Title = items[i].title[0].toLowerCase();
840
        if (Title.includes("disc only") > 0 ||
841
            Title.includes("disk only") > 0 ||
842
            Title.includes("only disc") > 0 ||
843
            Title.includes("only disk") > 0 ||
844
            Title.search(/dis[ck].*only/) > 0) {
845
            continue; // exclude "disc only listing
846
        }
847
 
848
        currentConditionId = (items[i].condition === undefined ? 0 : Number(items[i].condition[0].conditionId));
849
        currentPrice = Number(items[i].sellingStatus[0].convertedCurrentPrice[0].__value__);
850
        currentPriceInt = Math.ceil(currentPrice);
851
 
852
        if (currentConditionId > conditionId) {
853
            continue; // Like for like conditions only
854
        } else if (currentConditionId > conditionId) {
855
            if (minBetterCondition < 0.01 || minBetterCondition > currentPrice) {
856
                minBetterCondition = currentPrice;
857
            }
858
 
859
            ++noBetterCondition;
860
        }
861
 
862
        if (items[i].sellingStatus[0].bidCount === 0 && items[i].listingInfo[0].convertedBuyItNowPrice !== undefined) {
863
            currentPrice = Number(items[i].listingInfo[0].convertedBuyItNowPrice[0].__value__);
864
        }
865
 
866
        if (items[i].shippingInfo[0].shippingServiceCost) {
867
            currentPrice += Number(items[i].shippingInfo[0].shippingServiceCost[0].__value__);
868
        }
869
 
870
        if (currentConditionId > conditionId) {
871
            if (betterConditionbBreakdown[currentPriceInt] === undefined) {
872
                betterConditionbBreakdown[currentPriceInt] = 0;
873
            }
874
            ++betterConditionbBreakdown[currentPriceInt];
875
        } else {
876
            if (sameConditionbBreakdown[currentPriceInt] === undefined) {
877
                sameConditionbBreakdown[currentPriceInt] = 0;
878
            }
879
            ++sameConditionbBreakdown[currentPriceInt];
880
        }
881
 
882
        if (currentPrice < myPrice) {
883
            ++noLower;
884
        }
885
 
886
        if (minPrice < 0.01 || minPrice > currentPrice) {
887
            minPrice = currentPrice;
888
        }
889
 
890
        if (maxPrice < 0.01 || maxPrice < currentPrice) {
891
            maxPrice = currentPrice;
892
        }
893
 
894
        ++noActive;
895
    }
896
 
897
    document.getElementById('Active' + productId).innerHTML = noActive;
898
    document.getElementById('Lower' + productId).innerHTML = noLower;
899
    document.getElementById('Minimum' + productId).innerHTML = '$' + minPrice.toFixed(2);
900
    document.getElementById('Maximum' + productId).innerHTML = '$' + maxPrice.toFixed(2);
901
    document.getElementById('BetterCondition' + productId).innerHTML = noBetterCondition;
902
    document.getElementById('MinBetterCondition' + productId).innerHTML = minBetterCondition;
903
    document.getElementById('BetterConditionBreakdown' + productId).innerHTML = JSON.stringify(betterConditionbBreakdown);
904
    document.getElementById('SameConditionBreakdown' + productId).innerHTML = JSON.stringify(sameConditionbBreakdown);
905
 
906
    if (Number(response.paginationOutput[0].totalPages) > Number(response.paginationOutput[0].pageNumber)) {
907
        ++productsToPrice;
908
        ++maxProductsToPrice;
909
        var row = document.getElementById('Lower' + productId).parentNode.rowIndex;
910
        findProductPrices(document.getElementById("itemTable").rows[row].cells[4].innerText, Number(response.paginationOutput[0].pageNumber) + 1);
911
    }
912
 
913
    --productsToPrice;
914
    ++productsPriced;
915
    updateProgressBar(maxProductsToPrice, productsPriced);
916
}
917
 
918
function changePrice(itemId) {
919
    var i;
920
    var newPrice = parseFloat(document.getElementById('PriceAdj' + itemId).value).toFixed(2);
921
 
922
    if (isNaN(newPrice) || newPrice < configAdjMinPrice) {
923
        document.getElementById('PriceAdj' + itemId).value = '';
924
        return;
925
    }
926
 
927
    document.getElementById('PriceAdj' + itemId).value = newPrice;
928
 
929
    if (eBayAuthTokenFlag === false) {
930
        return;
931
    }
932
 
933
    var xw = new XMLWriter('UTF-8', '1.0');
934
    var xhr = new XMLHttpRequest();
935
 
936
    if (!createAddXML(xw, xhr, 'ReviseItemRequest', 'ReviseItem', itemId, newPrice)) {
937
        return;
938
    }
939
 
940
    xml = xw.flush();
941
    xw.close();
942
 
943
    xhr.onload = function() {
944
        var obj = XMLparse(xhr.responseXML);
945
 
946
        var returnCode = obj.Ack;
947
 
948
        var x = document.getElementById("results");
949
        if (x.className.indexOf("w3-show") == -1) {
950
            x.className += " w3-show";
951
        }
952
        x.className = x.className.replace(" process-errors", "");
953
 
954
        if (returnCode == 'Success' || (returnCode == 'Warning' && (obj.Errors.ErrorCode == '21917108' || obj.Errors.ErrorCode == '23007'))) {
955
            document.getElementById('PriceAdj' + itemId).style.color = "green";
956
 
957
            x.innerHTML = '<p><strong>' + returnCode + '</strong></p>';
958
 
959
            if (returnCode == 'Warning') {
960
                x.innerHTML += "<p>" + obj.Errors.SeverityCode + " (" + obj.Errors.ErrorCode + "): " + escapeHtml(obj.Errors.LongMessage) + "</p>";
961
                x.className += " process-errors";
962
            }
963
            var fees = obj.Fees;
964
            x.innerHTML += "<p>";
965
            for (i = 0; i < fees.length; i++) {
966
                if (fees[i].Fee.text !== "0.0") {
967
                    x.innerHTML += fees[i].Name + ": $" + Number(fees[i].Fee.text).toFixed(2) + "<br/>";
968
                }
969
            }
970
            x.innerHTML += "</p>";
971
 
972
            if (obj.DiscountReason) {
973
                x.innerHTML += "<p>Discount Reason: " + obj.DiscountReason + "</p>";
974
            }
975
 
976
            var recommendations = obj.ListingRecommendations;
977
            if (recommendations) {
978
                if (recommendations.length > 0) {
979
                    for (i = 0; i < recommendations.length; i++) {
980
                        x.innerHTML += decode(recommendations[i]);
981
                    }
982
                } else {
983
                    x.innerHTML += decode(recommendations);
984
                }
985
            }
986
        } else {
987
            document.getElementById('PriceAdj' + itemId).style.color = "red";
988
            x.innerHTML = "<p><strong>" + returnCode + ":</strong></p>";
989
            x.className += " process-errors";
990
 
6 - 991
            var errors = getJsonArray(obj.Errors);
2 - 992
            x.innerHTML += "<p>";
6 - 993
            for (i = 0; i < errors.length; i++) {
994
                x.innerHTML += errors[i].SeverityCode + " (" + errors[i].ErrorCode + "): " + escapeHtml(errors[i].LongMessage) + "<br/>";
2 - 995
            }
996
            x.innerHTML += "</p>";
997
        }
998
 
999
        if (obj.Message) {
1000
            x.innerHTML += obj.Message;
1001
        }
1002
 
1003
        if (!x.className.includes("process-errors")) {
1004
            setTimeout(function() {
1005
                x.className = x.className.replace(" w3-show", "");
1006
            }, 3000);
1007
        }
1008
    };
1009
 
1010
    xhr.send(xml);
1011
}
1012
 
1013
function createAddXML(xw, xhr, xmlrequest, callname, itemId, newPrice) {
1014
    xw.writeStartDocument();
1015
    xw.writeStartElement(xmlrequest);
1016
    xw.writeAttributeString('xmlns', 'urn:ebay:apis:eBLBaseComponents');
1017
 
1018
    xw.writeStartElement('RequesterCredentials');
1019
    xw.writeElementString('eBayAuthToken', eBayAuthToken);
1020
    xw.writeEndElement(); /* RequesterCredentials */
1021
 
1022
    xw.writeStartElement('Item');
1023
 
1024
    xw.writeStartElement('StartPrice');
1025
    xw.writeAttributeString('currencyID', 'USD');
1026
    xw.writeString(newPrice);
1027
    xw.writeEndElement(); /* StartPrice */
1028
 
1029
    //xw.writeElementString('ItemID', itemId);
1030
    xw.writeString('<ItemID>' + itemId + '</ItemID>');
1031
 
1032
    if (document.getElementById('BestOffer' + itemId).innerHTML == 'true') {
1033
        if (newPrice >= 14.99) {
1034
            var autoAcceptPrice = newPrice * configAutoAcceptPrice;
1035
            var minBestOfferPrice = newPrice * configMinBestOfferPrice;
1036
 
1037
            xw.writeStartElement('BestOfferDetails');
1038
            xw.writeElementString('BestOfferEnabled', 'true');
1039
            xw.writeEndElement(); /* BestOfferDetails */
1040
            xw.writeStartElement('ListingDetails');
1041
            xw.writeStartElement('BestOfferAutoAcceptPrice');
1042
            xw.writeAttributeString('currencyID', 'USD');
1043
            xw.writeString(autoAcceptPrice.toFixed(2));
1044
            xw.writeEndElement(); /* BestOfferAutoAcceptPrice */
1045
            xw.writeStartElement('MinimumBestOfferPrice');
1046
            xw.writeAttributeString('currencyID', 'USD');
1047
            xw.writeString(minBestOfferPrice.toFixed(2));
1048
            xw.writeEndElement(); /* MinimumBestOfferPrice */
1049
            xw.writeEndElement(); /* ListingDetails */
1050
        } else {
1051
            xw.writeStartElement('BestOfferDetails');
1052
            xw.writeElementString('BestOfferEnabled', 'false');
1053
            xw.writeEndElement(); /* BestOfferDetails */
1054
        }
1055
    }
1056
 
1057
    xw.writeEndElement(); /* Item */
1058
 
1059
    xw.writeElementString('ErrorLanguage', 'en_US');
1060
    xw.writeElementString('Version', configeBayTradingVersion);
1061
    xw.writeElementString('WarningLevel', configWarningLevel);
1062
 
1063
    xw.writeEndElement(); /* xmlrequest */
1064
    xw.writeEndDocument();
1065
 
1066
    xhr.open('POST', configProxyUrl, true);
1067
    xhr.setRequestHeader('Content-Type', 'text/xml');
1068
    xhr.setRequestHeader('X-EBAY-API-APP-NAME', configAppid);
1069
    xhr.setRequestHeader('X-EBAY-API-COMPATIBILITY-LEVEL', configeBayTradingVersion);
1070
    xhr.setRequestHeader('X-EBAY-API-CALL-NAME', callname);
1071
    xhr.setRequestHeader('X-EBAY-API-SITEID', '0');
1072
    xhr.setRequestHeader('X-EBAY-API-DEV-NAME', '');
1073
    xhr.setRequestHeader('X-EBAY-API-CERT-NAME', '');
1074
    xhr.setRequestHeader('X-Proxy-URL', configServiceEndpoint);
1075
 
1076
    return true;
1077
}
1078
 
1079
function connected() {
1080
    var x;
1081
 
1082
    eBayAuthTokenFlag = true;
1083
    document.getElementById("connected").innerHTML += " (Connected)";
1084
 
1085
    x = document.getElementById("login");
1086
    x.className = x.className.replace(" w3-show", "");
1087
 
1088
    x = document.getElementById("results");
1089
    x.innerHTML = "";
1090
    x.className = x.className.replace(" w3-show", "");
1091
}
1092
 
1093
    </script>
1094
 
1095
</body>
1096
</html>