Edit on GitHub
Skuvault Lite link
Updated August 16, 2023
SkuVault is a cloud-based inventory and warehouse management platform.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | We infer deletes for the WAREHOUSE ,EXTERNAL_WAREHOUSE , BRAND ,CLASSIFICATION ,SUPPLIER ,INCOMING_ITEM ,HANDLING_TIME_KIT ,HANDLING_TIME_PRODUCT ,SALE ,INVENTORY_LOCATION ,LOCATION ,RECEIVE_HISTORY ,RECEIVE_CORRECTION ,EXTERNAL_WAREHOUSE_QUANTITIY ,SHIPMENT , and SERIAL_NUMBER tables. |
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step SkuVault setup guide to connect SkuVault with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
AVAILABLE_QUANTITY
ITEM_QUANTITY
KIT
PRODUCT
PURCHASE_ORDER
TRANSACTION
We also re-import the above listed tables once a week to capture updates and deletes.
NOTE : We also re-import the
TRANSACTION
table once a day.
Schema informationlink
This schema applies to all SkuVault connectors.
To zoom, open the ERD in a new window.Limitationlink
Fivetran can only retrieve the last 6 days' worth of data from the TRANSACTION endpoint. This limitation stems from the source side.