Skip to main content

Amazon: Setting up catalogue export


The Amazon catalogue is here! Amazon is the first big market to be offered for variation export via catalogues. However, if you prefer you can still use the old export.

1. Why catalogues?

  • Your catalogues will quickly become your control centre for all variation exports.

  • The catalogue provides the data structure of the flatfile. As such, you know exactly which variation data is necessary to sell your products on Amazon.

  • You decide what variation data is exported for each flatfile and each platform. At the same time, suggestions help you to set up additional catalogues more quickly: Because once you have mapped a marketplace data field to a plentymarkets field, this mapping is suggested to you next time.

  • You can transmit data more flexibly because you can map fields in any way you like.

Amazon catalogues are a new feature!

Catalogues for exporting variation data to Amazon are a new feature.

2. Important information on Amazon catalogues

  • A separate catalogue is created for each combination of an Amazon account, an Amazon platform and a flatfile.
    Note: If Amazon releases a new version of the flatfile, a new catalogue needs to be created. The good news is: You can copy and edit the catalogue with the old flatfile version with a few convenient clicks.

  • Characteristics and free text fields cannot be transmitted to Amazon in catalogues. You can create properties for the mandatory field of a flatfile in the assistant for the Amazon catalogue. You can create and map additional properties at any time.

  • A separate flatfile exists for Amazon Business (B2B). As such, you need to create a separate catalogue for Amazon Business.

  • BMVD export categories are ignored in the catalogues.

  • All mandatory fields of the flatfile are mapped in the assistant. You can map additional fields in the Data » Catalogues menu after the catalogue is created.

  • Do you already sell on Amazon and export variation data to the market? When you activate an Amazon catalogue for one combination of Amazon account, Amazon platform and flatfile, the old variation export for this combination is deactivated automatically.

3. Important preparation

4. Creating a catalogue for variation export

Amazon catalogues are created with the Creating catalogues - Amazon assistant in the Setup » Assistants » Omni-Channel menu.

  • A separate catalogue is created for each combination of an Amazon account, an Amazon platform and a flatfile.

  • All mandatory fields of the flatfile are mapped in the assistant.

  • Optional fields are mapped in the Data » Catalogue menu once the catalogue has been created.

  • Amazon catalogues can only be created in the assistant, not in the Data » Catalogue menu.

Free text fields and characteristics are not supported

Catalogues do not support free text fields or characteristics. Only properties can be transmitted to Amazon in catalogues. You can create properties for all mandatory fields of a flatfile in the assistant.

4.1. Creating a catalogue in the assistant

The assistant Create catalogues - Amazon allows you to create a catalogue for exporting your variation data to Amazon in a few easy steps. You specify a name for the catalogue and decide on the flatfiles and the Amazon platform to use. You also map all mandatory fields in the catalogue.

One catalogue per account, plattform and flatfile

You need a separate catalogue for each combination of Amazon account, Amazon platform and flatfile. This is made easy thanks to suggestions: Because once you have mapped a marketplace data field to a plentymarkets field, this mapping is suggested to you next time.

Creating a catalogue in the assistant:

  1. Open the menu Setup » Assistants » Omni-Channel.

  2. Click on the assistant Create catalogues - Amazon.

  3. Follow the instructions on the screen. If you need additional information about one of the options, expand the info boxes below this description ().

  4. In the step Summary, check your settings to make sure they are correct.
    Tip: In the Summary step, click on the arrow () to show the settings.

  5. If everything is as it should be, click on Finalise.
    → The catalogue is created.

  6. Open the catalogue in the Data » Catalogues menu to map more fields.
    Note: You need a separate catalogue for each combination of Amazon account, Amazon platform and flatfile.

Step User account

Select the amazon account from the drop-down list. You need to create a separate catalogue for each combination of one Amazon account, one Amazon platform and one Amazon flatfile. You can only select Amazon accounts that are already saved in your plentymarkets system. If the account is not shown, go to Setup » Markets » Amazon » Settings and create a new account or use the assistant Base settings - Amazon.

Note: Create the necessary customer classes in advance if they do not already exist in your plentymarkets system.

Step Name, flatfile and platform
Setting Explanation

Name

Enter a name for the catalogue. If no name is entered, a name is generated automatically.

Activate item export

Activates the export. The export is deactivated by default.
Note: Check all mappings before activating the export. You can also activate the catalogue later in the Data » Catalogue menu.

Fulfilment method

Select if only MFN variations, only FBA variations or both are to be exported in this catalogue.

  • Transmit MFN and FBA variations (default setting) = MFN variations and FBA variations are transmitted (recommended).

  • Only transmit MFN variations = Only variations that you ship yourself are transmitted. As such, a separate catalogue must be created for FBA variations.

  • Only transmit FBA variations = Only variations shipped by Amazon are transmitted. As such, you need to create a separate catalogue for variations that you ship yourself.
    Tip: We recommend that you manage both fulfilment methods in a single catalogue.

Amazon flatfile

Select the flatfile to use for this catalogue.
A flatfile is a file template for specific product categories provided by Amazon. This file template specifies the variation and stock data that needs to be exported to Amazon.
Note: Only flatfiles for platforms that are activated for the Amazon account that you selected in step 1 are shown. If necessary, activate additional platforms for the Amazon account.

Amazon platform
(only shown once a flatfile is selected)

Select the Amazon platform from the drop-down list.
Note: Only Amazon platforms that are activated for the Amazon account that you selected in step 1 are shown. If necessary, activate additional platforms for the Amazon account.

Flatfile version

Indicates the version of the flatfile used.
Note: If Amazon releases a new version of the flatfile, you need to create a new catalogue.

Step Setting up the catalogue

In this step, you map plentymarkets data fields with the data fields of the selected Amazon flatfile. All data fields shown in this step are mandatory fields and need to be mapped. You can map additional fields in the Data » Catalogue menu after you completed the assistant.

If you have created a catalogue for Amazon already, data fields are shown as suggestions in every catalogue after that. For each marketplace data field, the plentymarkets data field that you mapped to this field most often is suggested.

Create property = Creates a new property and maps this property to the data field. The properties are grouped in the property group Amazon Catalog of the Setup » Settings » Properties » Groups menu. The name of the property is based on the field in the flatfile.


Create price = Creates a sales price and maps this sales price to the data field. Automatically created sales prices can be checked and edited in the Setup » Item » Sales prices menu. The name of the sales price carries the prefix "Amazon Catalogue".


Create barcode = Creates a new barcode and maps this barcode to the data field. Automatically created barcodes can be checked and edited in the Setup » Item » Barcodes menu.


Select data field = A data field in plentymarkets is transmitted to Amazon. Select the data field from the drop-down list Select data field.
Note: Fields with the option Map data field manually cannot be mapped in the assistant. You need to map these fields manually after the catalogue has been created.


Manually map data field = These fields are not mapped automatically in the assistant. You need to map these data fields manually after the catalogue has been created.

4.2. Mapping additional data fields (not in assistant)

You have already mapped important mandatory fields for the flatfile in the assistant. You need to map additional data fields after you completed the assistant. You can also map additional fields to send even more information about your products to Amazon.

Getting to know the catalogue menu
catalogue menu colours

Menu structure of a catalogue with marketplace format

  • Navigation When you open a catalogue, the view Mapping is shown by default. Use the navigation to switch to other views of the catalogue. Access the catalogue settings or set filters to only export specific data. You can also go back to the catalogues overview or create a new catalogue.

  • Toolbar The toolbar provides actions for the catalogue. For example, save your mappings, restore an older version of the catalogue or hide or show optional marketplace data fields.

  • Marketplace data fields To the right of the navigation, all data fields available for the market are listed. Mandatory fields are marked with an asterisk (✱).
    Tip: Click on the further actions () in the toolbar to show or hide optional data fields.

  • plentymarkets data fields The left side of the catalogue is where you map the marketplace data fields with suitable plentymarkets data fields. In the screenshot, a few of the fields are already mapped.

Mapping catalogue fields:

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The Mapping tab opens.
    Note: The catalogue may appear to be empty at first. Depending on the size of the flatfile, it may take several minutes before the data fields are loaded and shown.
    → In the left-hand column, the market’s data fields are listed.
    Tip: Mandatory fields are flagged with an asterisk (*).
    → In the right column, you map the plentymarkets data fields. Any plentymarkets data fields that are already assigned are also shown in the right column.

  3. Now, map suitable plentymarkets data fields to the market data fields.
    You can choose from the following mappings which are described in the info boxes below:

    • Simple 1:1 mapping

    • Complex 1:1 mapping

    • 1:1 mapping with fallback data fields

    • 1:n mapping

    • Own value mapping

  4. Save () the catalogue.
    → The mappings are saved.

Simple 1:1 mapping: 1 marketplace data field, 1 plentymarkets data field

In a simple 1:1 mapping, you map a plentymarkets data field to the marketplace data field. If no suitable setting exists in plentymarkets, you can map a property instead.

As such, simple 1:1 mappings allow you to:

  • I want to fill this marketplace data field with the data from this plentymarkets setting.

  • If the data field is empty for a variation, no value is exported for this variation.

Creating a simple 1:1 mapping:

  1. Next to the marketplace data field, click on + Add data field.
    → To the left, the list of available plentymarkets data fields are shown in groups.

  2. Click on a group to expand the associated plentymarkets data fields.
    → The plentymarkets data fields are shown.

  3. Click on the plus to the right of the plentymarkets data field you want to select.
    → The plentymarkets data field is added to the right.

  4. Click on Confirm.

Example: Sales price and RRP

This gif shows you how to map the marketplace data fields Sales price and RRP for Otto Market to suitable plentymarkets data fields:

gif catalogue mapping simple en
Complex 1:1 mapping: 1 marketplace data field, 1 plentymarkets data field

Like with the simple 1:1 mappings, you map a plentymarkets setting or property to a marketplace data field. Complex mappings are necessary if a marketplace data field has more than one possible value. Instead of mapping data fields, for complex mappings you instead map the values of these data fields. For example, you cannot simply map the plentymarkets data field Shipping profile to the marketplace data field Shipping method. This is because the market cannot know which of your shipping profiles in plentymarkets corresponds to which of their shipping methods.

Do not enter own values for complex mappings. All values that you enter must be saved for the variations, either in a setting or as a property value. This also applies if the value Comparative value is shown. You still need to enter exactly the value of the setting or property that you mapped.

Examples of complex 1:1 mappings are:

  • Categories

  • Brands

  • Shipping setting

You can recognize complex mappings from the field that is shown below the name of the marketplace data field. Click on the field to show the values available for the marketplace data field.

catalogue complex mappings
Do not map own values or properties of the type None for complex mappings.

Creating a complex 1:1:n mapping:

  1. Click on the field for the marketplace data field.
    → A list of the available values is shown.

  2. Select the value that you want to map a plentymarkets data field to.
    → The value is mapped.

  3. Next to the marketplace data field, click on + Add data field.
    → To the left, the available plentymarkets data fields are listed in groups.

  4. Click on a group.
    → The plentymarkets data fields are shown.

  5. Click on the plentymarkets data field for which you want to map values.
    Important: Do not map own values or properties of the type None.
    → Your next steps depend on the plentymarkets data field you selected:

    • Alternative 1: The available values for the plentymarkets data value are shown on the left.

      • Next to the value you want to select, click on the plus.
        → The value is added to the field on the right.

      • Click on Confirm.

    • Alternative 2: The plentymarkets data field is inserted and the field Comparative value is shown.

      • In the field Comparative value, enter a value that is saved in the setting or the property of the mapped plentymarkets data field.

      • Click on Confirm.

    • Alternative 3: The plentymarkets data field is inserted and a drop-down list is shown.

      • Select a value from the drop-down list.

      • Click on Confirm.

This gif shows you how to map suitable plentymarkets values to the values of the marketplace data fields Delivery time in days for Otto Market:

gif catalogue mapping complex en
1:1 mapping with fallback data fields 1 marketplace data field, 1 plentymarkets data field with alternatives

In a 1:1 mapping with fallback data fields, you map a plentymarkets data field to the marketplace data field. In addition, you specify one or more fallback data fields. This ensures that the system keeps looking if the first plentymarkets data field is empty or contains an invalid value.

So this mapping specifies:

  • I want to fill this marketplace data field with the data from this plentymarkets setting.

  • If the data field is empty or invalid for a variation, the first fallback data field is checked and the value of that fallback data field is exported instead.

  • If the first fallback data field also is empty or invalid for a variation, the value of the second fallback data field is exported and so on.

Creating a 1:1 mapping with fallback data fields:

  1. Next to the marketplace data field, click on + Add data field.
    → To the left, the list of available plentymarkets data fields are shown in groups.

  2. Click on a group to expand the associated plentymarkets data fields.
    → The plentymarkets data fields are shown.

  3. Click on the plus to the right of the plentymarkets data field you want to select.
    → The plentymarkets data field is added to the right.

  4. In the list of plentymarkets data fields, click on the plus icon next to the plentymarkets data field that you want to map.
    → The fallback data field is exported when the first data field does not exist or is empty.
    Note: Even if you assign one or more fallback data fields, the value of only one of those fields is exported. For each variation, the mapped plentymarkets data fields are checked in the order in which you mapped them. This means that if the first data field does not provide a value for a variation, the first fallback data field is exported etc.

  5. Click on Confirm.

This gif shows you how to map the plentymarkets data field SKU and the fallback data field Variation ID to the marketplace data field SKU for Otto Market:

gif catalogue mapping fallback en
1:n mapping: 1 marketplace data field, several plentymarkets data fields

In a 1:n mapping, you map several plentymarkets data fields to the marketplace data field. You can link these data fields with a separator.

So this mapping specifies:

  • I want to combine these plentymarkets data fields during export so that the marketplace data field is filled with the data of these two or more plentymarkets settings.

Creating a 1:n mapping:

  1. Next to the marketplace data field, click on + Add data field.
    → To the left, the list of available plentymarkets data fields are shown in groups.

  2. Click on a group to expand the associated plentymarkets data fields.
    → The plentymarkets data fields are shown.

  3. Click on the plus to the right of the plentymarkets data field you want to select.
    → The plentymarkets data field is added to the right.

  4. Click on Confirm.

  5. To the right of the mapped plentymarkets data field, click on Add data field ().
    → To the left, the list of available plentymarkets data fields again are shown in groups.

  6. Map one or several additional plentymarkets data fields to the marketplace data field as described above.

  7. Click on Confirm.

  8. To the very right of the row, click on Settings ().

  9. Select a separator from the drop-down list Separator or add a custom separator.

  10. Save the settings.

  11. Save () the catalogue.
    → The mappings are saved.
    → During the export, the content of the plentymarkets data fields is combined and exported as one field.

Own value mapping: 1 marketplace data field, the same value for all variations

You are sure that you want to export the same value for all variations of a catalogue for a marketplace data field? Then specify an own value. This own value is then exported for all variations.

So this mapping specifies:

  • For this marketplace data field, I want to export the value that I entered in the field Own value for all variations of this catalogue.

Creating an own value mapping:

  1. Next to the marketplace data field, click on + Add data field.
    → To the left, the list of available plentymarkets data fields are shown in groups.

  2. Click on the plus next to Own value at the top of the list.
    → The field for the own value is added to the view.

  3. Enter a value into the input field.
    → This value is exported for all variations.

Example: Diameter information

You want to export diameter information for some of your variations. The diameter is saved in centimetres for all your variations. Instead of creating a property for the unit and linking this property to the variations, you can enter the own value cm.

This is how you can map an own value for the diameter unit:

diameter

5. Linking data fields created in the assistant with variations

Creating a catalogue in the assistant:

  1. Open the menu Setup » Assistants » Omni-Channel.

  2. Click on the assistant Create catalogues - Amazon.

  3. Follow the instructions on the screen. If you need additional information about one of the options, expand the info boxes below this description ().

  4. In the step Summary, check your settings to make sure they are correct.
    Tip: In the Summary step, click on the arrow () to show the settings.

  5. If everything is as it should be, click on Finalise.
    → The catalogue is created.

  6. Open the catalogue in the Data » Catalogues menu to map more fields.
    Note: You need a separate catalogue for each combination of Amazon account, Amazon platform and flatfile.

6. Activating the variation export

You have checked all mappings and now want to start the export of your variation data to Amazon?

  • Activate a catalogue for an existing export (How?)

  • Activate a catalogue for a new export (How?)

6.1. Activating a catalogue for an existing export

If you created a catalogue for a combination of Amazon account, Amazon platform and flatfile that you already use, the export is automatically switched to catalogue as soon as you activate the catalogue.

Activating a catalogue for an existing export:

  1. Go to Data » Catalogues.
    → The catalogues are listed.

  2. Find the row of the catalogue and move the toggle button () in the Active/Inactive column to the right.
    → The catalogue is active.
    → The data is transmitted to Amazon once a day at night.
    Tip: If incorrect data was transmitted to Amazon during the automatic export, you can correct the mappings in the catalogue, export a CSV file of the catalogue and then manually upload the file to Amazon.

6.2. Activating a catalogue for a new export

When you create a catalogue for a Amazon account, platform and flatfile that you are not currently using already, some additional settings are necessary.

Activating a catalogue for a new export:

  1. Go to Data » Catalogues.
    → The catalogues are listed.

  2. Find the row of the catalogue and move the toggle button () in the Active/Inactive column to the right.
    → The catalogue is active.

  1. Also check the settings listed below.

Carry out the following settings in the assistant Base settings - Amazon bevor activating the export of a new catalogue.

Settings for new catalogues in the assistant Base settings - Amazon:

  1. Go to Setup » Assistants » Omni-Channel.

  2. Click on Base settings - Amazon.

  3. Open the assistant for the Amazon account.
    → The assistant opens.

  4. Carry out the settings as described in Table 1.

  5. Complete the assistant.

Table 1. Settings for new catalogues in the assistant
Setting Explanation

Step Basic settings

Select the Amazon platforms that you would like to sell your items on.

The platforms specified for the catalogue must be activated.

Step Activate Amazon user account

Activate user account

The Amazon user account specified for the catalogue must be active.

Step Automatic data transfer

Select the Amazon platforms that your item data should be transferred to.

The variation export for the Amazon platforms must be active.
Note: The step Automatic data transfer is only visible after you activate the option Show extended settings in the step Marketplace setup.

Carry out the following settings before you activate the export for a new catalogue.

Settings in the setup menu:

  1. Go to Setup » Markets » Amazon » Settings.

  2. Select the Amazon account.

  3. Carry out the settings described in Table 2.

  4. Save () the settings.

Table 2. Settings for new catalogues in the menu
Setting Explanation

Tab Settings

Active

In the Access data area, place a check mark for the option Active.

Tab Item settings

Item export

From the drop-down list, select the option Daily.

Export categories;
BMVD export categories

Activate the flatfiles that you created a catalogue for.


7. Troubleshooting

I mapped fields incorrectly and exported incorrect data to Amazon as a result. What can I do?

First, correct the incorrect mappings in the catalogue. The data is transmitted to Amazon once a day at night.

I have switched from my old, reliable export to the new catalogues and it’s not working correctly. What can I do?

Don’t panic. Go to the Data » Catalogues menu and set the catalogue to inactive. Your variation data is transmitted to Amazon with the old export and you can check and correct your settings. Our support team is here to help you if you run into problems or have questions.

8. Next steps

You have set up the interface to Amazon and have prepared your variations and the export. What to do next depends on the additional Amazon services that you want to use:

If you want to use the FBA service by Amazon:

If you want to use additional Amazon services:

If something went wrong:


To top