Configuring the catalog export

  • Updated

This topic is for administrators and developers with administration access rights in Shopware.

This topic describes how to configure the catalog export, when using Shopware as e-commerce platform with Optimizely Campaign. You can transfer promotional texts and product images, and use this data in your newsletters. See Content interface paragraph.

How it works

The integration reads a feed created in Shopware and transmits feed data to Optimizely Campaign. You can use filters in Shopware to exclude product categories. The integration exports the catalog to a CSV file , and automatically transfers the catalog to the Optimizely server via a secure SFTP connection at specific time intervals.

Prerequisites

You need an SSH key pair and an SFTP user account to set up a secure connection. To create a key pair, see:

When you have created the key pair, do the following to request a user account:

  1. Contact customer support, providing the name of the CSV file with your product catalog.
  2. Email your public key (the file with the .pub extension) to customer support.
  3. Send your key fingerprint in a separate email to customer support.

For security reasons, always send your public key and key fingerprint in two separate emails.

When your account is configured, you will receive your user account information by email, and you can start the configuration.

Configuration steps

  1. Configure the feed for the catalog that is to be exported.
  2. Configure your Shopware integration for catalog export.
  3. Configure and activate the cron jobEpiserver Campaign Product Export in Shopware to automate daily catalog exports.

Step 1. Configuring your feed for catalog export

The Shopware integration includes a standard feed that you can copy and customize (recommended).

Do the following to configure a feed:

  1. Log in to the back end of Shopware with administrator rights.
  2. Go to Marketing > Item export.

    Image: Item export menu item

  3. In the list, find the entry optivo broadmail and click Edit item feed .

    Image: Edit item feed

  4. In the Format tab, in the Encoding drop-down list, select UTF-8.

    Image: Enter encoding

    Entries in the Header and Body tabs were created by the Shopware integration at the time of installation and are required for the product data exchange with the content interface. Do not change the entries in the Header tab. You can change the Body tab as needed in steps 5 and 6.

  5. Optional: In the Body tab, adjust the sending time by changing the number of days (10 by default).

    Image: Adjust sending time

    Do not change the variables and the filters used (such as |escape).

  6. Optional: In the Body tab, change the shipping service provider and the shipping method.

    Image: Change shipping service

    Deutsche Post Standard is the default shipping service provider and shipping method.

    Do not change the variables and the filters used (such as |escape).

  7. To exclude product categories from being transferred to Optimizely Campaign in the catalog export, open the Blocked categories tab and select the corresponding check box.

    Image: Exclude product categories

  8. Click Save and Close.
  9. Find the optivo broadmail feed and right-click the file name in the File name column. In the context menu of your browser, select the option Copy link location.

    Image: Select option to copy link

  10. Copy the Feed URL to your clipboard, or save the URL in a text document.

Step 2. Configuring Shopware integration for catalog export

  1. In Shopware, go to Configuration > Plugin Manager.

    Image: Plugin Manager menu item

  2. On the left side of the menu bar, click Installed.

    Image: Click Installed

  3. Find the Shopware integration for Episerver Campaign in the Plugin Manager, and click Open .

    Image: Open Shopware integration

  4. In the Configuration area, insert the data below:

    Image: Configuration area

    • Product export. Select Yes.
    • Export Name. Enter the file name for your catalog export.
    • Product export link. Enter the URL of the feed for your catalog export.
    • SFTP Username. Enter the user name for your Optimizely server account.
    • SFTP keyfile password. Enter the password for your private SSH key.
    • SFTP Private Keyfile. Enter your private SSH key.
  5. Click Save.

Step 3. Configuring and activating the Cron job

To automate daily catalog exports, you must configure and activate the Cron job Episerver Campaign Product Export in Shopware.

  1. In Shopware, go to Configuration > Basic settings.

    Image: Basic Settings menu item

  2. Go to System > Cronjobs.

    Image: Select Cronjobs

  3. In the list, find the Cron job Episerver Campaign Product Export and click Edit .

    Image: Locate and edit cron job

  4. Select Active.

    Image: Activate cron job

  5. In the Interval drop-down list, select a time interval, such as 1 day.

    Image: Select time interval

  6. Click Save.
  7. To activate the Cron job and start the automatic schedule, invoke the URL. Typically, this is something like: http://<your store URL>/backend/cron.

When the URL is invoked, you can find the job in the list of running Cron jobs under the Processing Episerver Campaign Product Export (if the execution is scheduled).