The attributes are the specifications of a product such as Pixels of CameraStand-By time of BatteryTouch screen feature of phone, etc…

The attribute values are the values for the attributes.
  • For example, if the Pixels of Camera is an attribute, the 2 Mega Pixel (M.P.), 3 M.P., etc… are the attribute values.

This interface allows you to assign the 'attribute values' in a bulk quantity to multiple products through an Excel file. To do so first, you need to download the product attributes data by category wise in the Excel format, update the attribute values and upload the Excel.

You can add new /update existing attribute values against the 'existing attributes' only and you cannot add 'new attributes' here.

While adding/updating the predefined attribute values (if any), you need to know the existing ‘predefined attributes values’ and you must enter only the existing predefined attribute values. To know the predefined attribute values, you can refer ‘Predefined Values’ sheet in the ‘Product Attribute’ Excel.



You can define Attributes to Category level, and assign attribute values for those Attributes at product level.
You also can define 'Predefined Attribute Values' and assign respective values for applicable products.

How do I assign the attribute values for multiple products in a bulk quantity?

  • The 'Bulk Product Attribute Download and Upload' interface allows you to bulk download the product attributes data by category wise in an Excel format, and to upload the 'attributes values' against the existing attributes of required custom products against each category.
    • You can quickly add, remove or edit the 'attribute values' against the existing attributes of required products from the required categories in a matter of seconds.

  • To assign the attribute values for multiple products in a bulk quantity, do the following:
  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Bulk Product Attribute Download and Upload

  • You will be navigated to the Dashboard page.


 Bulk Product Attribute Download and Upload

  • Click the  Bulk Product Attribute Download and Upload icon. The Products section will be displayed as shown in the figure.


 Bulk Product Attribute Download and Upload

  • Click Bulk Tools, and select Bulk Product Attribute Download & Upload. You will be navigated to the Bulk Tools > Product Attribute Download and Upload page.


 Bulk Product Attribute Download and Upload

  • There are two tabs here, namely, Download and Upload. By default, the Download tab will be selected.

  • To assign the 'attribute values' to the multiple products in a bulk quantity through an Excel file, first you need to download the product attributes data by category wise in an Excel formatupdate the attribute values and upload the Excel.


Downloading the product attributes' data by category wise:

  • Let's learn how to download the product attributes' data by category wise:
  • First you need to download the product attributes data by category wise to update the attribute values in bulk quantity. To do so, click Choose. The Select Category dialog box will be displayed.


 Bulk Product Attribute Download and Upload

  • The categories that are configured at your store will be displayed here. Find the required category (categories) and select.
  • Click Submit. The Select Category dialog box will be closed and the name of the selected category (categories) will be displayed in the 'Category' box.


 Bulk Product Attribute Download and Upload

  • Click Download. The download task will be initiated with a task id and the data will be downloaded under the Task History section.


 Bulk Product Attribute Download and Upload

  • You can find  Bulk Product Download, and  Bulk Product Attribute Download and Upload, icons under the Action column.
  • To open the downloaded excel file, click the  Bulk Product Attribute Download and Upload icon of the respective downloaded task. The ProductAttributeXXXXXXXXXXXXXX.xlsx file will be downloaded.
  • To open the 'ProductAttributeXXXXXXXXXXXXXX.xlsx' file, double-click the file. The Excel will be displayed as shown in the figure.


 Bulk Product Attribute Download and Upload

  • Update the attribute values and unit for attribute values (if any) in the Attribute_Name# and Attribute_Unit# respectively against required categories. In case of predefined attribute values, please verify the PredefinedValues sheet before defining them.
    • Note: You cannot upload other 'predefined attribute values' which are not listed here for the respective category.
  • After completing the updation, save the Excel in a suitable location.


Uploading the product attributes' data (in bulk quantity) through an Excel file:

  • Let's learn how to upload bulk product attributes' data (in bulk quantity) through an Excel file:
  • Click the Upload tab in the Bulk Tools > Product Attribute Upload page. The following section will be displayed.


 Bulk Product Attribute Download and Upload

  • To locate the excel file, click Browse. You will be displayed a File Upload dialog box.


 Bulk Product Attribute Download and Upload

  • Select the respective excel (i.e. ProductAttributeXXXXXXXXXXXXXX.xlsx) and click Open. The dialog box will be closed and the name of the selected file will be displayed in the Product Attribute Sheet box.


 Bulk Product Attribute Download and Upload

  • Click Upload. The ProductAttributeXXXXXXXXXXXXXX.xlsx will be uploaded. The upload will be dynamically updated under the Task History section.


 Bulk Product Attribute Download and Upload

  • Note: You can download the latest associated attribute values for crosschecking by clicking relevant the  Bulk Product Attribute Download and Upload icon.
  • You can delete this task (if required) from Product Attribute Uploads section by clicking relevant the  Bulk Product Attribute Download and Upload icon.
  • If some of the attribute values are not uploaded due to validations or exceptions, you can find the  Bulk Product Attribute Download and Upload icon against that upload task under the Action column.
  • Click the  Bulk Product Attribute Download and Upload icon under the Action column. You will be navigated to the Error Logs Summary page.


 Bulk Product Attribute Download and Upload

  • You can find Upload Summary and Error Logs here. You can verify error messages under Message column.
  • You can read the error messages, rectify the mistakes and upload the data again.

Learn More:


learnmore2.jpg
1. In order to download the ProductAttributeXXXXXXXXXXXXXX.xlsx, the 'attributes' should be defined for any one of the selected categories.

2. You neither can delete the existing attributes nor add new attributes through the Bulk Attribute Upload feature. You can only Add/Delete/Edit Attribute Values for existing attributes only.

3. To know the predefined attribute values for assigning to relevant product attributes, click the PredefinedValues sheet in the ProductAttributeXXXXXXXXXXXXXX.xlsx file.