← back to Patterndesignlab

db/003_shopify_push.sql

7 lines

-- Admin "add as DIG- item to Shopify" tracking. A pushed design remembers its
-- Shopify product so the admin bar shows "already in Shopify" instead of
-- creating duplicates.
ALTER TABLE designs ADD COLUMN IF NOT EXISTS shopify_product_id text;
ALTER TABLE designs ADD COLUMN IF NOT EXISTS shopify_sku text;
ALTER TABLE designs ADD COLUMN IF NOT EXISTS shopify_pushed_at timestamptz;