Import Product Offers to Activation

Summary

Akeneo Activation supports three ways to import offer data (price, stock, and condition) for your products: via the Offer API, via FTP or SFTP, and via manual CSV upload. The Offer API is covered in Sending product offers to marketplaces. This article describes the manual CSV upload and the FTP/SFTP import methods.

Manual import of offer data into Activation

This section covers manually importing offer data (price, stock, and condition) into Akeneo Activation using a CSV file.

Why manual import?

Akeneo Activation lets you import product and stock data automatically using the Offer API and FTP connections. Manual import is useful when you need more direct control:

  • Make quick changes: Adjust a price or stock number immediately without waiting for an automated data feed.
  • Fix errors: If something goes wrong with your automated feed, correct it right away by uploading a new CSV file.

How to manually import offer data

To manually import offer data into an Akeneo Activation channel:

  1. In Activation, open the channel into which you want to import offer data.
  2. In the channel header, locate the Import/Export area.
  3. Click the import button and select your CSV file.
  4. Activation validates the file format. If the file is valid, the import runs immediately.
  5. After the import completes, a confirmation message indicates whether it was successful. If there are errors, go to the Reports tab of the channel to download a detailed error report.

Once imported, the offer data is visible in the Activation product grid and ready to be exported to marketplaces.

You can download a template CSV file before importing to ensure your data matches the expected format:

Download offer template

CSV file format for offer imports

Your CSV file must include the columns listed below. Both comma (,) and semicolon (;) delimiters are supported — Activation auto-detects the delimiter from the file header.

Column name Example value Required Notes
product_identifier product_1 Yes The product identifier (for example, SKU or EAN) used to associate the offer with a product in Activation.
offer_sku offer_sku_1_1 Yes The offer identifier. Use the ASIN for Amazon, or the Product Offer SKU for MIRAKL-powered marketplaces.
base_price_amount 10.0 Required for new offers; optional for updates Must be provided together with base_price_currency and stock fields when creating a new offer.
base_price_currency USD Required for new offers; optional for updates Must be provided together with base_price_amount and stock fields when creating a new offer.
base_price_start_date 2024-01-01 No Default: null. Format: YYYY-MM-DD.
base_price_end_date 2024-01-01 No Default: null. Format: YYYY-MM-DD.
discounted_price_amount_1 15.0 Required if a discount applies Required when including a discounted price.
discounted_price_currency_1 USD Required if a discount applies Required when discounted_price_amount_1 is provided.
discounted_price_start_date_1 2024-01-01 No Default: null. Format: YYYY-MM-DD.
discounted_price_end_date_1 2024-01-01 No Default: null. Format: YYYY-MM-DD.
stock_quantity 10 Required for new offers; optional for updates Must be provided together with price fields when creating a new offer.
stock_condition new Required for new offers; optional for updates Accepted value: new.
stock_days_to_ship 2 No Default: null. Number of days between payment and carrier pickup.
stock_next_refill_date 2024-01-01 No Default: null. Format: YYYY-MM-DD.
stock_is_infinite TRUE No Default: FALSE.
  • File format: Only CSV files are accepted.
  • Column delimiter: Both commas (,) and semicolons (;) are supported. Activation auto-detects the delimiter from the file header.
  • Column header format: Column headers must match the names in the table above exactly. Cell data values are case-insensitive.
  • Creating vs. updating offers: When creating a new offer, both price fields (base_price_amount, base_price_currency) and stock fields (stock_quantity, stock_condition) are required together. When updating an existing offer, you can provide only the fields you want to change.

FTP and SFTP import of offer data into Activation

This section describes how to configure a recurring offer import job in Akeneo Activation using an FTP or SFTP connection. When enabled, Activation periodically checks a specified folder on your file server for new CSV files and imports any offer data it finds. Processed files are deleted from the folder afterward.

Prerequisites

  • An FTP or SFTP connection configured in Activation. You can create and manage connections at Settings > Connections in Activation (see Data exchange with Activation via FTP storage), or create a new connection directly within the channel settings when configuring the import job.

Configure the FTP or SFTP offer import job

To enable and configure the offer import job for an Akeneo Activation channel:

  1. In Activation, open the settings for the channel into which you want to import offer data.
  2. Navigate to the Offer section within the channel settings.
  3. Use the toggle to enable the offer import job.
  4. (Optional) Click Download file template to get a sample CSV that shows the required and optional fields and their expected format.
  5. Under Job frequency, select how often Activation should check for new offer files:
  6. Every X minutes: Choose between 15, 30, or 45-minute intervals.
  7. Every X hours: Select a specific hour interval within the day.
  8. Every day at...: Run the job daily at a chosen time.
  9. Every week on...: Run the job once per week on a chosen day.
  10. Under Storage connection, select an existing FTP or SFTP connection from the dropdown, or click the + icon to create a new connection inline.
  11. In the Folder path field, enter the path to the folder on your file server where Activation should look for CSV files.

The animation above shows the Offer section inside an Akeneo Activation channel's settings, with the enable toggle, job frequency selector, storage connection dropdown, and folder path field.

All settings in the Offer section are saved automatically as you make changes. There is no separate save button.

Monitor offer import jobs

To view the status and history of offer import jobs in Akeneo Activation, navigate to the Reports tab of the channel. You can filter by job type to display only offer import jobs. The Reports tab shows past executions with their status (success or failure), timestamps, import counts, and downloadable error reports for troubleshooting.

For full details on the reporting interface, see Job reporting.

Want to find out more? Take a look at these related articles