size-chart-sync

Size Chart Sync Workflow

End-to-end workflow for syncing size chart images to TikTok Shop listings for Shopify merchants.

Workflow Steps

1. Fetch Products

Fetch all products from the Shopify store via paginated /collections/all/products.json API.

GET {store_url}/collections/all/products.json?limit=250&page={n}

• Cache results to data/{store_name}_products.json
• Use --no-cache to force re-fetch
• Key fields: id (shopify_product_id), handle, title, product_type

2. Resolve Listing IDs

Map Shopify product IDs to AfterShip listing IDs via 3-step DB chain:

shopify_product_id (external_product_id)
  -> connectors-p-product.product_id    (connectors_product_id)
  -> products-p-core.product_id         (products_center_product_id)
  -> products-p-listings.product_listing_id  (listing_id)

• Query in batches of 50
• Filter by organization_id in step 1
• Not all products will resolve (some may not have listings)

3. Write CSV

Output to data/{store_name}_products.csv with columns:

• listing_id, shopify_product_id, handle, title
• Remove rows without listing_id
• If merchant has multiple size charts by category: add category and size_chart_url columns

4. Categorize Products (if needed)

Use Shopify product_type field to classify. Fall back to title/handle keywords for empty types.

Typical mapping:

product_type	category
tops, outerwear, jackets & vest, kimonos & cardigans	tops
bottoms	bottoms
dresses & rompers	dresses
shoes	shoes
jeans (title contains "jean")	denim
accessories	skip (no size chart)

5. Generate Batch Payloads

Create JSON payload files in generated_size_charts/{store_name}/payloads/.

Payload format:

{
    "group_name": "batch_edit_product_listings_product_attributes",
    "organization_id": "{org_id}",
    "store_key": "{store_key}",
    "platform": "shopify",
    "inputs": {
        "edit_attributes_task": {
            "product_listing_ids": ["id1", "id2", ...],
            "size_chart": {
                "images": [{
                    "sales_channel_id": "",
                    "url": "{size_chart_image_url}"
                }]
            }
        }
    }
}