So my client is having an issue regarding coupon codes. Here is what they want to setup:
1) Have select discount codes apply to specific products
2) Concurrently run time-limited sales for specific categories.
3) Also have the ability to have sitewide sales
Here is the issue as I see it and maybe I am not understanding this right. They can do unlimited sitewide sales coupon codes, that is no problem. #3
is a non-issue
However, you cannot do discounts that apply to specific products. So #1
You could do a discount that only applies to specific categories in FoxyCart. However, many products in the store belong to multiple categories and FoxyCart only lets us pass a single category in the Add to Cart code. So this I have no idea how to make #2
The site I have for this client is built on WordPress and unfortunately before I found FoxyShop so has a custom built integration with FoxyCart. We we currently do it is we have our public categories that are used to organize the products in the store and then our discount categories which are used to assign products to a category (or group) of products to be used in promotions/coupon codes. This is a workaround for the one category only allowed by FoxyCart. We actually pass the discount category (if there is one) in the add to cart form and not the public category.
However, a single product could be part of two separate discount categories. Now we're screwed as I see it because this isn't possible with FoxyCart.