We have set up a "coupon offer" by Product using the Offers in Marketing tab. It works fine.


However we want to add more skus to the offer. There are 300+ skus from our inventory we need to add here.



On the backend, I looked thru the tables but could not find any relationship or table that links the table bvc_offer to bvc_products.



The skus are spread out across multiple manufacturers and categories, so that makes it the more hard to filter. How do I automate/speed up this process, instead of manually typing in the skus in the search/filter fields one at a time?



Please assist as we need to launch this promo by tomorrow. Thanks!!