Import Product Offers to Activation

Summary

There are multiple ways to import Offer data into Activation, via the Offer API (covered in this article), via FTP, and manual import. The last two methods will be described in this article.

Manual Import of Offer Data into Activation

This section covers manually importing offer data (price/stock/condition) information into Activation using a CSV file.

Why Manual Import?

Activation already lets you import product and stock data automatically using APIs and FTP (see below). But sometimes you need more control. Manual import lets you:

Make quick changes: Need to adjust a price or stock number immediately? Manual import lets you do it without waiting for the automatic systems.
Fix errors: If something goes wrong with your automatic data feed, you can use manual import to correct it right away.

How to Manually Import Your Data

Import/Export area: In Activation, inside a channel header. There, you'll see a special section with buttons for importing and exporting data.

Get the right file format: Activation needs your data in a specific format. You'll find clear instructions on how to format your data in a CSV file. You can download a template file to see exactly what data you need to supply and in what format.

Example file

Import your data:

Click the import button and choose your CSV file.
Activation will check your file to make sure it's in the correct format.
If everything looks good, Activation will import your data.
You'll see a message telling you if the import was successful. If there are any problems, you'll soon be able to go to the reports page to get a report explaining what went wrong.
Once imported, your data is visible in the Activation product grid and ready to be exported to marketplaces

What Your File Needs

Your CSV file needs to have certain columns with specific information about your products and stock.

Here's a simplified table showing the essential parts:

Column Name	Examples	Required	Note
product_identifier	product_1 SKU	✅
offer_sku	offer_sku_1_1	✅
base_price_amount	10.0	✅ / ❌	❗Required alongside Stock information for new Offer creation and Optional for existing Offer updating.
base_price_currency	USD	✅ / ❌	❗Required alongside Stock information for new Offer creation and Optional for existing Offer updating.
base_price_start_date	2024-01-01	❌	Default: NULL
base_price_end_date	2024-01-01	❌	Default: NULL
discounted_price_amount_1	15.0	✅ / ❌	ℹ️ Discounted information here and bellow with “_1” can be duplicated to “_2”, “_3” and up to “_5” for a total of 5 discounts. ❗You can also have no discounted columns or all of them set to NULL for 0 discounts.
discounted_price_currency_1	USD	✅ / ❌	❗Required when discounted_amount is provided.
discounted_price_start_date_1	2024-01-01	❌	Default: NULL
discounted_price_end_date_1	2024-01-01	❌	Default: NULL
stock_quantity	10.0	✅ / ❌	❗Required alongside Price information for new Offer creation and Optional for existing Offer updating.
stock_condition	new / used / etc…	✅ / ❌	❗Required alongside Price information for new Offer creation and Optional for existing Offer updating.
stock_days_to_ship	2.0	❌	Default: NULL
stock_next_refill_date	2024-01-01	❌	Default: NULL
stock_is_infinite	TRUE / FALSE	❌	Default: FALSE

Important Things to Know

File types: For now, you can only import CSV files.
Errors: Activation will tell you if there are any errors in your file, like missing information or incorrect numbers.
Storage: The data is stored in the same way as the rest of the product information

FTP Import of Offer Data into Activation

This section outlines the steps to import offer data into Akeneo Activation using an FTP connection.

Prerequisites:

An established FTP connection configured within Activation. You can set up FTP connections either through your main Activation settings (described in this article) or directly within the Activation Channel Settings.

How to Import Your Data via FTP?

Once you have an FTP connection set up, follow these steps to enable and configure the offer import job for a specific Activation channel.

Activation Channel Settings: Access the settings for the specific Activation channel into which you want to import offer data.

Offer Section: Within the channel settings, locate and navigate to the "Offer" section.

Enable/Disable the Import Job:

You will find a toggle to Enable or Disable the offer import job for this channel.
To start importing offers via FTP, ensure this option is enabled.
When enabled, offer data will be imported from your specified storage (e.g., FTP). Only CSV files are processed and deleted afterward.

Download File Template (Recommended during initial setup):

Click on the option to Download file template.
This will provide you with a sample CSV file structure, clearly indicating the required and optional fields, along with the expected data format (as described in the for section above) each column. Using this template will help prevent errors during the import process.

Job Frequency:

Define how often you want the system to check for new offer files on the specified FTP location. You can select a frequency from the following options:
- Every minutes: Choose between 15, 30, or 45-minute intervals.
- Hours: Select a specific hour of the day.
- Days: Choose specific days of the week.
- Week: Select a specific day of the week for the job to run weekly.

Storage Connection:

you need to specify the storage location associated with your FTP connection.
You can either:
- Select an already established FTP connection from the dropdown menu. These are the connections you've previously configured in the Activation settings.
- Set up a new FTP connection on the fly by clicking the plus (+) icon. This will likely open a modal or inline form where you can provide the necessary FTP connection details (server address, port, username, password, etc.).

Folder Path:

Specify the exact folder path on your selected FTP storage where the CSV files containing your offer data will be located. The system will periodically check this folder for new files based on the configured frequency.

Automatic Saving: Please note that all selections and configurations within the Offer section of the channel settings are automatically saved as you make them. There is no separate "Save" button to click.

Post-Configuration:

Once you have selected the folder path, the offer import job is fully configured and will automatically run at the desired frequency, looking for new CSV files in the specified FTP folder.

Monitoring Import Jobs:

To view the status and reports of your offer import jobs, navigate to the Activation Channel report tab. Here, you will find details about past job executions, including any successes or failures, and potentially error logs for troubleshooting (as described in the section below)

Reporting

Please refer to this article on general job reporting, including offer import jobs.

Akeneo Help Center