IF YOU NEED TO BUNDLE YOUR SKUS, SO THAT THERE IS A PARENT AND CHILD SKU VARIATION, BASICALLY ANYONE WHO HAS PRODUCTS WITH VARIATIONS WILL NEED TO DO THIS, AND IT IS A NIGHTMARE! IT IS HOURS OF UNNECESSARY STUPID WORK.
AND TURN IT INTO THIS. SO THAT EACH OF THE SIZE VARIANT SKUS ARE IN ONE CELL IN ONE ROW IN ONE COLUMN, INSTEAD OF THEM BEING IN INDIVIDUAL CELLS IN ONE COLUMN.
THIS IS THE BEST THING I CAN THINK TO DO:
- COPY EACH INDIVIDUAL SIZED SKU (EXAMPLE: WCZF-BONY-S, WCZF-BONY-M, WCZF-BONY-L, WCZF-BONY-XL, WCZF-BONY-XXL)
- PASTE THE SKUS "TRANSPOSED" INTO COLUMNS D-H
- WRITE A FORMULA IN COLUMN I THAT CONCATENATES THE VALUES IN THOSE CELLS (ROW 2, COLUMNS D-H) AND ALSO ADDS A (" | ") IN BETWEEN EACH CELL SO THAT THE RESULT LOOKS LIKE THIS:
- " WCZF-BONY-L | WCZF-BONY-M | WCZF-BONY-S | WCZF-BONY-XL | WCZF-BONY-XXL"
- COPY THE RESULTS FROM COLUMN I
- PASTE VALUES INTO THE TOP ROW (THERE WILL BE 5 DEPENDING ON HOW MANY SIZED SKUS YOU HAVE TO GROUP INTO ONE CELL) OF THE "BUNDLED SKU" COLUMN.
- GO BACK AND DELETE THE EXTRA ROWS WITH THE INDIVIDUALLY SIZED SKUS (THERE WILL BE 4 IF YOU HAVE 5 SIZES)