💻
UNOSOF MANUAL
User Guidelines EN
User Guidelines EN
  • UNOSOF MANUAL
  • TAXONOMY DEFINITIONS
    • Products
      • Species
      • Varieties
      • Non-Real Varieties
    • Bunches
      • Solid Bunches
      • Rainbows
      • Bouquets
    • Boxes
      • Solid Boxes
      • Mixed / Assorted Boxes
      • Bouquet Boxes
      • Consumer Box
    • Product Definitions
      • Farm Products
      • Importer
    • Floricode
      • Floricode Schema
        • f_products
        • f_genus
    • Farm Workflow
    • Cultivation Management
    • Additional sources
  • Accounting
    • Account Transactions
      • Make Deposits
        • Commission Management
      • Retention
      • View Deposits
        • Move Unapplied Deposit Values
    • Accounting Administration
      • Company Info
      • Account info
      • Inventory Info
      • Holland Info
      • Sales Info
      • Consumer Invoices
      • Statements
      • Truck Invoices
      • Bouqueteria
      • Remote
      • Provides IDs
      • Bruto Variables
      • Sales Definitions
      • Flor de Baja
      • Alianza API
      • Projections
    • SRI Electronic Transfer
      • Invoices / Guia / Credits / Debits
        • SRI Generate/Sign/Send
        • Pre-Authorization Modifications
        • AWB Weights
        • Zip SRI Invoices
        • Email SRI Invoices
        • Invoices Used Outside UNOSOF
        • Unused (Skipped) Invoices
        • SRI Report (Check Post vs. Generated)
      • SRI Cases
      • SRI Status Comprobation
      • SRI Documents Annulment
      • SRI Blocking Messages
    • Workforce Managment
      • Manage Employees
      • Manage Departments
      • Daily Timecard
    • Accounts Management
      • Chart of Accounts
      • Manage Accounts
  • Customers
    • Customer Info
      • Customer Account Overview
        • Statement PDF Formats
        • Set Default Statements Message
      • Manage Customers
        • View Customers
        • Create a customer
          • Customer Form // Customer Info Tab
          • Customer Form // Contact Info Tab
          • Customer Form //Addresses
          • Customer Form // Accounting Tab
          • Customer Form Invoicing
          • Coface
          • Api Providers
          • Refresh Billing Customer Table and Customer Credit
        • Manage Customer Tips
      • Manage Markets
    • Customer Service
      • Email Multiple Invoices
      • Search Invoices
      • Rollback Customer Invoice
      • Send Statements
      • Manage Invoice Footers
      • Customer Credits
    • Fair Trade Management
      • Reporting
      • Invoice Format
      • Recommendations
  • Sales
    • Search Purchase Orders
      • Mass Change PO Date
      • PO's Color Codes
      • Minimum Pricing Check
      • Create PO Page Group
      • Priority Packing // Box Confirmation
      • Mass Swap Module
    • Purchase Order
      • Sales Practical Tips
      • Create a Purchase Order (V-next
        • Edit Boxes
      • Create a Purchase Order
        • Edit Boxes
        • Move boxes
        • Delete Purchase Orders
        • Box Labels
    • Invoice Purchase Order
      • Invoice Cases
    • Availability Builder
      • Create New Dispo
      • Modify pricing and box #
      • View Dispo
      • Send or Post Dispo
    • Standing Orders
      • Create Standing Orders
      • Modify Standing Orders
    • Supermarket Order Generation
    • Returned Boxes
    • Customer Mass Invoice
    • Mass Rollback Orders
    • Transfer PO
    • MIAMI
      • Delete boxes in MIAMI application
  • Pricing
    • Upload Customer Pricing
    • Upload Minimum Pricing
    • Incoterm Pricing
  • Exportations
    • LAG Integrations
    • Airway Bills
      • Commercial and Customer Invoice Mass Print Options
        • Exportation documents for Colombia
        • Exportation Documents Ethipia
    • O.E / DAE
    • Incoterms
      • Incoterm Freight By Box
    • Drivers
    • Manage Boxes
    • Cargo Agencies
    • Truck Companies
    • Truck Invoice
  • Dashboards
    • Sales Dashboard
  • Post Harvest
    • Station 1: Harvest Receiving
      • View Post Harvest Receiving
      • Field Plan Cutter Management
    • Station 2: Inventory Packing
      • View Inventory Packing List
      • Consumer Bunches
        • Generate Consumer Bunches
        • View Consumer Bunches
        • Assign Consumer Bunches
    • Station 3: Inventory Shipping
      • Scan Bunches into a Box
      • Auto-Pack Function
      • Unpack Boxes
      • Mass Print Box Labels
      • Bouquet Station 3
    • Station 4: Weight & Boxtype
    • Station 5: Truck Invoice
      • Return Box Module
    • Defections: Flor National
  • Inventory
    • Inventory Variables
    • View Inventory
      • Reading the Inventory
    • Future Availability
      • Projections
      • Future Availability Management Settings
      • Future Availability Sheets
      • Future Availability Reports
    • Inventory Management
      • Inventory Shoot
      • Inventory Prefrío Shoot
    • Inventory Packaging Boxes Scan
    • Manage Transfers Bunches
    • Manage Transfers Mallas
    • Mixed Box Management
      • Mix Box Management // create mix box
      • Mix Box Management // Recipe Management
      • Mix Box Management // S3 - Mix Box packing
      • Mix Box Management // Fix Problems
    • Exit Inventory
      • View Inventory Exits
    • Reprocess Inventory
      • Flor de Baja management
      • Manage Reprocess Inventory
      • S2 Process Downgraded Inventory
      • Report Reprocessing Inventory
    • Inventory Priority
      • Inventory Priority List
      • Priority Management
    • Post Harvest Practical Tips:
    • Box Inventory
    • Inventory Hotroom
      • Manage Hotroom
      • Hotroom Entrance
      • Hotroom Exit
  • Remote Inventory Management
  • Purchases
    • Purchases
  • Production
    • Production Management
      • Manage Products
        • Create SKU's GYP
        • Manage Product Api Mappings
    • Production Data
      • Double Life Cycle Bunches
      • Product Inventory Life
      • Daily Input Page
  • Bouquetteria
    • Bouquet Product Management
  • Reports
    • Reports
    • Production reports
    • Warehouse Reports
    • Accounting Reports
      • Customer Behaviour
      • Last Payment / Balance
      • Customer Account Review (Method)
      • Compare Reports for Multi-App Companies
        • Accounting Cases / Compare Reports for Deposits
        • Accounting cases / Compare Invoices
  • SITE MANAGER
    • Manage Locations
      • Create a New Warehouse
      • Maintain the Field Plan
      • Mass Edit Beds with Excel
    • Users
    • Users Permissions
    • Select Options
  • System Administration
    • Properties
    • Synch data
  • Vendors
    • Vendors
    • Manage Vendors
    • Requisition of Material
      • Search Purchase Requests
    • Vendor Purchase Orders
      • Search Vendor Orders
    • Order Receiving
      • View Order Receiving
    • Consignment
      • Consignment Cases
  • Alianza Logistik
    • Alianza Logistika API
    • Alianza Box Label Configuration
  • Integrations (API)
    • FreshPortal
    • Migros
    • UNOSOF API's
    • Accounting Migration Files
      • Venture
    • Cut Flower Trader (CFT)
      • Inventory Posting
      • Order Creation
    • Delaware Valley
    • Komet Sales
      • Integration Requirements
      • Load Orders from Komet to Unosof
      • Upload Stand Alone Orders | Open Market Box Inventory
      • Sunburst Farms Integration
      • Upload Bunch Inventory to Komet
    • FTD
    • Blumen Gali
    • Shopify
  • Hardware & Network & Infrastructure
    • How to Setup - PRINTER
    • How to Setup - Scale
    • Hardware Requirements
    • Network & Infrastructure Requirements
    • Tips, Optimize Network & Infrastructure.
Powered by GitBook
On this page
  • Generate Komet Sales Token and grant access to the APIs
  • Data Mapping
  • 1. View Komet Data
  • 2. Mapping Process

Was this helpful?

  1. Integrations (API)
  2. Komet Sales

Integration Requirements

On this page, the general Unosof and Komet Sales Integration requirements are explained.

PreviousKomet SalesNextLoad Orders from Komet to Unosof

Last updated 1 year ago

Was this helpful?

Generate Komet Sales Token and grant access to the APIs

Ask Komet Sales support to and grant access to the required APIs for the integration you wish to establish between both systems.

An API token is a unique identifier or key to authenticate a user or application to authorize access to an API. This is mainly used to protect data and resources.

Ask Unosof about the list of APIs that must be added to the token permissions.

Example: purchase.order.list

The list of APIs is listed on the

Data Mapping

To build any API integration, you must map appropriately the standard data fields that each endpoint requires so that we create seamless cooperation between the Unosof and Komet Sales apps.

Depending on the API method, mapping one or more data fields can be necessary (Species, varieties, SKUs, Billing Customers, Shipping Customers, Cargo Agencies, Carriers, Box Types, Order Types, Incoterms, etc.)

1. View Komet Data

Using some of the APIs described in the Komet Knowledge Base, Unosof can access the Komet Sales tables, store that data, and map some variables in the Unosof tables.

When clicking the dropdown menu, find the View Komet data section on the Komet Bridge Menu.

Here, you can visualize different data sets, such as Products, Carriers, Boxes, etc.

If you click on the Komet Boxes option (as an example), click on the Seach Button.

The page will display all box types created in Komet Sales, a description, and the Komet Sales ID.

2. Mapping Process

The KS IDs should be mapped on the Unosof tables. Each Komet system has a unique database, so you must do the mapping process for every KS and Unosof app.

a. Products

  1. The product codes from Komet should be mapped on the Unosof Manage Products / API Mappings Menu form, KS ID column.

To access this module, go to:

The page will display all SKUs. Find the column Komet ID and add the corresponding ID to the SKU.

Save your edits by clicking the button Save on the right side of each line.

Notice: The example above shows that the same ID is mapped on different Unosof SKUs. This can happen because Komet Sales generally manages SKUs by variety and length. I.e., ROSE AKITO 4OCM. Other variables, such as the number of stems per bunch and package type, are independent attributes and come as an additional field in the JSON file for the integrations.

  1. It is also possible to map every SKU entering the Manage Product form

To access this module, go to:

Production / Product Management / Manage Products

Please search for the SKU and enter its Product form by clicking on the SKU name.

Click the Mapping tab to find the SKU form's ID Komet field. Please insert the ID and click on the Save Button in the upper right corner of the page.

  1. Automated mapping is available as well. Unosof has a script to match both systems' product tables. For this, it is mandatory that in Komet Sales, the Komet Product ID is mapped on the Legacy Code field.

This method has the following limitations:

  • It can be done massively at the beginning of the integration.

  • 100% mapping is not assured.

b. Mixed Boxes

In some of our integrations, it is possible to post solid and mixed boxes. However, it is necessary to use the mixed box module for assorted boxes (different varieties or the same variety with different lengths).

To create mixed boxes, please follow the described steps in the following link. Mix Box Management // create mix box

Once the box is created, you can map out the mixed box IDs from Komet with those created boxes in UNOSOF. Insert the KS product ID in the option Product Code.

Choose the Stock Client by selecting the corresponding billing and shipping client.

c. Customers

The Billing and Shipping Customers from Komet Sales should be mapped in the Unosof Manage Customer Form.

To access this module, go to:

Customers / Customer Info / Manage Customers.

Find the customer in UNOSOF, and click on the name to open the Customer Form.

Inside the client form, click on the tab API/Providers.

Depending on the type of integration, we should map Komet Group, API Provider, and Provider Token.

If integrating in Order Creation, please fill in the KS ID in the Komet Group field.

If you are integrating with a Customer Komet System like Mayesh, Kennicot, Fresca, etc, fill the API Provider, Provider Token, Komet Location ID, and Komet Group fields

Click on the dropdown menu of the API Provider field and select Komet Sales (USA).

Fill in the Provider Token:

Fill in the Komet Location ID:

Fill in the Komet Group

d. Boxes

The KS ID should mapped on the Unosof Manage Boxes form, External Box ID field.

To access this module, go to:

e. KS Location - Incoterms

The locations from Komet Sales can be related to the Incoterm table in Unosof. These data should be mapped in the Unosof Incoterm Form.

To access this module, go to:

Customers / Exportation / Manage Incoterms

Find the Incoterm in UNOSOF, and click on the name to open the Incoterm Form.

Fill in the Komet Location ID on the Incoterm Code field and save changes.

Production / Product Management / Manage Products Menu: API Mappings

Customers / Exportations / Manage Boxes

https://farm.unosof.com/index.cfm?event=Products2.List
https://farm.unosof.com/index.cfm?event=Products2.List
https://farm.unosof.com/index.cfm?event=Customers.List
https://farm.unosof.com/index.cfm?event=Box.List#
https://farm.unosof.com/index.cfm?event=Incoterms.List#
generate a token
Komet Knowledge Base.
Komet Bridge - View KS data sectopm
Komet Bridge - View Komet Boxes
Manage Products API Mappings - ID Komet
Click in the SKU name to enter the Product form.
Product Form - Mapping Tab
Mixed Box Module
Enter the client form
Manage Products form - API/Providers tab
Manage Products form - API Provider
Manage Products form - Insert Provider Token
Manage Products form - Komet Location ID
Manage Products form - Komet Group
Manage Boxes Form - External Id
Manage Incoterm Form