cancel
Showing results for 
Search instead for 
Did you mean: 

import null value

import null value

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?

 

6 REPLIES 6

Re: import null value

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.

 

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: import null value

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 !

if issue solved,Click Kudos & Accept as Solution

Re: import null value

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.

 

 

Re: import null value

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 !

 

 

if issue solved,Click Kudos & Accept as Solution

Re: import null value

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.

Re: import null value

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