Please enable JavaScript.

Coggle requires JavaScript to display documents.

ButcherBox - Coggle Diagram

- - - - custom box
      - curated box
    - - wp_butcherbox_ftp
        
        .type : SUB_
        
        .is_reship : 0
      - wp_butcherbox_order_groups (Biling information)
        
        .type : recurring
        
        always has associated customer .customer_id
      - wp_butcherbox_ftp_subscription_shipping (shipping infomation)
      - order contents
        
        wp_butcherbox_ftp_addons
        
        wp_butcherbox_ftp_custom_plans_products
        
        wp_butcherbox_ftp_invoice_items
        
        wp_butcherbox_ftp_items
        
        wp_butcherbox_ftp_promos
        
        wp_butcherbox_order_items
  - - - one time curated box
    - - wp_butcherbox_ftp
        
        .type: RETAIL_
        
        .is_reship : 0
      - wp_butcherbox_order_groups
        
        .type: one_time
        
        .customer_id, may or may not have associated customer record
      - billing information: pull from shopify
      - shipping information: wp_butcherbox_ftp_retail
      - order contents
        
        wp_butcherbox_ftp_items
        
        wp_butcherbox_ftp_retail_custom_item
  - - - custom box purchases made by subscription customers
      - tables
        
        wp_butcherbox_ftp
        
        .type: MARKET_
        
        .is_reship: 0
        
        wp_butcherbox_order_groups
        
        .type: market
        
        .customer_id, always has associated customer record
        
        Billing information: Pull from shopify
        
        Shipping Information: wp_butcherbox_ftp_retail
        
        Order Contents
        
        wp_butcherbox_ftp_items
        
        wp_butcherbox_ftp_retail_custom_item
  - - - wp_butcherbox_ftp
        
        .type: COMP_
        
        .is_reship: 0
      - wp_butcherbox_order_groups
        
        .type: N/A, no wp_butcherbox_order_groups record
      - Billing Information: N/A
      - Shipping Information: wp_butcherbox_ftp_comps
      - Order Contents
        
        wp_butcherbox_ftp_items
        
        wp_butcherbox_ftp_retail_custom_item
  - - - wp_butcherbox_ftp
        
        .type: COMP_
        
        .is_reship: 0
      - wp_butcherbox_order_groups
        
        .type: N/A
      - wp_butcherbox_ftp_comps
        
        .stripe_charge_id, maybe not be null for corporate sale orders
        
        .corporate_sale: 1
      - Billing Information: N/A
      - Shipping Information: wp_butcherbox_ftp_comps
      - Order Contents
        
        wp_butcherbox_ftp_comp_extras
        
        wp_butcherbox_ftp_items
  - - - wp_butcherbox_utm_data, contains customer_id and utm_campaign values
  - - - wp_butcherbox_ftp
        
        .type: inherited from parent FTP
        
        .is_reship: 1
      - wp_butcherbox_order_groups
        
        .type: N/A, no wp_butcherbox_order_groups record
      - Billing & Shipping: See Parent FTP
      - see wp_butcherbox_ftp_reships table for parent and child FTP IDs
      - Order Contents
        
        wp_butcherbox_ftp_items
        
        wp_butcherbox_ftp_reship_items