Why not set your SKU number as the products model number (standard Zen Cart functionality) and then add an extra field (as post 1 in this thread explains) for your Manufacturers model number?