How to upload all list items from the worksheet

How to upload all list items from the worksheet

This feature is available starting from version 2.3.0  Using this feature you can upload multiple items in List, Radio Group and Image List fields from a spreadsheet file without adding each item manually. 

Upload your spreadsheet file 

To upload your spreadsheet file in order to add items for input fields like List, Radio Group and Image List, you have to go the way you create a normal field. Inside the specified fields, the button Import from file let you upload the spreadsheet of the calculator in xls, xlsx or ods format. 

The basic structure of the spreadsheet file 

The structure of the file should be specified as below:   
  • In column A, Value1 => is the string label to be shown to the customer. 
  • In column B, One => is the value used by the plugin to do the calculation in the background. 
  Important noteData must start at the first row and first column, otherwise the plug-in would not be able to get the data from the spreadsheet file.  The file structure could be different if you want to import items on List field, Radio Group field or Image List field: 

Spreadsheet structure for List field 

An item of a list input field can contain up to 4 attributes and should be placed in the spreadsheet file in this manner: 
  • Column C: It must contain the “Default Option” attribute, as shown in the picture it can take only the string ‘Yes’ or ‘No’ everything else would not take effect. It can also be blank. 
  • Column D: It must contain the Order Details, this attribute can contain every type of data. Its purpose is to give more information to the user on the product page for the selected option. It can be left blank as well. 

Spreadsheet structure for Radio Group 

An item of a radio-group input field can contain up to 7 attributes and should be placed in the spreadsheet file in this manner: 
  • Column C: It must contain the “Default Option” attribute, as shown in the picture it can take only the string ‘Yes’ or ‘No’ everything else would not take effect. It can be left blank as well. 
  • Column D: It must contain the “Order Detail”, this attribute can contain every type of data. Its purpose is to give more information to the user on the product page for the selected option. It can be left blank as well. 
  • Column E: It must contain the label position related to the radio button. It can take only two values ‘right’ or ‘left’ everything else would not take effect. It can be left blank as well. 
  • Column F: It must contain the pop-up message for the purpose of additional information for the user on the product page. It can be left blank as well. 
  • Column G: It must take the path of the image to be associated with the radio button. The path must be absolute. You can let it blank as well. 

Spreadsheet structure for Image List 

An item of a radio-group input field can contain up to 5 attribute and should be placed in the spreadsheet file in this manner: 
  • Column C: It must contain the “Default Option” attribute, as shown in the picture it can take only the string ‘Yes’ or ‘No’ everything else would not take effect. It can be left blank. 
  • Column D: It must contain the “Order Detail”, this attribute can contain every type of data. Its purpose is to give more information to the user on the product page for the related options to select. It can be left blank. 
  • Column E: It must take the path of the image to be associated with the radio button. The path must be absolute. Be careful it is a required column. 

Upload page 

Below is a screenshot how the upload form will look like:  After you have chosen the file click Import button. If the file structure is correct you will show the next page:  Here you can see created items and you can change the items as well. After that click the Save button.