← back to Kravet Fabric Fix 2026 04 23
chore: macstudio3 migration — reconcile from mac2 + repoint paths (stevestudio2→macstudio3, node/npm/npx→/opt/homebrew)
d3fd36d5232c4789e85f2d43a20630d0322272d0 · 2026-07-03 08:08:06 -0700 · Steve
Files touched
M archive_no_sheet_match.pyM fix_dwkk_misclassified.pyM fix_shopify_orphans.pyM resolve_missing_ids.py
Diff
commit d3fd36d5232c4789e85f2d43a20630d0322272d0
Author: Steve <steve@designerwallcoverings.com>
Date: Fri Jul 3 08:08:06 2026 -0700
chore: macstudio3 migration — reconcile from mac2 + repoint paths (stevestudio2→macstudio3, node/npm/npx→/opt/homebrew)
---
archive_no_sheet_match.py | 8 ++++----
fix_dwkk_misclassified.py | 4 ++--
fix_shopify_orphans.py | 6 +++---
resolve_missing_ids.py | 8 ++++----
4 files changed, 13 insertions(+), 13 deletions(-)
diff --git a/archive_no_sheet_match.py b/archive_no_sheet_match.py
index 621c6c3..1e1a302 100644
--- a/archive_no_sheet_match.py
+++ b/archive_no_sheet_match.py
@@ -9,10 +9,10 @@ from concurrent.futures import ThreadPoolExecutor, as_completed
import importlib.util
spec = importlib.util.spec_from_file_location('fx',
- '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
+ '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
fx = importlib.util.module_from_spec(spec); spec.loader.exec_module(fx)
-SHEET_CSV = '/Users/stevestudio2/Projects/kravet-sheet-sync-2026-04-20/kravet_sheet_2026-04-20.csv'
+SHEET_CSV = '/Users/macstudio3/Projects/kravet-sheet-sync-2026-04-20/kravet_sheet_2026-04-20.csv'
sheet = {}
with open(SHEET_CSV) as f:
for row in csv.DictReader(f):
@@ -22,7 +22,7 @@ print(f'Sheet rows: {len(sheet)}')
# No-sheet-match DWKKs from previous run
no_match = []
-with open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/orphan_fix_results.jsonl') as f:
+with open('/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/orphan_fix_results.jsonl') as f:
for line in f:
r = json.loads(line)
if r['status'] == 'no_sheet_match' and r.get('dw_sku'):
@@ -80,7 +80,7 @@ LOOKUP_BY_SKU = '''query($q: String!) {
}
}'''
-out = open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/archive_results.jsonl', 'w')
+out = open('/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/archive_results.jsonl', 'w')
def archive_one(item):
diff --git a/fix_dwkk_misclassified.py b/fix_dwkk_misclassified.py
index cd16306..dfbe664 100644
--- a/fix_dwkk_misclassified.py
+++ b/fix_dwkk_misclassified.py
@@ -22,8 +22,8 @@ SHOP = 'designer-laboratory-sandbox.myshopify.com'
TOKEN = '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'
GQL = f'https://{SHOP}/admin/api/2024-10/graphql.json'
SSH = ['ssh', 'root@45.61.58.125']
-CSV_PATH = '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/dwkk_misclassified_2026-04-23.csv'
-RESULTS = '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_results.jsonl'
+CSV_PATH = '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/dwkk_misclassified_2026-04-23.csv'
+RESULTS = '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/fix_results.jsonl'
TITLE_USE = {'MULTIPURPOSE': 'Multipurpose', 'UPHOLSTERY': 'Upholstery', 'DRAPERY': 'Drapery'}
STRIP_TITLE = re.compile(r'\s*\|\s*(wallpaper|wallcovering)s?\b', re.I)
diff --git a/fix_shopify_orphans.py b/fix_shopify_orphans.py
index a1134fe..490dfe7 100644
--- a/fix_shopify_orphans.py
+++ b/fix_shopify_orphans.py
@@ -15,11 +15,11 @@ from concurrent.futures import ThreadPoolExecutor, as_completed
import importlib.util
spec = importlib.util.spec_from_file_location('fx',
- '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
+ '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
fx = importlib.util.module_from_spec(spec); spec.loader.exec_module(fx)
-SHEET_CSV = '/Users/stevestudio2/Projects/kravet-sheet-sync-2026-04-20/kravet_sheet_2026-04-20.csv'
-OUT_PATH = '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/orphan_fix_results.jsonl'
+SHEET_CSV = '/Users/macstudio3/Projects/kravet-sheet-sync-2026-04-20/kravet_sheet_2026-04-20.csv'
+OUT_PATH = '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/orphan_fix_results.jsonl'
# Build sheet.use map
sheet = {}
diff --git a/resolve_missing_ids.py b/resolve_missing_ids.py
index f14d4c2..cd03ce0 100644
--- a/resolve_missing_ids.py
+++ b/resolve_missing_ids.py
@@ -5,7 +5,7 @@ import json, re, subprocess, sys, time, urllib.request
import importlib.util
spec = importlib.util.spec_from_file_location('fx',
- '/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
+ '/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/fix_dwkk_misclassified.py')
fx = importlib.util.module_from_spec(spec); spec.loader.exec_module(fx)
SHOP, TOKEN, SSH = fx.SHOP, fx.TOKEN, fx.SSH
@@ -18,7 +18,7 @@ LOOKUP = '''query($q: String!) {
}'''
missing = []
-with open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_results.jsonl') as f:
+with open('/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/fix_results.jsonl') as f:
for line in f:
r = json.loads(line)
if r['status'] == 'fetch_error':
@@ -27,13 +27,13 @@ with open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/fix_results
# sheet_use lookup from CSV
import csv
uses = {}
-with open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/dwkk_misclassified_2026-04-23.csv') as f:
+with open('/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/dwkk_misclassified_2026-04-23.csv') as f:
for row in csv.DictReader(f):
uses[row['dw_sku']] = row['sheet_use']
print(f'Resolving {len(missing)} missing IDs...')
resolved, still_missing, fixed = 0, 0, 0
-out = open('/Users/stevestudio2/Projects/kravet-fabric-fix-2026-04-23/resolve_results.jsonl', 'w')
+out = open('/Users/macstudio3/Projects/kravet-fabric-fix-2026-04-23/resolve_results.jsonl', 'w')
for i, dw in enumerate(missing, 1):
try:
← 668a148 auto-save: 2026-06-26T06:12:56 (1 files) — __pycache__/fix_d
·
back to Kravet Fabric Fix 2026 04 23
·
auto-save: 2026-07-14T08:29:59 (2 files) — archive_no_sheet_ 11edf5c →