Bulk variant attribute upload

Modified on: Tue, 12 Nov, 2019 at 3:08 PM

This interface allows you to assign 'attribute values' to the product variants against the required locations in a bulk quantity through an Excel file. To do so, you need to download the default Excel format, update the Excel with required data and upload.
You can specify the attribute values against the 'existing attributes' only, and you cannot add the 'new attributes' here.
In the case of predefined attribute values (if any), you must specify the existing predefined attribute values only.
- Note: Based on these attribute values, you can define some specific actions such as 'MRP Variance' after placing the Order, i.e. permitting the picker to modify the MRP of a variant item while picking it based on the predefined attribute value of the variant item.
The upload status against each upload will be updated in run-time in the ‘Task History’ section.

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:

Bulk Variant Attribute Upload

Bulk Variant Attribute Upload

Click the icon. The Products section will be displayed as shown in the figure.

Bulk Variant Attribute Upload

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

Bulk Variant Attribute Upload

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:

Bulk Variant Attribute Upload

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.

Bulk Variant Attribute Upload

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.

Bulk Variant Attribute Upload

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.

Bulk Variant Attribute Upload

Click Upload. The file will be uploaded and the upload status will be updated in the Task History section in run-time.

Bulk Variant Attribute Upload

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.