We are always receiving bulk merchandise items with Serial Numbers (SN) per SKU. What I want is to populate the SN on the details of every SKU receiving page.
Now, this is my question: Normally, SN is a long code with around 4 numerical digit at the end in sequential order. How can I strip the 4 numerical digits at the end and sequence them accordingly.
Example: From StartingSN XXXXXXXXXX3625 to EndingSN XXXXXXXXXX3666.