Skip to main content

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:

QG11

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:

QG11

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:

QG11

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.


Reordering of Sizes

How to access

Merchants can change the order of the sizes according to their preferences to ensure that the order of the sizes appear as they want.
Do the following steps to update the order of sizes:

  1. Navigate to the product whose size order you need to change.

  2. Go to the Sizes section.

  3. Click and hold the drag icon next to the size you need to move. QG1

    Figure 7: Reorder Sizes

  4. Drag the size to its new position in the list.

  5. Release the mouse button to drop the size into its new position.

  6. Click Save.


Reordering of Sizes in Bulk

How to access

This bulk update feature of size reordering allows you to prioritize certain sizes by placing them at the top of the size list. Use the Size Reorder command within the bulk upload template file in the Command column to facilitate bulk updates of size order.
Do the following steps to update the order of sizes in bulk:

  1. Export your products to get the data on the concerned products in Microsoft Excel sheet. Refer to Export Product for more details.
  2. Delete all the columns except the following:
    1. Item Code
    2. Brand
    3. Seller Identifier
  3. Delete the rows except the products you wish to modify.
  4. Add a new column with a header named Command.
  5. Make sure to enter Size Reorder in the Command column. QG1
    Figure : Bulk Upload Template File

note

Sizes not included in the bulk upload will automatically move to the end of the list but will retain their original order relative to each other.

  1. Save and import your file. Refer to Import Product for more details.

For example, if the current sequence of sizes is XSS, L, M, XL, S, XXL, and XLS. You have uploaded the bulk upload file with the sizes in the following order: M, L, XL, and XSS. The updated size order is M, L, XL, XSS, S, XXL, and XLS. In this updated sequence, sizes not listed in the bulk upload file (S, XXL, and XLS) will move at the end, maintaining their existing sequence.


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:

QG11

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:

QG11

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.


Was this section helpful?