Links

Unicommerce

Unicommerce ETL connector for data replication

Prerequisites

The following details are required to create the Unicommerce integration in Daton.
  1. 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. 1.
    Sign in to Daton
  2. 2.
    Select Unicommerce from Integrations page
  3. 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. 4.
    Provide Unicommerce facility codes, shop name, Username and Password.
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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. 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

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
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
Last modified 7mo ago