I need to add 1,325 discount codes to a nopcommerce 3.9 site. I can paste the information into the discount table of the database. My problem is the requirements, I need 1,250 codes to require certain products in the cart (example: products 19, 4, 18) and 75 of the codes to require a separate product (example: product 20). I see a table in the database called DiscountRequirement but it doesn't show the data from the Discount Details / Requirements page in the administration. Where is this data stored? I can't find it in any of the tables. I don't want to add the requirements to all 1,325 discount codes one at a time. Any suggestions? Is there a way to bulk import the codes and requirements?
Thank you everyone's help. I was able to find where the product relations is stored. It's in the settings table as DiscountRequirement.RestrictedProductIds ... Imagine that. It ended up being way to complicated to add the data directly into the database. I ended up having to enter the info in the discount requirements page in admin one at a time.