Here is the product page of the previous link. I can see the listing now. I’m checking resale economics, differentiation, supplier quality signals, and whether it fits a no-upfront-cost fulfillment model. Verdict: good sample product, weak flagship, poor profit-share partner The product itself is visually appealing and review sentiment is positive, but I would not sign a profit-sharing agreement with KitchenWise Home Store yet. What the listing tells us From the screenshot: 214 sold across all variants 38 reviews at 4.8 $9.99 for the selected 300 ml variant KitchenWise is explicitly identified as a “Trader,” not a factory Only 81.1% of deliveries arrive within 13 days The page shows 917 available, but that is not the same as inventory contractually reserved for your orders The specification says “capacity under 0.25 L,” while the selected option says 300 ml. That catalog inconsistency could produce feed errors and customer confusion. The listing has been price-tracked since March 13, 2025. Using the current 214-sold figure, its rough historical average is only approximately 3 units weekly or 14 monthly. This is an imperfect upper-bound estimate—not current audited velocity—but it does not indicate a market-winning product. The historical average price for the cheapest variant has been about $9.95, so the displayed $9.99 is essentially a normal consumer price, not a special wholesale opportunity. Factor Assessment Visual appeal Good Verified demand Moderate to low Differentiation Low Current margin potential Weak Supplier suitability Weak Worth sampling Yes Worth scaling unchanged No The category is already price-competitive A very similar 750 ml NiHome product—with two caps, straw and borosilicate-glass positioning—is listed from approximately $12.99 at Walmart and has 89 reviews. The same marketplace contains numerous glass tumbler multipacks around $13–$20. This creates a difficult price ceiling: Unchanged generic product: probably $17.95–$19.95 Improved, branded bundle: potentially $24.95–$29.95 $29.95 generic single bottle: difficult to defend against lower-priced marketplace alternatives Illustrative economics Assume: Supplier charge: $9.99 delivered Payment processing: 2.9% + $0.30 Advertising: 25% of revenue Refund/breakage reserve: 8% Supplier performance fee: 12% of positive contribution profit Retail price Your estimated retained contribution $19.99 $2.22 $24.99 $5.04 $29.99 $7.86 This is optimistic because: The $9.99 appears to be the 300 ml option, not necessarily 500 or 750 ml. The price is promotional and may be partly supported by AliExpress Choice. Customer service, software, replacement shipments and business overhead are not included. A $24.99–$29.99 price would be difficult without meaningful upgrades. At a realistic generic selling price of $19.99, the economics are too thin for paid acquisition and a supplier profit share. There is a much better direct sourcing path I found a near-identical Alibaba product: 350/500/700 ml glass bottle with time markers, straw and two lids It is offered by Cangzhou Oucai Cheng Glass Products Co., Ltd. for approximately $1.62–$2.09 per unit, with an MOQ of only 20. The listing shows a 4.7 rating across 25 reviews. Alibaba identifies the company as a hybrid manufacturer and trading company, so you would still need to confirm whether this particular bottle and its lids are produced internally or purchased from another factory. That likely explains the supply chain: Manufacturer or assembler → KitchenWise trader → AliExpress Choice fulfillment → retail customer For a long-term agreement, it is better to negotiate with the Alibaba supplier—or use it together with a fulfillment agent—rather than give the AliExpress retailer part of your profits. Recommended structure for this product Do not initially offer KitchenWise a profit share. They already earn a retail margin inside the $9.99 price. Instead, propose: Fixed all-inclusive price Your green-light targets should be approximately: Variant Maximum target DDP cost per customer order 300–350 ml $6.50–$7.00 500 ml $7.50–$8.00 700–750 ml $8.50–$9.00 The price must include: Product Both lids Straw Protective retail packaging Pick-and-pack International shipping Import charges and customs handling Damage replacement Valid end-to-end tracking Performance-based fulfillment bonus Rather than sharing your financial statements and profits, offer approximately: $0.25–$0.50 per successfully delivered bottle Pay the bonus only when: At least 95% ship within the contractual timeframe Valid tracking exceeds 99% Breakage and defects stay below 2% The package contains no AliExpress invoice, supplier advertisement or QR code The supplier does not contact your customer Customer data is used only for fulfillment Alternatively, offer 5% of positive order contribution profit, capped at $1 per order, but only when the supplier holds inventory and finances production and shipping until your customer’s payment settles. Zero-out-of-pocket payment cycle For a 30-order pilot: Your customer pays your store. The payment settles. The supplier accepts and ships the order. You pay the fixed base price from the settled customer funds. You retain 10% of the supplier payment for 30–45 days as a breakage reserve. The fulfillment bonus is paid monthly after delivery and refund reconciliation. Do not pay for 100 or 500 units in advance merely because the product has an Alibaba MOQ. The near-identical Alibaba listing has a low MOQ of 20, making a small controlled test possible. How to make the product defensible The current design is too generic. I would develop the 500 ml version as the primary SKU and add: Protective silicone sleeve or silicone bottom boot One fully sealed travel lid One straw lid Stainless-steel straw with a soft silicone tip Spare gasket Straw and bottle-cleaning brush Verified borosilicate glass Custom iced-latte, matcha or hydration measurement markings Protective gift box Replacement guarantee for transit breakage The positioning should be narrower than “water bottle for women and girls.” A stronger concept would be: 500 ml Glass Iced-Latte Bottle with Sealed Travel Lid and Straw Lid A matcha or iced-coffee bundle could also include recipe markings and a small recipe booklet. That may support a $24.95–$29.95 retail price without relying solely on the bottle. Sample tests before selling Order at least three units in each shortlisted size and test: Twenty-four-hour upside-down leakage Vigorous shaking with both lids Lid-thread durability Gasket odor and staining Straw fit and cleaning Dishwasher cycling Measurement-print durability Packaging drop resistance Breakage across separate shipments Fit in standard vehicle cup holders Actual filled weight and shipping weight Do not advertise it as hot-drink-safe, borosilicate, dishwasher-safe or completely leakproof until the supplier provides documentation and your samples pass testing. Recommended decision Do not launch or partner through the AliExpress listing unchanged. Use KitchenWise only for a few rapid samples. Send a parallel RFQ to Cangzhou Oucai Cheng for the near-identical wholesale version. Proceed only when you can obtain an enhanced 500 ml bottle at no more than approximately $8 delivered, with neutral fulfillment, documented food-contact materials and a delivery SLA above 95%. Yes. I applied a strict pre-screen for mainland U.S. delivery, valid product pages, U.S. inventory, brandless/customizable potential, and a publicly stated delivery window of 10 days or less. A critical distinction: these listings pass a fast-stock pre-screen, not yet a customer-delivery guarantee. Most Alibaba offers are carton orders delivered to you or a warehouse—not automatically one-unit blind dropshipping to each customer. Top 10 fast-shipping candidates Prices are displayed product prices and generally should not be interpreted as final one-unit DDP fulfillment costs. Rank Product and valid link Public shipping signal Displayed price/MOQ Commercial verdict 1 Coffee bean storage cellar/display rack U.S. local warehouse, 24-hour dispatch, approximately 2–7 days About $4.10, MOQ 100 sets Best premium niche. Upgrade to valve-equipped tubes, dosing marks, funnel and walnut/acacia stand. Test retail: $39.95–$59.95. 2 500 ml borosilicate glass water bottle U.S. warehouse; listing states 10-day delivery MOQ 100; quotation needed Best potential flagship. Add a silicone boot, sealed travel lid, straw lid, spare gasket and cleaning brush. Test retail: $24.95–$29.95. 3 Whiskey decanter, four glasses and wooden gift box California/New Jersey stock, dispatch within 24 hours and approximately 3–5 business days $116 per displayed pack; confirm whether it contains four complete sets Best high-order-value gift. Ideal for engraving, weddings, anniversaries and corporate gifts. Test retail per complete set: $79–$129. 4 Large acacia cutting board with juice groove U.S. local stock and 7-day delivery Current quotation required Strong personalization product. Sell as a housewarming, wedding or grill gift rather than a generic board. Test retail: $39.95–$69.95. 5 Acacia and resin charcuterie serving board U.S. local stock and 7-day delivery About $9.58, MOQ 10 Premium gifting opportunity. Require documentation that the cured resin and finish are appropriate for the intended food-contact use. Test retail: $49.95–$79.95. 6 40 oz handled glass travel tumbler U.S. local stock and 7-day delivery Public tiers include approximately $3.06 at 72+ units High demand but competitive. Differentiate through an anti-slip base, leak-resistant lid and iced-coffee or hydration markings. Test retail: $29.95–$39.95. 7 16 oz Libby-style glass can with bamboo lid and straw U.S. stock and approximately 2–5 days Current quotation required Good bundle component, weak generic standalone product. Position as an iced-latte, matcha or cocktail set. Test retail: $24.95–$34.95 for two. 8 Seven-piece bourbon glass gift set U.S. local stock and 7-day delivery About $7.70, MOQ 18 units Strong lower-priced gift SKU. Confirm exactly what comprises the seven pieces and the wooden-box quality. Test retail: $39.95–$59.95. 9 Double-wall snow-globe glass tumbler U.S. local stock and 7-day delivery About $2.60–$3.40, MOQ 25 Novelty test only. Good for seasonal personalization, but trend and leakage risk are higher. Test retail: $24.95–$34.95. 10 Candy-colored jelly glass cans U.S. local stock and 7-day delivery Around $1.53 displayed, generally case quantities Low-cost social-media test. Sell as coordinated two- or four-piece sets rather than individually. Test retail: $24.95–$39.95 per set. Recommended order of execution The first five products are the strongest commercially: Coffee bean cellars Improved 500 ml glass bottle Whiskey decanter gift set Personalized acacia cutting board Acacia-resin charcuterie board The glass-can, snow-globe and colored-tumbler products are inexpensive to test, but they are substantially more saturated and trend-sensitive. AliExpress findings I could not honestly certify ten AliExpress listings for delivery within ten calendar days. AliExpress delivery estimates change with destination, selected variant, shipping method and inventory location. Your KitchenWise bottle currently fails the strict requirement: the screenshot shows an estimated window of approximately 7–14 days and only 81.1% delivered within 13 days. These are valid AliExpress product links for samples and market comparison, but they are not approved for a 10-day customer promise until the checkout page shows U.S. dispatch and a destination-specific window of ten days or less: Product AliExpress link Current decision Coffee bean cellar organizer View listing Sample only; U.S. delivery SLA unverified Two-in-one glass oil sprayer View listing Sample only; U.S. delivery SLA unverified Thirty amber vanilla-extract bottles View listing Potential bulk sample; SLA unverified Sourdough starter jar kit View listing Attractive niche, but SLA unverified Glass sprouting kit View listing Attractive niche, but SLA unverified Glass butter dish View listing Lower-priority sample; SLA unverified Indexed snapshots confirm the coffee-cellar, vanilla-bottle, oil-sprayer and sourdough product identities, but not a dependable destination-specific ten-day delivery commitment. Why vanilla, sourdough and sprouting are absent from the approved top 10 They remain good product opportunities, but I did not find public listings that simultaneously demonstrated: U.S.-based inventory One-unit fulfillment capability Dispatch within one business day Delivery within ten calendar days The practical solution is to have the manufacturer place a small consignment quantity—perhaps 50–100 units—inside a U.S. warehouse or third-party logistics provider. The supplier retains ownership of the stock, while the warehouse ships individual customer orders. Requirements before calling any product “10-day delivery” A supplier should not be approved solely because Alibaba displays a “7-day delivery” badge. Require all of the following: Requirement Minimum standard Inventory Physically located in a named U.S. warehouse Fulfillment One-unit blind dropshipping, not merely carton delivery Handling Carrier acceptance within one business day Delivery No more than ten calendar days from order acceptance Tracking USPS, UPS, FedEx or another agreed end-to-end carrier Packaging Neutral; no Alibaba, AliExpress or supplier promotion Inventory reporting Daily inventory file or API access On-time rate At least 95% during a 30-order pilot Damage rate Below 2% for glass products Late-delivery remedy Shipping credit plus agreed service credit Stockout remedy Immediate rejection before the customer is charged Contract language Supplier warrants that at least 95% of accepted customer orders will be delivered within ten calendar days after order acceptance. Supplier will tender each shipment to the approved carrier within one business day and provide valid end-to-end tracking. Products will be fulfilled individually from Supplier's United States inventory using neutral packaging and without supplier advertisements, invoices, QR codes, marketplace branding or customer solicitation. An order delivered after ten calendar days will receive a full outbound shipping credit and the agreed late-service credit. Supplier-caused cancellations, stockouts, invalid tracking, breakage, incorrect shipments and defects will receive a full all-in fulfillment credit. Supplier must notify Brand before accepting an order if U.S. inventory is unavailable. Supplier may not substitute international fulfillment without Brand's written approval. Alibaba’s protection is strongest when product specifications and shipping obligations are written into the online Trade Assurance order and payment is made through Alibaba. A separate verbal promise or off-platform profit-sharing agreement would not receive the same platform protection. Delivery-validation test Before advertising ten-day shipping, place three separate one-unit orders to: A West Coast address A central U.S. address An East Coast address Repeat this with at least two suppliers per priority product. Record order acceptance, first carrier scan, delivery, packaging condition and tracking validity. Only suppliers achieving at least 95% delivery within ten calendar days over the first 30 orders should receive continuing customer orders. Wonderful! Thank you so much! The second product is unavailable. I think 10 is better to be replaced with something from KitchenWare on aliexpress? Can we please produce each products Shopify listing? import csv from pathlib import Path from artifact_tool import Workbook, SpreadsheetFile out_dir = Path("/mnt/data") xlsx_path = out_dir / "shopify_glass_kitchenware_listings.xlsx" csv_path = out_dir / "shopify_product_drafts.csv" products = [ { "rank": 1, "title": "Single-Dose Coffee Bean Cellar Set with Display Rack", "handle": "single-dose-coffee-bean-cellar-set", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html", "shipping_signal": "Supplier claim previously screened as U.S. stock / 2–7 days; reconfirm by ZIP.", "ten_day_status": "Recheck", "status": "Draft", "price": 49.95, "compare_at": 59.95, "source_cost": "$4.10 displayed before shipping/fulfillment; request an all-in DDP quote.", "category": "Home & Garden > Kitchen & Dining > Food Storage > Food Storage Containers", "type": "Coffee Bean Storage", "collection": "Coffee Bar", "tags": "coffee, espresso, single-dose, bean-cellar, coffee-bar, glass-storage, home-barista, gift", "country": "China — confirm", "hs_code": "Composite set; customs-broker classification required", "sku": "CFC-CLR-SET", "option_name": "Title", "variants": [("Default Title", 49.95, 59.95, "CFC-CLR-SET")], "description": ( "Build a cleaner, more consistent coffee ritual with pre-portioned beans ready for each brew. " "This countertop cellar set organizes individual doses in clear glass tubes so espresso, pour-over, " "decaf, and tasting beans stay easy to identify." "Individual glass tubes help organize single-brew portions" "Compact display rack keeps the coffee station tidy" "Clear design makes each roast easy to see" "Useful for coffee, tea, spices, or tasting samples" "What’s included: Display rack and glass storage tubes with caps. " "Final tube count and cap style will match the approved production configuration." "Care: Hand wash components and dry completely before refilling." ), "seo_title": "Single-Dose Coffee Bean Cellar Set with Glass Tubes", "seo_description": "Organize espresso and pour-over portions in clear glass tubes with a compact countertop rack—a polished coffee-station gift for home brewers.", "care": "Hand wash components and dry completely. Do not make freshness or valve claims until samples are verified.", "media": "Hero full set; overhead tube layout; tubes filled with beans; rack close-up; dimensions graphic; coffee-bar lifestyle; protective packaging.", "validation": "Confirm tube count, cap material, one-unit blind fulfillment, U.S. stock, breakage packaging, and whether valves are genuine.", "sample_tests": "Tube-cap fit; stand stability; glass defects; labeling adhesion; pack-out drop test.", "fulfillment": "One-unit neutral shipment; stock feed; valid tracking within 1 business day.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 2, "title": "2-in-1 Glass Oil Sprayer & Pourer – 16 oz", "handle": "2-in-1-glass-oil-sprayer-pourer-16oz", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html", "shipping_signal": "Alibaba local-stock listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 24.95, "compare_at": 29.95, "source_cost": "$2.50 displayed at MOQ 100 before direct-to-customer fulfillment.", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar Dispensers > Oil Dispensers", "type": "Oil Sprayer & Dispenser", "collection": "Kitchen Essentials", "tags": "oil-sprayer, oil-dispenser, glass-kitchenware, cooking-tools, meal-prep, kitchen-essentials, 16oz", "country": "China — confirm", "hs_code": "Provisional 7013.49; mechanism may alter classification—broker review required", "sku": "OIL-2IN1-16", "option_name": "Title", "variants": [("Default Title", 24.95, 29.95, "OIL-2IN1-16")], "description": ( "Measure, mist, or pour cooking oil from one streamlined bottle. The 16 oz glass body keeps " "contents visible while the dual-function top makes it easy to switch between light coverage and a steady pour." "Two dispensing modes: spray and pour" "16 oz clear glass bottle" "Useful for cooking oils, vinegar, and thin dressings" "Countertop-friendly design for everyday meal prep" "Care: Hand wash the top mechanism. Follow the approved supplier instructions for the glass body. " "Do not use with thick or particle-filled sauces unless compatibility is confirmed." ), "seo_title": "16 oz Glass Oil Sprayer & Pourer | 2-in-1 Dispenser", "seo_description": "Spray or pour cooking oil from one 16 oz glass bottle. The dual-function top supports controlled coverage, easy drizzling, and tidy storage.", "care": "Hand wash the sprayer head; test oil viscosity and spray pattern before publication.", "media": "Hero bottle; spray function; pour function; filled bottle; lid disassembled; hand-scale image; countertop lifestyle; packaging.", "validation": "Confirm food-contact reports, spray consistency, leak resistance, replacement gaskets, color options, and one-unit U.S. fulfillment.", "sample_tests": "24-hour inversion; 200 spray cycles; oil odor retention; pour control; dishwasher exposure only if claimed; packaging drop test.", "fulfillment": "U.S.-stock blind shipping, one-unit pick-and-pack, tracking within 1 business day.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 3, "title": "Whiskey Decanter Gift Set with 4 Glasses & Wooden Box", "handle": "whiskey-decanter-set-4-glasses-wooden-box", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html", "shipping_signal": "U.S. warehouse listing previously screened at approximately 3–5 business days.", "ten_day_status": "Recheck", "status": "Draft", "price": 109.95, "compare_at": 129.95, "source_cost": "$116 displayed per pack; confirm whether the pack contains four complete gift sets.", "category": "Home & Garden > Kitchen & Dining > Barware > Decanters", "type": "Whiskey Decanter Set", "collection": "Home Bar & Gifts", "tags": "whiskey, bourbon, decanter, barware, wooden-box, wedding-gift, groomsmen-gift, home-bar", "country": "China — confirm", "hs_code": "Provisional 7013.49 for glassware set; customs-broker review required", "sku": "DEC-4GLS-WBX", "option_name": "Title", "variants": [("Default Title", 109.95, 129.95, "DEC-4GLS-WBX")], "description": ( "Turn a home bar into a gift-worthy presentation with a glass decanter, four matching glasses, " "and a vintage-style wooden storage box." "Coordinated decanter and four-glass set" "Wooden presentation box for storage and gifting" "Designed for bourbon, whisky, brandy, or non-alcoholic spirits" "Blank surfaces may support personalization when offered" "Includes: 1 decanter, 4 glasses, and 1 wooden presentation box." "Care: Hand wash glassware and dry the wooden box promptly. Confirm stopper fit before long-term storage." ), "seo_title": "Whiskey Decanter Set with 4 Glasses & Wooden Gift Box", "seo_description": "Gift-ready whiskey decanter set with four matching glasses and a vintage-style wooden presentation box for bourbon lovers and home bars.", "care": "Hand wash. Do not claim lead-free crystal, airtight storage, or dishwasher safety without documents and tests.", "media": "Hero box open; complete set; decanter stopper close-up; four glasses; pouring lifestyle; personalization area; protective packaging.", "validation": "Confirm pack configuration, decanter capacity, glass composition, stopper seal, box material, engraving area, and actual per-set DDP cost.", "sample_tests": "Stopper seal; pour test; glass rim inspection; box hinges/latch; engraving test; multi-drop packaging test.", "fulfillment": "Individual gift-set shipment from U.S. stock with neutral outer carton and damage replacement.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 4, "title": "Extra-Large Acacia Cutting Board with Juice Groove", "handle": "extra-large-acacia-cutting-board-juice-groove", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html", "shipping_signal": "U.S. warehouse listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 129.95, "compare_at": 149.95, "source_cost": "$98–$118 displayed; verify whether this is a carton/pack price or one board.", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards", "type": "Acacia Cutting Board", "collection": "Kitchen Essentials", "tags": "cutting-board, acacia, juice-groove, carving-board, kitchen-prep, housewarming-gift, wooden-kitchenware", "country": "China — confirm", "hs_code": "Provisional 4419.90; customs-broker verification required", "sku": "CUT-ACACIA-XL", "option_name": "Title", "variants": [("Default Title", 129.95, 149.95, "CUT-ACACIA-XL")], "description": ( "Create a generous prep surface for carving, chopping, and serving. The acacia grain gives each board " "a naturally distinctive look, while the perimeter groove helps contain juices during food preparation." "Extra-large acacia work surface" "Perimeter juice groove" "Useful for carving, meal prep, or serving" "Natural grain makes every piece visually unique" "Care: Hand wash, dry upright, and condition periodically with food-grade board oil. " "Do not soak or place in a dishwasher." ), "seo_title": "Extra-Large Acacia Cutting Board with Juice Groove", "seo_description": "Prep, carve, and serve on a spacious acacia cutting board with a perimeter juice groove and naturally distinctive wood grain.", "care": "Hand wash, dry upright, and oil periodically. Exact dimensions and finish must be confirmed.", "media": "Hero board; juice-groove close-up; carving use; serving use; dimension graphic; wood-grain variation; packaging.", "validation": "Confirm exact dimensions, pack quantity, board thickness, finish chemistry, FSC claim, moisture content, warping tolerance, and per-board landed cost.", "sample_tests": "Flatness; warping after wash/dry cycles; finish rub test; groove capacity; odor; packaging corner protection.", "fulfillment": "One-board neutral shipment; dimensional-weight quote; corner protection and damage replacement.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 5, "title": "Round Acacia & Resin Charcuterie Serving Board", "handle": "round-acacia-resin-charcuterie-serving-board", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_1601661113107.html", "shipping_signal": "U.S. local-stock listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 59.95, "compare_at": 69.95, "source_cost": "$9.58 displayed at MOQ 10 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Serveware > Serving Trays", "type": "Charcuterie Board", "collection": "Entertaining & Serveware", "tags": "charcuterie-board, serving-board, acacia, resin, cheese-board, entertaining, housewarming-gift, host-gift", "country": "China — confirm", "hs_code": "Provisional 4419.90; resin composite requires broker review", "sku": "SERV-ACRESIN-RND", "option_name": "Title", "variants": [("Default Title", 59.95, 69.95, "SERV-ACRESIN-RND")], "description": ( "Bring warm wood grain and a modern resin accent to cheese boards, appetizers, and table styling. " "The round profile transitions easily from countertop prep to entertaining." "Round acacia-and-resin design" "Approximately 1.8 cm thick according to the supplier listing" "Designed for charcuterie, desserts, and serving" "Giftable for housewarmings, weddings, and hosts" "Care: Hand wash only. Avoid prolonged soaking, harsh abrasives, and high heat." ), "seo_title": "Round Acacia & Resin Charcuterie Serving Board", "seo_description": "Serve cheese, fruit, desserts, and appetizers on a round acacia board with a modern resin accent—made for hosting and gifting.", "care": "Hand wash only. Food-contact suitability of the resin and finish must be documented before activation.", "media": "Hero empty board; styled charcuterie; resin detail; side profile; dimensions; gift presentation; packaging.", "validation": "Require food-contact documents for resin and finish, exact diameter, color tolerance, scratch resistance, and individual U.S. fulfillment quote.", "sample_tests": "Odor; stain test; scratch test; flatness; food-oil exposure; packaging drop test.", "fulfillment": "Neutral one-unit shipment; protective sleeve and rigid carton; damage replacement.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 6, "title": "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "handle": "40oz-glass-tumbler-handle-bamboo-lid-straw", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-40oz-Reusable-Transparent-Blank_1601418429313.html", "shipping_signal": "U.S. local-stock listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 34.95, "compare_at": 39.95, "source_cost": "Approximately $3.06 displayed at 72+ units before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Travel Mugs", "type": "Glass Travel Tumbler", "collection": "Glass Drinkware", "tags": "glass-tumbler, 40oz, handled-tumbler, bamboo-lid, iced-coffee, hydration, glass-drinkware, straw-cup", "country": "China — confirm", "hs_code": "Provisional 7013.37/7013.49; broker classification required", "sku": "TMB-GLASS-40", "option_name": "Title", "variants": [("Default Title", 34.95, 39.95, "TMB-GLASS-40")], "description": ( "Keep iced coffee, water, tea, or milk close at hand in a roomy 40 oz glass tumbler. " "The large handle supports an easy grip, while the bamboo lid and straw create a clean, modern look." "40 oz capacity" "Clear glass body" "Large carry handle" "Bamboo lid and reusable straw included" "Care: Hand wash the bamboo lid. Avoid sudden temperature changes unless heat resistance is confirmed. " "This tumbler is not guaranteed leakproof." ), "seo_title": "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "seo_description": "Roomy 40 oz clear glass tumbler with handle, bamboo lid, and straw for iced coffee, water, tea, smoothies, and everyday hydration.", "care": "Hand wash bamboo lid. Avoid thermal shock. Do not advertise as leakproof until passed.", "media": "Hero with iced coffee; handle close-up; lid and straw; size-in-hand; cup-holder test; capacity graphic; packaging.", "validation": "Confirm glass type, wall thickness, lid seal, straw material, cup-holder fit, bamboo treatment, and one-unit U.S. shipment.", "sample_tests": "Cup-holder fit; 24-hour leak test; handle load; straw fit; print/finish rub; packaging drop test.", "fulfillment": "U.S.-stock one-unit blind shipment with molded or honeycomb glass protection.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 7, "title": "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "handle": "16oz-glass-can-tumbler-bamboo-lid-straw", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html", "shipping_signal": "U.S. stock listing previously screened at approximately 2–5 days.", "ten_day_status": "Recheck", "status": "Draft", "price": 19.95, "compare_at": 24.95, "source_cost": "Current quotation required; displayed product is supplied in bulk.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Glass Can Tumbler", "collection": "Glass Drinkware", "tags": "glass-can, 16oz, iced-coffee-glass, bamboo-lid, straw-cup, matcha, glass-drinkware, gift", "country": "China — confirm", "hs_code": "Provisional 7013.37; customs-broker verification required", "sku": "CAN-GLASS-16-S", "option_name": "Pack Size", "variants": [ ("Single", 19.95, 24.95, "CAN-GLASS-16-S"), ("Set of 2", 32.95, 39.95, "CAN-GLASS-16-2") ], "description": ( "A clean, can-shaped glass for iced lattes, matcha, juice, cocktails, and sparkling water. " "The bamboo lid and straw make it an easy everyday cup for a coffee bar or desk." "16 oz can-shaped glass" "Bamboo lid and reusable straw" "Available as a single cup or value set of two" "Minimal silhouette for coffee bars and gifting" "Care: Hand wash the lid and straw. Avoid sudden temperature changes." ), "seo_title": "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "seo_description": "Minimal 16 oz can-shaped glass with bamboo lid and straw. Choose a single cup or set of two for iced coffee, matcha, juice, or cocktails.", "care": "Hand wash lid and straw; avoid thermal shock. Supplier must assemble and ship the two-pack variant.", "media": "Hero single; set of two; lid and straw; iced matcha lifestyle; dimensions; gift setup; packaging.", "validation": "Confirm lid material, straw material, glass thickness, two-pack assembly, U.S. stock, and direct customer fulfillment.", "sample_tests": "Lid fit; straw fit; rim quality; cup-holder fit; thermal-shock caution; single and two-pack drop tests.", "fulfillment": "Blind one-unit or two-unit bundle shipment from U.S. stock; inventory by pack size.", "weight_note": "TBD for each pack size; CSV weights left at 0 g." }, { "rank": 8, "title": "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "handle": "bourbon-glass-whiskey-stone-gift-set", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Blank-7-Pieces-Bourbon_1601485847381.html", "shipping_signal": "U.S. local-stock listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 49.95, "compare_at": 59.95, "source_cost": "$10–$12 displayed at MOQ 12 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Drinkware Sets", "type": "Bourbon Gift Set", "collection": "Home Bar & Gifts", "tags": "bourbon-gift, whiskey-glass, whiskey-stones, slate-coaster, wooden-box, barware, fathers-day-gift, groomsmen", "country": "China — confirm", "hs_code": "Composite gift set; broker classification required", "sku": "BRB-GIFT-7PC", "option_name": "Title", "variants": [("Default Title", 49.95, 59.95, "BRB-GIFT-7PC")], "description": ( "A compact bourbon gift set built around one classic lowball glass, reusable chilling stones, " "a slate coaster, and a wooden presentation box." "1 whiskey glass" "4 reusable stone cubes" "1 slate coaster" "1 wooden presentation box" "Use & care: Wash and dry the stones before freezing. Hand wash all components and dry the box promptly." ), "seo_title": "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "seo_description": "A gift-ready bourbon set with one lowball glass, four chilling stones, a slate coaster, and a wooden presentation box.", "care": "Hand wash all pieces. Confirm exact stone material and seven-piece count from the approved sample.", "media": "Box-open hero; seven components; whiskey stones close-up; glass and coaster; gift lifestyle; engraving area; packaging.", "validation": "Confirm exact piece count, stone material, glass capacity, coaster dimensions, box construction, engraving suitability, and U.S. stock.", "sample_tests": "Stone shedding; glass rim; box hinges; stain test; engraving test; packaging drop test.", "fulfillment": "One gift set per neutral shipment; no supplier inserts; damage replacement.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 9, "title": "16 oz DIY Snow Globe Glass Tumbler Blank", "handle": "16oz-diy-snow-globe-glass-tumbler-blank", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-16oz-Snowglobe-Bottle-Double_1601536098285.html", "shipping_signal": "U.S. local-stock listing displays 7-day delivery.", "ten_day_status": "Pass pre-screen", "status": "Draft", "price": 24.95, "compare_at": 29.95, "source_cost": "Approximately $2.60–$3.40 displayed at MOQ 25 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Craft Tumbler Blank", "collection": "Craft Drinkware", "tags": "snow-globe-tumbler, glass-blank, diy-tumbler, craft-supplies, sublimation-blank, vinyl-blank, 16oz", "country": "China — confirm", "hs_code": "Provisional 7013.37; customs-broker verification required", "sku": "SNOW-GLASS-16", "option_name": "Title", "variants": [("Default Title", 24.95, 29.95, "SNOW-GLASS-16")], "description": ( "Create a personalized drinkware project with a 16 oz double-wall glass tumbler blank. " "The decorative inner chamber is designed for snow-globe-style craft effects, while the outer surface " "can be finished with compatible vinyl or transfer methods." "16 oz double-wall glass blank" "Craft configuration intended for snow-globe effects" "Suitable for compatible vinyl and transfer projects" "Made for experienced makers and small-batch personalization" "Craft notice: This is a DIY blank, not a pre-filled finished snow-globe cup. " "Follow compatible adhesive, sealing, curing, and care instructions before use." ), "seo_title": "16 oz DIY Snow Globe Glass Tumbler Blank", "seo_description": "Create personalized snow-globe drinkware with a 16 oz double-wall glass tumbler blank designed for compatible vinyl and craft finishes.", "care": "Sell as a DIY blank only unless the supplier provides a finished, sealed configuration. Include maker safety instructions.", "media": "Blank hero; chamber close-up; opening/seal detail; compatible decoration area; craft-step graphic; package contents; protective packaging.", "validation": "Confirm pre-drilled/sealed configuration, lid and straw contents, compatible materials, instructions, and direct customer shipment.", "sample_tests": "Leak/seal test after approved assembly; glass defects; lid fit; craft adhesion; packaging drop test.", "fulfillment": "Neutral U.S.-stock shipment; clearly identify blank versus finished product in packing slip.", "weight_note": "TBD from packed sample; CSV weight left at 0 g." }, { "rank": 10, "title": "Two-Lid Glass Iced Coffee Bottle with Straw", "handle": "two-lid-glass-iced-coffee-bottle", "platform": "AliExpress — KitchenWise Home Store", "source_url": "https://www.aliexpress.us/item/3256808432308153", "shipping_signal": "Screenshot showed Jun. 30–Jul. 7 from Jun. 23 (about 7–14 days) and 81.1% within 13 days.", "ten_day_status": "Fail strict SLA", "status": "Draft", "price": 19.95, "compare_at": 24.95, "source_cost": "$9.99 shown for the selected 300 ml consumer order; obtain a wholesale fulfillment quote.", "category": "Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Water Bottles", "type": "Glass Iced Coffee Bottle", "collection": "Glass Drinkware", "tags": "glass-water-bottle, iced-coffee-bottle, two-lids, straw-bottle, clear-bottle, 300ml, 500ml, 750ml", "country": "China — confirm", "hs_code": "Provisional 7013.49; customs-broker verification required", "sku": "ICED-2LID-300", "option_name": "Capacity", "variants": [ ("300 ml", 19.95, 24.95, "ICED-2LID-300"), ("500 ml", 22.95, 27.95, "ICED-2LID-500"), ("750 ml", 25.95, 29.95, "ICED-2LID-750") ], "description": ( "Switch between sipping and straw drinking with one clear glass bottle and two lid styles. " "Printed markings make it useful for iced coffee, matcha, milk, tea, or water throughout the day." "Two interchangeable lids" "Reusable straw" "Printed measurement and time-style markings" "Available in 300 ml, 500 ml, and 750 ml sizes" "Care: Hand wash lids and straw. Avoid sudden temperature changes. " "Test the seal before carrying the bottle in a bag." ), "seo_title": "Two-Lid Glass Iced Coffee Bottle with Straw", "seo_description": "Clear glass iced coffee bottle with two interchangeable lids, reusable straw, markings, and 300 ml, 500 ml, or 750 ml sizes.", "care": "Do not promise 10-day delivery from the current listing. Hand wash lids; avoid thermal shock; test seals.", "media": "All three sizes; both lids; straw; printed markings; size-in-hand; iced-coffee lifestyle; protective packaging.", "validation": "Obtain a wholesale agreement, neutral packaging, size-specific pricing, glass specification, lid colors, inventory feed, and ≤10-day SLA.", "sample_tests": "24-hour leak test for both lids; straw fit; print durability; glass defects; cup-holder/bag fit; separate-shipment breakage test.", "fulfillment": "Keep Draft until domestic stock or a contractual ≤10-calendar-day delivery SLA is documented.", "weight_note": "TBD by size; CSV weights left at 0 g." }, ] # Build rows in Shopify's current CSV structure. template_path = out_dir / "shopify_product_template.csv" with template_path.open("r", encoding="utf-8-sig", newline="") as f: base_headers = next(csv.reader(f)) headers = base_headers[:] # Shopify permits one extra Collection column. insert_at = headers.index("Tags") + 1 headers.insert(insert_at, "Collection") shopify_rows = [] for p in products: for idx, (option_value, price, compare_at, sku) in enumerate(p["variants"]): first = idx == 0 row = {h: "" for h in headers} row["Title"] = p["title"] if first else "" row["URL handle"] = p["handle"] row["Description"] = p["description"] if first else "" row["Vendor"] = "Your Brand" if first else "" row["Product category"] = p["category"] if first else "" row["Type"] = p["type"] if first else "" row["Tags"] = p["tags"] if first else "" row["Collection"] = p["collection"] if first else "" row["Published on online store"] = "FALSE" if first else "" row["Status"] = "Draft" if first else "" row["SKU"] = sku row["Option1 name"] = p["option_name"] if first else "" row["Option1 value"] = option_value row["Price"] = f"{price:.2f}" row["Compare-at price"] = f"{compare_at:.2f}" row["Cost per item"] = "" row["Charge tax"] = "TRUE" row["Inventory tracker"] = "shopify" row["Inventory quantity"] = "0" row["Continue selling when out of stock"] = "DENY" row["Weight value (grams)"] = "0" row["Weight unit for display"] = "g" row["Requires shipping"] = "TRUE" row["Fulfillment service"] = "manual" row["Gift card"] = "FALSE" row["SEO title"] = p["seo_title"] if first else "" row["SEO description"] = p["seo_description"] if first else "" row["Google Shopping / Condition"] = "New" if first else "" row["Google Shopping / Custom product"] = "FALSE" if first else "" shopify_rows.append([row[h] for h in headers]) # Write Shopify import CSV. with csv_path.open("w", encoding="utf-8", newline="") as f: writer = csv.writer(f, quoting=csv.QUOTE_MINIMAL, lineterminator="\n") writer.writerow(headers) writer.writerows(shopify_rows) # Create companion workbook. wb = Workbook.create() # ---------- Read Me ---------- readme = wb.worksheets.add("Read Me") readme.merge_cells("A1:H1") readme.get_range("A1").values = [["Shopify Draft Listings — Glassware & Kitchenware"]] readme.get_range("A1:H1").format = { "fill": "#173B3F", "font": {"bold": True, "color": "#FFFFFF", "size": 16}, "horizontal_alignment": "center", "vertical_alignment": "center", } readme.get_range("A1:H1").format.row_height = 32 readme_rows = [ ["Purpose", "Ten draft Shopify listings, with #2 replaced by a fast-stock glass oil sprayer and #10 replaced by the KitchenWise AliExpress bottle."], ["Import file", "Use shopify_product_drafts.csv. Products are unpublished Drafts, inventory is 0, and fulfillment is Manual."], ["Brand placeholder", "Replace “Your Brand” in the Vendor column before import."], ["Images", "Product image URLs are intentionally blank. Upload licensed supplier-approved or original media, then add public URLs if importing images by CSV."], ["Weights", "CSV weights are 0 g because packed weights were not verified. Update each variant before using carrier-calculated shipping."], ["Costs", "Cost per item is blank because Shopify should contain the all-in landed/fulfilled cost—not a supplier's headline unit price."], ["Shipping", "Do not advertise a 10-day promise until three-zone test orders and a written supplier SLA validate it. Product #10 currently fails the strict SLA."], ["Compliance", "All material, heat-resistance, dishwasher, leakproof, food-contact, FSC, and customs-code claims require documentation or testing."], ["Status", "Keep every product as Draft until its sample, packing, unit economics, and fulfillment workflow pass the Supplier Checks sheet."], ] readme.get_range(f"A3:B{2+len(readme_rows)}").values = readme_rows readme.get_range(f"A3:A{2+len(readme_rows)}").format = { "fill": "#E8F2F1", "font": {"bold": True, "color": "#173B3F"}, "vertical_alignment": "top", } readme.get_range(f"B3:B{2+len(readme_rows)}").format.wrap_text = True readme.get_range("A3:B11").format.borders = { "top": {"style": "continuous", "color": "#C8D7D6"}, "bottom": {"style": "continuous", "color": "#C8D7D6"}, "left": {"style": "continuous", "color": "#C8D7D6"}, "right": {"style": "continuous", "color": "#C8D7D6"}, } readme.get_range("A:A").format.column_width = 22 readme.get_range("B:B").format.column_width = 95 readme.get_range("A3:B11").format.row_height = 36 # ---------- Product Matrix ---------- matrix = wb.worksheets.add("Product Matrix") matrix_headers = [ "Rank", "Shopify title", "Platform", "Source URL", "Shipping signal", "10-day status", "Shopify status", "Price", "Compare-at", "Source cost signal", "Product category", "Type", "Collection", "Country of origin", "Provisional HS code", "Required validation" ] matrix_data = [matrix_headers] for p in products: matrix_data.append([ p["rank"], p["title"], p["platform"], p["source_url"], p["shipping_signal"], p["ten_day_status"], p["status"], p["price"], p["compare_at"], p["source_cost"], p["category"], p["type"], p["collection"], p["country"], p["hs_code"], p["validation"] ]) matrix.get_range(f"A1:P{len(matrix_data)}").values = matrix_data matrix.get_range("A1:P1").format = { "fill": "#173B3F", "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } matrix.freeze_panes.freeze_rows(1) matrix.get_range(f"A2:P{len(matrix_data)}").format.wrap_text = True matrix.get_range(f"H2:I{len(matrix_data)}").format.number_format = "$0.00" matrix.get_range(f"A1:P{len(matrix_data)}").format.borders = { "bottom": {"style": "continuous", "color": "#D8E0DF"} } widths = { "A:A": 7, "B:B": 36, "C:C": 24, "D:D": 58, "E:E": 44, "F:F": 18, "G:G": 14, "H:I": 13, "J:J": 38, "K:K": 54, "L:L": 24, "M:M": 24, "N:N": 19, "O:O": 37, "P:P": 58 } for rng, width in widths.items(): matrix.get_range(rng).format.column_width = width matrix.get_range(f"A2:P{len(matrix_data)}").format.row_height = 74 matrix.get_range(f"F2:F{len(matrix_data)}").conditional_formats.add_custom( '=F2="Pass pre-screen"', {"fill": "#D9EAD3", "font": {"color": "#274E13", "bold": True}} ) matrix.get_range(f"F2:F{len(matrix_data)}").conditional_formats.add_custom( '=F2="Recheck"', {"fill": "#FFF2CC", "font": {"color": "#7F6000", "bold": True}} ) matrix.get_range(f"F2:F{len(matrix_data)}").conditional_formats.add_custom( '=F2="Fail strict SLA"', {"fill": "#F4CCCC", "font": {"color": "#990000", "bold": True}} ) # ---------- Listing Copy ---------- copy_sheet = wb.worksheets.add("Listing Copy") copy_headers = [ "Rank", "Title", "URL handle", "Description (HTML)", "SEO title", "SEO description", "Tags", "Care / disclosure note", "Media shot list", "Weight note" ] copy_data = [copy_headers] for p in products: copy_data.append([ p["rank"], p["title"], p["handle"], p["description"], p["seo_title"], p["seo_description"], p["tags"], p["care"], p["media"], p["weight_note"] ]) copy_sheet.get_range(f"A1:J{len(copy_data)}").values = copy_data copy_sheet.get_range("A1:J1").format = { "fill": "#173B3F", "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } copy_sheet.freeze_panes.freeze_rows(1) copy_sheet.get_range(f"A2:J{len(copy_data)}").format.wrap_text = True copy_widths = {"A:A": 7, "B:B": 36, "C:C": 42, "D:D": 95, "E:E": 55, "F:F": 74, "G:G": 58, "H:H": 62, "I:I": 66, "J:J": 32} for rng, width in copy_widths.items(): copy_sheet.get_range(rng).format.column_width = width copy_sheet.get_range(f"A2:J{len(copy_data)}").format.row_height = 130 # ---------- Supplier Checks ---------- checks = wb.worksheets.add("Supplier Checks") check_headers = ["Rank", "Product", "Must confirm before launch", "Sample tests", "Fulfillment requirement", "Decision gate"] check_data = [check_headers] for p in products: gate = "Activate only after approved sample, profitable DDP quote, neutral packaging, inventory feed, and successful delivery tests." if p["rank"] == 10: gate = "Do not activate until a written ≤10-calendar-day SLA or domestic-stock fulfillment is secured." check_data.append([p["rank"], p["title"], p["validation"], p["sample_tests"], p["fulfillment"], gate]) checks.get_range(f"A1:F{len(check_data)}").values = check_data checks.get_range("A1:F1").format = { "fill": "#173B3F", "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } checks.freeze_panes.freeze_rows(1) checks.get_range(f"A2:F{len(check_data)}").format.wrap_text = True for rng, width in {"A:A": 7, "B:B": 38, "C:C": 76, "D:D": 65, "E:E": 62, "F:F": 62}.items(): checks.get_range(rng).format.column_width = width checks.get_range(f"A2:F{len(check_data)}").format.row_height = 92 # ---------- Shopify Import ---------- import_sheet = wb.worksheets.add("Shopify Import") import_sheet.get_range_by_indexes(0, 0, len(shopify_rows) + 1, len(headers)).values = [headers] + shopify_rows import_sheet.get_range_by_indexes(0, 0, 1, len(headers)).format = { "fill": "#173B3F", "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } import_sheet.freeze_panes.freeze_rows(1) import_sheet.get_range_by_indexes(1, 0, len(shopify_rows), len(headers)).format.wrap_text = True # Reasonable widths for the most important columns; keep the very wide sheet usable. header_index = {h: i for i, h in enumerate(headers)} for header, width in { "Title": 36, "URL handle": 42, "Description": 85, "Vendor": 20, "Product category": 58, "Type": 24, "Tags": 55, "Collection": 24, "Status": 12, "SKU": 22, "Option1 name": 18, "Option1 value": 18, "Price": 12, "Compare-at price": 15, "SEO title": 58, "SEO description": 75, "Product image URL": 34, "Image alt text": 34 }.items(): col = header_index[header] import_sheet.get_range_by_indexes(0, col, len(shopify_rows) + 1, 1).format.column_width = width import_sheet.get_range_by_indexes(1, 0, len(shopify_rows), len(headers)).format.row_height = 48 # Add a note above? Preserve exact CSV structure in sheet, so no extra rows. # Data validations are intentionally omitted from import sheet to keep it clean. # Verification check = wb.inspect({ "kind": "table", "range": "Product Matrix!A1:P11", "include": "values,formulas", "table_max_rows": 12, "table_max_cols": 16, }) print(check.ndjson[:2500]) errors = wb.inspect({ "kind": "match", "search_term": "#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A", "options": {"use_regex": True, "max_results": 100}, "summary": "final formula error scan", }) print(errors.ndjson) SpreadsheetFile.export_xlsx(wb).save(str(xlsx_path)) print(f"Created: {xlsx_path}") print(f"Created: {csv_path}") --------------------------------------------------------------------------- FileNotFoundError Traceback (most recent call last) Cell In[1], line 421 417 ] 418 419 # Build rows in Shopify's current CSV structure. 420 template_path = out_dir / "shopify_product_template.csv" --> 421 with template_path.open("r", encoding="utf-8-sig", newline="") as f: 422 base_headers = next(csv.reader(f)) 423 headers = base_headers[:] 424 # Shopify permits one extra Collection column. File /usr/lib/python3.13/pathlib/_local.py:539, in Path.open(self, mode, buffering, encoding, errors, newline) 537 if "b" not in mode: 538 encoding = io.text_encoding(encoding) --> 539 return io.open(self, mode, buffering, encoding, errors, newline) FileNotFoundError: [Errno 2] No such file or directory: '/mnt/data/shopify_product_template.csv' import csv from pathlib import Path from artifact_tool import Workbook, SpreadsheetFile OUT_DIR = Path("/mnt/data") XLSX_PATH = OUT_DIR / "shopify_glass_kitchenware_listings.xlsx" CSV_PATH = OUT_DIR / "shopify_product_drafts.csv" # Current Shopify product CSV headers, plus Shopify's permitted Collection column. SHOPIFY_HEADERS = [ "Title", "URL handle", "Description", "Vendor", "Product category", "Type", "Tags", "Collection", "Published on online store", "Status", "SKU", "Barcode", "Option1 name", "Option1 value", "Option1 Linked To", "Option2 name", "Option2 value", "Option2 Linked To", "Option3 name", "Option3 value", "Option3 Linked To", "Price", "Compare-at price", "Cost per item", "Charge tax", "Tax code", "Unit price total measure", "Unit price total measure unit", "Unit price base measure", "Unit price base measure unit", "Inventory tracker", "Inventory quantity", "Continue selling when out of stock", "Weight value (grams)", "Weight unit for display", "Requires shipping", "Fulfillment service", "Product image URL", "Image position", "Image alt text", "Variant image URL", "Gift card", "SEO title", "SEO description", "Color (product.metafields.shopify.color-pattern)", "Google Shopping / Google product category", "Google Shopping / Gender", "Google Shopping / Age group", "Google Shopping / Manufacturer part number (MPN)", "Google Shopping / Ad group name", "Google Shopping / Ads labels", "Google Shopping / Condition", "Google Shopping / Custom product", "Google Shopping / Custom label 0", "Google Shopping / Custom label 1", "Google Shopping / Custom label 2", "Google Shopping / Custom label 3", "Google Shopping / Custom label 4" ] products = [ { "rank": 1, "title": "Single-Dose Coffee Bean Cellar Set with Display Rack", "handle": "single-dose-coffee-bean-cellar-set", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html", "shipping_signal": "Previously screened as U.S. local stock with approximately 2–7 day delivery; reconfirm by destination ZIP.", "ten_day_status": "Recheck", "price": 49.95, "strategy_price": 59.95, "source_cost": "$4.10 displayed before direct fulfillment, packaging, duties, and damage allowance.", "category": "Home & Garden > Kitchen & Dining > Food Storage > Food Storage Containers", "type": "Coffee Bean Storage", "collection": "Coffee Bar", "tags": "coffee, espresso, single-dose, bean-cellar, coffee-bar, glass-storage, home-barista, gift", "country": "China — confirm with supplier", "hs_code": "Composite set; customs-broker classification required", "sku": "CFC-CLR-SET", "option_name": "Title", "variants": [("Default Title", 49.95, "CFC-CLR-SET")], "description": ( "Build a cleaner, more consistent coffee ritual with pre-portioned beans ready for each brew. " "This countertop cellar set organizes individual doses in clear glass tubes so espresso, pour-over, " "decaf, and tasting beans stay easy to identify." "Individual glass tubes organize single-brew portions" "Compact display rack keeps the coffee station tidy" "Clear design makes each roast easy to identify" "Useful for coffee, tea, spices, or tasting samples" "Included: Display rack and glass storage tubes with caps. " "The final tube count and cap configuration will match the approved production sample." "Care: Hand wash components and dry completely before refilling." ), "seo_title": "Single-Dose Coffee Bean Cellar Set with Glass Tubes", "seo_description": "Organize espresso and pour-over portions in clear glass tubes with a compact countertop rack—a polished coffee-station gift for home brewers.", "care": "Hand wash and dry completely. Do not claim a one-way valve or freshness preservation until the cap is verified.", "media": "Hero image of full set; overhead tube layout; beans in tubes; rack close-up; dimension graphic; coffee-bar lifestyle; protective packaging.", "validation": "Confirm tube count, cap material, one-unit blind fulfillment, U.S. inventory, breakage packaging, and whether any valve is functional.", "sample_tests": "Tube-cap fit; rack stability; glass defects; label adhesion; packed-set drop test.", "fulfillment": "One-unit neutral shipment; daily stock visibility; valid carrier scan within one business day." }, { "rank": 2, "title": "2-in-1 Glass Oil Sprayer & Pourer – 16 oz", "handle": "2-in-1-glass-oil-sprayer-pourer-16oz", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html", "shipping_signal": "Alibaba listing identifies U.S. stock and a 7-day delivery program; validate one-unit delivery by ZIP.", "ten_day_status": "Pass pre-screen", "price": 24.95, "strategy_price": 29.95, "source_cost": "$2.50 displayed at MOQ 100 before direct-to-customer fulfillment.", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar Dispensers > Oil Dispensers", "type": "Oil Sprayer & Dispenser", "collection": "Kitchen Essentials", "tags": "oil-sprayer, oil-dispenser, glass-kitchenware, cooking-tools, meal-prep, kitchen-essentials, 16oz", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.49; dispensing mechanism may alter classification", "sku": "OIL-2IN1-16", "option_name": "Title", "variants": [("Default Title", 24.95, "OIL-2IN1-16")], "description": ( "Measure, mist, or pour cooking oil from one streamlined bottle. The 16 oz glass body keeps " "contents visible, while the dual-function top makes it easy to switch between light coverage and a steady pour." "Two dispensing modes: spray and pour" "16 oz clear glass bottle" "Useful for cooking oils, vinegar, and thin dressings" "Countertop-friendly design for everyday meal prep" "Care: Hand wash the top mechanism. Follow the approved supplier instructions for the glass body. " "Do not use with thick or particle-filled sauces unless compatibility is confirmed." ), "seo_title": "16 oz Glass Oil Sprayer & Pourer | 2-in-1 Dispenser", "seo_description": "Spray or pour cooking oil from one 16 oz glass bottle. The dual-function top supports controlled coverage, easy drizzling, and tidy storage.", "care": "Hand wash the sprayer head. Validate oil compatibility, spray pattern, and any dishwasher claim before activation.", "media": "Hero bottle; spray action; pour action; filled bottle; lid components; scale-in-hand image; countertop lifestyle; packaging.", "validation": "Confirm food-contact reports, spray consistency, leak resistance, replacement gaskets, color options, and one-unit U.S. fulfillment.", "sample_tests": "24-hour inversion; 200 spray cycles; oil odor retention; pour control; packaging drop test.", "fulfillment": "U.S.-stock blind shipping, one-unit pick-and-pack, and valid tracking within one business day." }, { "rank": 3, "title": "Whiskey Decanter Gift Set with 4 Glasses & Wooden Box", "handle": "whiskey-decanter-set-4-glasses-wooden-box", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html", "shipping_signal": "Previously screened as U.S. warehouse stock with approximately 3–5 business day delivery; reconfirm pack configuration.", "ten_day_status": "Recheck", "price": 109.95, "strategy_price": 129.95, "source_cost": "$116 displayed per pack; confirm whether one pack contains four complete gift sets.", "category": "Home & Garden > Kitchen & Dining > Barware > Decanters", "type": "Whiskey Decanter Set", "collection": "Home Bar & Gifts", "tags": "whiskey, bourbon, decanter, barware, wooden-box, wedding-gift, groomsmen-gift, home-bar", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.49 for glassware; composite gift-set review required", "sku": "DEC-4GLS-WBX", "option_name": "Title", "variants": [("Default Title", 109.95, "DEC-4GLS-WBX")], "description": ( "Turn a home bar into a gift-worthy presentation with a glass decanter, four matching glasses, " "and a vintage-style wooden storage box." "Coordinated decanter and four-glass set" "Wooden presentation box for storage and gifting" "Designed for bourbon, whisky, brandy, or non-alcoholic spirits" "Blank surfaces may support personalization when offered" "Included: 1 decanter, 4 glasses, and 1 wooden presentation box." "Care: Hand wash the glassware and dry the wooden box promptly." ), "seo_title": "Whiskey Decanter Set with 4 Glasses & Wooden Gift Box", "seo_description": "Gift-ready whiskey decanter set with four matching glasses and a vintage-style wooden presentation box for bourbon lovers and home bars.", "care": "Hand wash. Do not claim lead-free crystal, airtight storage, or dishwasher safety without documentation and tests.", "media": "Open-box hero; complete set; stopper close-up; four glasses; pouring lifestyle; personalization area; protective packaging.", "validation": "Confirm pack configuration, decanter capacity, glass composition, stopper seal, box material, engraving area, and actual per-set DDP cost.", "sample_tests": "Stopper fit; pour test; glass-rim inspection; box hinge/latch test; engraving test; multi-drop packaging test.", "fulfillment": "Individual gift-set shipment from U.S. stock with neutral outer carton and full damage replacement." }, { "rank": 4, "title": "Large Acacia Cutting Board with Juice Groove", "handle": "large-acacia-cutting-board-juice-groove", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html", "shipping_signal": "U.S. warehouse listing displays a 7-day delivery program; confirm exact unit count and dimensional shipping.", "ten_day_status": "Pass pre-screen", "price": 69.95, "strategy_price": 79.95, "source_cost": "$98–$118 displayed; pack quantity is unclear and must be resolved before launch.", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards", "type": "Acacia Cutting Board", "collection": "Kitchen Essentials", "tags": "cutting-board, acacia, juice-groove, carving-board, kitchen-prep, housewarming-gift, wooden-kitchenware", "country": "China — confirm with supplier", "hs_code": "Provisional 4419.90; customs-broker verification required", "sku": "CUT-ACACIA-LG", "option_name": "Title", "variants": [("Default Title", 69.95, "CUT-ACACIA-LG")], "description": ( "Create a generous prep surface for carving, chopping, and serving. The acacia grain gives each board " "a naturally distinctive look, while the perimeter groove helps contain juices during food preparation." "Large acacia work surface" "Perimeter juice groove" "Useful for carving, meal prep, or serving" "Natural grain makes every piece visually unique" "Care: Hand wash, dry upright, and condition periodically with food-grade board oil. " "Do not soak or place in a dishwasher." ), "seo_title": "Large Acacia Cutting Board with Juice Groove", "seo_description": "Prep, carve, and serve on a spacious acacia cutting board with a perimeter juice groove and naturally distinctive wood grain.", "care": "Hand wash, dry upright, and oil periodically. Confirm exact dimensions and finish before publication.", "media": "Hero board; juice-groove close-up; carving use; serving use; dimension graphic; wood-grain variation; packaging.", "validation": "Confirm exact dimensions, pack quantity, thickness, finish chemistry, any FSC documentation, moisture content, warping tolerance, and per-board landed cost.", "sample_tests": "Flatness; wash/dry warping; finish rub test; groove capacity; odor; packaging corner protection.", "fulfillment": "One-board neutral shipment with a verified dimensional-weight quote and reinforced corner protection." }, { "rank": 5, "title": "Round Acacia & Resin Charcuterie Serving Board", "handle": "round-acacia-resin-charcuterie-serving-board", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_1601661113107.html", "shipping_signal": "U.S. local-stock listing displays a 7-day delivery program.", "ten_day_status": "Pass pre-screen", "price": 59.95, "strategy_price": 69.95, "source_cost": "$9.58 displayed at MOQ 10 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Serveware > Serving Trays", "type": "Charcuterie Board", "collection": "Entertaining & Serveware", "tags": "charcuterie-board, serving-board, acacia, resin, cheese-board, entertaining, housewarming-gift, host-gift", "country": "China — confirm with supplier", "hs_code": "Provisional 4419.90; resin composite requires broker review", "sku": "SERV-ACRESIN-RND", "option_name": "Title", "variants": [("Default Title", 59.95, "SERV-ACRESIN-RND")], "description": ( "Bring warm wood grain and a modern resin accent to cheese boards, appetizers, and table styling. " "The round profile transitions easily from countertop preparation to entertaining." "Round acacia-and-resin design" "Approximately 1.8 cm thick according to the supplier listing" "Designed for charcuterie, desserts, and serving" "Giftable for housewarmings, weddings, and hosts" "Care: Hand wash only. Avoid prolonged soaking, harsh abrasives, and high heat." ), "seo_title": "Round Acacia & Resin Charcuterie Serving Board", "seo_description": "Serve cheese, fruit, desserts, and appetizers on a round acacia board with a modern resin accent—made for hosting and gifting.", "care": "Hand wash only. Document food-contact suitability of the resin and finish before activation.", "media": "Hero empty board; styled charcuterie; resin detail; side profile; dimensions; gift presentation; packaging.", "validation": "Require food-contact documentation for resin and finish, exact diameter, color tolerance, scratch resistance, and an individual U.S. fulfillment quote.", "sample_tests": "Odor; stain test; scratch test; flatness; food-oil exposure; packaging drop test.", "fulfillment": "Neutral one-unit shipment with protective sleeve, rigid carton, and damage replacement." }, { "rank": 6, "title": "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "handle": "40oz-glass-tumbler-handle-bamboo-lid-straw", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-40oz-Reusable-Transparent-Blank_1601418429313.html", "shipping_signal": "U.S. local-stock listing displays a 7-day delivery program.", "ten_day_status": "Pass pre-screen", "price": 34.95, "strategy_price": 39.95, "source_cost": "Approximately $3.06 displayed at 72+ units before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Travel Mugs", "type": "Glass Travel Tumbler", "collection": "Glass Drinkware", "tags": "glass-tumbler, 40oz, handled-tumbler, bamboo-lid, iced-coffee, hydration, glass-drinkware, straw-cup", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.37 or 7013.49; broker classification required", "sku": "TMB-GLASS-40", "option_name": "Title", "variants": [("Default Title", 34.95, "TMB-GLASS-40")], "description": ( "Keep iced coffee, water, tea, or smoothies close at hand in a roomy 40 oz glass tumbler. " "The large handle supports an easy grip, while the bamboo lid and straw create a clean, modern look." "40 oz capacity" "Clear glass body" "Large carry handle" "Bamboo lid and reusable straw included" "Care: Hand wash the bamboo lid. Avoid sudden temperature changes unless heat resistance is confirmed. " "This tumbler is not guaranteed leakproof." ), "seo_title": "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "seo_description": "Roomy 40 oz clear glass tumbler with handle, bamboo lid, and straw for iced coffee, water, tea, smoothies, and everyday hydration.", "care": "Hand wash bamboo lid. Avoid thermal shock. Do not advertise as leakproof until the sample passes testing.", "media": "Hero with iced coffee; handle close-up; lid and straw; size-in-hand; cup-holder test; capacity graphic; packaging.", "validation": "Confirm glass type, wall thickness, lid seal, straw material, cup-holder fit, bamboo treatment, and one-unit U.S. shipment.", "sample_tests": "Cup-holder fit; 24-hour leak test; handle load; straw fit; finish rub test; packaging drop test.", "fulfillment": "U.S.-stock one-unit blind shipment with molded or honeycomb glass protection." }, { "rank": 7, "title": "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "handle": "16oz-glass-can-tumbler-bamboo-lid-straw", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html", "shipping_signal": "Previously screened as U.S. stock with approximately 2–5 day delivery; reconfirm one-unit and two-unit bundle handling.", "ten_day_status": "Recheck", "price": 19.95, "strategy_price": 24.95, "source_cost": "Current quotation required; public listing is bulk-oriented.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Glass Can Tumbler", "collection": "Glass Drinkware", "tags": "glass-can, 16oz, iced-coffee-glass, bamboo-lid, straw-cup, matcha, glass-drinkware, gift", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.37; customs-broker verification required", "sku": "CAN-GLASS-16-S", "option_name": "Pack Size", "variants": [ ("Single", 19.95, "CAN-GLASS-16-S"), ("Set of 2", 32.95, "CAN-GLASS-16-2"), ], "description": ( "A clean, can-shaped glass for iced lattes, matcha, juice, cocktails, and sparkling water. " "The bamboo lid and straw make it an easy everyday cup for a coffee bar or desk." "16 oz can-shaped glass" "Bamboo lid and reusable straw" "Available as a single cup or value set of two" "Minimal silhouette for coffee bars and gifting" "Care: Hand wash the lid and straw. Avoid sudden temperature changes." ), "seo_title": "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "seo_description": "Minimal 16 oz can-shaped glass with bamboo lid and straw. Choose a single cup or set of two for iced coffee, matcha, juice, or cocktails.", "care": "Hand wash lid and straw; avoid thermal shock. Supplier must assemble and ship the two-pack variant correctly.", "media": "Hero single; set of two; lid and straw; iced-matcha lifestyle; dimensions; gift setup; packaging.", "validation": "Confirm lid and straw materials, glass thickness, two-pack assembly, U.S. stock, and direct-customer fulfillment.", "sample_tests": "Lid fit; straw fit; rim quality; thermal-shock caution; single and two-pack drop tests.", "fulfillment": "Blind one-unit or two-unit bundle shipment from U.S. stock with inventory tracked by pack size." }, { "rank": 8, "title": "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "handle": "bourbon-glass-whiskey-stone-gift-set", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Blank-7-Pieces-Bourbon_1601485847381.html", "shipping_signal": "U.S. local-stock listing displays a 7-day delivery program.", "ten_day_status": "Pass pre-screen", "price": 49.95, "strategy_price": 59.95, "source_cost": "$10–$12 displayed at MOQ 12 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Drinkware Sets", "type": "Bourbon Gift Set", "collection": "Home Bar & Gifts", "tags": "bourbon-gift, whiskey-glass, whiskey-stones, slate-coaster, wooden-box, barware, fathers-day-gift, groomsmen", "country": "China — confirm with supplier", "hs_code": "Composite gift set; customs-broker classification required", "sku": "BRB-GIFT-7PC", "option_name": "Title", "variants": [("Default Title", 49.95, "BRB-GIFT-7PC")], "description": ( "A compact bourbon gift set built around one classic lowball glass, reusable chilling stones, " "a slate coaster, and a wooden presentation box." "1 whiskey glass" "4 reusable chilling stones" "1 slate coaster" "1 wooden presentation box" "Use & care: Wash and dry the stones before freezing. Hand wash all components and dry the box promptly." ), "seo_title": "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "seo_description": "A gift-ready bourbon set with one lowball glass, four chilling stones, a slate coaster, and a wooden presentation box.", "care": "Hand wash all pieces. Confirm the stone material and exact seven-piece count from the approved sample.", "media": "Open-box hero; all seven components; chilling-stone close-up; glass and coaster; gift lifestyle; engraving area; packaging.", "validation": "Confirm exact piece count, stone material, glass capacity, coaster dimensions, box construction, engraving suitability, and U.S. stock.", "sample_tests": "Stone shedding; glass-rim inspection; box hinges; stain test; engraving test; packaging drop test.", "fulfillment": "One gift set per neutral shipment with no supplier inserts and full damage replacement." }, { "rank": 9, "title": "16 oz DIY Snow Globe Glass Tumbler Blank", "handle": "16oz-diy-snow-globe-glass-tumbler-blank", "platform": "Alibaba", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-16oz-Snowglobe-Bottle-Double_1601536098285.html", "shipping_signal": "U.S. local-stock listing displays a 7-day delivery program.", "ten_day_status": "Pass pre-screen", "price": 24.95, "strategy_price": 29.95, "source_cost": "Approximately $2.60–$3.40 displayed at MOQ 25 before individual fulfillment.", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Craft Tumbler Blank", "collection": "Craft Drinkware", "tags": "snow-globe-tumbler, glass-blank, diy-tumbler, craft-supplies, sublimation-blank, vinyl-blank, 16oz", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.37; customs-broker verification required", "sku": "SNOW-GLASS-16", "option_name": "Title", "variants": [("Default Title", 24.95, "SNOW-GLASS-16")], "description": ( "Create a personalized drinkware project with a 16 oz double-wall glass tumbler blank. " "The decorative inner chamber is designed for snow-globe-style craft effects, while the outer surface " "can be finished with compatible vinyl or transfer methods." "16 oz double-wall glass blank" "Craft configuration intended for snow-globe effects" "Suitable for compatible vinyl and transfer projects" "Made for experienced makers and small-batch personalization" "Craft notice: This is a DIY blank, not a pre-filled finished snow-globe cup. " "Follow compatible adhesive, sealing, curing, and care instructions before use." ), "seo_title": "16 oz DIY Snow Globe Glass Tumbler Blank", "seo_description": "Create personalized snow-globe drinkware with a 16 oz double-wall glass tumbler blank designed for compatible vinyl and craft finishes.", "care": "Sell as a DIY blank unless a finished, sealed configuration is separately validated. Include maker safety instructions.", "media": "Blank hero; chamber close-up; opening/seal detail; decoration area; craft-step graphic; package contents; protective packaging.", "validation": "Confirm pre-drilled or sealed configuration, included lid and straw, compatible materials, instructions, and direct-customer shipment.", "sample_tests": "Seal test after approved assembly; glass defects; lid fit; craft adhesion; packaging drop test.", "fulfillment": "Neutral U.S.-stock shipment that clearly identifies the item as a blank, not a finished filled tumbler." }, { "rank": 10, "title": "Two-Lid Glass Iced Coffee Bottle with Straw", "handle": "two-lid-glass-iced-coffee-bottle", "platform": "AliExpress — KitchenWise Home Store", "source_url": "https://www.aliexpress.us/item/3256808432308153", "shipping_signal": "User screenshot showed a 7–14 day window and only 81.1% delivered within 13 days.", "ten_day_status": "Fail strict SLA", "price": 19.95, "strategy_price": 24.95, "source_cost": "$9.99 shown for the selected 300 ml consumer order; obtain a wholesale fulfillment quote.", "category": "Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Water Bottles", "type": "Glass Iced Coffee Bottle", "collection": "Glass Drinkware", "tags": "glass-water-bottle, iced-coffee-bottle, two-lids, straw-bottle, clear-bottle, 300ml, 500ml, 750ml", "country": "China — confirm with supplier", "hs_code": "Provisional 7013.49; customs-broker verification required", "sku": "ICED-2LID-300", "option_name": "Capacity", "variants": [ ("300 ml", 19.95, "ICED-2LID-300"), ("500 ml", 22.95, "ICED-2LID-500"), ("750 ml", 25.95, "ICED-2LID-750"), ], "description": ( "Switch between sipping and straw drinking with one clear glass bottle and two lid styles. " "Printed markings make it useful for iced coffee, matcha, milk, tea, or water throughout the day." "Two interchangeable lids" "Reusable straw" "Printed measurement and time-style markings" "Available in 300 ml, 500 ml, and 750 ml sizes" "Care: Hand wash lids and straw. Avoid sudden temperature changes. " "Test the seal before carrying the bottle in a bag." ), "seo_title": "Two-Lid Glass Iced Coffee Bottle with Straw", "seo_description": "Clear glass iced coffee bottle with two interchangeable lids, reusable straw, markings, and 300 ml, 500 ml, or 750 ml sizes.", "care": "Do not promise 10-day delivery from the current listing. Hand wash lids; avoid thermal shock; test both seals.", "media": "All three sizes; both lids; straw; printed markings; size-in-hand; iced-coffee lifestyle; protective packaging.", "validation": "Obtain a wholesale agreement, neutral packaging, size-specific pricing, glass specification, lid colors, inventory feed, and a ≤10-day SLA.", "sample_tests": "24-hour leak test for both lids; straw fit; print durability; glass defects; cup-holder and bag fit; separate-shipment breakage test.", "fulfillment": "Keep Draft until domestic inventory or a written ≤10-calendar-day delivery SLA is documented." }, ] # Create Shopify import rows. shopify_rows = [] for p in products: for variant_index, (option_value, price, sku) in enumerate(p["variants"]): first = variant_index == 0 row = {header: "" for header in SHOPIFY_HEADERS} row.update({ "Title": p["title"] if first else "", "URL handle": p["handle"], "Description": p["description"] if first else "", "Vendor": "Your Brand" if first else "", "Product category": p["category"] if first else "", "Type": p["type"] if first else "", "Tags": p["tags"] if first else "", "Collection": p["collection"] if first else "", "Published on online store": "FALSE" if first else "", "Status": "draft" if first else "", "SKU": sku, "Option1 name": p["option_name"] if first else "", "Option1 value": option_value, "Price": f"{price:.2f}", # Intentionally blank: use only when a bona fide former/reference price is documented. "Compare-at price": "", # Intentionally blank: enter negotiated all-in landed/fulfilled cost, not headline unit price. "Cost per item": "", "Charge tax": "TRUE", "Inventory tracker": "shopify", "Inventory quantity": "0", "Continue selling when out of stock": "DENY", "Weight value (grams)": "0", "Weight unit for display": "g", "Requires shipping": "TRUE", "Fulfillment service": "manual", "Gift card": "FALSE", "SEO title": p["seo_title"] if first else "", "SEO description": p["seo_description"] if first else "", "Google Shopping / Condition": "New" if first else "", "Google Shopping / Custom product": "FALSE" if first else "", }) shopify_rows.append([row[h] for h in SHOPIFY_HEADERS]) with CSV_PATH.open("w", encoding="utf-8", newline="") as f: writer = csv.writer(f, lineterminator="\n") writer.writerow(SHOPIFY_HEADERS) writer.writerows(shopify_rows) # Build companion workbook. wb = Workbook.create() dark = "#173B3F" accent = "#DCEBE8" light = "#F4F8F7" grid = "#D7E0DE" warning = "#FFF2CC" # Read Me readme = wb.worksheets.add("Read Me") readme.merge_cells("A1:H1") readme.get_range("A1").values = [["Shopify Draft Listings — Glassware & Kitchenware"]] readme.get_range("A1:H1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF", "size": 16}, "horizontal_alignment": "center", "vertical_alignment": "center", } readme.get_range("A1:H1").format.row_height = 34 readme.get_range("A3:D3").values = [["Total products", "Fast pre-screen", "Recheck", "Strict SLA fail"]] readme.get_range("A4").formulas = [["=COUNTA('Product Matrix'!B2:B11)"]] readme.get_range("B4").formulas = [['=COUNTIF(\'Product Matrix\'!F2:F11,"Pass pre-screen")']] readme.get_range("C4").formulas = [['=COUNTIF(\'Product Matrix\'!F2:F11,"Recheck")']] readme.get_range("D4").formulas = [['=COUNTIF(\'Product Matrix\'!F2:F11,"Fail strict SLA")']] readme.get_range("A3:D3").format = { "fill": accent, "font": {"bold": True, "color": dark}, "horizontal_alignment": "center", "vertical_alignment": "center", } readme.get_range("A4:D4").format = { "fill": "#FFFFFF", "font": {"bold": True, "size": 14, "color": dark}, "horizontal_alignment": "center", "vertical_alignment": "center", } readme.get_range("A3:D4").format.row_height = 25 notes = [ ["Import file", "Use shopify_product_drafts.csv. All products are unpublished Drafts with zero inventory and manual fulfillment."], ["Replacements", "#2 is now the 16 oz 2-in-1 glass oil sprayer/pourer. #10 is the KitchenWise two-lid glass bottle."], ["Brand placeholder", "Replace “Your Brand” in the Vendor column before import."], ["Images", "Image URLs are intentionally blank. Upload original or supplier-licensed media to a public location before CSV image import."], ["Weights", "Variant weights are 0 g because packed weights were not verified. Update every variant before carrier-calculated shipping."], ["Costs", "Cost per item is blank. Enter the negotiated all-in landed or per-order fulfillment cost—not the supplier's headline unit price."], ["Compare-at prices", "Compare-at fields are blank. Use a compare-at price only when it is a genuine former or supportable reference price."], ["Shipping promise", "Do not advertise 10-day delivery until written SLAs and three-zone test orders validate it. Product #10 currently fails."], ["Compliance", "Material, leakproof, heat-safe, dishwasher-safe, food-contact, FSC, and customs claims require documentation or testing."], ["Activation gate", "Keep all items as Draft until samples, packaging, unit economics, inventory visibility, and fulfillment tests pass."], ] readme.get_range(f"A7:B{6+len(notes)}").values = notes readme.get_range(f"A7:A{6+len(notes)}").format = { "fill": accent, "font": {"bold": True, "color": dark}, "vertical_alignment": "top", } readme.get_range(f"B7:B{6+len(notes)}").format = { "fill": "#FFFFFF", "wrap_text": True, "vertical_alignment": "top", } readme.get_range(f"A7:B{6+len(notes)}").format.borders = { "bottom": {"style": "continuous", "color": grid} } readme.get_range("A1:A20").format.column_width = 23 readme.get_range("B1:B20").format.column_width = 95 readme.get_range(f"A7:B{6+len(notes)}").format.row_height = 38 # Product Matrix matrix = wb.worksheets.add("Product Matrix") matrix_headers = [ "Rank", "Shopify title", "Platform", "Source URL", "Shipping signal", "10-day status", "Shopify status", "Suggested price", "Optional future reference price", "Source cost signal", "Product category", "Type", "Collection", "Country of origin", "Provisional HS code", "Required validation" ] matrix_rows = [matrix_headers] for p in products: matrix_rows.append([ p["rank"], p["title"], p["platform"], p["source_url"], p["shipping_signal"], p["ten_day_status"], "Draft", p["price"], p["strategy_price"], p["source_cost"], p["category"], p["type"], p["collection"], p["country"], p["hs_code"], p["validation"] ]) matrix.get_range(f"A1:P{len(matrix_rows)}").values = matrix_rows matrix.get_range("A1:P1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } matrix.freeze_panes.freeze_rows(1) matrix.get_range(f"A2:P{len(matrix_rows)}").format = { "wrap_text": True, "vertical_alignment": "top", } matrix.get_range(f"H2:I{len(matrix_rows)}").format.number_format = "$0.00" matrix.get_range(f"A2:P{len(matrix_rows)}").format.borders = { "bottom": {"style": "continuous", "color": grid} } for rng, width in { "A1:A11": 7, "B1:B11": 38, "C1:C11": 25, "D1:D11": 58, "E1:E11": 46, "F1:F11": 18, "G1:G11": 14, "H1:I11": 15, "J1:J11": 40, "K1:K11": 56, "L1:L11": 25, "M1:M11": 25, "N1:N11": 22, "O1:O11": 40, "P1:P11": 62 }.items(): matrix.get_range(rng).format.column_width = width matrix.get_range("A2:P11").format.row_height = 82 matrix.get_range("F2:F11").conditional_formats.add_custom( '=F2="Pass pre-screen"', {"fill": "#D9EAD3", "font": {"color": "#274E13", "bold": True}} ) matrix.get_range("F2:F11").conditional_formats.add_custom( '=F2="Recheck"', {"fill": "#FFF2CC", "font": {"color": "#7F6000", "bold": True}} ) matrix.get_range("F2:F11").conditional_formats.add_custom( '=F2="Fail strict SLA"', {"fill": "#F4CCCC", "font": {"color": "#990000", "bold": True}} ) matrix.get_range("G2:G11").data_validation = { "rule": {"type": "list", "values": ["Draft", "Sample ordered", "Approved", "Active", "Rejected"]} } # Listing Copy copy_sheet = wb.worksheets.add("Listing Copy") copy_headers = [ "Rank", "Title", "URL handle", "Description (HTML)", "SEO title", "SEO description", "Tags", "Care / disclosure note", "Media shot list" ] copy_rows = [copy_headers] for p in products: copy_rows.append([ p["rank"], p["title"], p["handle"], p["description"], p["seo_title"], p["seo_description"], p["tags"], p["care"], p["media"] ]) copy_sheet.get_range(f"A1:I{len(copy_rows)}").values = copy_rows copy_sheet.get_range("A1:I1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } copy_sheet.freeze_panes.freeze_rows(1) copy_sheet.get_range("A2:I11").format = { "wrap_text": True, "vertical_alignment": "top", } for rng, width in { "A1:A11": 7, "B1:B11": 38, "C1:C11": 44, "D1:D11": 95, "E1:E11": 58, "F1:F11": 75, "G1:G11": 58, "H1:H11": 65, "I1:I11": 70 }.items(): copy_sheet.get_range(rng).format.column_width = width copy_sheet.get_range("A2:I11").format.row_height = 135 copy_sheet.get_range("A2:I11").format.borders = { "bottom": {"style": "continuous", "color": grid} } # Supplier Checks checks = wb.worksheets.add("Supplier Checks") check_headers = [ "Rank", "Product", "Must confirm before launch", "Sample tests", "Fulfillment requirement", "Decision gate" ] check_rows = [check_headers] for p in products: gate = "Activate only after an approved sample, profitable DDP quote, neutral packaging, reliable inventory feed, and successful delivery tests." if p["rank"] == 10: gate = "Do not activate until domestic inventory or a written ≤10-calendar-day delivery SLA is secured and tested." check_rows.append([ p["rank"], p["title"], p["validation"], p["sample_tests"], p["fulfillment"], gate ]) checks.get_range(f"A1:F{len(check_rows)}").values = check_rows checks.get_range("A1:F1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } checks.freeze_panes.freeze_rows(1) checks.get_range("A2:F11").format = { "wrap_text": True, "vertical_alignment": "top", } for rng, width in { "A1:A11": 7, "B1:B11": 40, "C1:C11": 76, "D1:D11": 66, "E1:E11": 64, "F1:F11": 64 }.items(): checks.get_range(rng).format.column_width = width checks.get_range("A2:F11").format.row_height = 100 checks.get_range("A2:F11").format.borders = { "bottom": {"style": "continuous", "color": grid} } checks.get_range("F11").format = {"fill": "#F4CCCC", "font": {"bold": True, "color": "#990000"}, "wrap_text": True} # Shopify Import mirror import_sheet = wb.worksheets.add("Shopify Import") import_values = [SHOPIFY_HEADERS] + shopify_rows import_sheet.get_range_by_indexes(0, 0, len(import_values), len(SHOPIFY_HEADERS)).values = import_values import_sheet.get_range_by_indexes(0, 0, 1, len(SHOPIFY_HEADERS)).format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } import_sheet.freeze_panes.freeze_rows(1) import_sheet.get_range_by_indexes(1, 0, len(shopify_rows), len(SHOPIFY_HEADERS)).format = { "wrap_text": True, "vertical_alignment": "top", } header_index = {h: i for i, h in enumerate(SHOPIFY_HEADERS)} for header, width in { "Title": 38, "URL handle": 44, "Description": 90, "Vendor": 18, "Product category": 58, "Type": 25, "Tags": 58, "Collection": 25, "Status": 12, "SKU": 22, "Option1 name": 18, "Option1 value": 18, "Price": 12, "Compare-at price": 16, "SEO title": 58, "SEO description": 75, "Product image URL": 35, "Image alt text": 35 }.items(): col = header_index[header] import_sheet.get_range_by_indexes(0, col, len(import_values), 1).format.column_width = width import_sheet.get_range_by_indexes(1, 0, len(shopify_rows), len(SHOPIFY_HEADERS)).format.row_height = 50 print(f"Built {len(products)} products and {len(shopify_rows)} Shopify variant rows.") print(f"CSV staged at: {CSV_PATH}") STDOUT/STDERR Built 10 products and 13 Shopify variant rows. CSV staged at: /mnt/data/shopify_product_drafts.csv # Compact verification before export. matrix_check = wb.inspect({ "kind": "table", "range": "Product Matrix!A1:P11", "include": "values,formulas", "table_max_rows": 12, "table_max_cols": 16, }) print(matrix_check.ndjson[:3500]) error_check = wb.inspect({ "kind": "match", "search_term": "#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A", "options": {"use_regex": True, "max_results": 100}, "summary": "final formula error scan", }) print(error_check.ndjson) # Render a compact preview to verify the front sheet visually. preview = wb.render({ "sheet_name": "Read Me", "range": "A1:D16", "scale": 1.2, }) preview_path = OUT_DIR / "shopify_listings_preview.png" preview.save(str(preview_path)) SpreadsheetFile.export_xlsx(wb).save(str(XLSX_PATH)) # Validate CSV dimensions and required fields. with CSV_PATH.open("r", encoding="utf-8", newline="") as f: parsed = list(csv.reader(f)) assert len(parsed[0]) == len(SHOPIFY_HEADERS) assert len(parsed) == 14 # header + 13 variants assert all(len(r) == len(SHOPIFY_HEADERS) for r in parsed) assert XLSX_PATH.exists() and CSV_PATH.exists() print(f"Exported workbook: {XLSX_PATH}") print(f"Validated CSV: {CSV_PATH}") print(f"Preview: {preview_path}") STDOUT/STDERR {"kind":"table","sheet":"Product Matrix","address":"A1:P11","rows":11,"cols":16,"values":[["Rank","Shopify title","Platform","Source URL","Shipping signal","10-day status","Shopify status","Suggested price","Optional future reference price","Source cost signal","Product category","Type","Collection","Country of origin","Provisional HS code","Required validation"],[1,"Single-Dose Coffee Bean Cellar Set with Display Rack","Alibaba","https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html","Previously screened as U.S. local stock with approximately 2–7 day delivery; reconfirm by destination ZIP.","Recheck","Draft",49.95,59.95,"$4.10 displayed before direct fulfillment, packaging, duties, and damage allowance.","Home & Garden > Kitchen & Dining > Food Storage > Food Storage Containers","Coffee Bean Storage","Coffee Bar","China — confirm with supplier","Composite set; customs-broker classification required","Confirm tube count, cap material, one-unit blind fulfillment, U.S. inventory, breakage packaging, and whether any valve is functional."],[2,"2-in-1 Glass Oil Sprayer & Pourer – 16 oz","Alibaba","https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html","Alibaba listing identifies U.S. stock and a 7-day delivery program; validate one-unit delivery by ZIP.","Pass pre-screen","Draft",24.95,29.95,"$2.50 displayed at MOQ 100 before direct-to-customer fulfillment.","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar Dispensers > Oil Dispensers","Oil Sprayer & Dispenser","Kitchen Essentials","China — confirm with supplier","Provisional 7013.49; dispensing mechanism may alter classification","Confirm food-contact reports, spray consistency, leak resistance, replacement gaskets, color options, and one-unit U.S. fulfillment."],[3,"Whiskey Decanter Gift Set with 4 Glasses & Wooden Box","Alibaba","https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html","Previously screened as U.S. warehouse stock with approximately 3–5 business day delivery; reconfirm pack configuration.","Recheck","Draft",109.95,129.95,"$116 displayed per pack; confirm whether one pack contains four complete gift sets.","Home & Garden > Kitchen & Dining > Barware > Decanters","Whiskey Decanter Set","Home Bar & Gifts","China — confirm with supplier","Provisional 7013.49 for glassware; composite gift-set review required","Confirm pack configuration, decanter capacity, glass composition, stopper seal, box material, engraving area, and actual per-set DDP cost."],[4,"Large Acacia Cutting Board with Juice Groove","Alibaba","https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html","U.S. warehouse listing displays a 7-day delivery program; confirm exact unit count and dimensional shipping.","Pass pre-screen","Draft",69.95,79.95,"$98–$118 displayed; pack quantity is unclear and must be resolved before launch.","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards","Acacia Cutting Board","Kitchen Essentials","China — confirm with supplier","Provisional 4419.90; customs-broker verification required","Confirm exact dimensions, pack quantity, thickness, finish chemistry, any FSC documentation, moisture content, warping tolerance, and per-board landed cost."],[5,"Round Acacia & Resin Charcuterie Serving Board","Alibaba","https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_16016611 {"kind":"notice","message":"Cell search matched 0 entries."} Exported workbook: /mnt/data/shopify_glass_kitchenware_listings.xlsx Validated CSV: /mnt/data/shopify_product_drafts.csv Preview: /mnt/data/shopify_listings_preview.png Completed all 10 Shopify draft listings. shopify_glass_kitchenware_listings.xlsx The workbook includes Read Me, Product Matrix, Listing Copy, Supplier Checks, and Shopify Import sheets. I replaced product #2 with the 16 oz 2-in-1 glass oil sprayer and pourer, and product #10 with the KitchenWise two-lid glass iced-coffee bottle. Product #10 remains a Draft because its displayed delivery window can exceed 10 days. Before importing or activating: Replace Your Brand in the Vendor field. Add verified packaged weights and negotiated all-in costs. Upload original or supplier-authorized images. Keep inventory at zero until the fulfillment connection is working. Leave compare-at prices blank unless they represent genuine, supportable reference prices. The CSV follows Shopify’s current product-import structure, including its permitted Collection column. Shopify requires publicly accessible URLs when images are imported through a product CSV. Shouldnt wr include how many are in the bulk and what the price is per qty = 1? from pathlib import Path from artifact_tool import Blob, SpreadsheetFile base_dir = Path("/mnt/data") input_xlsx = base_dir / "shopify_glass_kitchenware_listings.xlsx" wb2 = SpreadsheetFile.import_xlsx(Blob.load(str(input_xlsx))) print(wb2.inspect({"kind": "sheet", "include": "id,name"}).ndjson) STDOUT/STDERR {"kind":"sheet","id":"ws/i1edya","name":"Read Me","index":0,"range":"A1:D16","address":"A1:D16"} {"kind":"sheet","id":"ws/kdnjlr","name":"Product Matrix","index":1,"range":"A1:P11","address":"A1:P11"} {"kind":"sheet","id":"ws/fk0chk","name":"Listing Copy","index":2,"range":"A1:I11","address":"A1:I11"} {"kind":"sheet","id":"ws/52c1ew","name":"Supplier Checks","index":3,"range":"A1:F11","address":"A1:F11"} {"kind":"sheet","id":"ws/gagzec","name":"Shopify Import","index":4,"range":"A1:BF14","address":"A1:BF14"} import csv from datetime import date from pathlib import Path base_dir = Path("/mnt/data") source_csv = base_dir / "shopify_product_drafts.csv" updated_csv = base_dir / "shopify_product_drafts_with_pack_qty.csv" updated_xlsx = base_dir / "shopify_glass_kitchenware_listings_with_unit_economics.xlsx" # ---------- Update Shopify descriptions with the customer-facing sale quantity ---------- sold_as_by_title = { "Single-Dose Coffee Bean Cellar Set with Display Rack": "1 complete storage set", "2-in-1 Glass Oil Sprayer & Pourer – 16 oz": "1 × 16 oz bottle", "Whiskey Decanter Gift Set with 4 Glasses & Wooden Box": "1 complete gift set: 1 decanter, 4 glasses, and 1 wooden box", "Large Acacia Cutting Board with Juice Groove": "1 cutting board", "Round Acacia & Resin Charcuterie Serving Board": "1 serving board", "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw": "1 × 40 oz tumbler with lid and straw", "16 oz Glass Can Tumbler with Bamboo Lid & Straw": "choose 1 tumbler or a set of 2", "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box": "1 complete 7-piece gift set", "16 oz DIY Snow Globe Glass Tumbler Blank": "1 DIY tumbler blank", "Two-Lid Glass Iced Coffee Bottle with Straw": "1 bottle in the selected capacity", } with source_csv.open("r", encoding="utf-8", newline="") as f: reader = csv.DictReader(f) csv_headers = reader.fieldnames csv_rows = list(reader) for row in csv_rows: title = row.get("Title", "") if title in sold_as_by_title and row.get("Description"): sold_line = f"Sold as: {sold_as_by_title[title]}." description = row["Description"] if "Sold as:" not in description: first_close = description.find("") if first_close >= 0: insert_at = first_close + len("") description = description[:insert_at] + sold_line + description[insert_at:] else: description = sold_line + description row["Description"] = description with updated_csv.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=csv_headers, lineterminator="\n") writer.writeheader() writer.writerows(csv_rows) # ---------- Add a supplier unit-economics sheet ---------- sheet_name = "Supplier Unit Economics" try: existing = wb2.worksheets.get_item(sheet_name) existing.delete() except Exception: pass ue = wb2.worksheets.add(sheet_name) dark = "#173B3F" accent = "#DCEBE8" light = "#F4F8F7" grid = "#D7E0DE" green = "#D9EAD3" amber = "#FFF2CC" red = "#F4CCCC" ue.merge_cells("A1:Z1") ue.get_range("A1").values = [["Supplier Bulk Quantity & Per-Unit Economics"]] ue.get_range("A1:Z1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF", "size": 16}, "horizontal_alignment": "center", "vertical_alignment": "center", } ue.get_range("A1:Z1").format.row_height = 34 ue.merge_cells("A2:Z2") ue.get_range("A2").values = [[ "Displayed supplier prices are product-only unless explicitly stated. " "Enter the negotiated all-in DDP/direct-fulfillment cost in column T before relying on margin." ]] ue.get_range("A2:Z2").format = { "fill": light, "font": {"italic": True, "color": dark}, "wrap_text": True, "vertical_alignment": "center", } ue.get_range("A2:Z2").format.row_height = 34 headers = [ "Rank", "Shopify product", "Variant", "Customer sale qty", "Customer sale UOM", "Shopify retail price", "Retail price per customer unit", "Platform", "Supplier MOQ qty", "Supplier MOQ UOM", "Retail sale units per supplier order unit", "Supplier price at MOQ / order unit", "Best visible supplier price / order unit", "Source cost per retail sale unit at MOQ", "Best visible source cost per retail sale unit", "Source product cost per Shopify order at MOQ", "Best visible source product cost per Shopify order", "Minimum product subtotal at MOQ", "One-unit shipping included in displayed supplier price?", "All-in fulfilled cost per Shopify order (input)", "Gross profit before fees/ads", "Gross margin before fees/ads", "Source / pack notes", "Confidence", "Source URL", "As of" ] ue.get_range("A4:Z4").values = [headers] ue.get_range("A4:Z4").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } ue.get_range("A4:Z4").format.row_height = 58 ue.freeze_panes.freeze_rows(4) unit_rows = [ # rank, product, variant, cust_qty, cust_uom, retail, platform, MOQ qty, MOQ uom, # retail units / supplier order unit, price at MOQ, best visible, shipping incl, notes, confidence, source [1, "Single-Dose Coffee Bean Cellar Set with Display Rack", "Default", 1, "set", 49.95, "Alibaba", 100, "sets", 1, 4.10, 3.88, "No—quote required", "Visible tiers: 100–299 sets $4.10; 300–999 sets $3.98; 1,000+ sets $3.88. Tube count still requires confirmation.", "High for displayed tiers; fulfillment unverified", "https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html"], [2, "2-in-1 Glass Oil Sprayer & Pourer – 16 oz", "Default", 1, "bottle", 24.95, "Alibaba", 100, "pieces", 1, 2.50, 2.50, "No—quote required", "Displayed as $2.50 each at MOQ 100. U.S.-stock/7-day badge does not prove one-unit blind fulfillment is included.", "High for displayed MOQ/price; fulfillment unverified", "https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html"], [3, "Whiskey Decanter Gift Set with 4 Glasses & Wooden Box", "Default", 1, "gift set", 109.95, "Alibaba", 1, "pack", None, 116.00, 105.00, "Unclear", "Critical ambiguity: “Pack of 4” might mean four complete gift sets, or it might refer to the four glasses in one set. " "If four complete sets, product cost is $26.25–$29.00 per set; if one set, it is $105–$116 per set.", "Low—do not activate until pack contents are confirmed", "https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html"], [4, "Large Acacia Cutting Board with Juice Groove", "Default", 1, "board", 69.95, "Alibaba", 1, "box", 12, 118.00, 98.00, "Unclear", "Alibaba surfaces show MOQ 1 box and also 12 pieces. Calculation assumes 12 boards per box; supplier must confirm carton count.", "Medium—pack count inferred from listing surfaces", "https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html"], [5, "Round Acacia & Resin Charcuterie Serving Board", "Default", 1, "board", 59.95, "Alibaba", 12, "pieces", 1, 10.64, 9.50, "No—quote required", "Displayed range $9.50–$10.64 each, MOQ 12. The higher figure is used for the MOQ-case calculation.", "High for displayed range/MOQ; fulfillment unverified", "https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_1601661113107.html"], [6, "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "Default", 1, "tumbler", 34.95, "Alibaba", 12, "pieces", 1, 3.55, 1.79, "No—quote required", "Displayed sale range $1.79–$3.55 each, MOQ 12. Price varies by tier/variant; use $3.55 for the minimum-order case.", "Medium—exact linked listing should be reconfirmed", "https://www.alibaba.com/product-detail/USA-Warehouse-40oz-Reusable-Transparent-Blank_1601418429313.html"], [7, "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "Single", 1, "tumbler", 19.95, "Alibaba", 48, "pieces", 1, 5.51, 5.15, "No—quote required", "Displayed range $5.15–$5.51 each, MOQ 48. One customer order consumes one supplier piece.", "High for displayed range/MOQ; fulfillment unverified", "https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html"], [7, "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "Set of 2", 2, "tumblers", 32.95, "Alibaba", 48, "pieces", 1, 5.51, 5.15, "No—quote required", "Two-pack customer order consumes two supplier pieces; supplier must agree to assemble and protect the two-unit bundle.", "High for displayed range/MOQ; bundle fulfillment unverified", "https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html"], [8, "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "Default", 1, "7-piece set", 49.95, "Alibaba", 12, "sets", 1, 12.00, 10.00, "No—quote required", "Displayed range $10–$12 per complete set, MOQ 12. Use $12 for the minimum-order case.", "High for displayed range/MOQ; fulfillment unverified", "https://www.alibaba.com/product-detail/USA-Warehouse-Blank-7-Pieces-Bourbon_1601485847381.html"], [9, "16 oz DIY Snow Globe Glass Tumbler Blank", "Default", 1, "blank tumbler", 24.95, "Alibaba", 25, "pieces", 1, 3.40, 2.60, "No—quote required", "Displayed range $2.60–$3.40 each, MOQ 25. Use $3.40 for the minimum-order case.", "High for displayed range/MOQ; fulfillment unverified", "https://www.alibaba.com/product-detail/USA-Warehouse-16oz-Snowglobe-Bottle-Double_1601536098285.html"], [10, "Two-Lid Glass Iced Coffee Bottle with Straw", "300 ml", 1, "bottle", 19.95, "AliExpress — KitchenWise", 1, "piece", 1, 9.99, 9.99, "Yes on captured listing", "The captured $9.99 price applies to the selected 300 ml variant. Coupons and marketplace pricing can change.", "High for captured 300 ml price; fails strict 10-day SLA", "https://www.aliexpress.us/item/3256808432308153"], [10, "Two-Lid Glass Iced Coffee Bottle with Straw", "500 ml", 1, "bottle", 22.95, "AliExpress — KitchenWise", 1, "piece", 1, None, None, "Unverified", "500 ml source price was not visible in the supplied screenshot. Obtain a current variant-specific quote before activation.", "Low—variant cost unverified and delivery SLA fails", "https://www.aliexpress.us/item/3256808432308153"], [10, "Two-Lid Glass Iced Coffee Bottle with Straw", "750 ml", 1, "bottle", 25.95, "AliExpress — KitchenWise", 1, "piece", 1, None, None, "Unverified", "750 ml source price was not visible in the supplied screenshot. Obtain a current variant-specific quote before activation.", "Low—variant cost unverified and delivery SLA fails", "https://www.aliexpress.us/item/3256808432308153"], ] start_row = 5 for i, row in enumerate(unit_rows, start=start_row): # A-F ue.get_range(f"A{i}:F{i}").values = [[row[0], row[1], row[2], row[3], row[4], row[5]]] # G formula ue.get_range(f"G{i}").formulas = [[f'=IFERROR(F{i}/D{i},"")']] # H-M ue.get_range(f"H{i}:M{i}").values = [[row[6], row[7], row[8], row[9], row[10], row[11]]] # N-R formulas ue.get_range(f"N{i}").formulas = [[f'=IFERROR(L{i}/K{i},"")']] ue.get_range(f"O{i}").formulas = [[f'=IFERROR(M{i}/K{i},"")']] ue.get_range(f"P{i}").formulas = [[f'=IFERROR(N{i}*D{i},"")']] ue.get_range(f"Q{i}").formulas = [[f'=IFERROR(O{i}*D{i},"")']] ue.get_range(f"R{i}").formulas = [[f'=IFERROR(I{i}*L{i},"")']] # S and T ue.get_range(f"S{i}").values = [[row[12]]] ue.get_range(f"T{i}").values = [[""]] # U-V formulas ue.get_range(f"U{i}").formulas = [[f'=IF(T{i}="","",F{i}-T{i})']] ue.get_range(f"V{i}").formulas = [[f'=IF(T{i}="","",U{i}/F{i})']] # W-Z ue.get_range(f"W{i}:Z{i}").values = [[row[13], row[14], row[15], "2026-06-24"]] last_row = start_row + len(unit_rows) - 1 ue.get_range(f"A5:Z{last_row}").format = { "wrap_text": True, "vertical_alignment": "top", } ue.get_range(f"A5:Z{last_row}").format.borders = { "bottom": {"style": "continuous", "color": grid} } ue.get_range(f"F5:G{last_row}").format.number_format = "$0.00" ue.get_range(f"L5:R{last_row}").format.number_format = "$0.00" ue.get_range(f"T5:U{last_row}").format.number_format = "$0.00" ue.get_range(f"V5:V{last_row}").format.number_format = "0.0%" ue.get_range(f"T5:T{last_row}").format = { "fill": amber, "number_format": "$0.00", "font": {"bold": True, "color": "#7F6000"}, } ue.get_range(f"X5:X{last_row}").conditional_formats.add_custom( '=LEFT(X5,4)="High"', {"fill": green, "font": {"color": "#274E13", "bold": True}} ) ue.get_range(f"X5:X{last_row}").conditional_formats.add_custom( '=LEFT(X5,6)="Medium"', {"fill": amber, "font": {"color": "#7F6000", "bold": True}} ) ue.get_range(f"X5:X{last_row}").conditional_formats.add_custom( '=LEFT(X5,3)="Low"', {"fill": red, "font": {"color": "#990000", "bold": True}} ) ue.get_range(f"V5:V{last_row}").conditional_formats.add_color_scale({ "minColor": "#F4CCCC", "midColor": "#FFF2CC", "maxColor": "#D9EAD3" }) # Column widths width_map = { "A:A": 7, "B:B": 40, "C:C": 18, "D:D": 14, "E:E": 18, "F:G": 16, "H:H": 24, "I:I": 14, "J:J": 16, "K:K": 20, "L:R": 18, "S:S": 23, "T:V": 19, "W:W": 70, "X:X": 32, "Y:Y": 58, "Z:Z": 13 } for rng, width in width_map.items(): ue.get_range(rng).format.column_width = width ue.get_range(f"A5:Z{last_row}").format.row_height = 86 # ---------- Add a summary of MOQ and unit cost to Product Matrix ---------- pm = wb2.worksheets.get_item("Product Matrix") pm.get_range("Q1:V1").values = [[ "Supplier MOQ", "Supplier bulk / pack contents", "Product cost per qty=1 at MOQ", "Minimum product subtotal", "Public Shopify sale unit", "Unit-economics status" ]] pm.get_range("Q1:V1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } pm.get_range("Q1:V1").format.row_height = 58 summary_values = [ ["100 sets", "1 retail storage set per supplier set", "1 set", "Displayed MOQ/price verified; all-in fulfillment pending"], ["100 pieces", "1 bottle per supplier piece", "1 bottle", "Displayed MOQ/price verified; all-in fulfillment pending"], ["1 pack", "TBC: “Pack of 4” is ambiguous", "1 gift set", "HOLD—pack contents must be confirmed"], ["1 box", "12 boards per box assumed; confirm", "1 board", "Pack count requires supplier confirmation"], ["12 pieces", "1 board per piece", "1 board", "Displayed MOQ/price verified; all-in fulfillment pending"], ["12 pieces", "1 tumbler per piece", "1 tumbler", "Displayed range/MOQ; exact linked tier should be reconfirmed"], ["48 pieces", "1 tumbler per piece", "Single or set of 2", "Displayed MOQ/price verified; bundle fulfillment pending"], ["12 sets", "1 complete 7-piece set per supplier set", "1 gift set", "Displayed MOQ/price verified; all-in fulfillment pending"], ["25 pieces", "1 blank tumbler per piece", "1 blank tumbler", "Displayed MOQ/price verified; all-in fulfillment pending"], ["1 piece", "1 bottle per order; only 300 ml price captured", "1 bottle in selected capacity", "300 ml cost known; 500/750 ml and ≤10-day SLA unresolved"], ] ue_row_map = [5, 6, 7, 8, 9, 10, 11, 13, 14, 15] for pm_row, (vals, ue_row) in enumerate(zip(summary_values, ue_row_map), start=2): pm.get_range(f"Q{pm_row}:R{pm_row}").values = [[vals[0], vals[1]]] pm.get_range(f"S{pm_row}").formulas = [[f"='Supplier Unit Economics'!N{ue_row}"]] pm.get_range(f"T{pm_row}").formulas = [[f"='Supplier Unit Economics'!R{ue_row}"]] pm.get_range(f"U{pm_row}:V{pm_row}").values = [[vals[2], vals[3]]] pm.get_range("S2:T11").format.number_format = "$0.00" pm.get_range("Q2:V11").format = {"wrap_text": True, "vertical_alignment": "top"} for rng, width in { "Q:Q": 15, "R:R": 38, "S:S": 18, "T:T": 18, "U:U": 24, "V:V": 48 }.items(): pm.get_range(rng).format.column_width = width pm.get_range("Q2:V11").format.row_height = 82 pm.get_range("V2:V11").conditional_formats.add_custom( '=LEFT(V2,4)="HOLD"', {"fill": red, "font": {"color": "#990000", "bold": True}} ) # ---------- Update Read Me ---------- readme = wb2.worksheets.get_item("Read Me") readme.get_range("A17:B18").values = [ ["Bulk vs retail", "Supplier MOQ and wholesale cost belong in the internal Unit Economics sheet. The public Shopify Price is for one customer sale unit: one bottle, one board, one set, or the selected multipack."], ["Cost per item", "After negotiating, enter the all-in per-customer-order cost in Supplier Unit Economics column T and then copy that value into Shopify Cost per item. Do not use the headline factory price alone."], ] readme.get_range("A17:A18").format = { "fill": accent, "font": {"bold": True, "color": dark}, "vertical_alignment": "top", } readme.get_range("B17:B18").format = { "fill": "#FFFFFF", "wrap_text": True, "vertical_alignment": "top", } readme.get_range("A17:B18").format.borders = { "bottom": {"style": "continuous", "color": grid} } readme.get_range("A17:B18").format.row_height = 42 readme.get_range("B7").values = [["Use shopify_product_drafts_with_pack_qty.csv. All products remain unpublished Drafts with zero inventory and manual fulfillment."]] # ---------- Update descriptions in Listing Copy ---------- listing_copy = wb2.worksheets.get_item("Listing Copy") listing_check = wb2.inspect({ "kind": "table", "range": "Listing Copy!A1:D11", "include": "values", "table_max_rows": 12, "table_max_cols": 4, }) # Write the same updated descriptions by title. for excel_row in range(2, 12): title = listing_copy.get_range(f"B{excel_row}").values[0][0] if title in sold_as_by_title: desc = listing_copy.get_range(f"D{excel_row}").values[0][0] if desc and "Sold as:" not in desc: sold_line = f"Sold as: {sold_as_by_title[title]}." first_close = desc.find("") if first_close >= 0: pos = first_close + len("") desc = desc[:pos] + sold_line + desc[pos:] else: desc = sold_line + desc listing_copy.get_range(f"D{excel_row}").values = [[desc]] # ---------- Replace the Shopify Import mirror with the updated CSV ---------- shopify_import = wb2.worksheets.get_item("Shopify Import") with updated_csv.open("r", encoding="utf-8", newline="") as f: all_csv_rows = list(csv.reader(f)) shopify_import.get_range("A1:BF14").values = all_csv_rows # Verification print(f"Updated {len(unit_rows)} variant-level unit-economics rows.") print(f"Updated CSV: {updated_csv}") STDOUT/STDERR Updated 13 variant-level unit-economics rows. Updated CSV: /mnt/data/shopify_product_drafts_with_pack_qty.csv from artifact_tool import SpreadsheetFile # Compact verification of the new unit-economics sheet. unit_check = wb2.inspect({ "kind": "table", "range": "Supplier Unit Economics!A4:Z17", "include": "values,formulas", "table_max_rows": 14, "table_max_cols": 26, }) print(unit_check.ndjson[:7000]) matrix_check = wb2.inspect({ "kind": "table", "range": "Product Matrix!Q1:V11", "include": "values,formulas", "table_max_rows": 12, "table_max_cols": 6, }) print(matrix_check.ndjson[:3500]) error_check = wb2.inspect({ "kind": "match", "search_term": "#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A", "options": {"use_regex": True, "max_results": 100}, "summary": "final formula error scan", }) print(error_check.ndjson) # Render a preview of the economically important columns. preview = wb2.render({ "sheet_name": "Supplier Unit Economics", "range": "A1:R17", "scale": 0.85, }) preview_path = base_dir / "supplier_unit_economics_preview.png" preview.save(str(preview_path)) SpreadsheetFile.export_xlsx(wb2).save(str(updated_xlsx)) assert updated_xlsx.exists() assert updated_csv.exists() print(f"Exported workbook: {updated_xlsx}") print(f"Exported CSV: {updated_csv}") print(f"Preview: {preview_path}") STDOUT/STDERR {"kind":"table","sheet":"Supplier Unit Economics","address":"A4:Z17","rows":14,"cols":26,"values":[["Rank","Shopify product","Variant","Customer sale qty","Customer sale UOM","Shopify retail price","Retail price per customer unit","Platform","Supplier MOQ qty","Supplier MOQ UOM","Retail sale units per supplier order unit","Supplier price at MOQ / order unit","Best visible supplier price / order unit","Source cost per retail sale unit at MOQ","Best visible source cost per retail sale unit","Source product cost per Shopify order at MOQ","Best visible source product cost per Shopify order","Minimum product subtotal at MOQ","One-unit shipping included in displayed supplier price?","All-in fulfilled cost per Shopify order (input)","Gross profit before fees/ads","Gross margin before fees/ads","Source / pack notes","Confidence","Source URL","As of"],[1,"Single-Dose Coffee Bean Cellar Set with Display Rack","Default",1,"set",49.95,49.95,"Alibaba",100,"sets",1,4.1,3.88,4.1,3.88,4.1,3.88,409.99999999999994,"No—quote required","","","","Visible tiers: 100–299 sets $4.10; 300–999 sets $3.98; 1,000+ sets $3.88. Tube count still requires confirmation.","High for displayed tiers; fulfillment unverified","https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html","2026-06-24"],[2,"2-in-1 Glass Oil Sprayer & Pourer – 16 oz","Default",1,"bottle",24.95,24.95,"Alibaba",100,"pieces",1,2.5,2.5,2.5,2.5,2.5,2.5,250,"No—quote required","","","","Displayed as $2.50 each at MOQ 100. U.S.-stock/7-day badge does not prove one-unit blind fulfillment is included.","High for displayed MOQ/price; fulfillment unverified","https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html","2026-06-24"],[3,"Whiskey Decanter Gift Set with 4 Glasses & Wooden Box","Default",1,"gift set",109.95,109.95,"Alibaba",1,"pack",null,116,105,"","",0,0,116,"Unclear","","","","Critical ambiguity: “Pack of 4” might mean four complete gift sets, or it might refer to the four glasses in one set. If four complete sets, product cost is $26.25–$29.00 per set; if one set, it is $105–$116 per set.","Low—do not activate until pack contents are confirmed","https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html","2026-06-24"],[4,"Large Acacia Cutting Board with Juice Groove","Default",1,"board",69.95,69.95,"Alibaba",1,"box",12,118,98,9.833333333333334,8.166666666666666,9.833333333333334,8.166666666666666,118,"Unclear","","","","Alibaba surfaces show MOQ 1 box and also 12 pieces. Calculation assumes 12 boards per box; supplier must confirm carton count.","Medium—pack count inferred from listing surfaces","https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html","2026-06-24"],[5,"Round Acacia & Resin Charcuterie Serving Board","Default",1,"board",59.95,59.95,"Alibaba",12,"pieces",1,10.64,9.5,10.64,9.5,10.64,9.5,127.68,"No—quote required","","","","Displayed range $9.50–$10.64 each, MOQ 12. The higher figure is used for the MOQ-case calculation.","High for displayed range/MOQ; fulfillment unverified","https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_1601661113107.html","2026-06-24"],[6,"40 oz Glass Tumbler with Handle, Bamboo Lid & Straw","Default",1,"tumbler",34.95,34.95,"Alibaba",12,"pieces",1,3.55,1.79,3.55,1.79,3.55,1.79,42.599999999999994,"No—quote required","","","","Displayed sale range $1.79–$3.55 each, MOQ 12. Price varies by tier/variant; use $3.55 for the minimum-order case.","Medium—exact linked listing should be reconfirmed","https://www.alibaba.com/product-detail/USA-Warehouse-40oz-Reusable-Transparent-Blank_1601418429313.html","2026-06-24"],[7,"16 oz Glass Can Tumbler with Bamboo Lid & Straw","Single",1,"tumbler",19.95,19.95,"Alibaba",48,"pieces",1,5.51,5.15,5.51,5.15,5.51,5.15,264.48,"No—quote required","","","","Displayed range $5.15–$5.51 each, MOQ 48. One customer order consumes one supplier piece.","High for displayed range/MOQ; fulfillment unverified","https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html","2026-06-24"],[7,"16 oz Glass Can Tumbler with Bamboo Lid & Straw","Set of 2",2,"tumblers",32.95,16.475,"Alibaba",48,"pieces",1,5.51,5.15,5.51,5.15,11.02,10.3,264.48,"No—quote required","","","","Two-pack customer order consumes two supplier pieces; supplier must agree to assemble and protect the two-unit bundle.","High for displayed range/MOQ; bundle fulfillment unverified","https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html","2026-06-24"],[8,"Bourbon Glass & Whiskey Stone Gift Set in Wooden Box","Default",1,"7-piece set",49.95,49.95,"Alibaba",12,"sets",1,12,10,12,10,12,10,144,"No—quote required","","","","Displayed range $10–$12 per complete set, MOQ 12. Use $12 for the minimum-order case.","High for displayed range/MOQ; fulfillment unverified","https://www.alibaba.com/product-detail/USA-Warehouse-Blank-7-Pieces-Bourbon_1601485847381.html","2026-06-24"],[9,"16 oz DIY Snow Globe Glass Tumbler Blank","Default",1,"blank tumbler",24.95,24.95,"Alibaba",25,"pieces",1,3.4,2.6,3.4,2.6,3.4,2.6,85,"No—quote required","","","","Displayed range $2.60–$3.40 each, MOQ 25. Use $3.40 for the minimum-order case.","High for displayed range/MOQ; fulfillment unverified","https://www.alibaba.com/product-detail/USA-Warehouse-16oz-Snowglobe-Bottle-Double_1601536098285.html","2026-06-24"],[10,"Two-Lid Glass Iced Coffee Bottle with Straw","300 ml",1,"bottle",19.95,19.95,"AliExpress — KitchenWise",1,"piece",1,9.99,9.99,9.99,9.99,9.99,9.99,9.99,"Yes on captured listing","","","","The captured $9.99 price applies to the selected 300 ml variant. Coupons and marketplace pricing can change.","High for captured 300 ml price; fails strict 10-day SLA","https://www.aliexpress.us/item/3256808432308153","2026-06-24"],[10,"Two-Lid Glass Iced Coffee Bottle with Straw","500 ml",1,"bottle",22.95,22.95,"AliExpress — KitchenWise",1,"piece",1,null,null,0,0,0,0,0,"Unverified","","","","500 ml source price was not visible in the supplied screenshot. Obtain a current variant-specific quote before activation.","Low—variant cost unverified and delivery SLA fails","https://www.aliexpress.us/item/3256808432308153","2026-06-24"],[10,"Two-Lid Glass Iced Coffee Bottle with Straw","750 ml",1,"bottle",25.95,25.95,"AliExpress — KitchenWise",1,"piece",1,null,null,0,0,0,0,0,"Unverified","","","","750 ml source price was not visible in the supplied screenshot. Obtain a current variant-specific quote before activation.","Low—variant cost unverified and delivery SLA fails","https://www.aliexpress.us/item/3256808432308153","2026-06-24"]]} {"kind":"table","sheet":"Product Matrix","address":"Q1:V11","rows":11,"cols":6,"values":[["Supplier MOQ","Supplier bulk / pack contents","Product cost per qty=1 at MOQ","Minimum product subtotal","Public Shopify sale unit","Unit-economics status"],["100 sets","1 retail storage set per supplier set",4.1,409.99999999999994,"1 set","Displayed MOQ/price verified; all-in fulfillment pending"],["100 pieces","1 bottle per supplier piece",2.5,250,"1 bottle","Displayed MOQ/price verified; all-in fulfillment pending"],["1 pack","TBC: “Pack of 4” is ambiguous","",116,"1 gift set","HOLD—pack contents must be confirmed"],["1 box","12 boards per box assumed; confirm",9.833333333333334,118,"1 board","Pack count requires supplier confirmation"],["12 pieces","1 board per piece",10.64,127.68,"1 board","Displayed MOQ/price verified; all-in fulfillment pending"],["12 pieces","1 tumbler per piece",3.55,42.599999999999994,"1 tumbler","Displayed range/MOQ; exact linked tier should be reconfirmed"],["48 pieces","1 tumbler per piece",5.51,264.48,"Single or set of 2","Displayed MOQ/price verified; bundle fulfillment pending"],["12 sets","1 complete 7-piece set per supplier set",12,144,"1 gift set","Displayed MOQ/price verified; all-in fulfillment pending"],["25 pieces","1 blank tumbler per piece",3.4,85,"1 blank tumbler","Displayed MOQ/price verified; all-in fulfillment pending"],["1 piece","1 bottle per order; only 300 ml price captured",9.99,9.99,"1 bottle in selected capacity","300 ml cost known; 500/750 ml and ≤10-day SLA unresolved"]]} {"kind":"notice","message":"Cell search matched 0 entries."} Exported workbook: /mnt/data/shopify_glass_kitchenware_listings_with_unit_economics.xlsx Exported CSV: /mnt/data/shopify_product_drafts_with_pack_qty.csv Preview: /mnt/data/supplier_unit_economics_preview.png # Patch formula logic so unknown supplier prices remain blank rather than displaying $0.00. for i in range(5, 18): ue.get_range(f"N{i}").formulas = [[f'=IF(OR(K{i}="",L{i}=""),"",L{i}/K{i})']] ue.get_range(f"O{i}").formulas = [[f'=IF(OR(K{i}="",M{i}=""),"",M{i}/K{i})']] ue.get_range(f"P{i}").formulas = [[f'=IF(N{i}="","",N{i}*D{i})']] ue.get_range(f"Q{i}").formulas = [[f'=IF(O{i}="","",O{i}*D{i})']] ue.get_range(f"R{i}").formulas = [[f'=IF(OR(I{i}="",L{i}=""),"",I{i}*L{i})']] # Re-export and verify the ambiguous/unknown rows. unknown_check = wb2.inspect({ "kind": "table", "range": "Supplier Unit Economics!K7:R7", "include": "values,formulas", "table_max_rows": 2, "table_max_cols": 8, }) print(unknown_check.ndjson) variant_check = wb2.inspect({ "kind": "table", "range": "Supplier Unit Economics!K16:R17", "include": "values,formulas", "table_max_rows": 3, "table_max_cols": 8, }) print(variant_check.ndjson) SpreadsheetFile.export_xlsx(wb2).save(str(updated_xlsx)) print(f"Re-exported: {updated_xlsx}") STDOUT/STDERR {"kind":"table","sheet":"Supplier Unit Economics","address":"K7:R7","rows":1,"cols":8,"values":[[null,116,105,"","","","",116]]} {"kind":"table","sheet":"Supplier Unit Economics","address":"K16:R17","rows":2,"cols":8,"values":[[1,null,null,"","","","",""],[1,null,null,"","","","",""]]} Re-exported: /mnt/data/shopify_glass_kitchenware_listings_with_unit_economics.xlsx Yes. We should track two different quantities: Supplier economics: MOQ, units per carton/pack, wholesale price per unit, and minimum order subtotal. Shopify economics: quantity the customer receives and retail price for that customer-facing unit. Supplier costs should remain internal. Shopify’s Unit price field is intended for measurement-based pricing such as price per kilogram or liter, while Cost per item should ultimately contain your actual cost for that variant. I updated the files accordingly. For example, the coffee-cellar listing shows 100 sets at $4.10 each, with lower visible tiers at larger quantities; the oil sprayer shows $2.50 each at an MOQ of 100. Ambiguous listings are flagged rather than assigned a potentially false unit cost—for example, the decanter’s “Pack of 4” wording requires supplier confirmation. The revised workbook now includes: Supplier MOQ and unit of measure Number of sellable units inside each supplier box or pack Wholesale product cost per quantity of one Minimum product subtotal required to meet the MOQ Customer-facing pack quantity Retail price per customer unit An editable all-in fulfillment-cost field Automatic gross-profit and margin calculations Warnings for unconfirmed pack quantities and variant prices The Shopify descriptions now explicitly state what the customer receives, such as one bottle, one complete set, or a set of two. Supplier pricing remains outside the storefront. shopify_glass_kitchenware_listings_with_unit_economics.xlsx Wonderful! Thank you so much! Please ensure that we update the csv for the SEO sections to be filled for the Shopify listing. We need to ensure ease of transfer. import csv import html import re from pathlib import Path from artifact_tool import Blob, SpreadsheetFile base_dir = Path("/mnt/data") source_csv = base_dir / "shopify_product_drafts_with_pack_qty.csv" source_xlsx = base_dir / "shopify_glass_kitchenware_listings_with_unit_economics.xlsx" seo_ready_csv = base_dir / "shopify_products_seo_ready.csv" manual_transfer_csv = base_dir / "shopify_seo_manual_transfer.csv" seo_ready_xlsx = base_dir / "shopify_glass_kitchenware_seo_ready.xlsx" seo_map = { "single-dose-coffee-bean-cellar-set": { "seo_title": "Single-Dose Coffee Bean Cellar Set with Glass Tubes | Sentience Labs", "seo_description": "Organize espresso and pour-over portions in clear glass coffee bean tubes with a compact display rack for a polished home coffee station.", "primary_keyword": "single-dose coffee bean cellar set", }, "2-in-1-glass-oil-sprayer-pourer-16oz": { "seo_title": "16 oz Glass Oil Sprayer & Pourer | Sentience Labs", "seo_description": "Spray or pour cooking oil from one 16 oz glass dispenser. The dual-function top supports controlled misting, easy drizzling, and tidy storage.", "primary_keyword": "glass oil sprayer and pourer", }, "whiskey-decanter-set-4-glasses-wooden-box": { "seo_title": "Whiskey Decanter Set with 4 Glasses & Gift Box | Sentience Labs", "seo_description": "Create a gift-ready home bar with a glass whiskey decanter, four matching tumblers, and a wooden presentation box for bourbon lovers.", "primary_keyword": "whiskey decanter set with glasses", }, "large-acacia-cutting-board-juice-groove": { "seo_title": "Large Acacia Cutting Board with Juice Groove | Sentience Labs", "seo_description": "Prep, carve, and serve on a spacious acacia cutting board with a perimeter juice groove and naturally distinctive wood grain.", "primary_keyword": "large acacia cutting board", }, "round-acacia-resin-charcuterie-serving-board": { "seo_title": "Round Acacia Resin Charcuterie Board | Sentience Labs", "seo_description": "Serve cheese, fruit, desserts, and appetizers on a round acacia charcuterie board with a modern resin accent for hosting and gifting.", "primary_keyword": "round acacia charcuterie board", }, "40oz-glass-tumbler-handle-bamboo-lid-straw": { "seo_title": "40 oz Glass Tumbler with Handle & Bamboo Lid | Sentience Labs", "seo_description": "Enjoy iced coffee, tea, smoothies, or water in a roomy 40 oz glass tumbler with a large handle, bamboo lid, and reusable straw.", "primary_keyword": "40 oz glass tumbler with handle", }, "16oz-glass-can-tumbler-bamboo-lid-straw": { "seo_title": "16 oz Glass Can Tumbler with Bamboo Lid | Sentience Labs", "seo_description": "Serve iced coffee, matcha, juice, or cocktails in a minimal 16 oz can-shaped glass with a bamboo lid and reusable straw.", "primary_keyword": "16 oz glass can tumbler", }, "bourbon-glass-whiskey-stone-gift-set": { "seo_title": "Bourbon Glass & Whiskey Stone Gift Set | Sentience Labs", "seo_description": "Gift a classic lowball glass with four reusable chilling stones, a slate coaster, and a wooden presentation box for bourbon enthusiasts.", "primary_keyword": "bourbon glass gift set", }, "16oz-diy-snow-globe-glass-tumbler-blank": { "seo_title": "16 oz DIY Snow Globe Glass Tumbler Blank | Sentience Labs", "seo_description": "Create personalized drinkware with a 16 oz double-wall glass snow globe tumbler blank designed for compatible vinyl and craft finishes.", "primary_keyword": "snow globe glass tumbler blank", }, "two-lid-glass-iced-coffee-bottle": { "seo_title": "Glass Iced Coffee Bottle with Straw & Two Lids | Sentience Labs", "seo_description": "Choose a 300 ml, 500 ml, or 750 ml clear glass bottle with two interchangeable lids, a reusable straw, and printed measurement markings.", "primary_keyword": "glass iced coffee bottle with straw", }, } def html_to_plain(value: str) -> str: if not value: return "" text = re.sub(r"", "• ", value, flags=re.I) text = re.sub(r"", "\n", text, flags=re.I) text = re.sub(r"?(p|ul|ol|strong|em|br)[^>]*>", "\n", text, flags=re.I) text = re.sub(r"<[^>]+>", "", text) text = html.unescape(text) text = re.sub(r"\n[ \t]+", "\n", text) text = re.sub(r"\n{3,}", "\n\n", text) return text.strip() # Read Shopify CSV. with source_csv.open("r", encoding="utf-8", newline="") as f: reader = csv.DictReader(f) shopify_headers = reader.fieldnames rows = list(reader) # Update exact Shopify import fields. seen_handles = set() for row in rows: handle = row["URL handle"] first_product_row = handle not in seen_handles if first_product_row: seen_handles.add(handle) seo = seo_map[handle] row["SEO title"] = seo["seo_title"] row["SEO description"] = seo["seo_description"] row["Vendor"] = "Sentience Labs" else: # Shopify product-level fields remain on the first row only. row["SEO title"] = "" row["SEO description"] = "" with seo_ready_csv.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=shopify_headers, lineterminator="\n") writer.writeheader() writer.writerows(rows) # Build one-row-per-product manual transfer CSV for the Add product screen. grouped = {} order = [] for row in rows: handle = row["URL handle"] if handle not in grouped: grouped[handle] = {"base": row.copy(), "variants": []} order.append(handle) variant_label = row.get("Option1 value") or "Default" grouped[handle]["variants"].append( { "label": variant_label, "price": row.get("Price", ""), "sku": row.get("SKU", ""), } ) manual_headers = [ "Rank", "Product title", "Product description - plain text", "Product description - HTML", "Category", "Product type", "Vendor", "Collection", "Tags", "Variant setup", "Default price", "Default SKU", "SEO page title", "SEO meta description", "URL handle", "SEO title characters", "SEO description characters", "SEO readiness", "Shopify status", ] manual_rows = [] for rank, handle in enumerate(order, start=1): base = grouped[handle]["base"] variants = grouped[handle]["variants"] variant_setup = "; ".join( f"{v['label']} — ${v['price']} — SKU {v['sku']}" for v in variants ) seo = seo_map[handle] title_len = len(seo["seo_title"]) desc_len = len(seo["seo_description"]) readiness = "Ready" if title_len <= 70 and desc_len <= 160 else "Review length" manual_rows.append({ "Rank": rank, "Product title": base["Title"], "Product description - plain text": html_to_plain(base["Description"]), "Product description - HTML": base["Description"], "Category": base["Product category"], "Product type": base["Type"], "Vendor": "Sentience Labs", "Collection": base["Collection"], "Tags": base["Tags"], "Variant setup": variant_setup, "Default price": variants[0]["price"], "Default SKU": variants[0]["sku"], "SEO page title": seo["seo_title"], "SEO meta description": seo["seo_description"], "URL handle": handle, "SEO title characters": title_len, "SEO description characters": desc_len, "SEO readiness": readiness, "Shopify status": "Draft", }) with manual_transfer_csv.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=manual_headers, lineterminator="\n") writer.writeheader() writer.writerows(manual_rows) # Update workbook. wb = SpreadsheetFile.import_xlsx(Blob.load(str(source_xlsx))) # Replace Shopify Import sheet with revised CSV. shopify_sheet = wb.worksheets.get_item("Shopify Import") with seo_ready_csv.open("r", encoding="utf-8", newline="") as f: csv_matrix = list(csv.reader(f)) shopify_sheet.get_range_by_indexes( 0, 0, len(csv_matrix), len(csv_matrix[0]) ).values = csv_matrix # Update Listing Copy SEO columns and vendor context. listing_sheet = wb.worksheets.get_item("Listing Copy") for excel_row, handle in enumerate(order, start=2): seo = seo_map[handle] listing_sheet.get_range(f"E{excel_row}:F{excel_row}").values = [[ seo["seo_title"], seo["seo_description"] ]] # Replace/add SEO Transfer sheet. try: old = wb.worksheets.get_item("SEO Transfer") old.delete() except Exception: pass seo_sheet = wb.worksheets.add("SEO Transfer") title_fill = "#173B3F" sub_fill = "#DCEBE8" grid = "#D7E0DE" seo_sheet.merge_cells("A1:S1") seo_sheet.get_range("A1").values = [["Shopify SEO & Manual Transfer Sheet"]] seo_sheet.get_range("A1:S1").format = { "fill": title_fill, "font": {"bold": True, "color": "#FFFFFF", "size": 16}, "horizontal_alignment": "center", "vertical_alignment": "center", } seo_sheet.get_range("A1:S1").format.row_height = 34 seo_sheet.merge_cells("A2:S2") seo_sheet.get_range("A2").values = [[ "For direct import, use shopify_products_seo_ready.csv. For manual entry, copy the Product title and full description into the upper product fields, then copy the SEO page title, meta description, and URL handle into Search engine listing." ]] seo_sheet.get_range("A2:S2").format = { "fill": "#F4F8F7", "font": {"italic": True, "color": title_fill}, "wrap_text": True, "vertical_alignment": "center", } seo_sheet.get_range("A2:S2").format.row_height = 42 seo_matrix = [manual_headers] + [[row[h] for h in manual_headers] for row in manual_rows] seo_sheet.get_range_by_indexes(3, 0, len(seo_matrix), len(manual_headers)).values = seo_matrix seo_sheet.get_range("A4:S4").format = { "fill": title_fill, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True, } seo_sheet.get_range("A4:S4").format.row_height = 52 seo_sheet.freeze_panes.freeze_rows(4) seo_sheet.get_range("A5:S14").format = { "wrap_text": True, "vertical_alignment": "top", } seo_sheet.get_range("A5:S14").format.row_height = 112 seo_sheet.get_range("A5:S14").format.borders = { "bottom": {"style": "continuous", "color": grid} } for rng, width in { "A:A": 7, "B:B": 40, "C:C": 74, "D:D": 90, "E:E": 58, "F:F": 25, "G:G": 20, "H:H": 26, "I:I": 58, "J:J": 46, "K:L": 15, "M:M": 70, "N:N": 78, "O:O": 46, "P:Q": 15, "R:R": 16, "S:S": 14, }.items(): seo_sheet.get_range(rng).format.column_width = width seo_sheet.get_range("P5:Q14").format.number_format = "0" seo_sheet.get_range("R5:R14").conditional_formats.add_custom( '=R5="Ready"', {"fill": "#D9EAD3", "font": {"bold": True, "color": "#274E13"}} ) seo_sheet.get_range("R5:R14").conditional_formats.add_custom( '=R5<>"Ready"', {"fill": "#F4CCCC", "font": {"bold": True, "color": "#990000"}} ) # Add a note to Read Me. readme = wb.worksheets.get_item("Read Me") readme.get_range("A19:B20").values = [ ["SEO import", "Use shopify_products_seo_ready.csv for direct Shopify import. Its SEO title and SEO description columns are populated on the first row of each product."], ["Manual entry", "Use shopify_seo_manual_transfer.csv or the SEO Transfer worksheet. Keep the full product description separate from the shorter SEO meta description."], ] readme.get_range("A19:A20").format = { "fill": sub_fill, "font": {"bold": True, "color": title_fill}, "vertical_alignment": "top", } readme.get_range("B19:B20").format = { "fill": "#FFFFFF", "wrap_text": True, "vertical_alignment": "top", } readme.get_range("A19:B20").format.borders = { "bottom": {"style": "continuous", "color": grid} } readme.get_range("A19:B20").format.row_height = 42 # Compact verification. check = wb.inspect({ "kind": "table", "range": "SEO Transfer!A4:S14", "include": "values,formulas", "table_max_rows": 12, "table_max_cols": 19, }) print(check.ndjson[:6000]) errors = wb.inspect({ "kind": "match", "search_term": "#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A", "options": {"use_regex": True, "max_results": 100}, "summary": "final formula error scan", }) print(errors.ndjson) SpreadsheetFile.export_xlsx(wb).save(str(seo_ready_xlsx)) # Validate direct import CSV. with seo_ready_csv.open("r", encoding="utf-8", newline="") as f: validation_rows = list(csv.DictReader(f)) product_rows = [r for r in validation_rows if r["Title"]] assert len(product_rows) == 10 assert all(r["SEO title"] and r["SEO description"] for r in product_rows) assert all(len(r["SEO title"]) <= 70 for r in product_rows) assert all(len(r["SEO description"]) <= 160 for r in product_rows) print(f"Created: {seo_ready_csv}") print(f"Created: {manual_transfer_csv}") print(f"Created: {seo_ready_xlsx}") STDOUT/STDERR {"kind":"table","sheet":"SEO Transfer","address":"A4:S14","rows":11,"cols":19,"values":[["Rank","Product title","Product description - plain text","Product description - HTML","Category","Product type","Vendor","Collection","Tags","Variant setup","Default price","Default SKU","SEO page title","SEO meta description","URL handle","SEO title characters","SEO description characters","SEO readiness","Shopify status"],[1,"Single-Dose Coffee Bean Cellar Set with Display Rack","Build a cleaner, more consistent coffee ritual with pre-portioned beans ready...","Build a cleaner, more consistent coffee ritual with pre-portioned beans re...","Home & Garden > Kitchen & Dining > Food Storage > Food Storage Containers","Coffee Bean Storage","Sentience Labs","Coffee Bar","coffee, espresso, single-dose, bean-cellar, coffee-bar, glass-storage, home-b...","Default Title — $49.95 — SKU CFC-CLR-SET","49.95","CFC-CLR-SET","Single-Dose Coffee Bean Cellar Set with Glass Tubes | Sentience Labs","Organize espresso and pour-over portions in clear glass coffee bean tubes wit...","single-dose-coffee-bean-cellar-set",68,137,"Ready","Draft"],[2,"2-in-1 Glass Oil Sprayer & Pourer – 16 oz","Measure, mist, or pour cooking oil from one streamlined bottle. The 16 oz gla...","Measure, mist, or pour cooking oil from one streamlined bottle. The 16 oz ...","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar D...","Oil Sprayer & Dispenser","Sentience Labs","Kitchen Essentials","oil-sprayer, oil-dispenser, glass-kitchenware, cooking-tools, meal-prep, kitc...","Default Title — $24.95 — SKU OIL-2IN1-16","24.95","OIL-2IN1-16","16 oz Glass Oil Sprayer & Pourer | Sentience Labs","Spray or pour cooking oil from one 16 oz glass dispenser. The dual-function t...","2-in-1-glass-oil-sprayer-pourer-16oz",49,142,"Ready","Draft"],[3,"Whiskey Decanter Gift Set with 4 Glasses & Wooden Box","Turn a home bar into a gift-worthy presentation with a glass decanter, four m...","Turn a home bar into a gift-worthy presentation with a glass decanter, fou...","Home & Garden > Kitchen & Dining > Barware > Decanters","Whiskey Decanter Set","Sentience Labs","Home Bar & Gifts","whiskey, bourbon, decanter, barware, wooden-box, wedding-gift, groomsmen-gift...","Default Title — $109.95 — SKU DEC-4GLS-WBX","109.95","DEC-4GLS-WBX","Whiskey Decanter Set with 4 Glasses & Gift Box | Sentience Labs","Create a gift-ready home bar with a glass whiskey decanter, four matching tum...","whiskey-decanter-set-4-glasses-wooden-box",63,133,"Ready","Draft"],[4,"Large Acacia Cutting Board with Juice Groove","Create a generous prep surface for carving, chopping, and serving. The acacia...","Create a generous prep surface for carving, chopping, and serving. The aca...","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards","Acacia Cutting Board","Sentience Labs","Kitchen Essentials","cutting-board, acacia, juice-groove, carving-board, kitchen-prep, housewarmin...","Default Title — $69.95 — SKU CUT-ACACIA-LG","69.95","CUT-ACACIA-LG","Large Acacia Cutting Board with Juice Groove | Sentience Labs","Prep, carve, and serve on a spacious acacia cutting board with a perimeter ju...","large-acacia-cutting-board-juice-groove",61,125,"Ready","Draft"],[5,"Round Acacia & Resin Charcuterie Serving Board","Bring warm wood grain and a modern resin accent to cheese boards, appetizers,...","Bring warm wood grain and a modern resin accent to cheese boards, appetize...","Home & Garden > Kitchen & Dining > Tableware > Serveware > Serving Trays","Charcuterie Board","Sentience Labs","Entertaining & Serveware","charcuterie-board, serving-board, acacia, resin, cheese-board, entertaining, ...","Default Title — $59.95 — SKU SERV-ACRESIN-RND","59.95","SERV-ACRESIN-RND","Round Acacia Resin Charcuterie Board | Sentience Labs","Serve cheese, fruit, desserts, and appetizers on a round acacia charcuterie b...","round-acacia-resin-charcuterie-serving-board",53,133,"Ready","Draft"],[6,"40 oz Glass Tumbler with Handle, Bamboo Lid & Straw","Keep iced coffee, water, tea, or smoothies close at hand in a roomy 40 oz gla...","Keep iced coffee, water, tea, or smoothies close at hand in a roomy 40 oz ...","Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Travel Mugs","Glass Travel Tumbler","Sentience Labs","Glass Drinkware","glass-tumbler, 40oz, handled-tumbler, bamboo-lid, iced-coffee, hydration, gla...","Default Title — $34.95 — SKU TMB-GLASS-40","34.95","TMB-GLASS-40","40 oz Glass Tumbler with Handle & Bamboo Lid | Sentience Labs","Enjoy iced coffee, tea, smoothies, or water in a roomy 40 oz glass tumbler wi...","40oz-glass-tumbler-handle-bamboo-lid-straw",61,127,"Ready","Draft"],[7,"16 oz Glass Can Tumbler with Bamboo Lid & Straw","A clean, can-shaped glass for iced lattes, matcha, juice, cocktails, and spar...","A clean, can-shaped glass for iced lattes, matcha, juice, cocktails, and s...","Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers","Glass Can Tumbler","Sentience Labs","Glass Drinkware","glass-can, 16oz, iced-coffee-glass, bamboo-lid, straw-cup, matcha, glass-drin...","Single — $19.95 — SKU CAN-GLASS-16-S; Set of 2 — $32.95 — SKU CAN-GLASS-16-2","19.95","CAN-GLASS-16-S","16 oz Glass Can Tumbler with Bamboo Lid | Sentience Labs","Serve iced coffee, matcha, juice, or cocktails in a minimal 16 oz can-shaped ...","16oz-glass-can-tumbler-bamboo-lid-straw",56,120,"Ready","Draft"],[8,"Bourbon Glass & Whiskey Stone Gift Set in Wooden Box","A compact bourbon gift set built around one classic lowball glass, reusable c...","A compact bourbon gift set built around one classic lowball glass, reusabl...","Home & Garden > Kitchen & Dining > Tableware > Drinkware > Drinkware Sets","Bourbon Gift Set","Sentience Labs","Home Bar & Gifts","bourbon-gift, whiskey-glass, whiskey-stones, slate-coaster, wooden-box, barwa...","Default Title — $49.95 — SKU BRB-GIFT-7PC","49.95","BRB-GIFT-7PC","Bourbon Glass & Whiskey Stone Gift Set {"kind":"notice","message":"Cell search matched 0 entries."} Created: /mnt/data/shopify_products_seo_ready.csv Created: /mnt/data/shopify_seo_manual_transfer.csv Created: /mnt/data/shopify_glass_kitchenware_seo_ready.xlsx Done. The revised files keep the full product description separate from the shorter SEO page title and meta description—the screenshot currently has the meta description in the main Description field. All 10 products now have unique SEO titles under 70 characters, meta descriptions under 160 characters, URL handles, and Sentience Labs as the vendor. Shopify stores customized SEO fields separately and requires exact CSV headers with UTF-8 encoding. shopify_glass_kitchenware_seo_ready.xlsx Use the first file for Shopify’s Products → Import workflow. Use the second when entering products manually—it presents the fields in the same logical order as the Add product screen. What about all the other sections? Price, inventory, shipping variants, categories, metafields, search engine listing, product organization? import csv import json import re import zipfile from pathlib import Path from artifact_tool import Workbook, SpreadsheetFile base = Path("/mnt/data") source_csv = base / "shopify_products_seo_ready.csv" product_csv_path = base / "01_shopify_products_standard_import.csv" metafield_csv_path = base / "02_shopify_product_metafields_import.csv" inventory_csv_path = base / "03_shopify_inventory_1519_steely.csv" workbook_path = base / "shopify_catalog_complete_setup.xlsx" zip_path = base / "shopify_catalog_import_package.zip" with source_csv.open("r", encoding="utf-8", newline="") as f: reader = csv.DictReader(f) standard_headers = reader.fieldnames source_rows = list(reader) product_data = { "single-dose-coffee-bean-cellar-set": { "title": "Single-Dose Coffee Bean Cellar Set with Glass Tubes", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Kitchen Organizers > Kitchen Counter & Beverage Station Organizers", "type": "Coffee Bean Cellar Set", "collection": "Coffee Bar", "material": "Glass tubes; display rack and cap materials to be confirmed", "capacity": "Single-dose storage; exact tube count and tube capacity to be confirmed", "included": "Display rack; glass storage tubes; caps", "care": "Hand wash all components and dry completely before refilling.", "highlights": "Organizes pre-portioned coffee beans\nCompact countertop display\nClear tubes make roasts easy to identify", "shipping_note": "Delivery estimate is shown at checkout. Final packed weight and fulfillment service must be confirmed before activation.", "fulfillment_readiness": "Pending supplier SLA, exact packed weight, customs data, approved media, and final all-in cost.", "package_profile": "Fragile countertop set — package dimensions required", "category_attributes": "Color: Clear / rack finish TBD; Placement: Countertop; Material: Glass; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1601435245127.html", "source_cost_signal": "$4.10 displayed at 100 sets; excludes one-order fulfillment", "sla_status": "Pending", "hero_alt": "Single-dose coffee bean cellar set with clear glass tubes in a countertop display rack", "media_plan": "Full-set hero; tubes filled with beans; rack close-up; dimensions; coffee-bar lifestyle; protective packaging", }, "2-in-1-glass-oil-sprayer-pourer-16oz": { "title": "2-in-1 Glass Oil Sprayer & Pourer – 16 oz", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar Dispensers > Oil Dispensers", "type": "Oil Sprayer & Dispenser", "collection": "Kitchen Essentials", "material": "Glass bottle with mixed-material dispensing top", "capacity": "16 oz", "included": "Glass bottle; dual-function spray-and-pour top", "care": "Hand wash the dispensing mechanism. Use only with compatible thin oils, vinegars, or dressings.", "highlights": "Spray and pour from one bottle\nClear 16 oz glass body\nDesigned for controlled cooking-oil dispensing", "shipping_note": "Delivery estimate is shown at checkout. Leak testing and exact packed weight must be confirmed before activation.", "fulfillment_readiness": "Fast-stock pre-screen passed; pending supplier SLA, leak test, exact packed weight, customs data, media, and all-in cost.", "package_profile": "Small fragile bottle — package dimensions required", "category_attributes": "Color: Clear; Shape: Cylindrical; Material: Glass / mixed top; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805.html", "source_cost_signal": "$2.50 displayed at 100 pieces; excludes direct fulfillment", "sla_status": "Pending", "hero_alt": "Sixteen-ounce glass oil sprayer and pourer with dual-function dispensing top", "media_plan": "Hero bottle; spray action; pour action; lid components; scale-in-hand; kitchen lifestyle; packaging", }, "whiskey-decanter-set-4-glasses-wooden-box": { "title": "Whiskey Decanter Gift Set with 4 Glasses & Wooden Box", "category": "Home & Garden > Kitchen & Dining > Barware > Decanters", "type": "Whiskey Decanter Set", "collection": "Home Bar & Gifts", "material": "Glass decanter and tumblers with wooden presentation box", "capacity": "Decanter and glass capacities to be confirmed", "included": "1 decanter; 4 glasses; 1 wooden presentation box", "care": "Hand wash the glassware. Wipe and dry the wooden box promptly.", "highlights": "Complete five-piece glassware presentation\nWooden gift box\nSuitable for home-bar gifting", "shipping_note": "Delivery estimate is shown at checkout. Pack contents, stopper fit, and packed weight must be confirmed before activation.", "fulfillment_readiness": "Hold: supplier wording is ambiguous about whether the displayed pack contains one or four complete sets.", "package_profile": "Large fragile gift set — reinforced carton required", "category_attributes": "Color: Clear / natural wood; Material: Glass / wood; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601659168065.html", "source_cost_signal": "$105–$116 displayed per ambiguous pack", "sla_status": "Not approved", "hero_alt": "Whiskey decanter gift set with four matching glasses in a wooden presentation box", "media_plan": "Open-box hero; complete set; stopper close-up; four glasses; pouring scene; packaging protection", }, "large-acacia-cutting-board-juice-groove": { "title": "Large Acacia Cutting Board with Juice Groove", "category": "Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards", "type": "Acacia Cutting Board", "collection": "Kitchen Essentials", "material": "Acacia wood; finish composition to be confirmed", "capacity": "Exact dimensions and thickness to be confirmed", "included": "1 cutting board", "care": "Hand wash, dry upright, and condition periodically with food-grade board oil. Do not soak or dishwasher-clean.", "highlights": "Large preparation surface\nPerimeter juice groove\nNatural acacia grain", "shipping_note": "Delivery estimate is shown at checkout. Exact dimensions, packed weight, and finish documentation are required before activation.", "fulfillment_readiness": "Fast-stock pre-screen passed; pack quantity, dimensions, finish, packed weight, customs data, and all-in cost remain pending.", "package_profile": "Flat rigid board — reinforced corners required", "category_attributes": "Color: Natural wood; Shape: Rectangular; Material: Acacia wood; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acacia_1601719547362.html", "source_cost_signal": "$98–$118 displayed per box; assumed 12 boards, confirmation required", "sla_status": "Pending", "hero_alt": "Large rectangular acacia cutting board with a perimeter juice groove", "media_plan": "Hero board; juice-groove close-up; carving use; serving use; dimensions; grain variation; corner packaging", }, "round-acacia-resin-charcuterie-serving-board": { "title": "Round Acacia & Resin Charcuterie Serving Board", "category": "Home & Garden > Kitchen & Dining > Tableware > Serveware > Serving Trays", "type": "Charcuterie Serving Board", "collection": "Entertaining & Serveware", "material": "Acacia wood and resin; food-contact finish documentation required", "capacity": "Exact diameter to be confirmed", "included": "1 round serving board", "care": "Hand wash only. Avoid soaking, abrasives, and high heat.", "highlights": "Round serving profile\nNatural acacia grain with resin accent\nDesigned for appetizers and entertaining", "shipping_note": "Delivery estimate is shown at checkout. Food-contact documentation, exact dimensions, and packed weight are required.", "fulfillment_readiness": "Fast-stock pre-screen passed; pending resin/finish documents, exact dimensions, packed weight, customs data, media, and all-in cost.", "package_profile": "Flat fragile serving board — rigid carton required", "category_attributes": "Color: Natural / resin accent; Shape: Round; Material: Acacia wood / resin; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_1601661113107.html", "source_cost_signal": "$9.50–$10.64 displayed at 12 pieces", "sla_status": "Pending", "hero_alt": "Round acacia wood charcuterie serving board with a decorative resin accent", "media_plan": "Empty-board hero; styled charcuterie; resin detail; side profile; dimensions; gift setup; packaging", }, "40oz-glass-tumbler-handle-bamboo-lid-straw": { "title": "40 oz Glass Tumbler with Handle, Bamboo Lid & Straw", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Glass Tumbler", "collection": "Glass Drinkware", "material": "Glass tumbler; bamboo lid; reusable straw", "capacity": "40 oz", "included": "1 glass tumbler; 1 bamboo lid; 1 reusable straw", "care": "Hand wash the bamboo lid. Avoid sudden temperature changes. Do not present as leakproof until tested.", "highlights": "Roomy 40 oz capacity\nLarge carry handle\nBamboo lid and reusable straw", "shipping_note": "Delivery estimate is shown at checkout. Cup-holder fit, seal performance, and packed weight must be confirmed.", "fulfillment_readiness": "Fast-stock pre-screen passed; pending sample tests, packed weight, customs data, approved media, and all-in cost.", "package_profile": "Large fragile tumbler — molded glass protection required", "category_attributes": "Color: Clear / natural lid; Shape: Cylindrical; Material: Glass / bamboo; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-40oz-Reusable-Transparent-Blank_1601418429313.html", "source_cost_signal": "$1.79–$3.55 displayed at 12 pieces", "sla_status": "Pending", "hero_alt": "Forty-ounce clear glass tumbler with a handle, bamboo lid, and reusable straw", "media_plan": "Iced-drink hero; handle detail; lid and straw; size-in-hand; cup-holder test; capacity graphic; packaging", }, "16oz-glass-can-tumbler-bamboo-lid-straw": { "title": "16 oz Glass Can Tumbler with Bamboo Lid & Straw", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "Glass Can Tumbler", "collection": "Glass Drinkware", "material": "Glass tumbler; bamboo lid; reusable straw", "capacity": "16 oz per tumbler", "included": "Selected pack size of glass tumbler(s), bamboo lid(s), and reusable straw(s)", "care": "Hand wash the lid and straw. Avoid sudden temperature changes.", "highlights": "Minimal can-shaped silhouette\n16 oz capacity per glass\nSingle and two-pack options", "shipping_note": "Delivery estimate is shown at checkout. The supplier must assemble and protect the two-pack variant correctly.", "fulfillment_readiness": "Pending exact one-unit and two-unit fulfillment agreement, packed weights, customs data, media, and all-in costs.", "package_profile": "Small fragile glass; separate single and two-pack presets required", "category_attributes": "Color: Clear / natural lid; Shape: Cylindrical; Material: Glass / bamboo; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/US-Warehouse-16oz-Libby-Beer-Can_1601419477214.html", "source_cost_signal": "$5.15–$5.51 per supplier piece at 48 pieces", "sla_status": "Pending", "hero_alt": "Sixteen-ounce can-shaped glass tumbler with bamboo lid and reusable straw", "media_plan": "Single hero; two-pack image; lid and straw; iced-matcha scene; dimensions; gift setup; single/two-pack packaging", }, "bourbon-glass-whiskey-stone-gift-set": { "title": "Bourbon Glass & Whiskey Stone Gift Set in Wooden Box", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Drinkware Sets", "type": "Bourbon Gift Set", "collection": "Home Bar & Gifts", "material": "Glass, chilling stone, slate, and wood; exact stone material to be confirmed", "capacity": "Glass capacity to be confirmed", "included": "1 whiskey glass; 4 reusable chilling stones; 1 slate coaster; 1 wooden presentation box", "care": "Wash and dry the stones before freezing. Hand wash all pieces and dry the box promptly.", "highlights": "Complete seven-piece presentation\nReusable chilling stones\nWooden gift box", "shipping_note": "Delivery estimate is shown at checkout. Exact stone material, glass capacity, and packed weight must be confirmed.", "fulfillment_readiness": "Fast-stock pre-screen passed; pending material confirmation, sample tests, packed weight, customs data, media, and all-in cost.", "package_profile": "Medium fragile gift set — compartmented protection required", "category_attributes": "Color: Clear / natural / dark; Material: Glass / stone / slate / wood; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-Blank-7-Pieces-Bourbon_1601485847381.html", "source_cost_signal": "$10–$12 displayed at 12 sets", "sla_status": "Pending", "hero_alt": "Bourbon gift set with a lowball glass, four chilling stones, slate coaster, and wooden box", "media_plan": "Open-box hero; all seven pieces; stone detail; glass and coaster; gift lifestyle; engraving area; packaging", }, "16oz-diy-snow-globe-glass-tumbler-blank": { "title": "16 oz DIY Snow Globe Glass Tumbler Blank", "category": "Home & Garden > Kitchen & Dining > Tableware > Drinkware > Tumblers", "type": "DIY Tumbler Blank", "collection": "Craft Drinkware", "material": "Double-wall glass; lid and straw materials to be confirmed", "capacity": "16 oz", "included": "1 DIY glass tumbler blank; included accessories to be confirmed", "care": "This is a DIY blank. Follow compatible sealing, curing, and hand-washing instructions before use.", "highlights": "Double-wall glass craft blank\nDesigned for compatible snow-globe effects\nSuitable for small-batch personalization", "shipping_note": "Delivery estimate is shown at checkout. The exact blank configuration and sealing instructions must be confirmed.", "fulfillment_readiness": "Fast-stock pre-screen passed; pending configuration confirmation, maker instructions, packed weight, customs data, media, and all-in cost.", "package_profile": "Small fragile craft blank — rigid protection required", "category_attributes": "Color: Clear; Shape: Cylindrical; Material: Double-wall glass; Cleaning: Hand wash", "source_url": "https://www.alibaba.com/product-detail/USA-Warehouse-16oz-Snowglobe-Bottle-Double_1601536098285.html", "source_cost_signal": "$2.60–$3.40 displayed at 25 pieces", "sla_status": "Pending", "hero_alt": "Sixteen-ounce double-wall DIY snow globe glass tumbler blank", "media_plan": "Blank hero; chamber detail; opening and seal; decoration area; craft steps; included components; packaging", }, "two-lid-glass-iced-coffee-bottle": { "title": "Two-Lid Glass Iced Coffee Bottle with Straw", "category": "Home & Garden > Kitchen & Dining > Food & Beverage Carriers > Water Bottles", "type": "Glass Iced Coffee Bottle", "collection": "Glass Drinkware", "material": "Glass bottle with mixed-material lids and reusable straw", "capacity": "300 ml, 500 ml, or 750 ml", "included": "1 bottle in selected capacity; 2 interchangeable lids; 1 reusable straw", "care": "Hand wash lids and straw. Avoid sudden temperature changes. Test the seal before carrying in a bag.", "highlights": "Two interchangeable lid styles\nReusable straw\nThree capacity options", "shipping_note": "Do not promise delivery within 10 days from the current listing; its captured delivery window extended beyond that target.", "fulfillment_readiness": "Hold: domestic inventory or a written and tested 10-calendar-day delivery SLA is required.", "package_profile": "Fragile bottle; separate package/weight data required by capacity", "category_attributes": "Color: Clear; Shape: Cylindrical; Material: Glass / mixed lids; Cleaning: Hand wash", "source_url": "https://www.aliexpress.us/item/3256808432308153", "source_cost_signal": "$9.99 captured for 300 ml; 500 ml and 750 ml source costs unverified", "sla_status": "Not approved", "hero_alt": "Clear glass iced coffee bottle with two interchangeable lids and a reusable straw", "media_plan": "All sizes; both lids; straw; printed markings; size-in-hand; iced-coffee scene; protective packaging", }, } # Update standard product CSV fields. first_seen = set() updated_rows = [] for row in source_rows: handle = row["URL handle"] data = product_data[handle] is_first = handle not in first_seen if is_first: first_seen.add(handle) row["Title"] = data["title"] row["Vendor"] = "Sentience Labs" row["Product category"] = data["category"] row["Type"] = data["type"] row["Collection"] = data["collection"] row["Published on online store"] = "FALSE" row["Status"] = "draft" row["SEO title"] = row["SEO title"].strip() row["SEO description"] = row["SEO description"].strip() row["Google Shopping / Condition"] = "New" row["Google Shopping / Custom product"] = "" else: row["Title"] = "" row["Vendor"] = "" row["Product category"] = "" row["Type"] = "" row["Collection"] = "" row["Published on online store"] = "" row["Status"] = "" row["SEO title"] = "" row["SEO description"] = "" row["Google Shopping / Condition"] = "" row["Google Shopping / Custom product"] = "" # Safe operational defaults. Exact values remain intentionally unguessed. row["Cost per item"] = "" row["Inventory tracker"] = "shopify" row["Inventory quantity"] = "0" row["Continue selling when out of stock"] = "DENY" row["Weight value (grams)"] = "0" row["Weight unit for display"] = "g" row["Requires shipping"] = "TRUE" row["Fulfillment service"] = "manual" row["Charge tax"] = "TRUE" row["Compare-at price"] = "" row["Barcode"] = "" row["Product image URL"] = "" row["Variant image URL"] = "" row["Image position"] = "" row["Image alt text"] = "" row["Color (product.metafields.shopify.color-pattern)"] = "" updated_rows.append(row) with product_csv_path.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=standard_headers, lineterminator="\n") writer.writeheader() writer.writerows(updated_rows) # Create product metafield import (after definitions are created). metafield_headers = [ "Title", "URL handle", "Material (product.metafields.custom.material)", "Capacity (product.metafields.custom.capacity)", "What's included (product.metafields.custom.whats_included)", "Care instructions (product.metafields.custom.care_instructions)", "Product highlights (product.metafields.custom.product_highlights)", "Shipping note (product.metafields.custom.shipping_note)", "Fulfillment readiness (product.metafields.custom.fulfillment_readiness)", ] metafield_rows = [] for handle, data in product_data.items(): metafield_rows.append({ "Title": data["title"], "URL handle": handle, "Material (product.metafields.custom.material)": data["material"], "Capacity (product.metafields.custom.capacity)": data["capacity"], "What's included (product.metafields.custom.whats_included)": data["included"], "Care instructions (product.metafields.custom.care_instructions)": data["care"], "Product highlights (product.metafields.custom.product_highlights)": data["highlights"], "Shipping note (product.metafields.custom.shipping_note)": data["shipping_note"], "Fulfillment readiness (product.metafields.custom.fulfillment_readiness)": data["fulfillment_readiness"], }) with metafield_csv_path.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=metafield_headers, lineterminator="\n") writer.writeheader() writer.writerows(metafield_rows) # Create location-specific inventory CSV. inventory_headers = [ "Handle", "Title", "Option 1 Name", "Option 1 Value", "Option 2 Name", "Option 2 Value", "Option 3 Name", "Option 3 Value", "SKU", "HS Code", "COO", "Location", "Bin name", "Incoming (not editable)", "Unavailable (not editable)", "Committed (not editable)", "Available (not editable)", "On hand (current)", "On hand (new)" ] inventory_rows = [] current_titles = {} for row in updated_rows: handle = row["URL handle"] if row["Title"]: current_titles[handle] = row["Title"] inventory_rows.append({ "Handle": handle, "Title": current_titles[handle], "Option 1 Name": row["Option1 name"] or "Title", "Option 1 Value": row["Option1 value"] or "Default Title", "Option 2 Name": row["Option2 name"], "Option 2 Value": row["Option2 value"], "Option 3 Name": row["Option3 name"], "Option 3 Value": row["Option3 value"], "SKU": row["SKU"], "HS Code": "", "COO": "", "Location": "1519 Steely", "Bin name": "", "Incoming (not editable)": "", "Unavailable (not editable)": "", "Committed (not editable)": "", "Available (not editable)": "", "On hand (current)": "", "On hand (new)": "0", }) with inventory_csv_path.open("w", encoding="utf-8", newline="") as f: writer = csv.DictWriter(f, fieldnames=inventory_headers, lineterminator="\n") writer.writeheader() writer.writerows(inventory_rows) # ---------- Build comprehensive workbook ---------- wb = Workbook.create() dark = "#173B3F" accent = "#DCEBE8" light = "#F4F8F7" grid = "#D5DFDD" yellow = "#FFF2CC" green = "#D9EAD3" red = "#F4CCCC" # Import Guide guide = wb.worksheets.add("Import Guide") guide.merge_cells("A1:H1") guide.get_range("A1").values = [["Shopify Catalog — Complete Setup & Import Package"]] guide.get_range("A1:H1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF", "size": 16}, "horizontal_alignment": "center", "vertical_alignment": "center" } guide.get_range("A1:H1").format.row_height = 36 guide.get_range("A3:E3").values = [[ "Order", "File / action", "Shopify destination", "What it fills", "Important note" ]] guide.get_range("A3:E3").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } steps = [ [1, "Create the 7 definitions in Metafield Definitions", "Settings > Custom data > Products", "Product metafield schema", "Do this before importing the metafield CSV."], [2, "01_shopify_products_standard_import.csv", "Products > Import", "Title, description, price, variants, category, type, vendor, one collection, tags, SKU, SEO, inventory tracking, physical-product flag", "Products remain Draft, unpublished, at quantity 0."], [3, "02_shopify_product_metafields_import.csv", "Products > Import", "Material, capacity, contents, care, highlights, shipping note, internal fulfillment readiness", "Import only after the definitions exist."], [4, "03_shopify_inventory_1519_steely.csv", "Products > Inventory > Import", "Location-specific inventory and placeholders for HS code / COO", "Location names are case-sensitive. Replace 1519 Steely if the supplier or app owns inventory."], [5, "Complete yellow cells in Product Master", "Supplier documents / samples", "Packed weight, true cost, COO, HS code, media approval, supplier SLA", "These values were not guessed because errors affect rates, margin, and customs."], [6, "Complete Manual-Only Fields", "Shipping settings, theme editor, product admin", "Package presets, shipping profile/rates, theme template, sales-channel publishing, media", "These aren't fully handled by the standard product CSV."], [7, "QA, then set products Active", "Products", "Storefront publication", "Run three-zone test orders before making a 10-day delivery promise."], ] guide.get_range(f"A4:E{3+len(steps)}").values = steps guide.get_range(f"A4:E{3+len(steps)}").format = {"wrap_text": True, "vertical_alignment": "top"} guide.get_range(f"A3:E{3+len(steps)}").format.borders = {"bottom": {"style": "continuous", "color": grid}} for rng, width in {"A:A": 8, "B:B": 40, "C:C": 32, "D:D": 64, "E:E": 65}.items(): guide.get_range(rng).format.column_width = width guide.get_range(f"A4:E{3+len(steps)}").format.row_height = 62 guide.get_range("A13:B13").values = [["Official Shopify reference", "URL"]] guide.get_range("A13:B13").format = { "fill": accent, "font": {"bold": True, "color": dark} } references = [ ["Product CSV fields and metafields", "https://help.shopify.com/en/manual/products/import-export/using-csv"], ["Inventory CSV and locations", "https://help.shopify.com/en/manual/products/inventory/setup/inventory-csv"], ["Product details fields", "https://help.shopify.com/en/manual/products/details/product-details-page"], ["Category metafields", "https://help.shopify.com/en/manual/custom-data/metafields/category-metafields"], ] guide.get_range("A14:B17").values = references guide.get_range("A14:B17").format = {"wrap_text": True} guide.get_range("A13:B17").format.borders = {"bottom": {"style": "continuous", "color": grid}} # Product Master master = wb.worksheets.add("Product Master") master_headers = [ "Product", "Handle", "Variant", "Retail price", "SKU", "Shopify category", "Product type", "Vendor", "Collection", "Tags", "Status", "Published", "Inventory tracker", "On hand at 1519 Steely", "Continue selling", "Physical product", "Fulfillment service", "Packed weight g (INPUT)", "Cost per item (INPUT)", "COO (INPUT)", "HS code (INPUT)", "Package preset (MANUAL)", "Theme template (MANUAL)", "SEO title", "SEO description", "Source cost signal", "Supplier source", "Media approval", "Supplier SLA", "Launch readiness", "Notes" ] master.get_range("A1:AE1").values = [master_headers] master.get_range("A1:AE1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } master.freeze_panes.freeze_rows(1) master_rows = [] title_by_handle = {} for row in updated_rows: handle = row["URL handle"] data = product_data[handle] if row["Title"]: title_by_handle[handle] = row["Title"] variant = row["Option1 value"] or "Default Title" master_rows.append([ title_by_handle[handle], handle, variant, float(row["Price"]), row["SKU"], data["category"], data["type"], "Sentience Labs", data["collection"], row["Tags"] or next( (r["Tags"] for r in updated_rows if r["URL handle"] == handle and r["Tags"]), "" ), "Draft", "No", "shopify", 0, "Deny", "Yes", "manual", 0, "", "", "", data["package_profile"], "Default product", next(r["SEO title"] for r in updated_rows if r["URL handle"] == handle and r["SEO title"]), next(r["SEO description"] for r in updated_rows if r["URL handle"] == handle and r["SEO description"]), data["source_cost_signal"], data["source_url"], "Pending", data["sla_status"], "", data["fulfillment_readiness"] ]) master.get_range_by_indexes(1, 0, len(master_rows), len(master_headers)).values = master_rows last_master_row = len(master_rows) + 1 for r in range(2, last_master_row + 1): master.get_range(f"AD{r}").formulas = [[ f'=IF(AND(R{r}>0,S{r}<>"",T{r}<>"",U{r}<>"",AB{r}="Approved",AC{r}="Approved"),"READY","HOLD")' ]] master.get_range(f"D2:D{last_master_row}").format.number_format = "$0.00" master.get_range(f"N2:N{last_master_row}").format.number_format = "0" master.get_range(f"R2:R{last_master_row}").format.number_format = "0" master.get_range(f"S2:S{last_master_row}").format.number_format = "$0.00" master.get_range(f"A2:AE{last_master_row}").format = {"wrap_text": True, "vertical_alignment": "top"} master.get_range(f"R2:U{last_master_row}").format.fill = yellow master.get_range(f"AB2:AC{last_master_row}").format.fill = yellow master.get_range(f"AD2:AD{last_master_row}").conditional_formats.add_custom( '=AD2="READY"', {"fill": green, "font": {"bold": True, "color": "#274E13"}} ) master.get_range(f"AD2:AD{last_master_row}").conditional_formats.add_custom( '=AD2="HOLD"', {"fill": red, "font": {"bold": True, "color": "#990000"}} ) master.get_range(f"AB2:AB{last_master_row}").data_validation = { "rule": {"type": "list", "values": ["Pending", "Approved", "Rejected"]} } master.get_range(f"AC2:AC{last_master_row}").data_validation = { "rule": {"type": "list", "values": ["Pending", "Approved", "Not approved"]} } for rng, width in { "A:A": 40, "B:B": 44, "C:C": 16, "D:D": 13, "E:E": 20, "F:F": 67, "G:G": 28, "H:H": 18, "I:I": 24, "J:J": 55, "K:Q": 15, "R:U": 18, "V:W": 36, "X:X": 66, "Y:Y": 78, "Z:Z": 40, "AA:AA": 58, "AB:AD": 16, "AE:AE": 70 }.items(): master.get_range(rng).format.column_width = width master.get_range(f"A2:AE{last_master_row}").format.row_height = 86 master.get_range(f"A1:AE{last_master_row}").format.borders = {"bottom": {"style": "continuous", "color": grid}} # Standard Import mirror std = wb.worksheets.add("Product Import") std_matrix = [standard_headers] + [[row[h] for h in standard_headers] for row in updated_rows] std.get_range_by_indexes(0, 0, len(std_matrix), len(standard_headers)).values = std_matrix std.get_range_by_indexes(0, 0, 1, len(standard_headers)).format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } std.freeze_panes.freeze_rows(1) std.get_range_by_indexes(1, 0, len(updated_rows), len(standard_headers)).format = { "wrap_text": True, "vertical_alignment": "top" } std.get_range_by_indexes(1, 0, len(updated_rows), len(standard_headers)).format.row_height = 48 # Metafield Definitions defs = wb.worksheets.add("Metafield Definitions") def_headers = ["Name", "Namespace and key", "Shopify type", "Customer-facing?", "Purpose", "Create before import?"] definitions = [ ["Material", "custom.material", "Single line text", "Yes", "Primary material summary", "Yes"], ["Capacity", "custom.capacity", "Single line text", "Yes", "Capacity, size, or configuration summary", "Yes"], ["What's included", "custom.whats_included", "Multi-line text", "Yes", "Package contents", "Yes"], ["Care instructions", "custom.care_instructions", "Multi-line text", "Yes", "Cleaning and handling guidance", "Yes"], ["Product highlights", "custom.product_highlights", "Multi-line text", "Yes", "Scannable feature summary", "Yes"], ["Shipping note", "custom.shipping_note", "Single line text", "Optional", "Delivery or handling disclosure", "Yes"], ["Fulfillment readiness", "custom.fulfillment_readiness", "Single line text", "No—internal", "Internal launch-control note", "Yes"], ] defs.get_range("A1:F1").values = [def_headers] defs.get_range("A2:F8").values = definitions defs.get_range("A1:F1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } defs.get_range("A2:F8").format = {"wrap_text": True, "vertical_alignment": "top"} for rng, width in {"A:A": 25, "B:B": 38, "C:C": 22, "D:D": 20, "E:E": 50, "F:F": 22}.items(): defs.get_range(rng).format.column_width = width defs.get_range("A2:F8").format.row_height = 42 defs.get_range("A1:F8").format.borders = {"bottom": {"style": "continuous", "color": grid}} # Metafield Import mirror meta = wb.worksheets.add("Metafield Import") meta_matrix = [metafield_headers] + [[row[h] for h in metafield_headers] for row in metafield_rows] meta.get_range_by_indexes(0, 0, len(meta_matrix), len(metafield_headers)).values = meta_matrix meta.get_range_by_indexes(0, 0, 1, len(metafield_headers)).format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } meta.freeze_panes.freeze_rows(1) meta.get_range_by_indexes(1, 0, len(metafield_rows), len(metafield_headers)).format = { "wrap_text": True, "vertical_alignment": "top" } for rng, width in { "A:A": 40, "B:B": 44, "C:D": 46, "E:G": 66, "H:H": 74, "I:I": 76 }.items(): meta.get_range(rng).format.column_width = width meta.get_range(f"A2:I{len(metafield_rows)+1}").format.row_height = 88 # Inventory Import mirror inv = wb.worksheets.add("Inventory Import") inv_matrix = [inventory_headers] + [[row[h] for h in inventory_headers] for row in inventory_rows] inv.get_range_by_indexes(0, 0, len(inv_matrix), len(inventory_headers)).values = inv_matrix inv.get_range_by_indexes(0, 0, 1, len(inventory_headers)).format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } inv.freeze_panes.freeze_rows(1) inv.get_range_by_indexes(1, 0, len(inventory_rows), len(inventory_headers)).format = { "wrap_text": True, "vertical_alignment": "top" } inv.get_range(f"J2:K{len(inventory_rows)+1}").format.fill = yellow inv.get_range(f"S2:S{len(inventory_rows)+1}").format.fill = yellow for rng, width in { "A:A": 44, "B:B": 40, "C:H": 18, "I:I": 20, "J:K": 16, "L:L": 20, "M:M": 18, "N:S": 20 }.items(): inv.get_range(rng).format.column_width = width inv.get_range(f"A2:S{len(inventory_rows)+1}").format.row_height = 44 # Category Attribute Suggestions cat = wb.worksheets.add("Category Attributes") cat_headers = ["Product", "Shopify category", "Suggested values to select manually", "Why manual", "Source"] cat_rows = [] for handle, data in product_data.items(): cat_rows.append([ data["title"], data["category"], data["category_attributes"], "Category metafields vary by assigned taxonomy category and can use Shopify metaobject entries; select the available values after category import.", "https://help.shopify.com/en/manual/custom-data/metafields/category-metafields" ]) cat.get_range("A1:E1").values = [cat_headers] cat.get_range(f"A2:E{len(cat_rows)+1}").values = cat_rows cat.get_range("A1:E1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } cat.freeze_panes.freeze_rows(1) cat.get_range(f"A2:E{len(cat_rows)+1}").format = {"wrap_text": True, "vertical_alignment": "top"} for rng, width in {"A:A": 40, "B:B": 68, "C:C": 66, "D:D": 70, "E:E": 62}.items(): cat.get_range(rng).format.column_width = width cat.get_range(f"A2:E{len(cat_rows)+1}").format.row_height = 76 # Media Plan media = wb.worksheets.add("Media Plan") media_headers = ["Product", "Hero image alt text", "Recommended media set", "Public image URL (INPUT)", "Approval"] media_rows = [[ data["title"], data["hero_alt"], data["media_plan"], "", "Pending" ] for data in product_data.values()] media.get_range("A1:E1").values = [media_headers] media.get_range(f"A2:E{len(media_rows)+1}").values = media_rows media.get_range("A1:E1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } media.get_range(f"A2:E{len(media_rows)+1}").format = {"wrap_text": True, "vertical_alignment": "top"} media.get_range(f"D2:E{len(media_rows)+1}").format.fill = yellow media.get_range(f"E2:E{len(media_rows)+1}").data_validation = { "rule": {"type": "list", "values": ["Pending", "Approved", "Rejected"]} } for rng, width in {"A:A": 40, "B:B": 66, "C:C": 75, "D:D": 62, "E:E": 16}.items(): media.get_range(rng).format.column_width = width media.get_range(f"A2:E{len(media_rows)+1}").format.row_height = 70 # Manual-Only Fields manual = wb.worksheets.add("Manual-Only Fields") manual_headers = ["Admin section", "Field", "CSV status", "Recommended setting", "Why / action"] manual_rows = [ ["Shipping", "Package preset and package dimensions", "Manual", "Create fragile bottle, fragile gift-set, and flat-board package presets after measuring approved samples", "Shopify uses the assigned package and exact weight to calculate rates; measurements must be real."], ["Shipping", "Shipping profile and rates", "Manual", "Create a supplier-fulfilled profile or connect the fulfillment app; do not promise 10 days until tested", "Shipping profiles/rates are store settings, not ordinary product CSV fields."], ["Shipping", "Packed product weight", "Product CSV supports it, but value is pending", "Replace 0 g with exact packed weight for every variant", "Shopify says weight should be exact because it is used for shipping-rate calculations."], ["Customs", "Country of origin and HS code", "Inventory CSV / bulk editor", "Enter only after the supplier confirms final manufacturing/assembly origin and a valid classification", "Do not guess customs data."], ["Inventory", "Location", "Inventory CSV", "1519 Steely is included as a template only", "If the supplier or an app manages inventory, use that fulfillment location instead."], ["Inventory", "Live stock quantity", "Inventory CSV / integration", "0 until a reliable stock feed exists", "Avoid selling stock that the supplier cannot fulfill."], ["Media", "Images, video, 3D", "CSV supports public URLs; files not supplied", "Upload original or supplier-authorized media and paste public URLs", "No supplier marketplace images were copied into the import file."], ["Category metafields", "Color, shape, material, cleaning instructions, etc.", "Manual after category assignment", "Use Category Attributes sheet as a starting point", "Available attributes differ by category and can rely on Shopify metaobject entries."], ["Product metafields", "Material, capacity, contents, care, highlights, shipping note", "Separate CSV after definitions", "Create definitions, then import file 02", "This keeps the standard product import less fragile."], ["Search engine listing", "SEO page title, meta description, URL handle", "Included", "Already populated in file 01", "These are separate from the full product description."], ["Product organization", "Type, vendor, collection, tags", "Included", "Already populated in file 01", "A product CSV can add one collection; add other collections through rules or admin."], ["Theme template", "Product template", "Manual", "Default product", "Change only after a custom product template exists in the live theme."], ["Publishing", "Sales channels and markets", "Manual review", "Keep unpublished while Draft; publish after QA", "Review channel availability after the product import."], ] manual.get_range("A1:E1").values = [manual_headers] manual.get_range(f"A2:E{len(manual_rows)+1}").values = manual_rows manual.get_range("A1:E1").format = { "fill": dark, "font": {"bold": True, "color": "#FFFFFF"}, "horizontal_alignment": "center", "vertical_alignment": "center", "wrap_text": True } manual.get_range(f"A2:E{len(manual_rows)+1}").format = {"wrap_text": True, "vertical_alignment": "top"} for rng, width in {"A:A": 23, "B:B": 37, "C:C": 32, "D:D": 66, "E:E": 70}.items(): manual.get_range(rng).format.column_width = width manual.get_range(f"A2:E{len(manual_rows)+1}").format.row_height = 62 # Verification key_check = wb.inspect({ "kind": "table", "range": "Product Master!A1:AE14", "include": "values,formulas", "table_max_rows": 14, "table_max_cols": 31, }) print(key_check.ndjson[:5000]) error_check = wb.inspect({ "kind": "match", "search_term": "#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A", "options": {"use_regex": True, "max_results": 100}, "summary": "formula error scan", }) print(error_check.ndjson) SpreadsheetFile.export_xlsx(wb).save(str(workbook_path)) # Validate the three CSVs. for path in [product_csv_path, metafield_csv_path, inventory_csv_path]: assert path.exists() and path.stat().st_size > 0 with product_csv_path.open("r", encoding="utf-8", newline="") as f: product_import_rows = list(csv.DictReader(f)) assert len(product_import_rows) == 13 assert sum(1 for r in product_import_rows if r["Title"]) == 10 assert all(r["Price"] for r in product_import_rows) assert all(r["SKU"] for r in product_import_rows) assert all(r["Requires shipping"] == "TRUE" for r in product_import_rows) # Create a single package for convenient download. with zipfile.ZipFile(zip_path, "w", zipfile.ZIP_DEFLATED) as z: z.write(product_csv_path, product_csv_path.name) z.write(metafield_csv_path, metafield_csv_path.name) z.write(inventory_csv_path, inventory_csv_path.name) z.write(workbook_path, workbook_path.name) print(f"Created {product_csv_path}") print(f"Created {metafield_csv_path}") print(f"Created {inventory_csv_path}") print(f"Created {workbook_path}") print(f"Created {zip_path}") STDOUT/STDERR {"kind":"table","sheet":"Product Master","address":"A1:AE14","rows":14,"cols":31,"values":[["Product","Handle","Variant","Retail price","SKU","Shopify category","Product type","Vendor","Collection","Tags","Status","Published","Inventory tracker","On hand at 1519 Steely","Continue selling","Physical product","Fulfillment service","Packed weight g (INPUT)","Cost per item (INPUT)","COO (INPUT)","HS code (INPUT)","Package preset (MANUAL)","Theme template (MANUAL)","SEO title","SEO description","Source cost signal","Supplier source","Media approval","Supplier SLA","Launch readiness","Notes"],["Single-Dose Coffee Bean Cellar Set with Glass Tubes","single-dose-coffee-bean-cellar-set","Default Title",49.95,"CFC-CLR-SET","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Kitchen Organiz...","Coffee Bean Cellar Set","Sentience Labs","Coffee Bar","coffee, espresso, single-dose, bean-cellar, coffee-bar, glass-storage, home-b...","Draft","No","shopify",0,"Deny","Yes","manual",0,"","","","Fragile countertop set — package dimensions required","Default product","Single-Dose Coffee Bean Cellar Set with Glass Tubes | Sentience Labs","Organize espresso and pour-over portions in clear glass coffee bean tubes wit...","$4.10 displayed at 100 sets; excludes one-order fulfillment","https://www.alibaba.com/product-detail/Coffee-Beans-Display-Rack-with-Clear_1...","Pending","Pending","HOLD","Pending supplier SLA, exact packed weight, customs data, approved media, and ..."],["2-in-1 Glass Oil Sprayer & Pourer – 16 oz","2-in-1-glass-oil-sprayer-pourer-16oz","Default Title",24.95,"OIL-2IN1-16","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Oil & Vinegar D...","Oil Sprayer & Dispenser","Sentience Labs","Kitchen Essentials","oil-sprayer, oil-dispenser, glass-kitchenware, cooking-tools, meal-prep, kitc...","Draft","No","shopify",0,"Deny","Yes","manual",0,"","","","Small fragile bottle — package dimensions required","Default product","16 oz Glass Oil Sprayer & Pourer | Sentience Labs","Spray or pour cooking oil from one 16 oz glass dispenser. The dual-function t...","$2.50 displayed at 100 pieces; excludes direct fulfillment","https://www.alibaba.com/product-detail/16-OZ-Glass-Oil-Bottle-2_1601107163805...","Pending","Pending","HOLD","Fast-stock pre-screen passed; pending supplier SLA, leak test, exact packed w..."],["Whiskey Decanter Gift Set with 4 Glasses & Wooden Box","whiskey-decanter-set-4-glasses-wooden-box","Default Title",109.95,"DEC-4GLS-WBX","Home & Garden > Kitchen & Dining > Barware > Decanters","Whiskey Decanter Set","Sentience Labs","Home Bar & Gifts","whiskey, bourbon, decanter, barware, wooden-box, wedding-gift, groomsmen-gift...","Draft","No","shopify",0,"Deny","Yes","manual",0,"","","","Large fragile gift set — reinforced carton required","Default product","Whiskey Decanter Set with 4 Glasses & Gift Box | Sentience Labs","Create a gift-ready home bar with a glass whiskey decanter, four matching tum...","$105–$116 displayed per ambiguous pack","https://www.alibaba.com/product-detail/USA-Warehouse-Wholesale-Pack-of-4_1601...","Pending","Not approved","HOLD","Hold: supplier wording is ambiguous about whether the displayed pack contains..."],["Large Acacia Cutting Board with Juice Groove","large-acacia-cutting-board-juice-groove","Default Title",69.95,"CUT-ACACIA-LG","Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Cutting Boards","Acacia Cutting Board","Sentience Labs","Kitchen Essentials","cutting-board, acacia, juice-groove, carving-board, kitchen-prep, housewarmin...","Draft","No","shopify",0,"Deny","Yes","manual",0,"","","","Flat rigid board — reinforced corners required","Default product","Large Acacia Cutting Board with Juice Groove | Sentience Labs","Prep, carve, and serve on a spacious acacia cutting board with a perimeter ju...","$98–$118 displayed per box; assumed 12 boards, confirmation required","https://www.alibaba.com/product-detail/USA-Warehouse-Fast-Delivery-Large-Acac...","Pending","Pending","HOLD","Fast-stock pre-screen passed; pack quantity, dimensions, finish, packed weigh..."],["Round Acacia & Resin Charcuterie Serving Board","round-acacia-resin-charcuterie-serving-board","Default Title",59.95,"SERV-ACRESIN-RND","Home & Garden > Kitchen & Dining > Tableware > Serveware > Serving Trays","Charcuterie Serving Board","Sentience Labs","Entertaining & Serveware","charcuterie-board, serving-board, acacia, resin, cheese-board, entertaining, ...","Draft","No","shopify",0,"Deny","Yes","manual",0,"","","","Flat fragile serving board — rigid carton required","Default product","Round Acacia Resin Charcuterie Board | Sentience Labs","Serve cheese, fruit, desserts, and appetizers on a round acacia charcuterie b...","$9.50–$10.64 displayed at 12 pieces","https://www.alibaba.com/product-detail/USA-Warehouse-Round-Acacia-Wood-Resin_...","Pending","Pending","HOLD","Fast-stock pre-screen passed; pending resin/finish documents, exact dimension..."],["40 oz Glass Tumbler with Handle, {"kind":"notice","message":"Cell search matched 0 entries."} Created /mnt/data/01_shopify_products_standard_import.csv Created /mnt/data/02_shopify_product_metafields_import.csv Created /mnt/data/03_shopify_inventory_1519_steely.csv Created /mnt/data/shopify_catalog_complete_setup.xlsx Created /mnt/data/shopify_catalog_import_package.zip Yes—you were right. SEO was only one portion of the Shopify record. I rebuilt the catalog as a complete staged-import package covering pricing, SKUs, variants, categories, product organization, inventory tracking, shipping settings, SEO, and metafields. Download Individual files: shopify_catalog_complete_setup.xlsx What is now populated The standard product CSV includes: Retail prices Variant options and variant-specific prices SKUs Shopify product categories Product type Vendor: Sentience Labs Collection Tags Full product descriptions SEO page titles SEO meta descriptions URL handles Taxable-product setting Physical-product setting Manual fulfillment setting Inventory tracking Overselling disabled Draft status Online-store publishing disabled Shopify’s product CSV supports these fields, including product organization, pricing, variants, inventory settings, shipping weight, SEO, and defined product metafields. Inventory The separate inventory CSV contains all 13 variants and uses the location shown in your screenshot: 1519 Steely Every variant starts at quantity 0, preventing an order before supplier inventory synchronization is established. The inventory file also contains columns for: Location SKU Variant identification HS code Country of origin Bin New on-hand quantity Shopify requires the location name to match exactly and uses the option values to identify each variant. Because your model is supplier-fulfilled, 1519 Steely should eventually be replaced by a supplier, fulfillment-app, or third-party logistics location unless you actually stock the goods there. Metafields I created a separate metafield file containing: Material Capacity What is included Care instructions Product highlights Shipping note Internal fulfillment-readiness status The workbook includes the seven corresponding definitions to create under: Settings → Custom data → Products Shopify supports importing product metafields after their definitions exist; variant metafields require the bulk editor rather than the normal product CSV. Category metafields The workbook has a Category Attributes sheet with suggested values for: Color Shape Material Placement Cleaning instructions These remain manual because the available category attributes depend on the exact Shopify taxonomy category and often use Shopify-managed metaobject entries. Intentionally unfilled operational fields I did not invent: Packed product weights Final cost per item HS codes Country of origin Barcodes or GTINs Live supplier inventory Product image URLs Package dimensions Those cells are highlighted in yellow in the Product Master sheet. Exact weight affects shipping-rate calculations, while HS code and country of origin affect international customs and duties, so these should come from approved samples and supplier documentation. The workbook automatically keeps each product at HOLD until weight, cost, customs information, media approval, and supplier SLA are completed. Fields requiring manual Shopify setup The workbook’s Manual-Only Fields sheet covers: Package presets and dimensions Shipping profiles and rates Theme template Sales-channel publishing Product media Category metafield selections Supplier-managed fulfillment location These are not all exposed by Shopify’s standard product CSV. The default theme assignment is therefore listed as Default product, while package profiles remain pending actual measurements. Wonderful! Thank you so much! Can we please generate a list of descriptions for each product collection? Shopify Collection Descriptions 1. Coffee Bar Collection description Create a more organized and enjoyable home-brewing routine with coffee accessories designed for preparation, storage, and display. The Coffee Bar collection brings practical tools and polished countertop organization to espresso, pour-over, and everyday coffee rituals. SEO title Coffee Bar Accessories & Storage | Sentience Labs Meta description Organize your home coffee station with glass bean storage, brewing accessories, and countertop tools for espresso and pour-over routines. Suggested handle coffee-bar 2. Kitchen Essentials Collection description Discover practical kitchen tools made for everyday preparation, cooking, and serving. From controlled oil dispensing to spacious cutting surfaces, the Kitchen Essentials collection helps simplify common tasks while keeping your countertop functional and inviting. SEO title Kitchen Essentials & Everyday Cooking Tools | Sentience Labs Meta description Shop practical kitchen essentials, including oil dispensers, cutting boards, and everyday tools designed for easier food preparation. Suggested handle kitchen-essentials 3. Home Bar & Gifts Collection description Build a refined home-bar experience or find a memorable gift for the spirits enthusiast. This collection features coordinated decanter sets, whiskey glasses, chilling accessories, and presentation boxes suited to celebrations, housewarmings, weddings, and special occasions. SEO title Home Bar Accessories & Whiskey Gift Sets | Sentience Labs Meta description Explore whiskey decanters, bourbon glass sets, chilling stones, and gift-ready home-bar accessories for celebrations and special occasions. Suggested handle home-bar-gifts 4. Entertaining & Serveware Collection description Set the table for relaxed gatherings, celebrations, and thoughtful everyday presentation. The Entertaining & Serveware collection includes serving pieces designed for charcuterie, appetizers, desserts, and shared meals, bringing natural texture and visual interest to the table. SEO title Entertaining Serveware & Charcuterie Boards