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
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
2. Purchase Orders
Purpose: Get the list of the Purchase Orders residing in the system
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
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
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
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
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
Last modified 24d ago