💻
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
  • Managing Price Sheets per Customer
  • Create New Customer Price Sheet
  • Editing an Existing Customer Price Sheet
  • Master Server Synch Pricing

Was this helpful?

  1. Pricing

Upload Customer Pricing

Here we explain how to manage pricing for your customers. Our pricing module has several functionalities such as creating pricing sheets per customer, minimum pricing check and negotiation rates.

PreviousDelete boxes in MIAMI applicationNextUpload Minimum Pricing

Last updated 2 years ago

Was this helpful?

Managing Price Sheets per Customer

Every price-sheet can be linked to a purchase order, availability sheet (dispo's) and the webshop.

This is the primary page for creating, editing and viewing the customer pricing sheets:

Home / Customers / Pricing / Customer Pricing Management

It is possible to assign more than one price sheet for the same customer and it also possible to assign a price sheet to several customers.

Create New Customer Price Sheet

To create a new customer price sheet, download the Excel file by clicking the CSV(,) or the CSV(;) button in the upper left corner of the page.

The file format depends on the configuration of your Excel sheet.

Open the downloaded excel file and input the desired prices for every variety and length, in the Stem Price column, as shown on the image below, and save your file in your PC.

Do not delete any columns or rows, nor edit names or lengths from the excel file.

The items that require a price, come from the field Commercial Name in Manage products. Its possible to cluster many SKU's into one line item to price, learn more at Manage Products.

Return to the Unosof Customer Pricing Management module and open your saved file, by clicking on the Choose file button in the upper right corner.

Upload the file to the system by clicking on the Upload file button in the upper left corner of the screen.

This will bring up a format to add the price sheet details:

  • Market: Select for whom is this price sheet is activated. You can select all customers from a market or markets.

  • Customer: Apply this price sheet to a customer, or a group of customers.

  • Price Sheet Name: Name your price sheet as desired (Valentines, Summer 2020, OM prices, etc)

  • Price Range Min: Negotiation range from the price input. Price - Negotiation range min= Minimum acceptable price to sell a variety. Prices below this calculation cannot be invoiced)

  • Price Range Max: Negotiation range from the price input. Price + Negotiation range max=Maximum price acceptable to sell a variety. Prices above this calculation cannot be invoiced.

After setting the Pricing Sheet details, save it to the system by clicking the Process File button in the upper right side of the page.

Editing an Existing Customer Price Sheet

To edit an existing customer price sheet:

  • Pricing Sheet Name: To change the name of an existing sheet

  • Status: To activate or in-activate a price sheet.

  • Default: To choose between yes or no. If you choose yes, this price sheet will default when creating a new purchase order.

  • Price Range Min: To edit negotiation range from the price input. (Price - Negotiation range min)

  • Price Range Max: To edit negotiation range from the price input. (Price + Negotiation range min)

  • CSV(,) or CSV (;): To download the pricing sheet to an excel file.

  • Edit: Opens a window, which allows you to edit prices of a specific variety/length without the need to upload the whole sheet again.

  • Copy: To copy the prices into a price sheet. Here you copy this pricing to customers in a market or markets; or to a customer or group of customers, as well as edit the Pricing Sheet Name.

  • Delete: To delete an existing pricing sheet. However, if the price sheet its assigned to more than one PO, we do not allow the deletion of the Price Sheet. You can change the Status of it from Active to In-Active as described above

Master Server Synch Pricing

In case you have a master server structure, its necesary to synch the pricesheet down to the farms via the synch module, to be found here:

PO page // Pricing will only show up on the PO page, if the pricesheet is synched down to the farms.

Manage Products
https://farm.unosof.com/index.cfm?event=Product.Pricing.Customer.Upload
Customer Pricing Management
Download buttons
Customer Pricing Sheet
Choose File Button
Find your file in your PC
Upload File Button
Price Sheet details
Edit Button Customer Pricing Sheet
Copy Button Customer Price Sheet
Synch Data > Synch Pricesheets