Skip to main content

REWE

REWE marketplace closes down on 31/12/2021

REWE will close down their marketplace on the 31st of December 2021. After this date, the platform is expected to be operated until the 31st of January2022. Orders must be processed until the 31st of January2022. Existing customers can contact REWE for more details.

As such, the information on this page is now only relevant for existing customers.

1. Overview of automatic data exchange

After installing and setting up the plugin, the automatic processes described in Table 1 are available:

Table 1. Frequency of data exchange
Data Interval

Item export

once a day

Stock synchronisation

Every 15 minutes

Price synchronisation

Hourly

Order import

Every 15 minutes

2. Activating the automatic data exchange

Open the Setup » Markets » REWE » Basic Settings menu to set up the market REWE in plentymarkets. Activate the item export, the stock and price synchronisation, and the order import in this menu so that data is exchanged with REWE automatically.

Activating the automatic data exchange:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. Activate the following options to activate the automatic data exchange with REWE:

    • Item export

    • Stock and price update

    • Order import

  3. Save () the settings.

3. Defining stock export

By default, the stock information for each variation is exported based on the option you selected for the Limitation setting. You can also ignore this setting and instead export the actual net stock for all variations to REWE.

Defining stock export:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. Select an option for Export stock. Pay attention to the explanations given in Table 2.

  3. Save () the settings.

Table 2. Defining stock export
Setting Explanation

Export stock

Select how stock is to be exported.

Consider variation setting 'Limitation'
(default setting)

Stock is exported as specified for each variation. Stock limitation is managed in the Item » Edit item » [Open item] » [Open variation] » Variation tab: Settings » Area: Availability menu using the option Limitation.
Note: For variations for which the Limitation setting is set to Do not administer stock for this variation, a stock of 1000 is exported to REWE.

Export actual net stock

The stock Limit setting is ignored for all variations during export to REWE. Instead, the actual net stock is exported to REWE for each variation. You can check the actual net stock in the Item » Edit item » [Open item] » [Open variation] » Variation tab: Stock » Tab: Stock menu in the column Net.
Note: For variations for which the Limitation setting is set to Do not administer stock for this variation, a stock of 0 is exported to REWE. As such, the variation cannot be bought on REWE.
Tip: The net stock is the quantity of a variation that is available for sale. The net stock is a subset of the physical stock. Substract all reserved quantities from the physical stock and you will get the net stock.

4. Defining a sales price

Sales prices define the conditions under which a variation is sold at a specific price and on a specific sales channel. That means that to sell variations on {referrer}, you need a sales price in which the order referrer {referrer} is activated. The price that you save for this sales price is the price that will be shown on {referrer}.

Defining a sales price for {referrer}:

  1. Go to Setup » Item » Sales prices » [Open sales price].
    Tip: No sales prices? Then create a new sales price first.

  2. Open the Settings tab.

  3. Activate the referrer {referrer}.

  4. Save () the settings.

5. Managing promotion prices

You can export promotion prices that are valid for a specific period.

The promotion price is not started and ended on REWE automatically. The promotion price is only started and ended when you edit the price that is saved for the REWE special offer price in plentymarkets.

5.1. Defining a promotion price

Prerequisites for correctly exporting promotion prices:

  • You have created a sales price of the type Special offer.
    Tip: Do not forget to activate the referrer REWE for this special offer price.

  • You have mapped the following data fields in the REWE catalogues:

    • Marketplace data field Promotion price plentymarkets sales price of the type Special offer

    • Marketplace data field Promotion starts = plentymarkets property REWE promotion price start date

    • Marketplace data field Promotion ends = plentymarkets property REWE promotion price end date

Defining a promotion price:

  1. Link the sales price of the type Special offer to the variation.

  2. Save a price for the special offer price.

  3. Link the variation with the property REWE promotion price start date.

  4. Save a date for the property.
    Important: The promotion price is not started automatically on this date.

  5. Link the variation with the property REWE promotion price end date.

  6. Save a date for the property.
    Important: The promotion price is not ended automatically on this date.

  7. Set yourself a reminder for the start date and the end date. On these days, you need to start and end the promotion price yourself.

5.2. Starting the promotion price on the start date

On the start date, you need to change the price that you saved for the REWE special offer price in plentymarkets. This updates the prices on REWE and starts the promotion price.

There are several ways of changing the prices. Here, we show you two examples based on the number of variations for which you want to start promotion prices.

  1. Open the variation.

  2. Change the amount for the promotion price. For example, change the last decimal point of the amount.

  3. Save the change.
    → The promotion price for the variation is started on REWE.
    Tip: You can change back to the original price straight way. The change only serves to update the price on REWE.

  1. Open the variation group function.

  2. Carry out a price change for the promotion price. For an example, see the screenshot below.

  3. Execute the variation group function.
    → The promotion price is started for all variations that have reached or exceeded the start date saved in the property REWE promotion price start date.
    Tip: You can change back to the original price straight way. The change only serves to update the price on REWE.

rewe promotion price example
Figure 1. Price change: Increase by one cent for all REWE special offer prices

5.3. Ending promotion prices on the end date

On the end date, you need to change the price that you saved for the REWE special offer price in plentymarkets. This updates the prices on REWE and ends the promotion price.

There are several ways of changing the prices. Here, we show you two examples based on the number of variations for which you want to end promotion prices.

  1. Open the variation.

  2. Change the amount for the promotion price. For example, change the last decimal point of the amount.

  3. Save the change.
    → The promotion price for the variation is ended on REWE.
    → The normal sales price is shown as the new price.
    Tip: You can change back to the original price straight way. The change only serves to update the price on REWE.

  1. Open the group function.

  2. Carry out a price change for the promotion price. For an example, see the screenshot below.

  3. Execute the group function.
    → The promotion price is ended for all variations that have reached or exceeded the end date saved in the property REWE promotion price end date.
    → The normal sales price is shown as the new price.
    Tip: You can change back to the original price straight way. The change only serves to update the price on REWE.

rewe promotion price example
Figure 2. Price change: Increase by one cent for all REWE special offer prices

6. Setting the commission

Commission settings are optional

The settings for the commission for REWE are optional. If you do not set a commission, orders will be imported into plentymarkets with the sales prices that are displayed at REWE.
If no commission is set, prices will also be displayed without commission on the delivery note.

The standard commission is set up in the Setup » Markets » REWE » Basic settings menu. The commission serves to calculate the order sums free of commission.

Order sums free of commission are calculated with this formula:

  • Sales price REWE = Sales price customer * (1 - conversion factor)

  • Conversion factor = Commission * (1 + VAT rate)

For the calculation, the percentages for commission and VAT rate are converted into the corresponding factor, that is, divided by 100. The conversion factor is rounded to 3 decimal places.

Setting the commission:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. In the Commission area, enter a number for the commission in percent.

  3. Save () the settings.
    → The commission is the default commission for all items except for any variations for which a separate commission was set up.

You can set up a separate commission for variations. To do so, use the REWE commission variation property. The variation property REWE commission is created automatically when the REWE plugin is installed. In order to set up a separate commission for a variation, link the variation to the variation property REWE commission.

Setting up a separate commission for variations:

  1. Go to Item » Edit item.

  2. Open the item.

  3. Click on the Variations tab.

  4. Open the variation that you would like to set up a separate commission for.

  5. Open the variation’s Properties tab.

  6. From the Properties drop-down list, select REWE commission.

  7. Click on Add ().
    → The property is linked to the variation.

  8. Enter a whole number or a decimal number into the Value field for the commission in percent.

  9. Save () the settings.

7. Activating the order referrer

An order referrer tags an order with the sales channel on which the order was generated. You also need to activate the order referrer in order to link items, characteristics etc. with REWE. Go to Setup » Orders » Order referrer to activate the order referrer.

Activating the order referrer for REWE:

  1. Go to Setup » Orders » Order referrer.

  2. Activate the option Rewe.

  3. Save () the settings.

8. Setting the variation availability

You need to activate the variations that you want to sell on REWE. This is done in the Availability tab of a variation within the Item » Edit item » [Open item] » [Open variation] menu.

Making a variation available for REWE:

  1. Go to Item » Edit item » [Open item] » [Open variation].
    → The tab Settings of the variation is shown.
    Tip: To sell all variations of an item on REWE, carry out the settings for the item’s main variation. This activates the availability of all variations of the item.

  2. In the Availability area, activate the option Active.

  3. Click on the Availability tab.

  4. In the Markets area, click in the selection field.
    → A list of all available markets is displayed.

  5. Activate the option REWE.

  6. Click on Add ().
    → The market is added.

  7. Save () the settings.
    → The variation is available for REWE.

The variation group function allows you to edit several variations at once. You select the variations that you want to edit.

Making several variations available for REWE using the variation group function:

  1. Go to Item » Edit item.

  2. Set the filter Table type to Variations.

  3. Choose additional filters on the left if needed and click on Search ().

  4. Select () the variations to be edited from the overview on the right.

  5. Click on Variation group function.
    → The Variation group function window opens.

  6. Navigate to the area Market availability.

  7. Activate the checkbox to the left of the option REWE.

  8. Activate the checkbox to the right of the option REWE.

  9. Navigate to the area Availability.

  10. Activate the checkbox to the left of the option Active.

  11. Activate the checkbox to the right of the option Active.

  12. Click on Execute to apply the settings.

Batch processing allows you to edit several variations at once. You use filters to limit which variations are edited.

Making several variations available for REWE using batch processing:

  1. Go to Item » Batch processing.

  2. Click on the tab Variations in the upper left corner.

  3. Use the filters on the left to specify which variations should be processed.

  4. Navigate to the area Market availability.

  5. Activate the checkbox to the left of the option REWE.

  6. Activate the checkbox to the right of the option REWE.

  7. Navigate to the area Availability.

  8. Activate the checkbox to the left of the option Active.

  9. Activate the checkbox to the right of the option Active.

  10. Click on Apply to apply the settings to the variations.

9. Linking variations with the property REWE product type

Variations that you want to sell on REWE have to be linked with the REWE product type variation property. This variation property is created in your plentymarkets system as soon as you have installed the REWE plugin. Examples for REWE product types are:

  • Household

  • Garden

  • Fashion

Linking variations with the property REWE product type:

  1. Go to Item » Edit item » [Open item] » [Open variation] » Tab: Settings.
    Tip: To link all variations of an item, carry out these settings for the main variation. The settings are passed on to all variations of the item.

  2. In the Variation properties, click into the field Properties.

  3. Activate the property REWE product type.

  4. Click on Add ().
    → The property is added to the property list.

  5. Select an appropriate value from the drop-down list.
    → The REWE product types can be selected.

  6. Save () the settings.

10. Setting up the item export

Item data is exported to REWE via catalogues. The assistant Creating REWE catalogues helps you to create a catalogue for a specific product category.

For further information about the plentymarkets data fields that can be linked, refer to the Mapping data fields chapter.

Items cannot be deleted on commercetools

Items cannot be deleted on commercetools, neither by plentymarkets nor by REWE or commercetools. Therefore, make extra sure that the correct data fields are mapped in the catalogue prior to transferring your items.

At present, the REWE plugin allows you to create catalogues for the following REWE product categories:

  • AFG (Soft Drinks)

  • Alcoholic beverages

  • Baby Supplies

  • Books and Magazines

  • Drugstore

  • Fashion

  • Leisure/sports

  • Garden

  • Household

  • Multimedia

  • Contact Lenses

  • Food
    Information for the food product category:

    • Food specifications must always be made for 100g.

    • Energy information must be provided in kcal.

    • If the Nutrition information for prepared and non-prepared foods field is not mapped, the value non-prepared is transferred to REWE by default.

  • New Media (DVD etc.)

  • Stationary

  • Sets

  • Toys

  • Pet supplies

10.1. Notes on the REWE item data structure: product groups and variations

REWE differentiates between product groups and variation groups.

Product group

  • The variations look different.

  • As a result, every plentymarkets variation has its own images.

  • Product group attributes are attributes that influence how the product looks

Examples:

  • An item is sold in different colours and/or with different prints.

  • An item is sold in different sizes and the packaging for each size is different.

In plentymarkets:

In plentymarkets, product groups are items with variations with at least one REWE group attribute, depending on the product type.

Example for attribute:

For the product type Food, the following Attributes for product group are available (as of 05/2021):

  • Flavour

  • Package size

  • Variety

Notes on mapping data fields:

Items in plentymarkets can have more than one REWE group attribute. However, only one REWE group attribute can be used to form product groups. Therefore, the Attribute for product group field has to be matched so that the first attribute will always be the attribute that you want to use to form a product group. If an item differs in colour and print and the print should be used as the REWE group attribute, you first have to map the print in the marketplace data field Attribute for product group and only then map the colour.

Tip:

The REWE group attributes for each product type are available in the catalogue templates. To do so, open the drop-down list Attribute for product group in the marketplace format.

Variations

  • The variations look the same.

  • As a result, the images for all variations are identical.

  • Variation attributes are attributes that do not influence how the product looks.

Examples:

  • An item is available in different sizes. All sizes look the same.

  • An item is available in different package sizes. However, the images are identical for all variations.

In plentymarkets:

In plentymarkets, variations are variations of an item no more than one REWE variation attribute, depending on the product type.

Example for attribute:

For the product type Food, the following Attributes for variation group are available (as of 05/2021):

  • Diameter

  • Dimensions

  • General size

Notes on mapping data fields:

  • For REWE variation attributes, only one variation attribute can be set, for example only size or only volume.

  • An item should not be linked to more than one attribute which was assigned as REWE variation attribute in the catalogue.

Tip:

The REWE variation attributes for each product type are available in the catalogue templates. To do so, open the drop-down list Attribute for variation group in the marketplace format.

10.2. Creating a catalogue in the assistant

Creating a catalogue in the assistant:

  1. Open the menu Setup » Assistants » Plugins » [Open client].

  2. Click on the assistant Create REWE catalogue.

  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 product category.

Step Settings
Setting Explanation

Select the REWE product category that should be added to the catalogue.

Select a product category from the drop-down list.
Note: You need a separate catalogue for each product category.

Enter a name for the REWE catalogue.

Enter a name for the catalogue. The catalogue will be listed under this name in the Data » Catalogues menu.

Step Mapping basic data fields

In this step of the assistant, you decide which variation data saved in plentymarkets you want to send to the market. To do so, you are going to map each data field of the market with the plentymarkets data field that contains the data that you want to export to the market. Instead of mapping an existing data field, you can also instead create a new data field for some fields.


SKU = From the drop-down list, select the data field in plentymarkets that contains the SKU.
Recommendation: The variation ID is unique for each variation. Map the marketplace data field SKU to the plentymarkets data field Variation ID.
Note: Do not change the SKU and Parent SKU of a variation once the variation has been created on commercetools.


Select data field = A data field that already exists in plentymarkets will be exported to REWE. Select a data field from the drop-down list Data field.
Note: The mappings you create will not be checked in terms of logic. As such, check your mappings carefully before starting the export.


Create property = Creates a property and maps this property to the data field. Properties can be used to export values for data fields that have no corresponding item data saved in plentymarkets, such as Diameter.

Automatically created property will be saved in the Setup » Settings » Properties » Configuration menu.

Automatically created properties are created with the following settings:

  • Section = Item

  • Type = depending on the market data field

  • Language = German

  • Name = Name of the product category

  • Group = REWE


Creating a sales price = Creates a sales price and maps this sales price to the data field. You can check and edit automatically created sales prices in the Setup » Item » Sales prices menu.

Automatically created sales prices are created with the following settings:

  • Subscription interval = None

  • Internal name = REWE

  • External name = REWE

  • Minimum quantity = 1

  • Live conversion = No

  • Currency = Euro

  • Display = Always display for new items

  • Client = ALL

  • Class = ALL

  • Country = Germany


Create barcode = Creates a barcode REWE and maps this barcode to the data field. If a barcode with the name REWE already exists in the system, that barcode is mapped instead. You can check and edit automatically created barcodes in the Setup » Item » Barcodes menu.

10.3. Mapping additional data fields in the catalogue (not in assistant)

You have already mapped important mandatory fields for the REWE product category in the assistant. However, after you have completed the assistant, you need to map additional data fields to send more information regarding your products to REWE.

Mapping catalogue fields:

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The Mapping tab opens.
    → 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:

    • 1:1 mapping

    • 1:1 mapping with fallback data fields

    • 1:n mapping

    • Own value mapping

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

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

In a 1:1 mapping, you map a plentymarkets data field to the marketplace data field.

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 for a variation, no value is exported for this variation.

Creating a 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.

1:1 mapping with fallback data fields: 1 marketplace data field, 1 plentymarkets data field with alternatives

In a 1:1 mapping with a fallback data field, 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 a fallback data field:

  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 map one or more fallback data fields to a marketplace data field, only one value is exported for each variation. For each variation, the 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.

1:n mapping: 1 marketplace data field, several concatenated 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.

10.4. Particularities for mapping data fields

Every market structures item data differently. As such, there are some particularities for each market when mapping data fields. Table 3 contains mapping information for important data fields for REWE.

Table 3. Notes on mapping data fields
Marketplace data field plentymarkets data field

SKU

We recommend to link the data field SKU with the plentymarkets data field Variation ID because the variation ID is clearly assigned to the variation.
Note: Do not change the SKU and Parent SKU of a variation once the variation has been created on commercetools. If you change the SKU or the Parent SKU later, the variation will no longer be updated on commercetools.

Attribute for product group

As described above, REWE distinguishes between product bgroups and variation groups.

Reminder: You need a REWE product group if the variations of an item have different images because they look different. Product group attributes are attributes that influence how the product looks.

As such, you would pap the following plentymarkets data field to the marketplace data field Attribute for product group:

  • Alternative 1: An attribute that changes the look of the variations

  • Alternative 2: A property that changes the look of the variations

Of course you can also map fallback data fields. This might be necessary if you use both attributes and properties in plentymarkets for the data that you want to export for the marketplace data field Attribute for product group.

Example 1: Mapping colour information for product type "Fashion"

The following example describes how you can map colour information in a catalogue for the product type "Fashion".

  • The colour changes how the variations look. Because of this, you specify the colours using the marketplace data field Attribute for product group.

  • In addition, the same plentymarkets data field must be mapped to the marketplace data filed Colour.

Summary for catalogue experts:

Mapping colour information for product type "Fashion":

  1. Map the following plentymarkets data field to this marketplace data field:

    • Alternative 1: Field Value name of the attribute for colour, language German

    • Alternative 2: Property for colour, language German

  2. Navigate to the area Attribute for product group.

  3. Map the following plentymarkets data field to the marketplace data field Attribute for product group:

    • Alternative 1: The same attribute for colour

    • Alternative 2: The same property for colour

Detailed description for first-time catalogue users:

The following two descriptions illustrate the settings in detail:

  • How to map an attribute for colour

  • How to map a property for colour

Mapping colour information in attributes for product type "Fashion":

  1. Open the REWE catalogue with the format Fashion.

  2. Navigate to the market data field Colour.

  3. Click on + Add data field.

  4. In the list of the data fields, click on the group Attribute.

  5. Click on the attribute.
    → Additional options are shown.

  6. Click on Value name.

  7. From the drop-down list underneath Value name, select the language German.

  8. Click on Confirm.
    → The plentymarkets data field is mapped.

  9. Navigate to the marketplace data field Attribute for product group.

  10. Click on the data field Attribute for product group.
    → The marketplace attributes are shown.

  11. Click on the marketplace attribute Colour.

  12. Click on + Add data field.

  13. In the list of the data fields, click on the group Attribute.

  14. Click on the plus sign to the right of the same attribute.

  15. Click on Confirm.
    → The plentymarkets data field is mapped.

Mapping colour information in properties for product type "Fashion":

  1. Open the REWE catalogue with the format Fashion.

  2. Navigate to the market data field Colour.

  3. Click on + Add data field.

  4. In the list of the data fields, click on the group Property.

  5. Click on the group with the property.
    → The properties of the group are shown.

  6. Click on the property.

  7. From the drop-down list underneath the name of the property, select the language German.

  8. Click on Confirm.
    → The plentymarkets data field is mapped.

  9. Navigate to the marketplace data field Attribute for product group.

  10. Click on the data field Attribute for product group.
    → The marketplace attributes are shown.

  11. Click on the marketplace attribute Colour.

  12. Click on + Add data field.

  13. In the list of the data fields, click on the group Property.

  14. Click on the group with the property.

  15. Click on the plus sign to the right of the same property.

  16. Click on Confirm.
    → The plentymarkets data field is mapped.

Example 2: Mapping package sizes for product type "Household"

The following example describes how you can map package size information in a catalogue for the product type "Household".

  • The packaging is different for the variations. Because of this, you specify the package size using the marketplace data field Attribute for product group.

  • In addition, the same plentymarkets data field must be mapped to the marketplace data filed General size.

Summary for catalogue experts:

Mapping package sizes for product type "Household":

  1. Open the REWE catalogue with the format Household.

  2. Navigate to the market data field General size.

  3. Map the following plentymarkets data field to this marketplace data field:

    • Alternative 1: Field Value name of the attribute for size, language German

    • Alternative 2: Property for size, language German

  4. Navigate to the area Attribute for product group.

  5. Map the following plentymarkets data field to the marketplace data field Attribute for product group:

    • Alternative 1: The same attribute for size

    • Alternative 2: The same property for size

Detailed description for first-time catalogue users:

The following two descriptions illustrate the settings in detail:

  • How to map an attribute for package size

  • How to map a property for package size

Mapping package sizes in attributes for product type "Household":

  1. Open the REWE catalogue with the format Household.

  2. Navigate to the market data field General size.

  3. Click on + Add data field.

  4. In the list of the data fields, click on the group Attribute.

  5. Click on the attribute.
    → Additional options are shown.

  6. Click on Value name.

  7. From the drop-down list underneath Value name, select the language German.

  8. Click on Confirm.
    → The plentymarkets data field is mapped.

  9. Navigate to the marketplace data field Attribute for product group.

  10. Click on the data field Attribute for product group.
    → The marketplace attributes are shown.

  11. Click on the marketplace attribute Package size.

  12. Click on + Add data field.

  13. In the list of the data fields, click on the group Attribute.

  14. Click on the plus sign to the right of the same attribute.

  15. Click on Confirm.
    → The plentymarkets data field is mapped.

Mapping package sizes in properties for product type "Household":

  1. Open the REWE catalogue with the format Household.

  2. Navigate to the market data field General size.

  3. Click on + Add data field.

  4. In the list of the data fields, click on the group Property.

  5. Click on the group with the property.
    → The properties of the group are shown.

  6. Click on the property.

  7. From the drop-down list underneath the name of the property, select the language German.

  8. Click on Confirm.
    → The plentymarkets data field is mapped.

  9. Navigate to the marketplace data field Attribute for product group.

  10. Click on the data field Attribute for product group.
    → The marketplace attributes are shown.

  11. Click on the marketplace attribute Package size.

  12. Click on + Add data field.

  13. In the list of the data fields, click on the group Property.

  14. Click on the group with the property.

  15. Click on the plus sign to the right of the same property.

  16. Click on Confirm.
    → The plentymarkets data field is mapped.

Promotion price;
Promotion starts;
Promotion ends

Use these marketplace data fields to export temporary promotion prices to REWE.
Note: You specify a start date and an end date for the promotion price for each variation. However, the promotion prices do not start and end automatically. Instead, you need to manually manage the promotion prices. (How?)

Offer price

Map a plentymarkets sales price of the type Special offer.

Promotion starts

Map the plentymarkets property REWE promotion price start date. This property of the type Date is automatically created in the property group REWE when you install the REWE plugin.

Promotion ends

Map the plentymarkets property REWE promotion price end date. This property of the type Date is automatically created in the property group REWE when you install the REWE plugin.

10.5. Example: Mapping the data field "Product description"

An example of how you can link the mandatory field Produktbeschreibung (product description) to data saved in plentymarkets is described below.

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The catalogue opens.

  3. For the REWE data field Product description, select a plentymarkets data field from the drop-down list.
    Example: Item text > Name 1, Name 2 or Name 3

  4. Link the other data fields in the same way. Link at least all mandatory fields.
    Tip: Mandatory fields are flagged with an asterisk (*).

  5. Save () the settings.
    → The content of the selected plentymarkets data field is shown as the product description on REWE.

11. Linking data fields created in the assistant with variations

If you selected the options Create sales price, Create barcode and/or Create property in the assistant, these prices, barcodes and/or properties are created automatically. You need to link these newly created data fields with the variations that you want to export to the market. This is described on the Item pages of the manual:

  • How to link Sales prices.

  • How to link Barcodes.

  • How to link properties and save a property value.
    Tip: Properties created in the assistant are automatically added to the property group REWE of the Setup » Settings » Properties » Groups menu. Open this group to see what new properties need to be mapped.

12. Activating the catalogue export to REWE

You have set up REWE and created a catalogue for exporting your item data? Then start the export of your item data.

Activating the catalogue export to REWE:

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

  2. Scroll to the REWE catalogue.

  3. In the Active/Inactive column, move the toggle button to the right ().
    → The catalogue is active.
    → The catalogue data is exported to REWE once a dayif the option Item export is activated in the Setup » Markets » REWE » Basic settings menu.

13. Matching shipping service providers

Shipping service providers saved in plentymarkets are matched with REWE shipping service providers in the Setup » Markets » REWE » Shipping service provider matching menu. If you do not match shipping service providers, then the shipping service provider unknown is sent to REWE.

Matching shipping service providers:

  1. Go to Setup » Markets » REWE » Shipping service provider matching.

  2. Select the REWE shipping service provider from the drop-down list.

  3. Save () the settings.

14. Matching reasons for return

Return reasons saved in plentymarkets are matched with REWE return reasons int the Setup » Markets » REWE » Return reason matching menu. If you do not match reasons for return, then the reason for return Other is sent to REWE. For further information about REWE reasons for return, refer to the seller documentation that you have received from REWE.

Linking return reasons:

  1. Go to Setup » Markets » REWE » Return reason matching.

  2. Select the REWE return reason from the drop-down list.

  3. Save () the settings.

15. Synchronising tax categories

If the tax categories were changed at REWE, you have to synchronise the tax categories in plentymarkets. Tax categories are synchronised with REWE in the Setup » Markets » REWE » Basic settings menu in the Tax categories area.

Synchronising tax categories:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. Go to the Tax categories area and click on Synchronise.
    → The tax categories are synchronised with REWE.

Last update indicates the last time the tax categories were synchronised with REWE.

Synchronise tax categories before switching to REWE live system

You need to synchronise the tax categories in plentymarkets before you switch from the REWE stage test environment to the live system. Otherwise, your item catalogue will not be exported. Enter your access data and the product key for the live system prior to switching to the live system. Afterwards, synchronise the tax categories. You have to map the tax categories again in your REWE catalogues after you synchronised them.

16. Manually synchronising brands

Brands are automatically synchronised with REWE once per day. Additionally, you can manually synchronise brands with REWE at any time. To do so, open the Setup » Markets » REWE » Basic settings menu.

Manually synchronising brands:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. In the Brands area, click on Synchronise.
    → The brands are synchronised with REWE.
    Tip: Last update indicates the last time the brands were synchronised with REWE.

17. Deactivating the creation of a contact

By default, REWE orders are always assigned to the contact and the invoice address of REWE. Activate the option Deactivate contact creation if you do not want to create a contact. Instead, only addresses are saved. Table 4 describes the differences between the two options.

Table 4. Deactivating the creation of a contact
Setting Explanation

Deactivating the creation of a contact

  • Option deactivated (default setting) = The creation of contacts is deactivated. When the first REWE order is imported, a contact is created for REWE. All other REWE orders are linked to this contact during the import. All invoice addresses are assigned to this contact.

    • In the order, the tab Contact is available.

    • The customer record can be retrieved via the search function of the CRM » Contacts menu.

    • The address records and the associated orders can be retrieved via the search function of the CRM » Quick search menu.

The order import in detail
  1. Check if an account already exists for REWE.

  2. If no account exists in the system, the account is created.

  3. Check if a contact already exists for REWE.

  4. If no contact exists in the system, the contact is created.

  5. If a new contact is created, the contact is linked to the account.

  6. Check if the invoice address already exists in the system.

  7. If the invoice address does not exist in the system, the invoice address is created.

  8. The invoice address is linked to the contact.

  9. The invoice address is linked to the order.

  10. A delivery address is created. There is no check if the delivery address already exists in the system. Also, the delivery address is not linked to the contact.

  11. The delivery address is linked to the order.

  • Option activated = The creation of contacts is deactivated. No contact is created when REWE orders are imported. Invoice address and delivery address are created and linked to the order.

    • The tab Contact is not available in the order.

    • The customer record cannot be retrieved via the search function of the CRM » Contacts menu.

    • The address records and the associated orders can be retrieved via the search function of the CRM » Quick search menu.

The order import in detail
  1. Check if the invoice address already exists in the system.

  2. If the invoice address does not exist in the system, the invoice address is created.

  3. The invoice address is linked to the order.

  4. A delivery address is created. There is no check if the delivery address already exists in the system. Also, the delivery address is not linked to the contact.

  5. The delivery address is linked to the order.

Deactivating the creation of a contact:

  1. Go to Setup » Markets » REWE » Basic settings.

  2. Navigate to the Order import area.

  3. Activate the option Deactivate contact creation.

  4. Save () the setting.
    → Only the invoice address and delivery address are created and linked to the order.
    → No contact is created.

18. Automatically updating the order status for REWE

Set up event procedures to automatically update the order status on REWE whenever specific events occur. You can set up the following event procedures:

  • Send out-of-stock status to REWE

  • Send buyer cancellation to REWE

  • Send seller cancellation to REWE

  • Send shipping preparation to REWE

  • Send shipping preparation completion to REWE

  • Send shipping confirmation to REWE

  • Send parcel delivery completion to REWE

  • Send return completion to REWE

An example of an event procedure you can use to report the shipping confirmation to REWE is described below. Set up other event procedures in the same way.

Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct Name for the event procedure.

  4. Select the Event according to Table 5.

  5. Save () the settings.

  6. Carry out the further settings according to Table 5.

  7. Activate the option Active ().

  8. Save () the settings.

Table 5. Event procedure for reporting order status to REWE

Setting

Option

Selection

Event

Order change: Status change

Select a status.

Filter 1

Order > Order type

Order

Filter 2

Order > Referrer

Rewe

Procedure

Plugin

Send shipping confirmation to REWE

Matching reasons for return

You need to match plentymarkets reasons for return with the reasons for return predefined by REWE. For example, when the event procedure Send return completion to REWE is triggered, a reason for return must be saved. For further information about matching reasons for return, refer to the chapter Matching reasons for return.

19. Information for REWE delivery periods

The variation availability in plentymarkets is assigned to delivery periods at REWE. An overview of the delivery periods at REWE and the corresponding plentymarkets availabilities can be found in Table 6.

Availability in case of errors

If an availability error occurs, the delivery period longer than 3 months is shown on the REWE marketplace.

Table 6. REWE delivery periods

plentymarkets availability

REWE delivery period

1

1-3 working days

2

ca. 3-6 working days

3

ca. 6-8 working days

4

ca. 8-10 working days

5

ca. 10-15 working days

6

ca. 15-20 working days

7

ca. 20-30 working days

8

ca. 30-40 working days

9

ca. 40-50 working days

10

ca. 50-60 working days

To top