Field mapping allows you to match your field names or headings to be imported to OpenCart’s available fields. The CSV column headings or the XML tag names do not have to match OpenCart’s fields.
Also, there is no minimum number of fields that must be inputted, so any or all fields can be left blank—these fields will be given sensible default values in each product where required.
If you wish to deliberately overwrite a field to a null value (for example, you wish to remove the special price of the products), reference a field that is empty in your file. This way the module will import the empty value as the new special price and thus ‘delete’ the existing special price.
Product Status: This takes a binary value 0/1 but can also handle disabled/no/off and will treat other values as 1
Category: Products can be imported with nested categories (e.g., “Computers > Desktop”); add sub-category fields by clicking the More è button and adding a vertical column. Multiple categories can be added for products by selecting the More ê button creating another row. This allows products to belong to more than one category (e.g. “DVDs” and “Digital files”)
Attribute: Product attributes can be imported—reference the attribute’s name (e.g., from the example in the “XML Format”, enter “type” without quotation marks). The field name will be used for the Attribute name, and the value in the field for each product will be used for the Attribute value.
If you wish to import a particular attribute structure you can do this by using a ':' separated list in your attribute field. This is then imported as '<group_name>:<attribute_name>:<attribute_value>' and creates the appropriate attribute group, attribute name and attribute value.
Options: Product options can be imported – see the section below on Product Options for the exact requirements for successful import. Use the More button to add multiple product options.
Image: This field takes the path to an image on your server. E.g 'data/image.jpg'. If you enabled 'Download Remote Images' in Step 2 this field can also take a URL to the location of the image.
Additional Images: Additional images can be imported – simply reference the field, using the More button to add multiple additional image fields.