Unicommerce
Unicommerce ETL connector for data replication
Prerequisites
The following details are required to create the Unicommerce integration in Daton.
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
Sign in to Daton
Select Unicommerce from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide Unicommerce facility codes, shop name, Username and Password.
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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
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 |
Last updated