Unicommerce

Unicommerce ETL connector for data replication

Note: Content Update In Progress

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 support@sarasanalytics.com.

Thank you for your continued trust in Daton.

Best regards,

Team Documentation of Saras Analytics

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

TablesReplication typeReplication 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

Last updated