Massive discounts creation

  • Resolved MKay

    (@mongia)


    8 years, 5 months ago

    Good morning! Great plugin, really awesome.
    I have a request, I would like to know if there is a way to create discounts massively.
    Try to explain: I have a shop with about 230 registered customer and 24 products lists. Every customer has a special discount on every single list. In order to achieve this from WP admin, I have to create one discount for customer per list, that it means beyond 5500 discounts from backend.
    Is there a way to reach this result in a semi-automated way, in example an SQL query?
    Thank you in advance for your collaboration!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Hermann LAHAMI

    (@mano88)

    No the query will be really complex to do. But can you give me more details on the context? For example, if you can group your customers by role or anything you can create discounts based on groups which will significantly reduce the number of discounts to create.

    Thread Starter MKay

    (@mongia)

    I considered that option yet, but in my case every customer has specific discounts on product lists that differs from one to another!

    IE: customer1 has 4% of discount on list games, 6% on list paintings and 10% on postcards
    customer2 has 13% on games, 5% on paintings and 11% on postcards
    customer3 has 7% on games, 8 on paintings and 16% on postcards

    and so on, and on, and on… ’till death ))

    Thread Starter MKay

    (@mongia)

    Basically the rule created from wp-admin is:

    Rule -> If Customer IN [Customer]

    Action -> Percentage off product price

    Percentage / Fixed amount -> [number]

    Products list -> [list_created_from_product_taxonomy]

    Plugin Author Hermann LAHAMI

    (@mano88)

    Oups! No there is no way to do that with sql. Too many ways to make a mistake when doing it…

    Plugin Author Hermann LAHAMI

    (@mano88)

    Because the data are too variable.

    Thread Starter MKay

    (@mongia)

    Ok, I’ll find another way! thank you very much

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Massive discounts creation’ is closed to new replies.