Add Manufacturer to OpenCart Products in Bulk
In OpenCart manufacturers are used to help customers faster recognize and find necessary products. The brand a product belongs to is displayed at product page, so assigning manufacturers to OpenCart products contributes greatly to making the goods more appealing for clients.
This tutorial explains how to indicate manufacturer for products in OpenCart 1.5.x and 2.x.
Adding Manufacturer to Product in OpenCart Back-End
In admin panel, you can add info on manufacturer creating new or modifying existing product in ‘Links’ tab of product form.
In ‘Manufacturer’ field you can select out from drop-down the brand to use for this item.
Important note: You can use only manufacturer available in the drop-down. If you want to specify some other brand name, you have to add it to Manufacturers list first.
Assign Manufacturer to Multiple Selected Products
In case you need to link a number of products to manufacturer in bulk, unfortunately you will not find such an option for mass updates in back-end.
You can assign manufacturer to multiple product with Store Manager for OpenCart application! Try free
With this helpful software you can enter brand for selected products in seconds.
All you need to do it to:
- Choose products to enter brand for
- In the lower grid open ‘General’ tab
- Select manufacturer from the drop-down and press ‘Apply’
The inputted value will be set as manufacturer to all selected goods.
Link Manufacturers to Products in Bulk Via Import
Store Manager for OpenCart also contains built-in export/import tool that allows add or update products with manufacturer import in bulk using CSV, TXT, XML, XLS, XLSX and ODS files.
In the file you can basically have ‘Model’ (or other column containing unique products identifier, like id, ean, upc etc) and ‘Manufacturer’ column.
If you need to update existing products, you can run export first and select necessary columns to get file for importing it back with changes.
When the file is ready, you can run Import Wizard of Store Manager.
The settings are pretty simple and require from you to click a few times next. Just pay attention to the following important steps:
- Map appropriate file columns to database fields.
- Import options step allows you set up important settings for upload.
This functionality is good if you have file headers are named differently than database fields, so you can associate them. For exported file the fields will be mapped automatically.
Do not forget to select product identifier to avoid duplicated data.
Note: Store Manager for OpenCart allows you to massively assign manufacturers to products, even if manufacturer has not been added to the brand list. For that you need to select the appropriate setting.
The complete import guide with all the steps explained you can find at: