Maximum Length | 20 | ||||||
Product Information- User Input | Generated SKU Code & Product Explanation | ||||||
Product Category | Product Name | Attribute1 | Attribute2 | Attribute3 | Product Explanation | Generated SKU Code | Modified SKU Code |
SAS PTPC | 5" Screw Philips head | UM | 5115 | xxxx | 5" Screw Philips head-UM-5115-xxxx | 5"SCREW-UM-511-XXX | 5"SCREW-UM-511-XXX |
<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>
The formula for the SKU code generated is:
= UPPER(SUBSTITUTE(IF(RIGHT(SUBSTITUTE(SUBSTITUTE(CONCATENATE(LEFT(SUBSTITUTE(B13," ",""),CEILING.MATH($E$10/3)),"-",LEFT(SUBSTITUTE(C13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(D13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(E13," ",""),CEILING.MATH($E$10/7))),"--","-"),"--","-"),1)="-", REPLACE(SUBSTITUTE(SUBSTITUTE(CONCATENATE(LEFT(SUBSTITUTE(B13," ",""),CEILING.MATH($E$10/3)),"-",LEFT(SUBSTITUTE(C13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(D13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(E13," ",""),CEILING.MATH($E$10/7))),"--","-"),"--","-"),LEN(SUBSTITUTE(SUBSTITUTE(CONCATENATE(LEFT(SUBSTITUTE(B13," ",""),CEILING.MATH($E$10/3)),"-",LEFT(SUBSTITUTE(C13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(D13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(E13," ",""),CEILING.MATH($E$10/7))),"--","-"),"--","-")),1,""),SUBSTITUTE(SUBSTITUTE(CONCATENATE(LEFT(SUBSTITUTE(B13," ",""),CEILING.MATH($E$10/3)),"-",LEFT(SUBSTITUTE(C13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(D13," ",""),CEILING.MATH($E$10/7)),"-",LEFT(SUBSTITUTE(E13," ",""),CEILING.MATH($E$10/7))),"--","-"),"--","-"))," ",""))
I would like to be able to make a 12NC SKU code having xxxx-xxxx-xxxx but the current formula is only allowing the XXX on the final 3 stages of the SKU code that is generated. Does any one have an idea on how to alter the above formula to increase the character limit from xxx to xxxx?