savan28
06-09-2018, 06:24 PM
Hello everyone,
I have started a new eCommerce website and need some help to edit the csv.
Basically I get a new updated CSV file every 2 days with edits in more than 5000 products. I need a quick way to edit the CSV and update the products in the website.
To do this firstly, I need to remove the product code from the name of the cell. The product name is in the following format
8694 3 Piece Set Of Wall Paintings Without Glass,
I need to remove the first set of numbers and to be written as 3 Piece Set Of Wall Paintings Without Glass.
And secondly to optimise the site and for SEO reasons, i need to remove certain characters from the description like, the, is, and and so on,
For example, from the following sentence I need to remove the, are, very and in
The towers are very tall in the city. and the output is tower, tall, city.
Thanks for your help in advance, :)
I have started a new eCommerce website and need some help to edit the csv.
Basically I get a new updated CSV file every 2 days with edits in more than 5000 products. I need a quick way to edit the CSV and update the products in the website.
To do this firstly, I need to remove the product code from the name of the cell. The product name is in the following format
8694 3 Piece Set Of Wall Paintings Without Glass,
I need to remove the first set of numbers and to be written as 3 Piece Set Of Wall Paintings Without Glass.
And secondly to optimise the site and for SEO reasons, i need to remove certain characters from the description like, the, is, and and so on,
For example, from the following sentence I need to remove the, are, very and in
The towers are very tall in the city. and the output is tower, tall, city.
Thanks for your help in advance, :)