# OF51 - Get offers CSV file (deprecated) Get a CSV file that includes the offers updated and deleted since the last request date.For deleted offers, only offer-id, product-sku, shop-id, shop-sku, active and deleted columns are returned. If the last_request_date param is not set the api returns all the active offers (inactive offers can be included with include_inactive_offers parameter).If offers have custom fields, a column is added for each existing custom field with as header the code of the custom field.Results are sorted by offer identifier.Call FrequencyRecommended usage: - Differential: every 5 minutes - Full: once per dayMaximum usage: - Differential: once per minute - Full: once per day Endpoint: GET /api/offers/export ## Query parameters: - `last_request_date` (string) Date and time of your last request.If provided, retrieves all offers updated since this date and time, including deleted and inactive offers.If not provided, retrieves all active offers only, unless otherwise specified in the include_inactive_offers field. - `channel_codes` (string) List of the channel codes to filter with, using a comma (,) as a separator. If specified, only offers that can be sold on the specified channel(s) will be returned. If not, offers will be returned regardless of their channels. - `shipping_zones` (string) List of the shipping zones codes to filter with, URL-encoded and using a comma (,) as a separator. If specified, only shipping information linked to the given zones will be returned. Otherwise, all shipping information for all zones will be returned. - `include_inactive_offers` (boolean) When calling the API in full mode (i.e. when no last_request_date is provided), inactive offers are not returned. To retrieve both active and inactive offers, set this field to true.When calling the API in differential mode (i.e. when the last_request_date is provided), both active and inactive offers are returned. This field cannot be used in differential mode otherwise the call fails. - `include_fields` (string) List of the fields to include, URL-encoded and using a comma (,) as a separator. If specified, only listed fields will be returned. - `shop_id` (integer) Use this parameter when your user has access to several shops. If not specified, the shop_id from your default shop will be used. ## Response 200 fields (text/csv): - `active` (boolean) Indicates if the offer is active or inactive (not for sale or discontinued) - `allow-quote-requests` (boolean) Allow customers to request quotes on this offer - `available-end-date` (string) The date when the offer will be deactivated - `available-start-date` (string) The date when the offer will be activated - `channels` (string) List of channel codes on which the offer can be sold. - `currency-iso-code` (string) ISO code of the currency Enum: "AED", "ARS", "AUD", "BAM", "BGN", "BHD", "BRL", "CAD", "CHF", "CLP", "CNY", "COP", "CZK", "DKK", "EGP", "EUR", "GBP", "GEL", "GTQ", "HKD", "HRK", "HUF", "IDR", "ILS", "INR", "IQD", "JOD", "JPY", "KES", "KRW", "KWD", "LKR", "MAD", "MGA", "MXN", "MYR", "NGN", "NOK", "NZD", "OMR", "PEN", "PHP", "PKR", "PLN", "QAR", "RON", "RSD", "RUB", "SAR", "SEK", "SGD", "TND", "TRY", "THB", "TWD", "UAH", "USD", "UYU", "UZS", "VND", "ZAR" - `date-created` (string) Date and time of the offer creation - `deleted` (boolean) Indicates whether the offer exists or is deleted - `delivery-time-earliest-days[zone=,method=]` (string) Minimum delivery time. Returned if Export shipping charges and delivery times in OF5X, P11 and the offer webhook is enabled. - `delivery-time-latest-days[zone=,method=]` (string) Maximum delivery time. Returned if Export shipping charges and delivery times in OF5X, P11 and the offer webhook is enabled. - `description` (string) Offer description - `discount-end-date` (string) The end date of the discount period. For Dropship specifically: the end date of the discount period on the purchasing price - `discount-end-date[channel=]` (string) The end date of the discount period for the indicated channel, when the Channel Pricing feature is activated. Can be empty. In this case, the discount price applies from the start date and is then always available for the indicated channel. - `discount-price` (number) The discount price of the offer For Dropship specifically: the discount purchasing price of the offer, also referred to as cost or wholesale price - `discount-price[channel=]` (number) The discount price of an offer for the indicated channel, when the Channel Pricing feature is activated. Can be empty when no discount price is defined for a given channel. In this case, the default discount price of the offer applies to the indicated channel. - `discount-ranges` (string) The ranges of the discount prices when the Volume Pricing feature is activated. - `discount-ranges[channel=]` (string) The ranges of the discount prices for the indicated channel, when the Channel Pricing and Volume Discount features are activated. - `discount-retail-price` (number) The discount retail price of the offer. Applicable only for Dropship offers. - `discount-retail-price-end-date` (string) The end date of the discount period for the retail price. Applicable only for Dropship offers. - `discount-retail-price-start-date` (string) The start date of the discount period for the retail price. Applicable only for Dropship offers. - `discount-start-date` (string) The start date of the discount period. For Dropship specifically: the start date of the discount period on the purchasing price - `discount-start-date[channel=]` (string) The start date of the discount period for the indicated channel, when the Channel Pricing feature is activated. Can be empty. In this case, the discount price applies from the start date and is then always available for the indicated channel. - `eco-contribution-amount[EPR category code]` (number) Amount of the eco-contribution for the EPR category. Returned if Data collection related to circular economy regulations is enabled. - `favorite-rank` (integer) If present, indicates that the offer is a favorite offer ranked - `fulfillment-center-code` (string) Code of the fullfilment center - `last-updated` (string) Date and time of the last update of the offer - `leadtime-to-ship` (integer) The lead time to ship corresponding to the offer - `logistic-class` (string) The logistic class associated to the offer - `max-order-quantity` (integer) The maximum order quantity customers must select to be able to place an order for that offer - `measurement-units` (string) The product measurement and the product unit This option is only available if the operator creates a product with a measurement unit. - `min-order-quantity` (integer) The minimum order quantity customers must select to be able to place an order for that offer - `min-shipping-price` (number) Minimum shipping charges for the offer - `min-shipping-price-additional` (number) Additional shipping charges for the offer - `min-shipping-type` (string) Shipping method with the minimum shipping charges (code referenced by the operator) - `min-shipping-zone` (string) Shipping zone with the minimum shipping charges (code referenced by the operator) - `msrp` (number) The retail price recommendation, also referred to as manufacturer's suggested retail price (MSRP) or recommended retail price (RRP). Applicable only for Dropship offers. - `offer-id` (integer) Unique offer identifier assigned by Mirakl - `origin-price` (number) The original price of the offer For Dropship specifically: the original purchasing price of the offer, also referred to as cost or wholesale price - `origin-price[channel=]` (number) The original price granted for an offer for the indicated channel - `origin-retail-price` (number) The original retail price of the offer, also referred to as original selling price. Applicable only for Dropship offers. - `package-quantity` (integer) For one order, customers can only add packages of product items. The number of items per package is the increment number of that product in an order. - `premium` (boolean) Indicates if the store is premium or not - `price` (number) Offer current price (original price or discount price if in discount period) For Dropship specifically: the purchasing price of the offer (original price or discount price if in discount period), also referred to as cost or wholesale price - `price-additional-info` (string) Information about the offer price - `price-ranges` (string) The price ranges when the Volume Pricing feature is activated. - `price-ranges[channel=]` (string) The price ranges for the indicated channel when the Channel Pricing and the Volume Pricing features are activated. Can be empty when no specific price range is defined for a given channel. - `price[channel=]` (number) The unit price of an offer for the indicated channel, when the Channel Pricing feature is activated. Can be empty when no specific price is defined for a given channel. In this case, the base price of the offer applies to the indicated channel. - `producer-id[EPR category code]` (string) Producer identifier of the eco-contribution for the EPR category. Returned if Data collection related to circular economy regulations is enabled. Not present if the producer identifier belongs to the operator. - `product-sku` (string) Product identifier within the operator's system - `product-tax-code` (string) Tax code for the product - `professional` (boolean) Indicates if the store is professional or not - `quantity` (integer) Offer quantity available - `retail-price` (number) Offer current retail price (original retail price or discount retail price if in discount period). Also referred to as selling price. Applicable only for Dropship offers. - `shipping-price[zone=,method=]` (number) Shipping charges for the offer, for each combination of shipping zone and method. Returned if Export shipping charges and delivery times in OF5X, P11 and the offer webhook is enabled. - `shop-id` (integer) Unique identifier for the store providing this offer (assigned by Mirakl) - `shop-name` (string) Name of the store providing this offer - `shop-sku` (string) Shop's sku of the offer - `state-code` (string) Offer condition code - `total-price` (number) Offer price + minimum shipping charge For Dropship specifically: the purchasing price of the offer + minimum shipping charge