Unicommerce
Unicommerce ETL connector for data replication
Please be informed that the content on this page is currently being reviewed and updated. Our goal is to offer you the most current and accurate information possible.
You may see sections temporarily marked as "Under Review" or witness minor shifts in the content presentation. We thank you for your patience during this update phase.
If you have urgent questions or concerns about this page's content, please don't hesitate to contact our support team at [email protected].
Thank you for your continued trust in Daton.
Best regards,
Team Documentation of Saras Analytics
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.
- 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
- 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
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 |
- 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 |
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 |
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 |
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 |
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 |
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 |
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 |
Last modified 1mo ago