import null value

[alenwang9788]

I have manually added to some upsell products to the products.

If I want to remove them, what to type for the column "upsell_skus" in the import csv files?

[Rakesh Jesadiya]

Yes, You are correct.

You need to keep CSV file with two columns.

sku,upsell_skus

Where sku is main product sku and upsell_sku is list of upsell products.

[Manthan Dave]

Hi @alenwang9788

okay - i understand , so assuming your question here is how to removed Upsell products from the existing product sku - using CSV import.

So if you wanted to remove that UpSell Products from that assigned product - in your csv file you need to keep blank upsell_skus field.

Meaning all the data will be there - but when you are importing that csv - make sure your column name upsell_skus field is blank - no value need to put in it.

so it will update that product and remove that upselll_skus from it.

Hope it helps !

[alenwang9788]

Hi 

In fact, I have tried that.

http://joxi.net/1A5LQM0TnbOz72

This is the csv files just include the columns of sku, store_view_code, upsell_skus, upsell_position

And imported the products with "add/update"

The import was successful, but no any change.

[Manthan Dave]

Hi @alenwang9788

With sku - pass store_code as well !

Also from the import behaviour dropdown = select add/update option

and then try it will works !

[alenwang9788]

http://joxi.net/82Qjpb1cj9gjWA http://joxi.net/MAjd7gDi4kG4xm http://joxi.net/RmzBKnDT0Ml0jm I tried both, 2 columns Sku， upsell_skus 3 columns Sku， upsell_skus，upsell_position But still no any change.

[bilyana_velinov]

Did that work for you after all? We have the same problem.