set location id and category id from product order