← back to Kravet Sheet Sync 2026 04 20
__pycache__/fix_pilot_variants.cpython-314.pyc
28 lines
+
x
Yj! � � � R t ^ RIt^ RIt^ RIt^ RIt^ RIt]P P RR4 t
Rt R&R lt R t
]
! R4 tRt] F� w ttttt]' d ]! ]4 P- 4 MRt]' d R ] R
2MR tR ]! ]4 R
RR]RR/RRRR]/./t]' d ]R8w d ]! ]4 R
]R, R& ] ! ]R]R].RR/4 t]R, R , R , t ] ' d ] ! R ] R ] 24 K� ]R, R , R , ^ , t ] ! R ] R!] R, R"] R , R#] R$, R%2 4 K� R# )'z3Add missing main-sell variant to 10 pilot products.N�SHOPIFY_ADMIN_TOKEN� zPhttps://designer-laboratory-sandbox.myshopify.com/admin/api/2024-10/graphql.jsonc
�F � \ P ! R T RT;' g / /4 P 4 p\ P ! \ P
P
\ P
P \ VRRRR\ /R7 ^ R7 P 4 4 # )�query� variables�POSTz Content-Typezapplication/jsonzX-Shopify-Access-Token)�data�method�headers)�timeout) �json�dumps�encode�loads�urllib�request�urlopen�Request�URL�TOKEN�read)�q�v�bodys && �2kravet-sheet-sync-2026-04-20/fix_pilot_variants.py�gqlr s� � �
���W�Q�{�1�7�7��3� 4� ;� ;� =�D� �:�:�f�n�n�,�,�V�^�^�-C�-C�C�T�Y_� � 0�1I�%�P� .D� .R�Z\� -� ^�^b�^b�^d� f� f� c �� � \ P ! R RRV R2.RRRR7 p\ P ! \ P
! VP 4 4 Uu. uF q"' g K VNK up# u upi )�sshzroot@45.61.58.125zLPGPASSWORD=DW2024! psql -h 127.0.0.1 -U dw_admin -d dw_unified --csv -t -c "�"T)�capture_output�text�check)�
subprocess�run�csv�reader�io�StringIO�stdout)r �r�rows & r �pgr,
sg � ��n�n�e� /�T�UV�TW�WX�Y�[��t�$�0�A� �:�:�b�k�k�!�(�(�&;�<� D�<�C��C�C�<� D�D�� Ds � A/�&A/az
SELECT c.dw_sku, c.shopify_product_id, c.price_retail::text, c.cost_price::text,
n.width
FROM kravet_catalog c
JOIN kravet_diff_new_2026_04_20 n ON n.new_dw_sku = c.dw_sku
WHERE c.dw_sku IN ('DWKK-140010','DWKK-140056','DWKK-140544','DWKK-140783','DWKK-141930',
'DWKK-142436','DWKK-142909','DWKK-143582','DWKK-143879','DWKK-144813')
z�mutation($pid:ID!,$vs:[ProductVariantsBulkInput!]!,$st:ProductVariantsBulkCreateStrategy){
productVariantsBulkCreate(productId:$pid,variants:$vs,strategy:$st){
productVariants{id sku title price}
userErrors{field message}
}
}zSold Per Single Roll - zIn Widez Single Roll�pricez.2f�
inventoryItem�sku�trackedT� optionValues�
optionName�Title�name�cost�pid�vs�st�DEFAULTr �productVariantsBulkCreate�
userErrorsz z FAIL: �productVariantsz: added z @ $z '�title�')N) �__doc__r �urllib.requestr r# r' r% �os�environ�getr r r r, �rows�ADD�dw_skur6 r- r5 �width�str�strip�w�
option_val�floatr r* �errs�print�nv� r r �<module>rQ sv �� 9� 0� 0� 0��j�j�n�n�*�2�.��V��f�
E�
� � ���� (,�#�F�C���e� #��E�
�����A�9:�*�1�#�W�5�
�J��E�%�L��%��%���D�9��,����D�E� �A�
���
�(-�d� �C�'8��/��6�"� �C�%��d�Q�C��y�9�:�A� �V�9�0� 1�,� ?�D� �
��6�(�'�$��(�)�
�v�Y�2�
3�4E�
F�q�
I��
��6�(�(�2�e�9�+�T�"�W�+� �c�"�W�+� �a�P�Q�! (,r