MMS Marketplace Logo

Offer file Creation and Update

Save time and effort by importing files

Offer file creation 2

Offer File Creation

Follow this simple steps

How to create an offer with a file?

Download the marketplace offer template in the backoffice​

Click on: Price & Stock > File Imports​

  1. Navigate to the "Offers" section and choose "Excel template." This action will initiate the download of the global offer template.​

offer file creation

Fill the offer template​

Note that for certain columns, you need to input a value that already exists in our predefined value list.​

You have the option to fill in these columns using the dropdown list that becomes visible when you click on a cell, or you can utilize the information from the "Reference Data" sheet.

offers

Mandatory fields in the Offer File

  • Offer SKU​: The offer’s unique identifier in the shop. Only this value (and the global Marketplace SKU) is provided when retrieving orders (API OR11). As a common practice, we recommend setting the SHOP_SKU as the offer SKU to ensure a smooth process.​

    If you do not select the Offer-SKU, you will automatically be assigned a random number (e.g. S02828). Required: YES - Type: TEXT

  • Product ID: Reference with which product the offer should be linked. This can be, for example, the EAN, shop SKU, or global SKU. A shop SKU is only available if a product integration has already been performed for the product. The easiest approach here is to simply insert the EAN numbers. Required: YES - Type: TEXT

  • Product ID Type​: This attribute is the input for the type of value in the "product-id" column that you have chosen. Valid inputs are EAN, SKU, SHOP_SKU. Required: YES - Type: LIST

  • Offer Price: The price of the offer including taxes.​ Required: YES - Type: INTEGER

  • Offer Quantity​: Quantity is optional for creating your offer in our listing. The offer will only become fully activated and visible in the webshop, when stock is also available. Required: NO - Type: INTEGER

  • Offer State​: The state of the offer.​ Required: YES - Type: LIST

  • Strike-Price-Type​: Type of the price which will be stroke through when a discount price is defined.​ This attribute is required, even if no discount price is set. Required: YES - Type: LIST

Optional fields in Offer File

  • Logistic Class​: The logistic class assigned to the offer (this will override the default logistic class). It is essential that at least one logistics class is active. Please see the "Store Setup" guide for more information. Required: NO - Type: LIST

  • Discount Price​: The reduced price of the offer.​ Required: NO - Type: INTEGER

  • Discount Start Date​: The initial day when the discount becomes accessible (if left blank, the discount has no starting date and is instantly active). Required: NO - Type: DATE

  • Discount End Date​: The final day when the discount is accessible (if left blank, the discount has no ending date - optional). Required: NO - Type: DATE

  • Minimum Quantity Alert: The lowest quantity that triggers a stock alert.​ Required: NO - Type: INTEGER

  • Leadtime to Ship​: The value must be a positive integer and must not exceed the limit of 45 days.​ Required: NO - Type: INTEGER

  • WEEE take back obligation: Indicates whether the assigned product falls within a WEEE directive category.​ If set to "true," this will provide additional information for the customer during the webshop checkout. Required: NO - Type: LIST

Offer File Import

Click on: Price & Stock > File Imports​

After finishing your file template, save it and:​

  1. Upload the Excel file containing your offer information from your computer.​

  2. Select the file content as "Offers."​

  3. Select the import mode:​

    • Normal: Use this for the import to create, update or delete data.​

    • Delete and replace: Delete existing data and replace it with data from the imported file (Replacement Mode). This mode is used, for example, for a regular full synchronization.

offer file import

Monitoring Offer File Imports​

Click on Price and Stock > File Imports > Track Offer Imports

  1. Track all imports of your offers.​

  2. Access the error reports that can help you comprehend how to correct issues in your offer files. Visit the troubleshooting page for the most common errors on offer imports​

Monitoring offer file imports

Offer File Update

Follow this simple steps

How to update your offer with a file?

You have the option to generate two file types from your list of offers.​

  1. "Offer Export" contains category and product-related details.​

  2. The "Ready to Import" inventory file follows the format of our "Offer File Template." Insert ONLY the criteria that require updates, like stock and price. You can import the file as usual through the "Import a File" page.​

Offer file update

Error Troubleshooting