Looking at importing a large number of new products via excel,
I need to place them as hidden products untill I have made some alterations or checked them
What excel header do I have to use to make the import products start off hidden and do I use 1 or 0 as the code if you know what I mean
Also the excel format the data is in has seperate columns for the product descriptions so I need to condense these into one column, but some may have say three columns of description whilst others may have up to five, I dont want to have lots of empty lines after the ones with only three lines if you can understand my logic
Understand I can use CONCATENATE using char (10) after each ref to get the three lines
I need to place them as hidden products untill I have made some alterations or checked them
What excel header do I have to use to make the import products start off hidden and do I use 1 or 0 as the code if you know what I mean
Also the excel format the data is in has seperate columns for the product descriptions so I need to condense these into one column, but some may have say three columns of description whilst others may have up to five, I dont want to have lots of empty lines after the ones with only three lines if you can understand my logic
Understand I can use CONCATENATE using char (10) after each ref to get the three lines