API Orders management

h.agent reference agent, entered manually in SellRapido 

h.billed 1 if the order was exported from SellRapido for invoicing

h.buyer_address1 address

h.buyer_address1_dd address - different destination

h.buyer_address2 address additional row

h.buyer_address2_dd address additional row - different destination

h.buyer_checkout_message message left by buyer

h.buyer_city city

h.buyer_city_dd city - different destination

h.buyer_country country

h.buyer_country_dd country - different destination

h.buyer_email email

h.buyer_fax fax

h.buyer_fax_dd different fax destination

h.buyer_fiscal_code fiscal code

h.buyer_invoice_ecode code for electronic invoicing

h.buyer_latitude not used

h.buyer_latitude_dd not used

h.buyer_loc_place not used

h.buyer_loc_place_dd not used

h.buyer_longitude not used

h.buyer_longitude_dd not used

h.buyer_mobile mobile phone

h.buyer_mobile_dd mobile phone - different destination

h.buyer_name buyer name

h.buyer_name_dd buyer name - different destination

h.buyer_pec certified email

h.buyer_phone phone

h.buyer_phone_dd phone - different destination

h.buyer_province province

h.buyer_province_dd province - different destination

h.buyer_token not used

h.buyer_user_id buyer ID on marketplace side

h.buyer_vat VAT no.

h.buyer_zip postcode

h.buyer_zip_dd postcode different destination

h.channel_code marketplace channel code

h.cod_cash_only 1 if payment is cash-on-delivery

h.cod_option not used

h.cod_price cash-on-delivery cost

h.code order code assigned by the marketplace

h.code_number order number assigned by the marketplace

h.content_type value entered manually in SellRapido; describes the content of the order

h.courier courier ID code, value entered manually in SellRapido 

h.courier_code marketplace courier code, downloaded from marketplace if available

h.created data created in SellRapido 

h.currency currency code

h.customer buyer ID encoded in SellRapido 

h.date_last_delivery last date for delivery

h.date_last_ship last date to begin shipment

h.date_order order date

h.date_payment payment date

h.date_shipping shipping date

h.feeds_date date when the last feedback was left

h.fields_lock field list locked (system field)

h.hidden 1 to indicate that the order is archived and therefore no longer visible in SellRapido 

h.id SellRapido order ID 

h.insurance_code not used

h.is_prime 1 to indicate that it is an Amazon Prime order

h.marketplace_code marketplace code

h.marketplace_country marketplace country

h.marketplace_fee marketplace commission

h.marketplace_payment_info_date date when you downloaded some additional order info (for Amazon only); this is a system field

h.merchant_id seller code

h.modified order modification date

h.note order notes

h.payment_code codice marketplace payment method code

h.payment_note payment note

h.paypal_fee paypal commission

h.paypal_transaction_id paypal transaction ID

h.price total order including everything (vat, discounts, etc.)

h.price_discount_markup if any mark-up discount is applied, this is a field calculated by difference to return the total

h.problem_description description of any problems

h.reference_1 reference person 1

h.reference_2 reference person 2

h.run_request system field

h.shipped_by_marketplace 1 if it is an order in marketplace logistics

h.shipping_code marketplace shipping method code

h.shipping_cost shipping cost (any cost incurred by the seller)

h.shipping_insurance_price not used

h.shipping_note shipping notes

h.shipping_price shipping cost (any cost incurred by the buyer)

h.shop system field

h.status order status

h.status_message associated with order status (usually an error)

h.status_old system field: previous order status

h.supplier_code supplier code

h.tags list of tags associated with the order

h.tracking tracking code

h.weight overall weight

h.total_tax total taxes (VAT) in absolute value (SellRapido Ecommerce orders only)

r.brand brand

r.category_id marketplace product category ID

r.category_name marketplace product category name

r.cod_price not used

r.courier_code marketplace courier code, downloaded from marketplace if available

r.created data created in SellRapido 

r.date_payment not used

r.date_shipping not used

r.ean ean code

r.fields_lock list of locked fields (system field)

r.id SellRapido order row ID 

r.image_url product image URL

r.marketplace_fee marketplace commission

r.modified date modified in SellRapido 

r.mpn manufacturer product code

r.note notes

r.on_demand_date the date when the product can be shipped

r.order_head SellRapido order ID ref 

r.order_row_supplier supplier order row ID ref (if any)

r.order_supplier not used

r.order_supplier_code not used

r.price product price (with or without VAT depending on the marketplace)

r.price_cost product cost (value entered manually or based on pre-sale listing)

r.price_discount_markup any mark-up discount applied

r.price_total row total

r.product_id product ID on marketplace side

r.quantity ordered quantity

r.refund_date refund date

r.refund_price amount refunded

r.refund_reason reason for refund

r.shipping_code not used

r.shipping_cost shipping cost (any cost incurred by the seller)

r.shipping_insurance_price not used

r.shipping_note shipping notes

r.shipping_price shipping cost (any cost incurred by the buyer)

r.sku product SKU

r.sku_parent parent product SKU (for variants)

r.stock_unloaded system field

r.supplier supplier ID

r.title title

r.title_extra not used

r.tracking tracking at row level (I don’t know of any cases where it is used)

r.transaction_id marketplace side transaction ID (e.g. eBay transaction ID)

r.vat_perc VAT percentage

r.product_tax unit taxes (VAT) in absolute value (only for SellRapido Ecommerce orders)