💻
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
  • Map Data
  • Sunburst Order Integration
  • Posting Issues: how to fix?
  • Box Information for the Unified S3 Label
  • AWB Posting

Was this helpful?

  1. Integrations (API)
  2. Komet Sales

Sunburst Farms Integration

Here, we explain a Buyer Integration between Sunburst Farms / Komet and Unosof.

PreviousUpload Stand Alone Orders | Open Market Box InventoryNextUpload Bunch Inventory to Komet

Last updated 1 year ago

Was this helpful?

Unosof has integrated with the customer Sunburst Farms via Komet Sales in 3 levels:

  • Purchase Order Integration (Komet --> Unosof)

  • Box Information for the unified dispatch label (S3)

  • AWB Posting (Unosof -->Komet)

Generate Komet Sales Token and grant access to the APIs

Token with the following API permissions is required:

carrier.list boxtype.list vendor.list customer.list product.list purchaseorder.order.list purchase.order.item.awb.add

Map Data

It's necessary to map species, varieties, SKUs, Mixed boxes, Sunburst Billing Customers, Sunburst Shipping Customer, Cargo Agencies, Carriers, Box Types, Order Types, Incoterms, etc.

Using some of the APIs described above, Unosof can access the Komets Sales tables, store that data, and automatically map some variables in the Unosof tables.

Sunburst Order Integration

Unosof calls the API that Komet has provided to get all orders input in their system and create them in Unosof with a Synch functionality.

Unosof calls the API and filters Sunburst Orders for the farms with the following technical criteria:

  • Vendor Name: Example FLORA CONCEPT

  • “Status: Confirmed

  • Define in which box type the Order Creation should be done.

To access this module, go to:

Reports / Accounting Reports

https://farm.unosof.com/index.cfm?event=Accounting.Report

Select the "Komet Orders (Sunburst)" option in the dropdown menu.

Select a date on the "Start Date" filter and hit "Generate Report" (Green Button). It's not possible to select more than one day range.

This search will show you all orders created in Komet on that specific date.

In this table, you will find all the information Komet Sales sends to Unosof via the API (JSON File).

To synch and create the order in Unosof, click on the "S" Button under the Synch Column and click again on the "Generate Report" button to refresh the page.

The order gets created in Unosof.

The table gives a general overview of the PO created (Date, PO ID, # Boxes, # Mapped Boxes, and amount in $).

Important: The box content should be mapped to synch an order from Komet to Unosof. We consider a box to be mapped when it relates one or more products from Komet to SKUs in Unosof. We use a box code or reference for every box recipe.

We create the order and set the customers according to the Info we receive via the API. To see this info, click on the JSON button on the Sunburst report:

LocationName: Sunburst Farms Warehouse #1 --> Sunburst Farm Inc as Billing and Shipping Customer.

Posting Issues: how to fix?

Please check the box mapping if a PO cannot be created in UNOSOF.

Box Information for the Unified S3 Label

Once Unosof receives the Purchase Orden information from Komet Sales, it's also necessary to get the Box information to generate the Unified S3 label with all the info.

For this, Komet should change the status from C to S in the orders on their system so we can get the Box information via the API.

The user should generally do the process in Station 3 to print the box stickers.

This sticker is only enabled for the Sunburst Purchase Orders.

AWB Posting

When boxes are dispatched, Komet Sales requires that Unosof posts the AWBs to their system.

For Excellence and Wayuu, the E-Flower /Fdim System does the coordination.

Unosof needs to receive the AWBs from Fdim via movements.

To pass the AWBs from Unosof to Komet, Fdim must confirm which AWB is the final one via each box's "Cierre de Guia" movement. Without receiving this movement, Unosof doesn't send AWB info to Komet.

To check the movements, please go to the "Log" Page in every Purchase Order, to the "Resume Log" tab.

The AWB post is automated for every 10 minutes. So, once we receive the "Cierre de Guia" Movement, it posts directly to Komet Sales without any manual process.

It is possible to post the AWBs manually if needed. For this, please go to the Accounting Sunburst report.

On the table, find the order you wish to post the AWBs and hit the blue button "Post AWB."

This will open a new window where it's possible to verify the status of the AWB posting.

Revise

See .

Integration Requirements: Data Mapping
Data Mapping: Mixed boxes
Download order - Vendor
Find the Komet Orders (Sunburst) option and hit the "Generate Report" button.
The order created on Komet Sales on that specific date.
Order gets created in Unosof
JSON Button
LocationName field
Resume Log Tab, details the movements received for every box
Click on the "Post AWB" button to fire the process manually
Hitting the "Post AWB" Button will open a window where you can verify the status of the AWB Posting.