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

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

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

3. Item Master

4. Vendor Item Master

5. GRN

6. Gate Pass

7. Inventory Snapshot

Last updated