Part of the Product setting didn't update after import

Hi, I am a noobie for NopCmmerce. It's a great e-commerce tool and the first case I'm dealing with is a 3.8 version of Nop.

What I face a problem is
After I edited and import the product excel into the system, not all of the setting fields of every products are modified successfully. But the message replied "Products have been imported successfully. ".
There are some of Products  cannot be modified by this way.
I found that those cannot be edited are added one by one directly through the administration platform, not like others can be edit thru export/import are added by excel bulk import. However, it doesn't make sense because despise the way of adding, any product can be modified by import method. Or else how can the managing tell which products were added in what way...  :(

Can any one please help. It's confusing and not very reasonable.

Thanks in advance~

Hi is there anyone can help? Please~

The Unique identifier for the Product Import/Export is the Product SKU. If the Product SKU not found against existing product then it will create the new product. Else it will update the Same product with the Supplied data.

Yes Thanks~ The problem is, I simply just export one product with its SKU, modified the category field then import it for modifying. it only works in the product I newly added by excel import, not those I added thru the administration...   Any steps had I missed?? @@

Export Single Product, And Update Columns Like SKU, Name, Price etc And do import. It might be possible that when you are generating the File to Add new products has some different Columns headers of some default columns are missing.

Hi, I did export one product. Carefully just edited one field (ex: Published is TRUE), leave the SKU as the original value. It's not working.

If you could provide me the access would be best to look on your issue.

Check your PM.

pankildesai1988, thank you for the PM offer,
I cannot share the data cuz it is already an official running site,
could be sensitive and confidential.

However, I just lookover the database today, table product,
found that those with modifying issue which SKU have a duplicate ones. means there are 2 same SKU in the table,
one of it the Deleted field is TRUE.

Theoretically, if we modify products by export/import method,
it should be SKU-dependent.
But shouldn't it verify if it was deleted or not first?
Instead of modify the first one SQL server found by SKU directly?

btw, I am using v3.8. Can someone please share some suggestions?

The Import Sku match on deleted products is a bug that has since been fixed in 3.90.

If you have a tool like SSMS, you can mass remove the SKU on deleted products

  UPDATE [Product]
  SET [Sku] = NULL
  WHERE [Deleted] = 1

New York, Thanks very much

New York wrote: