Partial Update of Primary Identifier-related Attributes

Adding a Secondary Identifier

Sample Scenario:

You created a product having a primary identifier; where GTIN Type = EAN and GTIN Value = 1000000000111. Now, you wish to add a secondary identifier; say GTIN Type = SKU and GTIN Value = BLU-SOF-101.

Columns required in the Excel sheet:

1. GTIN Type
2. GTIN Value
3. Seller Identifier
4. Command

Format:

Steps:

1. Export your products to get the concerned products' data in an Excel sheet.
2. Delete all the columns except the ones we mentioned earlier.
3. Delete all the rows except the products you wish to modify.
4. Add a new column with a header named Command.
5. Add another row below the seller identifiers to which you wish to add a secondary identifier.
6. Enter the secondary GTIN type and values.
7. Repeat the primary identifier in the Seller Identifier column.
8. Make sure to enter Update in the Command column.
9. Save the file and import your file.

---

Deleting a Secondary Identifier

Sample Scenario:

There’s a product having a primary identifier and a secondary identifier, but now you wish to delete the secondary identifier. Let’s say, primary identifier has GTIN Type = EAN and GTIN Value = 1000000000111. Secondary identifier has GTIN Type = SKU and GTIN Value = BLU-SOF-101.

Columns required in the Excel sheet:

1. GTIN Type
2. GTIN Value
3. Seller Identifier
4. Command

Format:

Steps:

1. Export your products to get the concerned products' data in an Excel sheet.
2. Delete all the columns except the ones we mentioned earlier.
3. Delete all the rows except the products you wish to modify.
4. Add a new column with a header named Command.
5. Keep the row containing the article (product-size) that has a primary identifier.
6. Delete the row containing the secondary identifier.
7. Make sure to enter Update in the Command column.
8. Save the file and import your file.

---

Updating Prices

Sample Scenario: There’s a product having Actual Price (MRP) = ₹1000 and Selling Price (ESP) = ₹700. But the market conditions have led to inflated costs, and now you wish that the Actual Price (MRP) be ₹1200 and Selling Price (ESP) be ₹800.

Columns required in the Excel sheet:

1. Seller Identifier
2. Actual Price
3. Selling Price
4. Command

Format:

Steps:

1. Export your products to get the concerned products' data in an Excel sheet.
2. Delete all the columns except the ones we mentioned earlier.
3. Delete all the rows except the products you wish to modify.
4. Add a new column with a header named Command.
5. Enter the updated prices in the respective columns.
6. Make sure to enter Update in the Command column.
7. Save the file and import your file.

tip

If you wish to update only the actual price, you need not include the selling price column and vice-versa in the Excel file.

caution

Actual Price in the product cannot be less than the highest actual price you defined in the product's inventory. Click here to know more.

---

Deleting a Size

Sample Scenario: There’s a product have sizes S, M, L, XL . However, manufacturing of XL size was discontinued due to low sales. Now you wish to delete XL size from the product.

Columns required in the Excel sheet:

1. Item Code
2. Brand
3. Seller Identifier
4. Command

Format:

Steps:

1. Export your products to get the concerned products' data in an Excel sheet.
2. Delete all the columns except the ones we mentioned earlier.
3. Delete all the rows except the products you wish to modify.
4. Add a new column with a header named Command.
5. Enter the item code, brand, and the seller identifier (of the size you wish to delete) in the respective columns.
6. Make sure to enter Delete in the Command column.
7. Save the file and import your file.

---

Updating the Packaging Dimensions

Sample Scenario: There’s a product for which you generally use a larger packaging box. However, you have decided to optimise costs and use a compact packaging henceforth. Now you wish to update the volumetric data of the smaller packaging in the product file.

Columns required in the Excel sheet:

1. Seller Identifier
2. Length
3. Width
4. Height
5. Weight
6. Command

Format:

Steps:

1. Export your products to get the concerned products' data in an Excel sheet.
2. Delete all the columns except the ones we mentioned earlier.
3. Delete all the rows except the products you wish to modify.
4. Add a new column with a header named Command.
5. Enter the updated volumetric data in the respective columns.
6. Make sure to enter Update in the Command column.
7. Save the file and import your file.

tip

If you wish to update only one attribute, say length, you need not include other columns for width, height, and weight in the Excel file.