How to Import Attributes into OpenCart?
Are you tired from adding attributes to OpenCart products one-by-one? There is the solution. Beginning from ver. 1.15.0 and higher of Store Manager for OpenCart - import of attributes and their values has been added.
You can import multiple attributes to OpenCart, associating them with new products you upload in the same file or updating existing in database goods with attributes.
Attribute Groups, Attributes and Attribute Values
Before getting down to the task itself, you need to clearly define for yourself that in OpenCart attributes can belong to certain group (a few attributes can be associated together) and when the attribute is added to product, it has got a value assigned.
Imagine you are selling cameras and such types of products have lots of different specs. If you do not want to include this info in description and would like to separate it into smartly-organized table, you can make use of attributes.
For example, you want to indicate camera’s dimensions: width - 15,2 cm; height 11,64 cm and depth 7,64 cm.
So attribute group will be - Dimensions. Width, height and depth are attributes and 5,2 cm, 11,64 cm and 7,64 cm will be attribute values for corresponding attributes.
How Attributes are Displayed at the Front-End?
With default template, newly created and assigned to products attributes are displayed in ‘Specification’ tab at the product page.
How to Perform OpenCart Attributes Import?
In this tutorial it will be shown how to upload multiple OpenCart attributes belonging to various attribute groups.
The aim of import is to achieve the result as on picture below -
As you can see, there are 3 attribute groups:
- Picture quality with attributes ‘Camera Type’, ‘Megapixel’, ‘Sensor type’
- Display with attributes ‘Display diagonal’ and ‘Display resolution’
- Battery with attributes ‘Battery technology’ and ‘Battery type’
A) File Format
To import all of this attribute-related info into OpenCart, you need to format your file and include the following fields -
- attributes_groups - with names of attribute groups. If you have a few attributes belonging to the same attribute group, you need to include the same attribute name as many times as attributes you have.
In our example, we have 3 attribute groups and 2 of them have 2 attributes each and one of them has 3 attributes assigned, so you need to format the column this way:
Picture quality|Picture quality|Picture quality|Display|Display|Battery|Battery
Attribute groups are separated by delimiter symbol, in our case it is pipe. You need to indicate delimiter symbol used in the file at the appropriate step of import, so keep reading.
- attributes_names - there you input the names of attributes. As per our example, they are ‘Camera Type’, ‘Megapixel’, ‘Sensor type’, ‘Display resolution’ etc.
- attributes_texts - in this column you should enter attribute values corresponding to indicated attributes.
New products with attributes: If you are importing new products do not forget also to include other columns to your spreadsheet, like name, model, status, price, quantity etc.
Update existing products with attributes: If you are updating existing products, mind to include column for product identification with some unique value - like products Model or SKU etc, in order to assign attributes to correct products.
B) Import Settings
After your file was correctly formatted for import, you can proceed to upload.
Check 14-day fully-functional version of Store Manager for OpenCart to try import of attributes right now! Download FREE
You can check detailed step-by-step OpenCart import instructions in related article -https://www.opencartmanager.com/useful-articles/opencart-product-management/opencart-product-import/
You need to pay special attention to the last import step, where you indicate import settings. Above we have discussed that multiple values in your file are separated by delimiter symbol. So at this step you need to point out what separator has been used.
Using attribute groups and attributes with products will help raise the level of customer satisfaction.
Provide your customers more information on product to influence their purchasing decision. Import attributes to OpenCart products in bulk with Store Manager!