Documentation Home

Options Format

Header Name Supported Import Types Implementation Class Value Format
options Sku SkuRecordPersistenceProcessor <product-option>[option-type]:<option-value>\

Below is an example import of shoes with different product options. The first line after the header is the parent product for
the other Skus below. The records after have their product column set which indicates that they will be inserted as a Sku.

externalId,product,retailPrice,name,manufacturer,longDescription,options,parentCategories,url,recencyType,defaultCategory,activeStartDate,canSellWithoutOptions
brooks-ravenna-99,,90.00,Brooks Ravenna 99,Brooks,,,shoes,/brooks-ravenna-99,NEW,shoes,2016.01.01 12:00:00,false
brooks-ravenna-99-1,brooks-ravenna-99,,,,,Size[SIZE]:6|Width[SELECT]:B|Color[COLOR]:Capri/Celestial/Diva Pink,,,,,,
brooks-ravenna-99-2,brooks-ravenna-99,,,,,Size[SIZE]:6.5|Width[SELECT]:B|Color[COLOR]:Capri/Celestial/Diva Pink,,,,,,
brooks-ravenna-99-3,brooks-ravenna-99,,,,,Size[SIZE]:7|Width[SELECT]]:B|Color[COLOR]:Capri/Celestial/Diva Pink,,,,,,
brooks-ravenna-99-4,brooks-ravenna-99,,,,,Size[SIZE]:7.5|Width[SELECT]:B|Color[COLOR]:Capri/Celestial/Diva Pink,,,,,,
brooks-ravenna-99-5,brooks-ravenna-99,,,,,Size[SIZE]:6|Width[SELECT]:B|Color[COLOR]:White/Raspberry/Paradise Green,,,,,,
brooks-ravenna-99-6,brooks-ravenna-99,,,,,Size[SIZE]:6.5|Width[SELECT]:B|Color[COLOR]:White/Raspberry/Paradise Green,,,,,,
brooks-ravenna-99-7,brooks-ravenna-99,,,,,Size[SIZE]:7|Width[SELECT]:B|Color[COLOR]:White/Raspberry/Paradise Green,,,,,,
brooks-ravenna-99-8,brooks-ravenna-99,,,,,Size[SIZE]:7.5|Width[SELECT]:B|Color[COLOR]:White/Raspberry/Paradise Green,,,,,,
tube-socks,,9.99,Tube Socks,Nike,,,socks,/tube-socks,NEW,socks,2016.01.01 12:00:00,true

Let's take one of the values for options, Size[SIZE]:6|Width[SELECT]:B|Color[COLOR]:Capri/Celestial/Diva Pink. This does the following:

  • Looks for a Product Option with the name Size with the option type of SIZE. If one does not exist, it is created
  • Looks for a Value in the Size Product Option for 6. If one is not found, it is created and associated to the Size Product Option
  • Associates the 6 value to the Sku
  • Looks for a Product Option with the name Width and an option type of SELECT. If one does not exist, it is created
  • Looks for a Value in the Width Product option for B. If one does not exist it is created and associated to the Width Product option
  • Associates the B value to the Sku
  • Looks for a Product Option with the name Color and an option type of COLOR. If one does not exist, it is created
  • Looks for a Value in the Color Product option for Capri/Celestial/Diva Pink. If one does not exist it is created and associated to the Color Product option
  • Associates the Capri/Celestial/Diva Pink option value to the Sku