Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Newstore Schema
  • Customers
  • Customer Address Table
  • Customer Extended Attributes
  • Order Events
  • Order Extended Attributes
  • Order Item Events
  • Order Item Extended Attributes
  • Order Item External Identifiers
  • Returns
  • Return Items
  • Inventory Count
  • Inventory Count Items
  • Inventory Count Item External Identifiers

Was this helpful?

  1. Extract
  2. All Integrations
  3. Newstore

Integration Specifications

This article will help you learn about how Daasity replicates data from Newstore, limitations to the data we can extract and where the data is stored in the Newstore schema

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

Integration Overview

Newstore is an omnichannel platform that provides retail businesses with mobile POS and integrated cloud-based order management systems.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

  • Enterprise

API Endpoints

The Daasity Newstore extractor is built based on this . The following endpoint is used by Daasity to replicate data from Newstore:

Entity Relationship Diagram (ERD)

Newstore Schema

The Daasity Newstore extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.​

Customers

  • Update Method: UPSERT

  • Table Name: [newstore.customers]

JSON Element
Database Column

tenant

tenant

name

name

published_at

published_at

payload::id

id

payload::email

email

payload::first_name

first_name

payload::last_name

last_name

payload::phone

phone

payload::source::location_id

location_id

payload::source::associate_id

associate_id

payload::source::associate_name

associate_name

payload::source::associate_email

associate_email

payload::created_at

created_at

payload::updated_at

updated_at

payload::revision

revision

environment

environment

account_id

_account_id

MD5(payload::id + payload::created_at + payload::updated_at + payload::revision)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Customer Address Table

  • Update Method: UPSERT

  • Table Name: [newstore.customer_address_table]

JSON Element
Database Column

tenant

tenant

name

name

published_at

published_at

payload::id

id

payload::customer_id

customer_id

payload::type

type

payload::salutation

salutation

payload::title

title

payload::first_name

first_name

payload::last_name

last_name

payload::suffix

suffix

payload::company

company

payload::address_line_1

address_line_1

payload::address_line_2

address_line_2

payload::address_line1

address_line1

payload::address_line2

address_line2

payload::zip_code

zip_code

payload::city

city

payload::state

state

payload::country

country

payload::phone

phone

payload::created_at

created_at

payload::updated_at

updated_at

payload::customer_revision

revision

environment

environment

account_id

_account_id

MD5(environment + payload::id + payload::customer_id + payload::created_at + payload::updated_at + payload::customer_revision)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Customer Extended Attributes

  • Update Method: UPSERT

  • Table Name: [newstore.customer_extended_attributes]

JSON Element
Database Column

customer::id

customer_id

customer::extended_attributes::name

extended_attribute

customer::extended_attributes::value

value

customer::revision

revision

environment

environment

account_id

_account_id

MD5(environment + customer::id + customer::extended_attributes:name + customer::extended_attributes::value + customer::revision)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Events

  • Update Method: UPSERT

  • Table Name: [newstore.order_events]

JSON Element
Database Column

payload::id

order_id

payload::external_id

external_id

payload::customer_email

customer_email

payload::customer_id

customer_id

status::name

status

published_at

published_at

payload::created_at

order_date

payload::subtotal

subtotal

payload::price_method

price_method

payload::discount_total

discount_total

payload::shipping_total

shipping_total

payload::shipping_tax

shipping_tax

payload::tax_total

tax_total

payload::grand_total

grand_total

payload::currency

currency

shipping::first_name

shipping_first_name

shipping::last_name

shipping_last_name

shipping::address_line1

shipping_address1

shipping::address_line2

shipping_address2

shipping::city

shipping_city

shipping::state

shipping_state

shipping::country

shipping_country

shipping::zip_code

shipping_zipcode

shipping::phone

shipping_phone

billing::first_name

billing_first_name

billing::last_name

billing_last_name

billing::address1

billing_address1

billing::address2

billing_address2

billing::city

billing_city

billing::state

billing_state

billing::country

billing_country

billing::zip_code

billing_zipcode

billing::phone

billing_phone

payload::channel_type

channel_type

payload::channel_id

channel_id

payload::associate_id

associate_id

payload::associate_email

associate_email

payload::is_exchange

is_exchange

payload::is_historical

is_historical

payload::is_tax_exempt

is_tax_exempt

name

event_name

cancellation_reason

cancellation_reason

payload::created_at || payload::published_at

created_at

environment

environment

source_id

source_id

MD5(environment + payload::id + source_id + payload::published_at + payload::name)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Extended Attributes

  • Update Method: UPSERT

  • Table Name: [newstore.order_extended_attributes]

JSON Element
Database Column

order::extended_attributes::id

order_id

order::extended_attributes::name

name

order::extended_attributes::value

value

environment

environment

MD5(environment + order::extended_attributes::id + order::extended_attributes::name)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Item Events

  • Update Method: UPSERT

  • Table Name: [newstore.order_item_events]

JSON Element
Database Column

payload::id

order_id

item::id

order_item_id

item::product_id

product_id

item::item_type

item_type

item::list_price

list_price

item::item_discounts

item_discounts

item::order_discounts

order_discounts

item::pricebook_id

pricebook_id

item::pricebook_price

pricebook_price

item::shipping_service_level

shipping_service_level

item::tax

tax

item::tax_class

tax_class

item::quantity

quantity

item::fulfillment_location_id

fulfillment_location_id

item::status

status

item::cancelled_reason

cancelled_reason

environment

environment

source_id

__source_id

MD5(environment + source_id + payload::id + item::id + payload::published_at + item::status)

__sync_key

published_at

__synced_at

Order Item Extended Attributes

  • Update Method: UPSERT

  • Table Name: [newstore.order_item_extended_attributes]

JSON Element
Database Column

item::extended_attributes::order_id

order_id

item::id

order_item_id

item::extended_attributes::name

name

item::extended_attributes::value

value

environment

environment

MD5(environment + item::extended_attributes::order_id + item::id + item::extended_attributes::name)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Item External Identifiers

  • Update Method: UPSERT

  • Table Name: [newstore.order_item_external_identifiers]

JSON Element
Database Column

content::payload + content::id

order_id

item::external_identifiers::id

order_item_id

'k'

name

'v'

value

environment

environment

MD5(environmnet + content::payload + content::id + item::external_identifiers::id + 'k')

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Returns

  • Update Method: UPSERT

  • Table Name: [newstore.returns]

JSON Element
Database Column

tenant

tenant

name

name

published_at

published_at

payload::id

id

payload::order_id

order_id

payload::returned_at

returned_at

payload::total_refund_amount

total_refund_amount

payload::total_refund_amount_adjusted

total_refund_amount_adjusted

payload::total_refund_excl_tax

total_refund_excl_tax

payload::return_fee

return_fee

payload::currency

currency

payload::returnlocation_id

return_location_id

payload::customer_id

customer_id

payload::customer_email

customer_email

payload::associate_id

associate_id

payload::associate_email

associate_email

environment

environment

account_id

_account_id

MD5(environment + payload::id +payload::order_id + payload::returned_at + payload::total_refund_amount + payload::total_refund_amount_adjusted + payload::total_refund_excl_tax + payload::total_refund_tax)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Return Items

  • Update Method: UPSERT

  • Table Name: [newstore.return_items]

JSON Element
Database Column

payload::id

return_id

item::id

id

item::product_id

product_id

item::item_type

item_type

item::item_condition

item_condition

item::condition_code

condition_code

item::return_Reason

return_Reason

item::return_code

return_code

item::refund_excl_tax

refund_excl_tax

item::refund_tax

refund_tax

item::refund_amount

refund_amount

item::refund_amount_adjusted

refund_amount_adjusted

item::quantity

quantity

environment

environment

account_id

_account_id

MD5(environment + payload::id + item::id + item::product_id)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Inventory Count

  • Endpoint: Inventory Manager

  • Update Method: UPSERT

  • Table Name: [newstore.inventory_count]

JSON Element
Database Column

tenant

tenant

name

name

published_at

published_at

payload::id

id

payload::count_type

count_type

payload::fulfillment_location_id

fulfillment_location_id

payload::associate_id

associate_id

payload::stock_location_name

stock_location_name

payload::due_date

due_date

payload::started_at

started_at

payload::completed_at

completed_at

payload::chunk_number

chunk_number

payload::total_chunks

total_chunks

environment

environment

account_id

_account_id

MD5(published_at + payload::id + payload::count_type + payload::fulfillment_location_id + payload::associate_id + payload::stock_location_name + payload::due_date + payload::started_at + payload::complete_at + payload::chunk_number)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Inventory Count Items

  • Endpoint: Stock Locations

  • Update Method: UPSERT

  • Table Name: [newstore.inventory_count_items]

JSON Element
Database Column

inventory_id

inventory_id

item::product_id

product_id

item::stock_on_hand

stock_on_hand

item::count

count

environment

environment

account_id

_account_id

MD5(environment + item::product_id + item::stock_on_hand + item::count)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Inventory Count Item External Identifiers

  • Endpoint: Stock Locations

  • Update Method: UPSERT

  • Table Name: [newstore.inventory_count_items_external_identifiers]

JSON Element
Database Column

inventory_id

inventory_id

item::product_id

product_id

'k'

external_identifier

'v'

value

environment

environment

account_id

_account_id

MD5(environment + inventory_id + item::product_id + k + v)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

integration illustrating the different tables and keys to join across tables.

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
Newstore API documentation
Customer Profile Updates
Inventory Manager
Item Return
Order
Stock Locations
Click here to view the ERD for the Daasity Newstore
Customer Profile Updates
Customer Profile Updates
Customer Profile Updates
Order
Order
Order
Order
Order
Item Return
Item Return
Customers
Customer Address Table
Customers Extended Attributes
Order Events
Order Extended Attributes
Order Item Events
Order Item Extended Attributes
Order Item Extended Identifiers
Returns
Return Items
Inventory Count
Inventory Count Items
Inventory Count Items External Identifiers