generate promotions by syscat id