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_QUANTITYITEM_QUANTITYKITPRODUCTPURCHASE_ORDERTRANSACTION
We also re-import the above listed tables once a week to capture updates and deletes.
NOTE : We also re-import the
TRANSACTIONtable 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.