Unicommerce

Unicommerce ETL connector for data replication

Prerequisites
The following details are required to create the Unicommerce integration in Daton.
1.Facility codes: They can be located by navigating to: Settings > Facilities > {Search or Select the facility from the list} 
2. Shop name: In the Unicommerce portal, check the URL after you login. It will be in the format of https://<shop-name>.unicommerce.com.
3. Email: The email id used to login to Unicommerce dashboard.
4. Password: The password used to login to Unicommerce dashboard.
​
Integrate Unicommerce with Daton
1.Sign in to Daton 
2.Select Unicommerce from Integrations page
3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 
4.Provide Unicommerce facility codes, shop name, Username and Password.
5.Post successful authentication, you will be prompted to choose from the list of available tables
6.Then select all required fields for each table
7.Submit the integration
Workflow
1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2.Users would be able to edit/pause/re-activate/delete integration anytime
3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Snapshot
Features
Details
Release Status
Released
Source API Version
​
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Username
Password
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1hr
Tables
Replication type
Replication Key
Sale Orders
Incremental
updatedOn
Purchase Orders
Incremental
addedOn
Item Master
Incremental
updatedOn
Vendor Item Master
Incremental
updatedOn
GRN
Incremental
addedOn
Gate Pass
Incremental
addedOn
Inventory Snapshot
Incremental
UpdatedIn
Vendors
Incremental
updatedOn
Putaway
Incremental
addedOn
Reverse Pickup
Incremental
reversePickupDateRange
Return Invoices
Incremental
addedOn
Invoice
Incremental
dateCreatedRange
Unicommerce Data
1.Sale Orders
Purpose: Get the list of the Sales Orders residing in the system
Source API Documentation : https://documentation.unicommerce.com/docs/export-create.html​
Fields
Field name
Type
SaleOrderItemCode
STRING
DisplayOrderCode
STRING
ReversePickupCode
STRING
ReversePickupCreatedDate
STRING
ReversePickupReason
STRING
NotificationEmail
STRING
NotificationMobile
STRING
RequireCustomization
STRING
COD
STRING
ShippingAddressId
STRING
Category
STRING
InvoiceCode
STRING
InvoiceCreated
STRING
ShippingAddressName
STRING
ShippingAddressLine1
STRING
ShippingAddressLine2
STRING
ShippingAddressCity
STRING
ShippingAddressState
STRING
ShippingAddressCountry
STRING
ShippingAddressPincode
STRING
ShippingAddressPhone
STRING
BillingAddressId
STRING
BillingAddressName
STRING
BillingAddressLine1
STRING
BillingAddressLine2
STRING
BillingAddressCity
STRING
BillingAddressState
STRING
BillingAddressCountry
STRING
BillingAddressPincode
STRING
BillingAddressPhone
STRING
ShippingMethod
STRING
ItemSKUCode
STRING
ChannelProductId
STRING
ItemTypeName
STRING
ItemTypeColor
STRING
ItemTypeSize
STRING
ItemTypeBrand
STRING
ChannelName
STRING
SKURequireCustomization
STRING
GiftWrap
STRING
GiftMessage
STRING
HSNCode
STRING
MRP
STRING
TotalPrice
STRING
SellingPrice
STRING
CostPrice
STRING
PrepaidAmount
STRING
Subtotal
STRING
Discount
STRING
GSTTaxTypeCo
STRING
2. Purchase Orders
Purpose: Get the list of the Purchase Orders residing in the system
Source API Documentation : https://documentation.unicommerce.com/docs/export-create.html​
Field name
Type
POCode
STRING
Created
STRING
POCreatedBy
STRING
POApprovedDate
STRING
DeliveryDate
STRING
ItemTypeName
STRING
ItemSkuCode
STRING
Category
STRING
HSNCode
STRING
GSTTaxTypeCode
STRING
VendorName
STRING
VendorCode
STRING
VendorSkuCode
STRING
OrderQuantity
STRING
RecievedQuantity
STRING
RejectedQuantity
STRING
PendingQuantity
STRING
_Pending
STRING
_Rejection
STRING
Facility
STRING
SubTotal
STRING
CGST
STRING
IGST
STRING
SGST
STRING
UTGST
STRING
CESS
STRING
CGSTRate
STRING
IGSTRate
STRING
SGSTRate
STRING
UTGSTRate
STRING
CESSRate
STRING
Total
STRING
PurchaseOrderStatus
STRING
RejectionReason
STRING
Updated
STRING
Type
STRING
POAgeing_Days_
STRING
UnitPrice
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch
NUMERIC
3. Item Master
Field name
Type
CategoryCode
STRING
ProductCode
STRING
Name
STRING
Description
STRING
ScanIdentifier
STRING
RequiresCustomization
STRING
Length_mm_
STRING
Width_mm_
STRING
Height_mm_
STRING
Weight_gms_
STRING
EAN
STRING
UPC
STRING
ISBN
STRING
Color
STRING
Size
STRING
Brand
STRING
ItemDetailFields
STRING
Tags
STRING
ImageUrl
STRING
ProductPageUrl
STRING
TaxTypeCode
STRING
GSTTaxTypeCode
STRING
BasePrice
STRING
CostPrice
STRING
TAT
STRING
MRP
STRING
Updated
STRING
CategoryName
STRING
Enabled
STRING
Type
STRING
ComponentProductCode
STRING
ComponentQuantity
STRING
ComponentPrice
STRING
HSNCODE
STRING
TaxCalculationType
STRING
BatchGroup
STRING
GRNexpirytolerance_inDays_
STRING
Dispatchexpirytolerance_inDays_
STRING
Returnexpirytolerance_inDays_
STRING
Expirable
STRING
DetermineExpiryFrom
STRING
ShelfLife
STRING
ExpiryDate
STRING
Facility
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
4. Vendor Item Master
​
Field name
Type
Facility
STRING
ProductCode
STRING
ProductName
STRING
UnitPrice
STRING
Inventory
STRING
VendorCode
STRING
VendorSkuCode
STRING
LeadTime_inHours_
STRING
Priority
STRING
Enabled
STRING
Updated
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
5. GRN
Field name
Type
GRNCode
STRING
GRNDate
STRING
GRNCreatedBy
STRING
ItemSkuCode
STRING
ItemTypeName
STRING
ItemTypeColor
STRING
ItemTypeSize
STRING
ItemTypeBrand
STRING
Facility
STRING
Category
STRING
BatchCode
STRING
AdditionalCost
STRING
VendorSkuCode
STRING
VendorName
STRING
VendorCode
STRING
GRNInvoiceNo
STRING
GRNInvoiceDate
STRING
POCode
STRING
PODate
DATETIME
QuantityReceived
STRING
QuantityRejected
STRING
PercentageRejection
STRING
ValuesofGoodsReceivedwithouttaxes
STRING
ValuesofGoodsReceivedwithtaxes
STRING
ValuesofGoodsRejectedwithouttaxes
STRING
ValuesofGoodsRejectedwithtaxes
STRING
RejectionReason
STRING
GrnitemStatus
STRING
Updated
DATETIME
ExpiryDate
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
6. Gate Pass
Field name
Type
GatepassCode
STRING
GatepassCreatedBy
STRING
Type
STRING
GatepassStatus
STRING
GatepassCreatedAt
STRING
GatepassUpdatedAt
STRING
Purpose
STRING
Reference
STRING
ToParty
STRING
ItemName
STRING
ItemSkuCode
STRING
Color
STRING
Size
STRING
Brand
STRING
HSNCode
STRING
UnitPrice
STRING
Quantity
STRING
ReceivedQuantity
STRING
InventoryType
STRING
GatepassItemStatus
STRING
Shelf
STRING
Reason
STRING
GatepassItemCreated
STRING
GatepassItemUpdated
STRING
GatepassOrderCode
STRING
Facility
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch
NUMERIC
7. Inventory Snapshot
Field name
Type
Facility
STRING
ItemTypeName
STRING
ItemSkuCode
STRING
Ean
STRING
UPC
STRING
ISBN
STRING
Color
STRING
Size
STRING
Brand
STRING
CategoryName
STRING
MRP
STRING
OpenSale
STRING
Inventory
STRING
InventoryBlocked
STRING
BadInventory
STRING
PutawayPending
STRING
PendingInventoryAssessment
STRING
StockInTransfer
STRING
OpenPurchase
STRING
Enabled
STRING
Updated
STRING
CostPrice
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC

Tables	Replication type	Replication Key
Sale Orders	Incremental	updatedOn
Purchase Orders	Incremental	addedOn
Item Master	Incremental	updatedOn
Vendor Item Master	Incremental	updatedOn
GRN	Incremental	addedOn
Gate Pass	Incremental	addedOn
Inventory Snapshot	Incremental	UpdatedIn
Vendors	Incremental	updatedOn
Putaway	Incremental	addedOn
Reverse Pickup	Incremental	reversePickupDateRange
Return Invoices	Incremental	addedOn
Invoice	Incremental	dateCreatedRange

Chargebee

PushEngage

Last modified 7mo ago

Features	Details
Release Status	Released
Source API Version
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Username Password
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1hr

Field name	Type
SaleOrderItemCode	STRING
DisplayOrderCode	STRING
ReversePickupCode	STRING
ReversePickupCreatedDate	STRING
ReversePickupReason	STRING
NotificationEmail	STRING
NotificationMobile	STRING
RequireCustomization	STRING
COD	STRING
ShippingAddressId	STRING
Category	STRING
InvoiceCode	STRING
InvoiceCreated	STRING
ShippingAddressName	STRING
ShippingAddressLine1	STRING
ShippingAddressLine2	STRING
ShippingAddressCity	STRING
ShippingAddressState	STRING
ShippingAddressCountry	STRING
ShippingAddressPincode	STRING
ShippingAddressPhone	STRING
BillingAddressId	STRING
BillingAddressName	STRING
BillingAddressLine1	STRING
BillingAddressLine2	STRING
BillingAddressCity	STRING
BillingAddressState	STRING
BillingAddressCountry	STRING
BillingAddressPincode	STRING
BillingAddressPhone	STRING
ShippingMethod	STRING
ItemSKUCode	STRING
ChannelProductId	STRING
ItemTypeName	STRING
ItemTypeColor	STRING
ItemTypeSize	STRING
ItemTypeBrand	STRING
ChannelName	STRING
SKURequireCustomization	STRING
GiftWrap	STRING
GiftMessage	STRING
HSNCode	STRING
MRP	STRING
TotalPrice	STRING
SellingPrice	STRING
CostPrice	STRING
PrepaidAmount	STRING
Subtotal	STRING
Discount	STRING
GSTTaxTypeCo	STRING

Field name	Type
POCode	STRING
Created	STRING
POCreatedBy	STRING
POApprovedDate	STRING
DeliveryDate	STRING
ItemTypeName	STRING
ItemSkuCode	STRING
Category	STRING
HSNCode	STRING
GSTTaxTypeCode	STRING
VendorName	STRING
VendorCode	STRING
VendorSkuCode	STRING
OrderQuantity	STRING
RecievedQuantity	STRING
RejectedQuantity	STRING
PendingQuantity	STRING
_Pending	STRING
_Rejection	STRING
Facility	STRING
SubTotal	STRING
CGST	STRING
IGST	STRING
SGST	STRING
UTGST	STRING
CESS	STRING
CGSTRate	STRING
IGSTRate	STRING
SGSTRate	STRING
UTGSTRate	STRING
CESSRate	STRING
Total	STRING
PurchaseOrderStatus	STRING
RejectionReason	STRING
Updated	STRING
Type	STRING
POAgeing_Days_	STRING
UnitPrice	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch	NUMERIC

Field name	Type
CategoryCode	STRING
ProductCode	STRING
Name	STRING
Description	STRING
ScanIdentifier	STRING
RequiresCustomization	STRING
Length_mm_	STRING
Width_mm_	STRING
Height_mm_	STRING
Weight_gms_	STRING
EAN	STRING
UPC	STRING
ISBN	STRING
Color	STRING
Size	STRING
Brand	STRING
ItemDetailFields	STRING
Tags	STRING
ImageUrl	STRING
ProductPageUrl	STRING
TaxTypeCode	STRING
GSTTaxTypeCode	STRING
BasePrice	STRING
CostPrice	STRING
TAT	STRING
MRP	STRING
Updated	STRING
CategoryName	STRING
Enabled	STRING
Type	STRING
ComponentProductCode	STRING
ComponentQuantity	STRING
ComponentPrice	STRING
HSNCODE	STRING
TaxCalculationType	STRING
BatchGroup	STRING
GRNexpirytolerance_inDays_	STRING
Dispatchexpirytolerance_inDays_	STRING
Returnexpirytolerance_inDays_	STRING
Expirable	STRING
DetermineExpiryFrom	STRING
ShelfLife	STRING
ExpiryDate	STRING
Facility	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Field name	Type
GRNCode	STRING
GRNDate	STRING
GRNCreatedBy	STRING
ItemSkuCode	STRING
ItemTypeName	STRING
ItemTypeColor	STRING
ItemTypeSize	STRING
ItemTypeBrand	STRING
Facility	STRING
Category	STRING
BatchCode	STRING
AdditionalCost	STRING
VendorSkuCode	STRING
VendorName	STRING
VendorCode	STRING
GRNInvoiceNo	STRING
GRNInvoiceDate	STRING
POCode	STRING
PODate	DATETIME
QuantityReceived	STRING
QuantityRejected	STRING
PercentageRejection	STRING
ValuesofGoodsReceivedwithouttaxes	STRING
ValuesofGoodsReceivedwithtaxes	STRING
ValuesofGoodsRejectedwithouttaxes	STRING
ValuesofGoodsRejectedwithtaxes	STRING
RejectionReason	STRING
GrnitemStatus	STRING
Updated	DATETIME
ExpiryDate	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Field name	Type
GatepassCode	STRING
GatepassCreatedBy	STRING
Type	STRING
GatepassStatus	STRING
GatepassCreatedAt	STRING
GatepassUpdatedAt	STRING
Purpose	STRING
Reference	STRING
ToParty	STRING
ItemName	STRING
ItemSkuCode	STRING
Color	STRING
Size	STRING
Brand	STRING
HSNCode	STRING
UnitPrice	STRING
Quantity	STRING
ReceivedQuantity	STRING
InventoryType	STRING
GatepassItemStatus	STRING
Shelf	STRING
Reason	STRING
GatepassItemCreated	STRING
GatepassItemUpdated	STRING
GatepassOrderCode	STRING
Facility	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch	NUMERIC