Integration Specifications

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

Integration Overview

Snapfulfil is an inventory and logistics platform that integrates with most major ERP systems, shopping carts and carriers, updating inventory and order status information in real-time to provide a single source of truth across all critical business systems and sales channels

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 Snapfulfil extractor is built based on this Snapfulfil API documentation. The following endpoints are used by Daasity to replicate data from Snapfulfil:

• StockDetail

• StockTotals

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity SnapFulfil integration illustrating the different tables and keys to join across tables.

Snapfulfil Schema

The Daasity Snapfulfil 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.

• Products

• Stock Details

• Stock Total Kits

• Stock Totals

Products

• Endpoint: StockTotals

• Update Method: UPSERT

• Table Name: [snapfulfil.products]

JSON Element	Database Column
stock_total::Product::SKUId	sku_id
stock_total::Product::Values	values
stock_total::Product::Status	status
stock_total::Product::BizId	biz_id
stock_total::Product::Description	description
stock_total::Product::Text	text
stock_total::Product::Group1	group_1
stock_total::Product::Group2	group_2
stock_total::Product::Type	type
stock_total::Product::Class	class
stock_total::Product::Value	value
stock_total::Product::Life	life
stock_total::Product::BoxQty	box_quantity
stock_total::Product::BoxUnit	box_unit
stock_total::Product::BoxPack	box_pack
stock_total::Product::BoxHeight	box_height
stock_total::Product::BoxWidth	box_width
stock_total::Product::BoxDepth	box_depth
stock_total::Product::BoxWeight	box_weight
stock_total::Product::ItemUnit	item_unit
stock_total::Product::ItemPack	item_pack
stock_total::Product::ItemHeight	item_height
stock_total::Product::ItemWidth	item_width
stock_total::Product::ItemDepth	item_depth
stock_total::Product::ItemWeight	item_weight
stock_total::Product::ExpiryReqd	expiry_reqd
stock_total::Product::ProductionReqd	production_reqd
stock_total::Product::BatchReqd	batch_reqd
stock_total::Product::SerialReqd	serial_reqd
stock_total::Product::PI	pi
stock_total::Product::MLORTyper	mlor_typer
stock_total::Product::MLORValuer	mlor_valuer
stock_total::Product::MLORTyped	mlor_typed
stock_total::Product::MLORValued	mlor_valued
stock_total::Product::QA	qa
stock_total::Product::QC	qc
stock_total::Product::HazardCode	hazard_code
stock_total::Product::RotationMethod	rotation_method
stock_total::Product::WeightType	weight_type
stock_total::Product::NMFCItem	nmfc_item
stock_total::Product::NMFCClass	nmfc_class
stock_total::Product::Country	country
stock_total::Product::DateHeld	date_held
stock_total::Product::Stage	stage
stock_total::Product::AttachInd	attach_ind
stock_total::Product::MaintInd	maint_ind
Daasity: source_id	__source_id
Daasity: account_id	_account_id
Daasity: stock_total::Product::SKUId	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Stock Details

• Endpoint: StockDetail

• Update Method: UPSERT

• Table Name: [snapfulfil.stock_details]

JSON Element	Database Column
stock_detail::StockId	stock_id
stock_detail::BizId	biz_id
stock_detail::OwnerId	owner_id
stock_detail::SKUId	sku_id
stock_detail::State	state
stock_detail::Site	site
stock_detail::Facility	facility
stock_detail::Zone	zone
stock_detail::Bay	bay
stock_detail::Section	section
stock_detail::Slot	location
stock_detail::StU	stu
stock_detail::StT	stt
stock_detail::Qty	quantity
stock_detail::Unit	unit
stock_detail::BoxQty	box_quantity
stock_detail::AverageWeight	average_weight
stock_detail::Status	status
stock_detail::DateProdn	date_production
stock_detail::DateReceipt	date_receipt
stock_detail::DateRelease	date_released
stock_detail::DateExpiry	date_expiry
stock_detail::Country	country
stock_detail::Batch	batch
stock_detail::Serial	serial
stock_detail::AssignType	assign_type
stock_detail::AssignRef	assign_ref
stock_detail::Consignment	consignment
stock_detail::Load	load
stock_detail::Pair	pair
stock_detail::PairStU	pair_stu
stock_detail::OriginStkId	origin_stock_id
stock_detail::Tamper	tamper
stock_detail::Printed	printed
stock_detail::DateCreated	date_created
stock_detail::DateHeld	date_held
stock_detail::DateLastMove	date_last_move
Daasity: source_id	__source_id
Daasity: account_id	_account_id
Daasity: MD5("#{StockId}:#{Slot}:#{Batch}")	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Stock Total Kits

• Endpoint: StockTotals

• Update Method: UPSERT

• Table Name: [snapfulfil.stock_total_kits]

JSON Element	Database Column
stock_total_kit::SKUId	sku_id
stock_total_kit::LineID	line_id
stock_total_kit::PotentialKitQty	potential_kit_quantity
stock_total_kit::State	state
stock_total_kit::Site	site
stock_total_kit::Facility	facility
stock_total_kit::BizId	biz_id
stock_total_kit::OwnerId	owner_id
stock_total_kit::Status	status
stock_total_kit::Unit	unit
stock_total_kit::Qty	quantity
stock_total_kit::QtyAllocated	quantity_allocated
stock_total_kit::QtyAssigned	quantity_assigned
stock_total_kit::QtyOrderIn	quantity_order_in
stock_total_kit::QtyDueIn	quantity_due_in
stock_total_kit::QtyOrderOut	quantity_order_out
stock_total_kit::QtyDueOut	quantity_due_out
stock_total_kit::StockLevelIndicator	stock_level_indicator
stock_total_kit::DateLastMoved	date_last_moved
Daasity: source_id	__source_id
Daasity: account_id	_account_id
Daasity: MD5("#{SKUId}:#{LineID}:#{Site}:#{Facility}")	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Stock Totals

• Endpoint: StockTotals

• Updatee Method: USPERT

• Table Name: [snapfulfil.stock_totals]

JSON Element	Database Column
stock_total::SKUId	sku_id
stock_total::LineID	line_id
stock_total::State	state
stock_total::Site	site
stock_total::Facility	facility
stock_total::BizId	biz_id
stock_total::OwnerId	owner_id
stock_total::Status	status
stock_total::Unit	unit
stock_total::Qty	quantity
stock_total::QtyAllocated	quantity_allocated
stock_total::QtyAssigned	quantity_assigned
stock_total::QtyOrderIn	quantity_ordered_in
stock_total::QtyDueIn	quantity_due_in
stock_total::QtyOrderOut	quantity_ordered_out
stock_total::QtyDueOut	quantity_due_out
stock_total::StockLevelIndicator	stock_level_indicator
stock_total::DateLastMoved	date_last_moved
Daasity: source_id	__source_id
Daasity: account_id	_account_id
Daasity: MD5("#{SKUId}:#{LineID}:#{Site}:#{Facility}")	__sync_key
Daasity: timestamp when loaded into DB	__synced_at