Shopify Extractor Document

mceclip0.pngShopify is the fasting growing eCommerce and direct-to-consumer platform for large and small brands. They make it incredibly easy for a novice store owner to get started, but have also built out the capabilities to serve even the largest DTC brands with their PLUS platform.

 

INTEGRATION OVERVIEW

The Daasity<>Shopify integration is the most comprehensive Shopify extraction tool available. In addition to the standard modules such as customers and orders, Daasity also has extractors for data such as gift cards, payouts, disputes and more.

All modules available with Daasity:

  • Customers (*)
  • Products (*)
  • Orders (*)
  • Refunds (*)
  • Fulfillments (*)
  • Inventory (*)
  • Transactions (*)
  • Disputes
  • Payouts
  • Gift Cards
  • Price Rules (*)

Modules used as part of the standard implementation are noted with a (*) 

In addition, Daasity snapshots certain data, such as inventory, daily. This provides merchants with the historical information available to conduct sell-through analysis, promo performance and more.

AVAILABILITY

Shopify is available to all merchants with an active Daasity subscription.

Non-standard modules are available for Professional merchants with additional configuration.

SUPPORTED ENDPOINTS

Documentation on the Shopify APIs can be found here: https://shopify.dev/docs/admin-api/rest/reference

Endpoints

Endpoint

Included

Collects

https://shopify.dev/docs/admin-api/rest/reference/products/collect?api[version]=2020-07

Customers

https://shopify.dev/docs/admin-api/rest/reference/customers/customer-address?api[version]=2020-07

https://shopify.dev/docs/admin-api/rest/reference/customers/customer?api[version]=2020-07

CustomCollections

https://shopify.dev/docs/admin-api/rest/reference/products/customcollection?api[version]=2020-07

DiscountCodes

https://shopify.dev/docs/admin-api/rest/reference/discounts/discountcode?api[version]=2020-07

Disputes

https://shopify.dev/docs/admin-api/rest/reference/shopify_payments/dispute?api[version]=2020-07

Fulfillments

https://shopify.dev/docs/admin-api/rest/reference/orders/order

GiftCards

https://shopify.dev/docs/admin-api/rest/reference/plus/giftcard?api[version]=2020-07

GiftCardAdjustments

this is an unpublished endpoint

InventoryLevels

https://shopify.dev/docs/admin-api/graphql/reference/object/inventoryitem?api[version]=2020-07

InventoryLevelsBulk

https://shopify.dev/docs/admin-api/rest/reference/inventory/inventorylevel?api[version]=2020-07

Locations

https://shopify.dev/docs/admin-api/rest/reference/inventory/location?api[version]=2020-07

Orders

https://shopify.dev/docs/admin-api/rest/reference/orders/order

PaymentTransactions

https://shopify.dev/docs/admin-api/rest/reference/shopify_payments/transaction?api[version]=2020-07

Payouts

https://shopify.dev/docs/admin-api/rest/reference/shopify_payments/payout?api[version]=2020-07

PriceRules

https://shopify.dev/docs/admin-api/rest/reference/discounts/pricerule?api[version]=2020-07

Products

https://shopify.dev/docs/admin-api/rest/reference/products/product

Product Images

https://shopify.dev/docs/admin-api/rest/reference/products/product-image?api[version]=2020-07

Product Variants

https://shopify.dev/docs/admin-api/rest/reference/products/product-variant

Refunds

https://shopify.dev/docs/admin-api/rest/reference/orders/refund?api[version]=2020-07#index-2020-07

Shops

https://shopify.dev/docs/admin-api/rest/reference/store-properties/shop?api[version]=2020-07

Transactions

https://shopify.dev/docs/admin-api/rest/reference/orders/transaction?api[version]=2020-07

 

 

ERD


X Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + tax_type)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Collects Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

collect_id

collection_id

collection_id

product_id

product_id

position

position

created_at

created_at

updated_at

updated_at

shop::id

shop_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Custom Collections Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

custom_collection_id

handle

handle

title

title

sort_order

sort_order

published_at

published_at

published_scope

published_scope

updated_at

updated_at

shop::id

shop_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

 

Customer Addresses Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

address_id

customer_id

customer_id

first_name

first_name

last_name

last_name

company

company

address1

address1

address2

address2

city

city

province

state

country

country

zip

zipcode

phone

phone_number

province_code

state_code

country_code

country_code

country_name

country_name

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Customers Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

customer_id

accepts_marketing

accepts_marketing

default_address::id

address_id

default_address::company

company

default_address::address1

address1

default_address::address2

address2

default_address::city

city

default_address::province

state

default_address::country

country

default_address::zip

zipcode

default_address::phone

phone_number

default_address::province_code

state_code

default_address::country_code

country_code

default_address::country_name

country_name

email

email

first_name

first_name

last_name

last_name

note

note

state

account_status

tags

tags

verified_email

verified_email

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Discount Codes Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

discount_code_id

code

discount_code

price_rule_id

price_rule_id

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Disputes Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

dispute_id

order_id

order_id

type

type

currency

currency

amount

amount

reason

reason

network_reason_code

network_reason_code

status

status

initiated_at

initiated_at

evidence_due_by

evidence_due_by

evidence_sent_on

evidence_sent_on

finalized_on

finalized_on

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Fulfillment Order Items Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

fulfillment_id

order_id

order_id

line_item::id

order_line_id

line_item::variant_id

variant_id

line_item::sku

sku

line_item::quantity

quantity

line_item::fulfillable_quantity

fulfillable_quantity

line_item::fulfillment_status

fulfillment_status

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(fulfillment_id + order_line_id + order_id)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Gift Cards Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

id

balance

balance

created_at

created_at

updated_at

updated_at

currency

currency

initial_value

initial_value

disabled_at

disabled_at

line_item_id

line_item_id

api_client_id

api_client_id

user_id

user_id

customer_id

customer_id

note

note

expires_on

expires_on

template_suffix

template_suffix

last_characters

last_characters

order_id

order_id

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Gift Card Adjustments Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

id

gift_card_id

gift_card_id

number

number

amount

amount

note

note

remote_transaction_ref

remote_transaction_ref

remote_transaction_url

remote_transaction_url

api_client_id

api_client_id

user_id

user_id

order_transaction_id

order_transaction_id

created_at

created_at

updated_at

updated_at

processed_at

processed_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + tax_type)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Inventory Items Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

inventory_item_id

variant_id

variant_id

sku

sku

cost

sku_cost

requires_shipping

required_shipping

tracked

tracked

country_code_of_origin

country_of_origin

created_at

created_at

updated_at

updated_at

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Inventory Levels Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

inventory_item_id

inventory_item_id

location_id

location_id

available

inventory_quantity

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

MD5(shop_id + inventory_item_id)

_key

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Locations Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

location_id

name

location_name

address1

address1

address2

address2

city

city

province

state

country

country

zip

zipcode

phone

phone_number

deleted_at

deleted_at

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Orders Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

order_id

app_id

app_id

browser_ip

browser_ip

cancel_reason

cancel_reason

cancelled_at

cancelled_at

cart_token

cart_token

currency

currency

customer.id

customer_id

customer_locale

customer_locale

email

email

financial_status

financial_status

fulfillment_status

fulfillment_status

tags

tags

name

order_code

note

note

phone

phone_number

referring_site

referring_site

source_name

source_name

subtotal_price

subtotal_price

total_discounts

total_discounts

total_line_items_price

total_line_items_price

total_price

amount_charged

total_tax

total_tax

total_weight

total_weight

location_id

location_id

billing_address::name

billing_name

billing_address::company

billing_company

billing_address::address1

billing_address1

billing_address::address2

billing_address2

billing_address::city

billing_city

billing_address::province

billing_state

billing_address::country

billing_country

billing_address::zip

billing_zipcode

billing_address::phone

billing_phone

billing_address::province_code

billing_state_code

billing_address::country_code

billing_country_code

billing_address::first_name

billing_first_name

billing_address::last_name

billing_last_name

billing_address::latitude

billing_latitude

billing_address::longitude

billing_longitude

shipping_address::name

shipping_name

shipping_address::company

shipping_company

shipping_address::address1

shipping_address1

shipping_address::address2

shipping_address2

shipping_address::city

shipping_city

shipping_address::province

shipping_state

shipping_address::country

shipping_country

shipping_address::zip

shipping_zipcode

shipping_address::phone

shipping_phone

shipping_address::province_code

shipping_state_code

shipping_address::country_code

shipping_country_code

shipping_address::first_name

shipping_first_name

shipping_address::last_name

shipping_last_name

shipping_address::latitude

shipping_latitude

shipping_address::longitude

shipping_longitude

processed_at

processed_at

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Order Discount Codes Table

From the discount_code nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

amount

amount

code

code

type

type

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + code)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Order Fulfillments Table

From the fulfillments nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

order_fulfillment_id

order_id

order_id

location_id

location_id

status

fulfillment_status

shipment_status

shipment_status

tracking_company

tracking_company

tracking_number

tracking_number

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Order Line Items Table

From the line_items nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

order_line_id

order_id

order_id

fulfillment_status

fulfillment_status

fulfillment_id

fulfillment_id

price

price

product_id

product_id

quantity

quantity

sku

sku

requires_shipping

requires_shipping

title

product_title

variant_id

variant_id

vendor

vendor

name

product_name

taxable

taxable_flag

total_discount

discount_amount

gift_card

gift_card

_tax_lines_total

tax_lines_total

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Order Line Item Discount Allocations Table

From the discount_allocations nested JSON within line_items nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

order_line_id

order_line_id

amount

amount

discount_application_index

discount_application_index

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + order_line_id + discount_applicaton_index)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Order Line Item Properties Table

From the properties nested JSON within line_items nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

order_line_id

order_id

order_id

name

name

value

value

MD5(shop_id + order_id + order_line_id + name)

_key

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Order Note Attributes Table

From the note_attributes nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

name

name

value

value

shop::id

shop_id

MD5(shop_id + order_id + name)

_key

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Order Payment Gateway Names Table

From the payment_gateway_names nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

value

value

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + value)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Order Refund Transactions Table

From the transactions nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

refund_id

refund_id

amount

refund_amount

currency

currency_code

gateway

gateway

source_name

source_name

status

status

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + tax_type)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Order Shipping Lines Table

From the shipping_lines nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

shipping_line_id

order_id

order_id

code

shipping_code

price

shipping_amount

source

source

title

shipping_title

carrier_identifier

carrier_identifier

SUM(tax_line::amount)

tax_lines_total

SUM(discount_allocations::amount)

discount_allocations_total

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Order Tax Lines Table

From the tax_lines nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

order_id

order_id

price

tax_amount

rate

tax_rate

title

tax_type

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + order_id + tax_type)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Payment Transactions Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

id

type

type

test

test

payout_id

payout_id

payout_status

payout_status

currency

currency

amount

amount

fee

fee

net

net

source_id

source_id

source_type

source_type

source_order_transaction_id

source_order_transaction_id

source_order_id

source_order_id

processed_at

processed_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

MD5(shop_id + id)

__sync_key

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Payouts Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

payout_id

status

status

date

payout_date

currency

currency

amount

amount

summary::adjustments_fee_amount

adjustments_fee_amount

summary::adjustments_gross_amount

adjustments_gross_amount

summary::charges_fee_amount

charges_fee_amount

summary::refunds_fee_amount

refunds_fee_amount

summary::refunds_gross_amount

refunds_gross_amount

summary::reserved_funds_fee_amount

reserved_fee_amount

summary::reserved_funds_gross_amount

reserved_gross_amount

summary::retried_payouts_fee_amount

retried_payouts_fee_amount

summary::retried_payouts_gross_amount

retried_payouts_gross_amount

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Price Rules Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

price_rule_id

title

title

target_type

target_type

target_selection

target_selection

allocation_method

allocation_method

value_type

value_type

value

value

once_per_customer

once_per_customer

usage_limit

usage_limit

customer_selection

customer_selection

starts_at

price_rule_starts_at

ends_at

price_rule_ends_at

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

 

Products Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

product_id

handle

product_handle

product_type

product_type

tags

tags

title

product_name

vendor

vendor_name

published_scope

published_scope

published_at

published_at

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Product Images Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

product_image_id

product_id

product_id

position

position

src

image_url

width

image_width

height

image_height

created_at

created_at

updated_at

updated_at

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Product Variants Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

variant_id

barcode

barcode

inventory_item_id

inventory_item_id

price

price

product_id

product_id

sku

sku

title

product_name

weight

weight

weight_unit

weight_unit

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Refunds Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

refund_id

order_id

order_id

note

note

restock

restock

processed_at

processed_at

created_at

created_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Refund Line Items Table

From the refund_line_items nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

refund_line_item_id

refund::order_id

order_id

refund::id

refund_id

line_item_id

line_item_id

quantity

quantity

refund::created_at

created_at

subtotal

subtotal

total_tax

total_tax

line_item::fulfillment_service

line_item_fulfillment_service

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Refund Order Adjustments Table

From the order_adjustments nested JSON

 

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

refund_order_adjustment_id

order_id

order_id

refund_id

refund_id

amount

amount

kind

kind

reason

reason

tax_amount

tax_amount

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

 

Shops Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

id

name

name

email

email

customer_email

customer_email

domain

domain

myshopify_domain

myshopify_domain

address1

address1

city

city

province

state

country

country

zip

zipcode

phone

phone_number

country_code

country_code

latitude

latitude

longitude

longitude

currency

currency

iana_timezone

timezone_name

shop_owner

shop_owner

multi_location_enabled

multi_location_enabled

created_at

created_at

updated_at

updated_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

 

Transactions Table

Data mapping from source JSON to database columns:

JSON Element 

Database Column 

id

transaction_id

order_id

order_id

amount

transaction_amount

authorization

authorization

currency

currency_code

error_code

error_code

gateway

gateway

kind

transaction_type

payment_details::avs_result_code

avs_result_code

payment_details::credit_card_bin

credit_card_bin

payment_details::credit_card_company

credit_card_company

payment_details::cvv_result_code

cvv_result_code

receipt::gift_card_id

receipt_gift_card_id

source_name

source_name

status

status

test

test_transaction

processed_at

processed_at

created_at

created_at

shop::id

shop_id

ID of Shopify in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

 

 

Business Rule

Value

Load type

UPSERT

Extraction Frequency

Daily

 

 

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