Cirro Fulfillments

Need help with something?

Talk to data expert

Cirro Fulfillments

Cirro Fulfillments (Cirro) is a cross-border 3PL (third-party logistics) and warehouse management platform used by e-commerce sellers to manage inbound receiving, inventory, order fulfillment, and shipping across their warehouse network. It also supports pre-pack and FBA prep workflows for sellers shipping into marketplace fulfillment centers. The Daton connector for Cirro Fulfillment replicates your order and fulfillment data, product and inventory records, and warehouse and shipping configuration into your data warehouse.

Prerequisites

  • An active Cirro Fulfillment account with API access enabled.
  • An App Key and App Token generated for API access.
  • A destination warehouse already connected in Daton.

How to Obtain Your Credentials

  1. Log in to your CIRRO Fulfillment account at oms.elogistic.com.
  2. Go to the Integrations (or Apps, Integrations & API) section of the app.
  3. Generate a new App Key and App Token, labeling them so they're easy to identify later (for example, "Saras Analytics"). The App Key functions as a client ID and the App Token as a client secret.
  4. Copy both values. You'll enter them in Daton during setup.
CIRRO Fulfillment was formerly branded eLogistic, which is why its app still runs on the elogistic.com domain. The exact menu path above is based on CIRRO's public support-center category structure ("Apps, Integrations & API") and third-party integration guides referencing this app key/app token pair — it's behind login, so confirm the precise screen with your CIRRO account manager if it doesn't match.

Steps to Integrate

  1. Integration Name: Enter a name to identify this integration.
  2. Description (optional): Enter a description to help identify the integration. You can change this at any time.
  3. Replication Frequency: Choose how often Daton should sync data. Options are 1h, 2h, 3h, 6h, 8h, 12h, and 24h.
  4. Replication Start Date: Select how far back you want Daton to pull historical data.
  5. Advanced Configuration Options:
    • Loading Mode: Choose Append to add new rows to the destination table, or Upsert to insert new rows and update existing ones based on primary key.
    • Loading Nested Objects: Choose how nested objects are flattened in the destination — Inherit from Warehouse Settings, Do not unnest, Upto one level, or Upto two levels.
  6. Authenticate: Enter your Cirro App Key and App Token.
  7. Select Tables: Choose the tables you want Daton to replicate.
  8. Configure Schema/Columns: Choose the columns to include in the destination schema for each selected table.
  9. Submit: Complete the setup to start replication.

Supported Tables

Table
Full Load Supported
Description

 

 
orders
No
Outbound customer orders, including line items, fees, shipping, and consignee details.
draft_orders
No
Draft/unconfirmed customer orders prior to release, with the same order attributes as orders.
pre_pack_orders
No
Pre-pack/FBA marketplace shipment plans, including product and box breakdowns.
products
No
Product/SKU catalog data, including dimensions, weights, and packaging attributes.
inbounds
Yes
Inbound shipments and receiving records at the warehouse.
inventory
Yes
On-hand inventory levels by SKU and warehouse, including sellable, unsellable, reserved, and shipped quantities.
shipping_methods
Yes
Shipping methods available per warehouse, with service and insurance attributes.
warehouses
Yes
Warehouse master data, including location and address details.
shipping_fees
Yes
Per-shipment shipping fee and cost detail by warehouse and shipping method.

Table Schemas

orders

Column Type Description
items RECORD (nested object)
Line items included in the order (SKU, quantity, product details).
fee_details RECORD (nested object)
Fee line items associated with the order (name, amount, currency, billing date).
date_palletization STRING
Date the order was palletized.
date_collection STRING
Date the order was collected for shipment.
date_eta STRING
Estimated time of arrival date.
date_ata STRING
Actual time of arrival date.
rfq_id STRING
Request-for-quote identifier associated with the order.
value_added_service RECORD (nested object)
Value-added services requested for the order.
po_number STRING
Purchase order number.
platform_order_id STRING
Order ID from the originating sales platform.
order_code STRING (Primary Key)
Unique Cirro order identifier.
reference_no STRING
Customer or external reference number for the order.
order_type NUMERIC
Order type code.
platform STRING
Sales platform the order originated from.
order_status NUMERIC
Current status code of the order.
abnormal_problem_reason STRING
Reason code for an abnormal/exception order.
shipping_method STRING
Shipping method selected for the order.
carrier_name STRING
Name of the shipping carrier.
tracking_no STRING
Shipment tracking number.
is_fba STRING
Indicates whether the order is an FBA (Fulfillment by Amazon) order.
warehouse_code STRING
Code of the warehouse fulfilling the order.
wp_code_list RECORD (nested object)
List of warehouse/pickup point codes associated with the order.
order_weight NUMERIC
Total weight of the order.
volume_length NUMERIC Package length.
volume_width NUMERIC Package width.
volume_height NUMERIC Package height.
order_desc STRING
Description of the order.
date_create TIMESTAMP
Date and time the order was created.
date_release TIMESTAMP
Date and time the order was released for fulfillment.
date_shipping STRING
Date the order shipped.
date_modify TIMESTAMP
Date and time the order was last modified.
consignee_info RECORD (nested object)
Consignee (recipient) name and address details.
vat_change_info RECORD (nested object)
VAT/tax change details for the order.
assign_priority NUMERIC
Priority level assigned to the order.
customer_package_type STRING
Customer-specified packaging type.
customer_package_requirement NUMERIC
Customer-specified packaging requirement code.
palletization STRING
Palletization setting for the order.
packing_type NUMERIC
Packing type code.
is_truck_service NUMERIC
Indicates whether truck delivery service is used.
distributor_type NUMERIC
Distributor type code.
product_quanlity NUMERIC
Total product quantity on the order (field name as provided by the Cirro API).
platform_number STRING
Platform-specific order number.

draft_orders

Column Type Description
order_code STRING (Primary Key)
Unique Cirro order identifier.
reference_no STRING
Customer or external reference number for the order.
order_type NUMERIC
Order type code.
platform STRING
Sales platform the order originated from.
order_status NUMERIC
Current status code of the order.
abnormal_problem_reason STRING
Reason code for an abnormal/exception order.
shipping_method STRING
Shipping method selected for the order.
carrier_name STRING
Name of the shipping carrier.
tracking_no STRING
Shipment tracking number.
is_fba STRING
Indicates whether the order is an FBA (Fulfillment by Amazon) order.
warehouse_code STRING
Code of the warehouse fulfilling the order.
order_weight NUMERIC
Total weight of the order.
volume_length NUMERIC Package length.
volume_width NUMERIC Package width.
volume_height NUMERIC Package height.
order_desc STRING
Description of the order.
date_create TIMESTAMP
Date and time the draft order was created.
date_release STRING
Date the draft order was released.
date_shipping STRING
Date the order shipped.
date_modify TIMESTAMP
Date and time the draft order was last modified.
consignee_info RECORD (nested object)
Consignee (recipient) name and address details.
vat_change_info RECORD (nested object)
VAT/tax change details for the order.
palletization STRING
Palletization setting for the order.
packing_type NUMERIC
Packing type code.
is_truck_service NUMERIC
Indicates whether truck delivery service is used.
distributor_type NUMERIC
Distributor type code.
value_added_service RECORD (nested object)
Value-added services requested for the order.
product_quanlity NUMERIC
Total product quantity on the order (field name as provided by the Cirro API).
estimated_pickup_time STRING
Estimated pickup time for the draft order.
platform_number STRING
Platform-specific order number.
platform_order_id STRING
Order ID from the originating sales platform.
customer_package_type STRING
Customer-specified packaging type.
customer_package_requirement NUMERIC
Customer-specified packaging requirement code.

pre_pack_orders

Column Type Description
plan_type NUMERIC
Pre-pack plan type code.
plan_order_code STRING (Primary Key)
Unique pre-pack order/plan identifier.
reference_no STRING
External reference number.
warehouse_code STRING
Warehouse code fulfilling the pre-pack order.
wp_code_list STRING
Warehouse/pickup point codes for the pre-pack order.
is_change_label NUMERIC
Indicates whether the label was changed.
is_stick_label NUMERIC
Indicates whether a stick-on label is used.
is_gpsr_service NUMERIC
Indicates whether GPSR compliance service is applied.
label_replacement_option NUMERIC
Label replacement option code.
actual_fee_estimate STRING
Estimated fee for the pre-pack order.
currency_code STRING
Currency of the fee estimate.
order_status NUMERIC
Current status code of the pre-pack order.
abnormal_reason STRING
Reason code for an abnormal/exception pre-pack order.
create_time TIMESTAMP
Date and time the pre-pack order was created.
update_time TIMESTAMP
Date and time the pre-pack order was last updated.
submit_time TIMESTAMP
Date and time the pre-pack order was submitted.
finish_time STRING
Date and time the pre-pack order was completed.
product_list RECORD (nested object)
Products included in the pre-pack plan.
box_list RECORD (nested object)
Box/carton breakdown for the pre-pack plan.
buyer_id STRING
Identifier of the buyer/marketplace account associated with the plan.

products

Column Type Description
product_weight NUMERIC Product weight.
product_length NUMERIC Product length.
product_width NUMERIC Product width.
product_height NUMERIC Product height.
receive_weight NUMERIC
Weight recorded at receiving.
receive_length NUMERIC
Length recorded at receiving.
receive_width NUMERIC
Width recorded at receiving.
receive_height NUMERIC
Height recorded at receiving.
product_sku STRING (Primary Key)
Unique product SKU.
sku_type NUMERIC SKU type code.
product_barcode STRING
Product barcode.
product_name_en STRING
Product name (English).
product_declared_name_en STRING
Declared product name for customs (English).
product_status STRING Product status.
goods_attribute NUMERIC
Goods attribute/category code.
product_package_type NUMERIC
Packaging type code.
reference_no STRING
External reference number.
is_brand NUMERIC
Indicates whether the product is branded.
product_brand STRING Brand name.
product_model STRING Product model.
product_url STRING
URL to the product listing.
unit STRING Unit of measure.
copyright_patent STRING
Copyright or patent information.
import_countries STRING
Countries the product can be imported into.
product_picture_url_list STRING
Product image URLs.
return_auth NUMERIC
Return authorization code/flag.
rebrand_barcode STRING
Rebranded barcode value.
is_collect_serial_number NUMERIC
Indicates whether serial numbers are collected for the product.
is_inbound_collect_serial_number NUMERIC
Indicates whether serial numbers are collected on inbound.
is_return_collect_serial_number NUMERIC
Indicates whether serial numbers are collected on return.
is_serial_number_rule_set NUMERIC
Indicates whether a serial number rule is configured.
serial_number_control NUMERIC
Serial number control setting.
sku_wrapper_type NUMERIC
SKU wrapper/packaging type code.
map_barcode_list STRING
Mapped/alternate barcode list.
predict_pcs_inner NUMERIC
Predicted pieces per inner pack.
receive_pcs_inner NUMERIC
Received pieces per inner pack.
spread_length NUMERIC
Spread (unfolded) length.
spread_width NUMERIC
Spread (unfolded) width.
spread_height NUMERIC
Spread (unfolded) height.
spread_receive_length NUMERIC
Spread length recorded at receiving.
spread_receive_width NUMERIC
Spread width recorded at receiving.
spread_receive_height NUMERIC
Spread height recorded at receiving.

inbounds

Column Type Description
receiving_code STRING (Primary Key)
Unique inbound/receiving shipment identifier.
reference_no STRING
External reference number.
transit_type STRING
Transit/shipment type.
receiving_status NUMERIC
Current status code of the inbound shipment.
receiving_shipping_type NUMERIC
Shipping type code for the inbound shipment.
create_at TIMESTAMP
Date and time the inbound shipment was created.
update_at TIMESTAMP
Date and time the inbound shipment was last updated.
tracking_number STRING
Inbound shipment tracking number.
box_total_count NUMERIC
Total number of boxes in the shipment.
sku_total_count NUMERIC
Total number of distinct SKUs in the shipment.
warehouse_code STRING
Destination warehouse code.
is_intercept_return NUMERIC
Indicates whether the shipment was intercepted/returned.

inventory

Column Type Description
product_sku STRING (Primary Key)
Unique product SKU.
sku_type STRING SKU type.
warehouse_code STRING (Primary Key)
Warehouse code the inventory record belongs to.
onway NUMERIC
Quantity on the way to the warehouse.
pending NUMERIC
Quantity pending processing.
sellable NUMERIC
Sellable quantity on hand.
unsellable NUMERIC
Unsellable quantity on hand.
reserved NUMERIC
Quantity reserved for orders.
shipped NUMERIC
Quantity already shipped.
product_barcode STRING
Product barcode.
warehouse_en STRING
Warehouse name (English).
unsellable_reserved NUMERIC
Unsellable quantity reserved.
unsellable_shipped NUMERIC
Unsellable quantity shipped.

shipping_methods

Column Type Description
warehouse_code STRING (Primary Key)
Warehouse code the shipping method applies to.
warehouse_name STRING
Warehouse name.
sm_code STRING (Primary Key)
Shipping method code.
sm_name STRING
Shipping method name.
type NUMERIC
Shipping method type code.
is_signature NUMERIC
Indicates whether signature is required on delivery.
sp_code STRING
Shipping provider code.
order_business_type NUMERIC
Order business type code the method applies to.
is_palletization NUMERIC
Indicates whether palletization is supported.
is_supports_locker_delivery NUMERIC
Indicates whether locker delivery is supported.
is_insurance NUMERIC
Indicates whether shipping insurance is offered.
gc_insurance_range RECORD (nested object)
Insurance coverage range details.

warehouses

Column Type Description
warehouse_code STRING
Warehouse code.
warehouse_name STRING
Warehouse name.
country_code STRING
Country the warehouse is located in.
wp_code STRING (Primary Key)
Unique warehouse/pickup point code.
address RECORD (nested object)
Warehouse address details.

shipping_fees

Column Type Description
wp_code STRING (Primary Key)
Warehouse/pickup point code.
  
sm_code STRING (Primary Key)
Shipping method code.
  
sm_code_text STRING
Shipping method name/label.
  
total_amount STRING
Total shipping fee amount.
  
currency_code STRING
Currency of the fee.
  
aging STRING
Estimated delivery aging (minimum).
  
aging_end STRING
Estimated delivery aging (maximum).
  
is_fast BOOLEAN
Indicates whether this is a fast shipping option.
  
is_thrifty BOOLEAN
Indicates whether this is an economy/thrifty shipping option.
  
fee_detail RECORD (nested object)
Breakdown of individual fee components.
  
message STRING
Additional message related to the fee quote.
  
is_support_tracking NUMERIC
Indicates whether tracking is supported.
  
volume_coefficient NUMERIC
Volumetric weight coefficient used for fee calculation.
  
distributor NUMERIC Distributor code.
order_business_type NUMERIC
Order business type code the fee applies to.
  
is_ooh_sm NUMERIC
Indicates whether this is an out-of-home (locker/pickup point) shipping method.
  

 

cloud services order management

Related Articles

Table of Contents

Prerequisites How to Obtain Your Credentials Steps to Integrate Supported Tables Table Schemas orders draft_orders pre_pack_orders products inbounds inventory shipping_methods warehouses shipping_fees