Make Coupon for a sale price?

  • Resolved tcwaters

    (@tcwaters)


    5 years, 6 months ago

    I guess two possible approaches here. My first thought was a coupon that sells an item for $10 and includes free shipping (and make it apply to a specific category). The other idea would be to go into the product table and set a sale price on all items in that category. Then the coupon would just be for free shippinfg on any sale item.

    I want to make a coupon for a specifuc category of Tshirt where the coupon is for $10 and includes free shipping. It looks like I have to select the coupon amount to be whatever I think the difference between $10 and the price in the product table, correct?

    Is there a way to select a category in the product table and set all to have a specific sale price, or is the on;t way to do it, one product at a time?

    THX

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @tcwaters,

    > Is there a way to select a category in the product table and set all to have a specific sale price, or is the on;t way to do it, one product at a time?

    One way to do that is to export the products in the category with into a CSV file and then edit it to set the sale price. Then import the file to update the products. Here’s a link to the documentation about the CSV tool.

    https://docs.woocommerce.com/document/product-csv-importer-exporter/

    If there aren’t too many products you can use the “bulk edit” feature to update all of them at one time. How many you can do at once depends on the server and amount or resources that are available. Here’s what you’d do.

    • Go to Products and click on the “Screen Options” tab in the top right. There is a box here where you can set how many products are shown per screen in the admin. Set that to a high enough number to show all the products in this category and apply the changes.
    • Use the drop-down filter at the top to select the category you’re wanting to change.
    • Click the box in the top-left above the list to select all the products. Then use the bulk actions drop-down to select “edit.”
    • Now you can set the sale price for every product in this list at once.
    • Save your changes.

    That should let you change the products in bulk. Depending on how many you have, you may need to do that a couple of times on different pages to cover them all.

    Hopefully, that will give you some options that don’t require direct DB manipulation.

    Cheers

    Hello @tcwaters,

    It’s been a while since we heard from you, so I’m marking this thread resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please let open up a new topic and we’ll be happy to help out.

    Take care

    Thread Starter tcwaters

    (@tcwaters)

    THX, I did find a solution by editing each product manually.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Make Coupon for a sale price?’ is closed to new replies.