I am facing a problem in which i need to retrieve the base sku of a product on the modified sku of that product which has the custom option sku suffixed.
for example> base product "shirt", sku = 1234, "red shirt"= 1234-12 how can i get the sku of the base "shirt" (1234) from the "red shirt"(1234-12) please take note that this isnt a case of "configurable products". and there doesnt exist in parent child relationship between the original and sub products(and parents are returned as "null"