File details: combined_merchant_product_offer.csv

Edit on GitHub

This document describes the combined_merchant_product_offer.csv file to configure Merchant product offer information in your Spryker shop.

To import the file, run

data:import --config data/import/common/combined_merchant_product_offer_import_config_{store}.yml
Info

See Importing Data with a Configuration File to learn more about bulk importing with the help of the configuration file.

Import file parameters

The file should have the following parameters:

PARAMETER REQUIRED? TYPE DEFAULT VALUE REQUIREMENTS OR COMMENTS DESCRIPTION
product_offer_reference String Unique Identifier of the merchant product offer in the system.
merchant_product_offer.concrete_sku String Unique SKU of the concrete product the offer is being created for.
merchant_product_offer.merchant_reference String Unique Identifier of the merchant owing the product offer in the system.
merchant_product_offer.merchant_sku String Unique Identifier of the merchant in the system.
merchant_product_offer.is_active Integer 1—is active
0—is not active
Defines whether the offer is active or not.
merchant_product_offer.approval_status String Can be:
  • waiting_for_approval
  • approved
  • denied
Defines the status of the offer in the system.
merchant_product_offer_store.store_name String Name of the store where the offer belongs.
product_offer_stock.stock_name String Stock name is defined as described in the merchant warehouse. Name of the stock.
product_offer_stock.quantity Integer Number of product offers that are in stock.
product_offer_stock.is_never_out_of_stock Integer 1—option is enabled
0—option is disabled.
Allows the offer to be never out of stock.
price_product_offer.price_type String Can be DEFAULT or ORIGINAL. Price type of the product offer.
price_product_offer.store String Value previously defined in the stores.php project configuration. Store where the merchant product offer belongs.
price_product_offer.currency String Defined in the ISO code. Currency of the price.
price_product_offer.value_net Integer Empty price values will be imported as zeros. Net price in cents.
price_product_offer.value_gross Integer Empty price values will be imported as zeros. Gross price in cents.
price_product_offer.price_data.volume_prices Array Price data which can be used to define alternative prices, i.e volume prices, overwriting the given net or gross price values.
product_offer_validity.valid_from Datetime Date and time from which the offer is active.
product_offer_validity.valid_to Datetime Date and time till which the offer is active.

Import file dependencies

The file has the following dependencies:

  • merchant.csv
  • stores.php configuration file of the demo shop PHP project

Import template file and content example

Find the template and an example of the file below:

FILE DESCRIPTION
template_combined_merchant_product_offer.csv Import file template with headers only.
combined_merchant_product_offer.csv Example of the import file with Demo Shop data.