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