The Supplier attribute allows differential processing of products during import. Use it to update the products related to a selected supplier and skip all the rest.
This attribute helps to avoid mistakes and use the catalog more efficiently if you upload several price lists from different suppliers on a regular basis. However, if you use a single file to populate your entire website, this featuremay not be necessary.
Using supplier attribute: where to begin
If your website already has products, first create the necessary number of supplier records and assign them to the products. Once done, you will be able to update the products with a specific supplier assigned via import.
Working with suppliers and their price lists
Add the necessary number of supplier records in the admin panel.
Assign these records to the products from the catalog.
Use the product import window to upload a price list file from a supplier and select the necessary record from the list in the Supplier field at the preview step.
Set up Actions with products to suit your needs and initiate the import process. The import operation will only apply to products from a specific supplier that you selected whereas the products from other suppliers or with no supplier assigned will not receive any updates.
Tip: it is best to create a dedicated supplier record for each price list that you use for updating products.
Adding and managing suppliers
You can add a supplier:
In the Suppliers section of the control panel;
On the preview screen while importing a file.
Suppliers section in the admin panel
Please note: this section is only accessible to users with owner access rights.
In the admin panel, go to Products → Attribute values lists → Suppliers section and click the Add button.
Enter a unique name of the suppler and click Save.
This section also allows to rename or delete suppliers. Deleting a supplier with related products sets the [not defined] attribute for all of them.
Import preview
This method is convenient if you're uploading a supplier’s price list for the first time with no products from that supplier present on the website.
Click Import in the Products section and upload the file.
At the preview step, click the Supplier field and enter a name.
Then click Add Supplier.
Assigning a supplier to a product
To assign a certain supplier to a product, use the Supplier field in the product attributes. By default, this field is set to [not defined] for all products.
Bulk supplier assigning via import
You can use the import function to define or change the supplier for a group of products. This method allows simultaneous assigning of suppliers to products and adding new ones, if absent.
In the import file, specify the names of product suppliers in the Supplier column.
Example of an Excel table for importing suppliers
Once the file is created, use the import function to update the products:
Go to the Products section of the admin panel, click Import and upload the file.
Make sure that the SKU and Supplier columns are mapped with corresponding product fields and click Import.
Select the Update action for the existing products in the Actions with products window and click Start import.
Attention: leave the Supplier field empty or else the values from the respective column in the file will not be imported.
During the import process, the system creates new suppliers and links them to products automatically.
Working with suppliers during import
Attention: make sure that you have suppliers assigned to all the products you intend to update before proceeding.
At the preview step, click the Supplier menu and select a supplier from the list.
If you have selected [not defined], the import operation will only apply to the products for which a supplier is not defined.
If you have not selected a supplier and left the field empty, the import operation will apply to all the products.
After selecting a supplier, click Import and set up the product processing options.
Actions with products
Once a supplier has been selected, the import operation will only process goods related to the supplier and skip all the rest. This results in the following logic of actions with products:
New Products (i.e. those which are present in the file, but absent from the website): import and assign the selected supplier.
Existing products (i.e. those which are present both in the file and on the website): update the products from the selected supplier and skip the products from other suppliers.
Products out of stock (i.e. those which are absent from the file, but present on the website): hide/change availability status of the products from the selected supplier and skip all other products.
This way, new imported products have a supplier assigned immediately, the products present on the website are updated while the action with the products out of stock only applies to the products from the selected supplier.