Picqer Lite
Picqer is an online warehouse management software.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | COMMENT , CUSTOMER , CUSTOMER_FIELD_DETAILED , LOCATION , ORDER_FIELD_DETAILED , PICKING_CONTAINER , PRICE_LIST , PRODUCT , PRODUCT_FIELD_DETAILED , PURCHASE_ORDER , SHIPPING_PROVIDER , STOCK_HISTORY , SUPPLIER , TAGS , TEMPLATE , USERS , VAT_GROUP , and WAREHOUSE tables. |
History mode | ||
Custom data | ||
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step by step Picqer setup guide to connect Picqer with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
BACKORDER
ORDERS
PICKLIST
RETURN
We also re-import these tables once a week to capture updates and deletes.
We re-import the following tables and their child tables during every sync to capture updates and deletes:
COMMENT
CUSTOMER
CUSTOMER_FIELD_DETAILED
LOCATION
ORDER_FIELD_DETAILED
PICKING_CONTAINER
PRICE_LIST
PRODUCT
PRODUCT_FIELD_DETAILED
PURCHASE_ORDER
SHIPPING_PROVIDER
STOCK_HISTORY
SUPPLIER
TAGS
TEMPLATE
USERS
VAT_GROUP
WAREHOUSE
Schema information
This schema applies to all Picqer connectors.
Explore Picqer schema ERD