opencarlos
opencarlos
/ js.js
Created
May 30, 2023 16:55
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| javascript:function lineItem(e,n){e.forEach((e=>{line=e.querySelector(".Polaris-Link_yj5sy"),line&&(query=line.getAttribute("href"),lineCont=e,querySplit=query.split("/"),pID=querySplit[3],varID=querySplit[5],fetch(`${n}/admin/api/2022-04/variants/${varID}.json`).then((e=>e.json())).then((n=>{datacont=document.createElement("table"),datacont.innerHTML=`<table align="left">\n <th align="center" style="border-bottom: 1px solid #e1e3e5">\n Inventory Qty\n </th>\n <th align="center" style="border-bottom: 1px solid #e1e3e5">\n Inventory Policy\n </th>\n <th align="center" style="border-bottom: 1px solid #e1e3e5">\n Inventory Tracker\n </th>\n </tr>\n <tr >\n <td align="center" style="padding: .5rem 0">\n <span style="background-color:#91e0d6;padding:3px;border-r |
opencarlos
/ gist:ba5adb585e29c091f4722e16d72f1791
Last active
May 25, 2023 17:13
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with MERCHANT AS ( | |
| SELECT | |
| c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA, | |
| om.OS_MERCHANT AS MERCHANT, | |
| om.OS_STORE_ID AS STORE_ID, | |
| om.os_store_url AS STORE_URL | |
| FROM | |
| ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c | |
| JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID | |
| WHERE |
opencarlos
/ change.sql
Created
May 24, 2023 20:46
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with MERCHANT AS ( | |
| SELECT | |
| c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA, | |
| om.OS_MERCHANT AS MERCHANT, | |
| om.OS_STORE_ID AS STORE_ID, | |
| om.os_store_url AS STORE_URL | |
| FROM | |
| ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c | |
| JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID | |
| WHERE |
opencarlos
/ assignees.sql
Created
May 24, 2023 20:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with MERCHANT AS ( | |
| SELECT | |
| c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA, | |
| om.OS_MERCHANT AS MERCHANT, | |
| om.OS_STORE_ID AS STORE_ID, | |
| om.os_store_url AS STORE_URL | |
| FROM | |
| ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c | |
| JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID | |
| WHERE |
NewerOlder