Товарный и финансовый учет на маркетплейс. Заказы, оптимизация по регионам.Озон, Мегамаркет, ЯMarket, Wildberries, AliExpress, Avito, Яндекс FBY, LeroyMerlin. Цены и скидки, этикетки и маркировка. Учет комиссии и начислений.

Variables for Field Filling


  • In the Order Processing Scenario settings - instead of fixed values for custom fields
    • use variables to retrieve information from each marketplace order

! Use formatting symbols and variable delimiters - curly braces: {{variable_name}}

  • Enter the variable value in double curly braces in the custom field parameter, for example
    • {{order.posting_number}}

General Variable Values:

  • order.posting_number - shipment number
  • order.order_id - order ID
  • order.labelprintlink - shipping label (Ozon, WB, Yandex)

When processing commissions and accruals, by default

  • information about the accrual amount - is passed to the Shipment document expenses section or calculated in the product price
  • order.sumDetail.payout - total order product cost minus the market commission
  • order.sumDetail.price - total order product cost without the market commission
  • order.sumDetail.commission_amount - total commission amount for the order
  • order.sumDetail.commission_percent - average commission percentage for the order
  • order.sumDetail.total_discount_value - total discount amount
  • order.sumDetail.total_discount_percent - average discount percentage
  • order.sumDetail.old_price - total pre-discount price
  • order.sumOverhead - total accruals for the order
  • order.quantity - total product quantity for the order
  • order.overhead.MarketplaceServiceItemDelivToCustomer - individual accrual value for the order
  • For example, to pass the accrual date for delivery in the Shipment document custom field parameter, specify:
    • {{order.overhead.MarketplaceServiceItemDelivToCustomer?order.overhead.operation_date}}

Order Variables from Ozon

  • Billing Information

    • order.overhead.MarketplaceServiceItemDelivToCustomer - last mile delivery
    • order.overhead.MarketplaceServiceItemDirectFlowLogistic - Logistics (up to 15.04 – delivery fee for KGT)
    • order.overhead.MarketplaceServiceItemDirectFlowTrans - mainline
    • order.overhead.MarketplaceServiceItemDropoffSC - shipment processing (SC)
    • order.overhead.MarketplaceServiceItemReturnAfterDelivToCustomer - return processing
    • order.overhead.MarketplaceServiceItemReturnFlowLogistic - Logistics (up to 15.04 – return fee for KGT)
    • order.overhead.MarketplaceServiceItemReturnFlowTrans - return mainline
    • order.overhead.MarketplaceServiceItemReturnNotDelivToCustomer - cancellation processing
    • order.overhead.MarketplaceServiceItemReturnPartGoodsCustomer - defective item processing
    • order.overhead.MarketplaceNotDeliveredCostItem - customer return of undelivered goods to the warehouse
    • order.overhead.MarketplaceReturnAfterDeliveryCostItem - customer return to the warehouse after delivery
    • order.overhead.MarketplaceDeliveryCostItem - delivery of goods to the customer
    • order.overhead.ItemAdvertisementForSupplierLogisticSeller - transportation and logistics services
    • order.overhead.MarketplaceServiceItemDropoffFF - shipment processing (FF)
    • order.overhead.MarketplaceServiceItemDropoffPVZ - shipment processing (PVZ)
    • order.overhead.MarketplaceServiceItemFulfillment - order fulfillment
    • order.overhead.MarketplaceSaleReviewsItem - purchase of reviews on the platform
    • order.overhead.ItemAdvertisementForSupplierLogistic - delivery of goods to the Ozon warehouse — cross-docking
    • order.overhead.MarketplaceServiceStorageItem - product placement
    • order.overhead.MarketplaceMarketingActionCostItem - product promotion
    • order.overhead.MarketplaceServiceItemInstallment - promotion and installment sales
    • order.overhead.MarketplaceServiceItemMarkingItems - mandatory product labeling
    • order.overhead.MarketplaceServiceItemFlexiblePaymentSchedule - flexible payment schedule
    • order.overhead.MarketplaceServiceItemReturnFromStock - product assembly for pickup by the seller
    • order.overhead.MarketplaceServiceItemPickup - pickup of shipments by the seller's address — Pick-up
    • order.overhead.MarketplaceServiceItemDropoffPPZ
    • order.overhead.MarketplaceServiceDeliveryGoodsToCustAgregator
    • order.overhead.MarketplaceServicePremiumCashback
    • order.overhead.MarketplaceServiceItemDropoffTSC
    • order.overhead.MarketplaceServicePremiumCashbackIndividualPoints
    • order.overhead.OperationMarketplaceWithHoldingForUndeliverableGoo
    • order.overhead.MarketplaceServicePremiumPromotion
    • order.overhead.MarketplaceReturnStorageServiceAtThePickupPointFbs
    • order.overhead.MarketplaceReturnStorageServiceInTheWarehouseFbsIt
    • order.overhead.MarketplaceServiceItemDirectFlowLogisticVDC
    • order.overhead.MarketplaceRedistributionOfAcquiringOperation
    • order.overhead.MarketplaceServiceItemDeliveryKGT
    • order.overhead.MarketplaceServiceItemRedistributionReturnsPVZ
    • order.overhead.MarketplaceServiceBrandCommission
    • order.overhead.MarketplaceReturnDisposalServiceFbsItem
    • order.overhead.MarketplaceAllPayout
  • order.barcodes.upper_barcode and order.barcodes.lower_barcode - shipping label barcode for the Ozon order

  • Additional Order Information

    • order.analytics_data.city - Delivery city - Only for rFBS shipments and sellers from the CIS.
    • order.analytics_data.delivery_date_begin - Delivery start date and time.
    • order.analytics_data.delivery_date_end - Delivery end date and time.
    • order.analytics_data.delivery_type - Delivery method.
    • order.analytics_data.is_legal - Flag indicating that the recipient is a legal entity:
      • true — legal entity,
      • false — individual.
  • Barcode

    • order.barcodes.upper_barcode
    • order.barcodes.lower_barcode

Order Variables from Wildberries

  • order.overhead.rebill_logistic_cost - Compensation for logistics/cargo handling costs
  • order.overhead.storage_fee - Storage cost
  • order.overhead.penalty - Total penalty amount
  • order.overhead.acquiring_fee - Acquiring fees/Payment processing fees
  • order.overhead.acceptance - Cost of paid acceptance
  • order.overhead.deduction - Other deductions/payments
  • order.overhead.installment_cofinancing_amount - Discount from installment co-financing program
  • order.overhead.ppvz_reward - Compensation for issuing and returning goods at PPVZ

Barcode (order):

  • order.labels[1].code
  • order.labels[2].code

Deprecated value

  • order.overhead.delivery_rub - Delivery cost

Order Variables from Yandex

  • order.overhead.FULFILLMENT — warehouse processing.
  • order.overhead.LOYALTY_PARTICIPATION_FEE — loyalty program participation and reviews for points, if enabled.
  • order.overhead.AUCTION_PROMOTION — sales boost.
  • order.overhead.INSTALLMENT — installment.
  • order.overhead.DELIVERY_TO_CUSTOMER — delivery to customer.
  • order.overhead.EXPRESS_DELIVERY_TO_CUSTOMER — express delivery to customer.
  • order.overhead.AGENCY — customer payment acceptance.
  • order.overhead.PAYMENT_TRANSFER — customer payment transfer.
  • order.overhead.RETURNED_ORDERS_STORAGE — storage of unclaimed orders and returns.
  • order.overhead.SORTING — order processing.
  • order.overhead.INTAKE_SORTING — organization of order pickup from the seller's warehouse (FBS).
  • order.overhead.RETURN_PROCESSING — order processing at the warehouse (FBY).
  • order.overhead.ILLIQUID_GOODS_SALE — sale of confiscated goods.

Order Variables from Avito

  • Customer information. Available only for DBS, CDBS, and RDBS after the order is paid.

    • order.analytics_data.delivery.buyerInfo.fullName - Customer's full name
    • order.analytics_data.delivery.buyerInfo.phoneNumber - Customer's phone number
  • Customer delivery address information for CDBS and RDBS courier delivery

    • order.analytics_data.delivery.courierInfo.address - Address where the customer ordered delivery
    • order.analytics_data.delivery.courierInfo.comment - Customer's comment
  • order.analytics_data.delivery.dispatchNumber - Dispatch number. Not available for RDBS.

  • order.analytics_data.delivery.serviceName - Delivery service name.

  • order.analytics_data.delivery.serviceType - "pvz" "dbs" "cdbs" "rdbs" Delivery method

    • pvz - Pickup point;
    • dbs - Delivery by seller partners (pickup point);
    • cdbs - Delivery by seller partners (courier);
    • rdbs - Delivery by seller courier;
    • postamat - Delivery via postamat;
  • Information about the pickup point selected by the customer for DBS delivery
    • order.analytics_data.delivery.terminalInfo.address - Pickup point address
    • order.analytics_data.delivery.terminalInfo.code - Pickup point code
  • order.analytics_data.delivery.trackingNumber - Tracking number for the shipment. Not available for RDBS.

  • order.analytics_data.chatId - For generating a link to the customer chat

Deprecated variables for retrieving payment details

  • order.overhead.commissions - market commission
  • order.overhead.delivery_fee - delivery cost