Please open the enclosed Excel worksheet. Four modifications in each row to the Excel spreadsheet page titled “Complete List” with 237 rows. I did the first five rows as an example and need the others done as follows.
#1. Look at Column B – New SKU and at the end of Pack of Two, etc…and add (2), (3), (5) etc… See rows 3-8 as an example.
#2. Look at column B – New SKU and copy - Pack of Two, - Pack of Three, - Pack of Four, etc.. and insert this at the end of column D – New Title and at the end in Column I – Product Description. See rows 3-8 as an example.
#3. If it’s a Pack of Two take the price in column E – Item Price and double it and insert in column F – New Price. See rows 3-8 as an example.
#4. If it’s a Pack of Two take the weight in column G – Shipping Weight and double it and insert in column H – New Weight. See rows 3-8 as an example.