Usages of 'Bulk Product Upload' interface:

  • 1. The Bulk Product Upload interface allows you to 'add new products' or 'update the required product information of existing products' in bulk quantity at a stretch.

    • You can also upload language sensitive data through this interface in a bulk quantity.


Highlites:

  • This is a powerful but easy-to-use solution for creating and maintaining your online product catalog. It saves a lot of your valuable time for updating the data without the requirement of any special tools or software.

  • You can find the task history of latest uploads in the following table. During the upload, you can verify number of updated rows, number of rows failed due to validations and exceptions in the run-time i.e. dynamically under the Task History.

  • You can also verify the log summary of the products that are failed to upload by clicking the  Bulk Product Upload icon under the ‘Action’ column.

  • You cannot add new 'Brand Ids' while bulk uploading and those new 'Brand Ids' should be initially added to your account through 'Add/Edit Product' page.

  • You can also verify the maximum rows that can be uploaded at an instance through an informative message box.

  • You can specify location based flag (i.e. by specifying 'True' or 'False' in 'Location Based' column) also for Addons. Earlier this feature was working only with normal products.
  • Note: If Addon is location based, then the end-user can only view the Addons of the selected location while customizing a bundle product.

1. How do I update the existing product data or upload new products at my webstore in bulk quantity?

Prerequisite:

  • You should have downloaded the ProductCatalogXXXXXXXXXXXXXX.xlsx file through 'Bulk Product Download' interface and updated your product data.


To update the existing product data or upload new products at your Web store in bulk quantity, do the following:

  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Bulk Product Upload

  • You will be navigated to the Dashboard page.


 Bulk Product Upload

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


 Bulk Product Upload

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


1. Uploading the Product Data of your own store in a bulk quantity:
 Bulk Product Upload

  • By default, the Store Category section will be opened.
  • You can download the latest Excel format by clicking Click Here link. Then the latest excel format ProductDefaultDataL4.xlsx will be downloaded.
  • Update the Excel with appropriate data.
    • Note:
      • If you have just downloaded the ProductCatalogXXXXXXXXXXXXXX.xlsx file through the 'Bulk Product Download' interface and updating the same, you need not to download the latest Excel format i.e. ProductDefaultDataL4.xlsx.
      • Once you download the latest Excel format, you can save it and use it for future requirements.
  • If you have downloaded the ProductDefaultDataL4.xlsx, double-click on it to open the file. It will be displayed as shown in the figure.


 Bulk Product Upload

  • Update the ProductDefaultDataL4.xlsx file with relevant product data in Sheet1 and save the file. You can refer Definitions to verify what to enter in each column.
  • To select the bulk product Excel, click Browse. An Open dialog box will be displayed.


 Bulk Product Upload

  • Select the respective file (i.e. either the ProductDefaultDataL4.xlsx or the latest ProductCatalogXXXXXXXXXXXXXX.xlsx) from the stored location and click Open. The dialog box will be closed and the name of the selected file will be displayed in the Upload a file text box.


 Bulk Product Upload

  • Note: The Maximum row limit for upload is 10,000 and the file should not contain any formulas or empty rows.
  • To upload the bulk products, click Upload. The relevant file will be uploaded and you can verify the number of updated rows, number of rows failed due to validations and exceptions in the run-time i.e. dynamically under the Task History.


 Bulk Product Upload

  • You can view the file that you have uploaded by clicking the  Bulk Product Upload icon against each upload.
  • You can also delete the 'uploaded task record' from the Task History section by clicking the  Bulk Product Upload icon of the relevant task.
  • In the case of some of the rows are failed to upload due to validations or exceptions, you can find the ' Bulk Product Upload' icon under the Action column.
  • To view the 'log summary' of a failed upload, click ' Bulk Product Upload' icon of the respective task under Action column. You will be navigated to the Error Logs Summary page.


 Bulk Product Upload

  • You can view the 'SKU/Variant SKU, Row No., Column Name, Failure reason, and Error message' etc… data against each failure row.
  • Rectify the relevant data in the Excel and upload the excel again.

2. How do I upload the language sensitive product Data of my Store in bulk quantity?

Prerequisite:

  • You should have downloaded latest excel format i.e. ProductDefaultDataL4.xls (as explained in this page) and updated the relevant data.
  • To upload the language-sensitive product Data of your Store in bulk quantity, do the following:
  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Bulk Product Upload

  • You will be navigated to the Dashboard page.


 Bulk Product Upload

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


 Bulk Product Upload

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


1. Uploading the Product Data of your own store in a bulk quantity:
 Bulk Product Upload

  • By default, the Store Category section will be opened.


 Bulk Product Upload

  • Click the Multilingual tab. You will be displayed the above options.
  • To download the default bulk product excel template, click the link Click Here. The ProductMLDefaultData.xlsx will be downloaded.
  • Note: If you have downloaded the latest ProductCatalogXXXXXXXXXXXXXX.xlsx file through the Multilingual tab of Bulk Tools > Bulk Product Download page, you need not to download the default bulk product excel template.
  • To open the ProductMLDefaultData.xlsx file, double-click the same. The excel will be displayed as shown in the figure.


 Bulk Product Upload

  • Update the ProductMLDefaultData.xlsx file with relevant product data in the Sheet1 and save the file. You can refer Definitions to verify what to enter in each column.
  • To select the respective file, click Browse. You will be displayed an Open dialog box.


 Bulk Product Upload

  • Select the respective file (i.e. either the ProductCatalogXXXXXXXXXXXXXX.xlsx or the latest ProductMLDefaultData.xlsx) from the stored location and click Open. The dialog box will be closed and the name of the selected file will be displayed in the Upload a file text box.


 Bulk Product Upload

  • Note: The Maximum row limit for upload is 10,000 and the file should not contain any formulas or empty rows.
  • To upload the multilingual product data, click Upload. The relevant file will be uploaded and you can verify the number of updated rows, number of rows failed due to validations and exceptions in run-time i.e. dynamically under the Task History.


 Bulk Product Upload

  • You can view the file that you have uploaded by clicking the  Bulk Product Upload icon against each upload.
  • You can also delete the 'uploaded task record' from Task History section by clicking the  Bulk Product Upload icon of the relevant task.
  • In the case of some of the rows are failed to upload due to validations or exceptions, you can find View Log ' Bulk Product Upload' icon under Actions column.
  • To view the 'log summary' of failed upload, click ' Bulk Product Upload' icon of the respective task under the Action column. You will be navigated to the Error Logs Summary page.


 Bulk Product Upload

  • You can view the 'SKU/Variant SKU, Row No., Sheet Name, Column Name, Failure reason, and Error message' etc… data against each failure row.
  • Rectify the relevant data in the Excel and upload the excel again.


Product attribute value upload in Bulk Product upload

Problem statement: The current way of uploading product attribute values using “Product attribute” template is complicated and requires significant effort from mis/merchant user to fill up the “Product attribute” template. On an average, merchants have 6 product attributes (sg cluster) and giving an option to add/update them through bulk product upload will help do away with a separate upload.

Solution:

  • Product attribute values up to 20 can be added/updated through bulk product upload.
  • Column names like attribute Name 1, attribute Value 1 should be used with their values at the end of the product upload template.
  • Attribute name and predefined attribute values should match as defined in the category attribute creation upload.
  • This upload is to add/update product attributes only. It does not support variant attribute value add/update.