Problem updating products (excel import)

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 years ago
Hello,

I'm trying to update the stock quantity of my products.


To test this out:
I export a single product to excel, open it and change the 'StockQuantity' value, save the file and Import it in the admin interface.

I've not changed anything else in the excel file other than the stock quantity.
no changes to categories or anything else, just want to update products.

error:
Log level: Error
Short message: Categories with the same name are not supported in the same category level. Check your category list in "Catalog -> Categories" page
Full message:
System.ArgumentException: Categories with the same name are not supported in the same category level. Check your category list in "Catalog -> Categories" page
   at Nop.Services.ExportImport.ImportManager.ImportProductsFromXlsx(Stream stream) in C:\andrei\nop_sources\src\Libraries\Nop.Services\ExportImport\ImportManager.cs:line 1218
   at Nop.Web.Areas.Admin.Controllers.ProductController.ImportExcel(IFormFile importexcelfile) in C:\andrei\nop_sources\src\Presentation\Nop.Web\Areas\Admin\Controllers\ProductController.cs:line 2332

Customer
Page URL: https://url/Admin/Product/ImportExcel
Referrer URL: https://url/Admin/Product/List
Created on: 11/19/2020 1:55:59 PM

nopCommerce version 4.30

Anyone have an idea what's wrong?
3 years ago
See this to sort out the categories issue
https://www.nopcommerce.com/en/boards/topic/55216/categories-with-the-same-name-are-not-supported-in-the-same-category-level.
But you can probably blank out that column if you are just updating stock quantity.  Be sure you have as SKU to do updates.
3 years ago
So i've solved the error now..  
The error message was correct, it was just not really related to what i was trying to do.

I did have duplicate category names but in different hierarchies, if it's this important to have unique names, it really shouldn't allow you to create them in the first place.

After renaming all the categories to unique names the error message is gone.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.