Page History

...

One can create and maintain most of the product information via Excel product import, and if one exports product information as Excel first, it is easy to import it back with changes.

In addition to product information feed supports import and export of other information as well. 

...

In general on import these rules apply when mapping Excel column to corresponding feed field:

• feed header selection values expect the feed import key on line level. 
• Text that is language dependent requires language to be selected on import.
• Integer and float numbers will give errors on values containing unexpected characters. 
• An Integer attribute will give errors on importing float numbers. 
• Import of Data register line values expect the feed import key for the line, not the value (text name). 
• Data register multiple expect feed import key line with comma separation to add multiple values.
• Dates uses the following format: DD.MM.YYYY
• Checkboxes expects: TRUE or FALSE 
• To delete a value in text or attribute, import with the value: [DELETE]
  • [DELETE] can also be used to remove media in feed, but only when they are not in use. 
  • [FORCE_DELETE] is a special command for media import, where you want to delete media that is connected to products. 

...