Article date

Shopify template

In this guide you'll find the JSON files for the Shopify modeling templates and a step-by-step guide on how to implement. Please check out the templates introduction guide to learn how to add a data modeling template in Y42.

Prerequisites

In order to use this template, please make sure that you have selected these tables and columns inside your Shopify integration:

 Table name  Column name
orders
  • cancelled_at
  • created_at
  • currency
  • customer
  • discount_codes
  • financial_status
  • fulfillment_status
  • fulfillments
  • gateway
  • id
  • line_items
  • name
  • order_number
  • refunds
  • shipping_address
  • shipping_lines
  • taxes_included
  • total_discounts
  • total_line_items_price
  • total_price
  • total_tax
  • updated_at

 

Data lineage

Bildschirmfoto_2022-04-05_um_18.33.53.png

 

Step-by-step guide

  1. Create a new model.
  2. Name it src_shopify_orders.
  3. Import the JSON file src_shopify_orders.
  4. Replace the INPUT node with your actual Shopify orders table
  5. Commit the model.
  6. Create a new model.
  7. Name it stg_shopify_orders.
  8. Import the JSON file stg_shopify_orders.
  9. Replace the INPUT node with your previously created src_shopify_orders model.
  10. Commit the model.
  11. Continue this process until you have committed the mrt_orders model.

Please find the template JSON files down below ⬇️

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful