Skip to main content

CSV Export Alternative

In addition to the real-time API integration, you can now export offers to CSV format according to Idealo specifications. This is useful for:

  • Bulk uploads to Idealo portal

  • Backup and archival purposes

  • Review and validation before publishing

  • Situations where API access is temporarily unavailable

How to Export to CSV​

Open the Offer window and press for "Export to CSV"

image-20251126-172921.png

Export Options​

| Field

|

Description

| | --- | --- | |

Shop Code

|

Required: Select the shop to export offers for.

| |

Status Filter

|

Choose which offer status to export:

• Active (default): Export only active offers

• New: Export only new (not yet published) offers

• Deleted: Export deleted offers

• Blank: Export all offers regardless of status

|

Additional Filters​

You can use standard BC filtering on:

  • Item No.: Export offers for specific items

  • From Date / To Date: Filter by offer period

  • Shop Code: Already filtered in the request page

CSV File Format​

The exported CSV file follows Idealo's specification and includes:

Required Fields​

  • sku: Offer entry number

  • brand: Brand code

  • title: Offer name

  • url: Product URL

  • price: Offer price

  • delivery: Max order processing time

Payment Costs Columns​

Dynamic columns for each payment method (e.g., paymentCosts_CreditCard, paymentCosts_PayPal):

  • Automatically includes all configured payment methods

  • Shows the cost applicable to this offer based on amount ranges

  • Uses item-level payment methods if configured, otherwise shop-level

Delivery Costs Columns​

Dynamic columns for each delivery method (e.g., deliveryCosts_DHL, deliveryCosts_DPD):

  • Automatically includes all configured delivery methods

  • Shows the cost applicable to this offer based on amount ranges

  • Uses shop-level delivery methods with automatic range selection

Optional Fields​

  • formerPrice: Old price (if discount applied)

  • basePrice: Price per unit

  • categoryPath: Idealo category

  • description: Offer description

  • imageUrls: Semicolon-separated image URLs

  • eans, hans, pzns, kbas: Semicolon-separated reference numbers

  • freeReturnDays: Free return period

  • fulfillmentType: Delivery type

  • twoManHandlingFee: Delivery to installation cost (item-level or shop-level)

  • disposalFee: Old appliance collection cost

  • deposit: Deposit amount

  • size, colour, gender, material: Product attributes

  • replica, used, download: Product flags

CSV File Example​

sku,brand,title,url,price,delivery,paymentCosts_CreditCard,paymentCosts_PayPal,deliveryCosts_DHL,deliveryCosts_DPD,formerPrice,basePrice,... 10001,Samsung,"Samsung Galaxy S24",https://shop.com/s24,899.00,2,2.50,0,4.99,5.99,999.00,,"","",... 10002,Apple,"iPhone 15 Pro",https://shop.com/iphone15,1199.00,2,2.50,0,0,0,,"","",...

Usage in Idealo Portal​

After exporting the CSV file:

  1. Log in to your Idealo Business Portal

  2. Navigate to Offer Management > Import

  3. Select CSV Upload

  4. Choose the exported file

  5. Review the import summary

  6. Confirm the import

Review the CSV file in Excel or a text editor before uploading to ensure all data is correct, especially:

  • Payment and delivery costs are calculated correctly

  • Image URLs are accessible

  • Category paths are valid Idealo categories

Key Differences: API vs CSV Export​

| Feature

|

API Export (Real-time)

|

CSV Export

| | --- | --- | --- | |

Speed

|

Immediate

|

Manual process

| |

Updates

|

Automatic with PATCH

|

Requires re-import

| |

Validation

|

Immediate error feedback

|

Validated during import

| |

Best For

|

Real-time synchronization

|

Bulk uploads, backup

| |

Payment/Delivery Costs

|

Included in API call

|

Included in CSV columns

|

Amount-Based Cost Calculation​

The CSV export automatically:

  1. Evaluates each offer's price

  2. Finds matching payment method costs (item-level → shop-level fallback)

  3. Finds matching delivery method costs (shop-level with range matching)

  4. Includes the correct cost in the respective CSV column

Example:

  • Offer price: 75 EUR

  • Shop payment method "Credit Card": 0-50 EUR = 2.50 EUR, 50-0 EUR = 0 EUR

  • CSV will show: paymentCosts_CreditCard = 0 (because 75 EUR falls in 50-0 range)

Item-Level Overrides
If an item has item-level payment methods configured, those take precedence over shop-level settings in the CSV export.

Troubleshooting​

Empty CSV File​

  • Ensure you've selected a Shop Code

  • Check that offers exist with the selected status filter

  • Verify your filter criteria aren't too restrictive

Missing Payment/Delivery Cost Columns​

  • Ensure payment and delivery methods are configured in the shop setup

  • Check that the methods have at least one cost entry (even if cost is 0)

Incorrect Costs in CSV​

  • Verify From/To Amount ranges don't overlap

  • Check item-level payment methods if costs seem wrong

  • Ensure offer prices fall within configured ranges

The CSV export shows costs as they would be calculated at the time of export. If you change payment/delivery method configurations, re-export the CSV to get updated costs.