Adding Quantity Discounts with SQL Queries

[bodyjewelrystores]

Hi,

We are working on a web store with 1000+ products. All of them are going to have qty discounts. Adding all the discounts by hand is going to take way too much time, and Easy Populate doesn't seem to have this functionality.

So I'm trying to automate this by using MS Excel to generate SQL queries for inserting qty discounts. However, I'm bad at SQL, so I would really appreciate some help.

Here is what I need to know, I guess:

• SQL query to insert one new qty discount, for the product with model "M", discount quantity "Q", and the discount price "P" (actual price).
  
  (I guess it would have to look up the products_id according to the product model, first... since the product_discount_quantity table lists products as products_id)
  
  (I've noticed that this table does not list the discount type - percentage / actual price / amount off... how does this work then?)

• If possible - SQL query to insert 2 or 3 new quantity discounts for the product with model "M" (that is, to add 2 or 3 new table rows in the same query, if possible, instead of doing it one by one as above)

• SQL query to delete all qty discounts for the product with model "M"

This could save us so much time it isn't even funny.... Many thanks in advance!

[swguy]

Have you looked at the Quantity Discounts contribution? If your discounting scheme is consistent (or at least mostly consistent), it might be a good way to go.

[bodyjewelrystores]

Have you looked at the Quantity Discounts contribution? If your discounting scheme is consistent (or at least mostly consistent), it might be a good way to go.

Thank you - however this contribution seems to have a big feature overkill compared to what I need, and it changes some files which I've already custom-modified myself, which I would like to avoid. I'm just looking for a faster way to do what ZC already does; i.e. by using SQL queries directly.