• The 'Import Location Wise Stock/Price - Upload' interface allows you add/update the location wise stock/price of multiple products or product variants at a stretch in one go. You can upload the updated Excel that has been downloaded through the ‘Location wise Stock/Price - Download’ interface or you can download the default Excel format from here, update the same and upload. The status and details of each upload will be updated under the ‘Task History’ section.

  • You can find the task history of latest uploads in the following table. During each upload, the upload status, total rows, updated rows, failed rows due to validations and exceptions will be updated in runtime under the 'Task History' section. In the case of any failures in the upload, you can find a  Location wise Stock and Price - Upload icon against that upload in the 'Action' column, by clicking which you can navigate to the error logs summary page. You can also download the uploaded data or delete an uploaded task record by clicking the  Location wise Stock and Price - Upload or  Location wise Stock and Price - Upload icons respectively under the ‘Action’ column.



How do I update location wise stock or price of my 'Products' or 'Product Variants' in a bulk quantity?

Prerequisites:

  • For uploading the location wise stock of your 'Products' or 'Product Variants' in a bulk quantity, the Location Based Inventory checkbox under Basic Information section in Add/Edit Product page should be selected for those products - Please Refer: Basic Information.

  • You should have downloaded (for updating the location wise stock) the LocationWiseStockOrPriceXXXXXXXXXXXXXX.xlsx from Location wise Stock and Price - Download tab of Bulk Tools module.
    • If you don't want to use the file LocationWiseStockOrPriceXXXXXXXXXXXXXX.xlsx that is downloaded from Location wise Stock and Price - Download tab, then you need to download default excel format from this page.


To update location wise stock or price of your 'Products' or 'Product Variants' in a bulk quantity, do the following:

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


 Bulk Attribute Values Upload

  • You will be navigated to the Dashboard page.


 Bulk Attribute Values Upload

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


 Location wise Stock and Price - Upload

  • Click Bulk Tools, and select Location wise Stock and Price - Upload. You will be navigated to the Import Location wise Stock/Price - Upload page.


 Location wise Stock and Price - Upload

  • Here you can upload the updated Excel that has been downloaded through ‘Location wise Stock and Price - Download’ interface or you can download default Excel format by clicking Click Here, update the same and upload.
  • Now you need to upload the updated LocationWiseStockOrPriceXXXXXXXXXXXXXX.xlsx.
  • To select the updated LocationWiseStockOrPriceXXXXXXXXXXXXXX.xlsx file, click Browse. You will be displayed a File Upload dialog box.


 Location wise Stock and Price - Upload

  • Select the updated LocationWiseStockOrPriceXXXXXXXXXXXXXX.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 as shown in the figure.


 Location wise Stock and Price - Upload

  • Click Upload, and you can find the upload task history in the Task History section.
    • Note: While uploading, you can also find the upload details such as the status of the upload, total rows, updated rows, failed rows due to validations, failed rows due to exceptions, etc… are being updated in runtime under the Task History section.


 Location wise Stock and Price - Upload

  • You can download the uploaded file (if required) by clicking the  Location wise Stock and Price - Upload icon of respective upload task under the Action column of the Task History section.
  • You can delete the record of any uploaded task from the Task History section (if required) by clicking the  Location wise Stock and Price - Upload icon of respective upload task under the Action column.
  • In the case of any failures in the upload, you can find a  Location wise Stock and Price - Upload icon against that upload in the 'Action' column, by clicking which you can navigate to the error logs summary page.
  • To view the error logs, click the respective  Location wise Stock and Price - Upload icon. You will be navigated to the Error Logs Summary page.


 Location wise Stock and Price - Upload

  • You can view the 'SKU/Variant SKU, Row No., Sheet name, Column Name, Failure reason, and Error message' etc… data against each log.
  • Rectify the data accordingly and upload the file again.