1. How do I assign attribute values to the product variants in bulk quantity?
To assign attribute values to the product variants in bulk quantity, do the following:
- Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.
- You will be navigated to the Dashboard page.
- Click the
icon. The Products section will be displayed as shown in the figure.
- Click Bulk Tools, and select Bulk Variant Attribute Upload. You will be navigated to the Bulk Tools > Product Variant Attribute Upload page.
- To download the default template for bulk product variant attribute upload, click the click here link. The VariantAttributeUploadDefaultTemplate.xlsx file will be downloaded. To open the file, double-click VariantAttributeUploadDefaultTemplate.xlsx, and it will be displayed as shown in the following figure:
- There are two sheets here, namely - Sheet1, and Definitions.
- To know about column heads in the Sheet1', click the 'Definitions' tab. The following data will be displayed.
- For your quick reference, the definitions are mentioned below:
- SKU: Enter the SKU of the Product.
- Variant SKU: Enter the Variant SKU of the Product.
- Location Ref. Code: Enter the location reference code for which the attribute value is applicable.
- Note: A single ref. code is allowed in each cell. Hence, use a separate row for each location.
- Attribute_Id: Enter the id of the attribute for which the attribute value is applicable.
- Attribute Value: Enter the attribute value.
- Note: In the case of a predefined value, enter only the respective existing predefined value. New values can't be processed.
- Once the Excel is updated, save the Excel.
- Click Browse in the Bulk Tools > Product Variant Attribute Upload page. An Open dialog box will be displayed.
- Select the updated VariantAttributeUploadDefaultTemplate.xlsx and click Open. The dialog box will be closed, and the name of the selected file will be displayed in a Upload a file text box in the Bulk Tools > Product Variant Attribute Upload page.
- Click Upload. The file will be uploaded and the upload status will be updated in the Task History section in run-time.
- You can find the upload status, total rows, updated rows, and failed rows due to validations/exceptions against each upload.
- You can download any uploaded file by clicking its
icon under the Action column.
- You can delete any upload task record by clicking its
icon under the Action column.
- In the case of any failures in uploading, you can find the
icon against the upload record under Action column. Click the
icon, you will be navigated to the Error Logs Summary page.
- Read the error messages and rectify the data. Upload the file again as described above.