Support » Plugin: WooCommerce Sequential Order Numbers » Pre-Sales: Number Sequencing for Single Product Line?

  • Resolved raccroc

    (@raccroc)


    Pre-Sales Question – Can the sequential numbering be assigned to only a specific product category or tag, but not others (or can some categories/tags be filtered out)?

    We have a small woocommerce storefront selling things to support our non-profit. We have decided to start a raffle fundraiser, where we want to sell tickets both online and in-person. The idea is, create a sequential number sequence to match a roll of physical tickets, when we can mix with those sold offline from another roll. At the drawing, the offline tickets will have names&numbers on them, while the online ones would match Woocommerce sales we can look up.

    If we cannot setup only a single sequence of numbers for everything, then any non-raffle ticket product purchases would gum up the works by throwing off the raffle number.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author SkyVerge

    (@skyverge)

    HeyΒ @raccroc,

    Thanks for writing to us about our plugin! I’d be happy to help out here. πŸ™‚

    I’m afraid that the plugin would likely not work for your needs as it applies sequential numbering to all of the orders and doesn’t offer a way to only apply these to specific categories.

    Having said that, I’d love to learn a little more about how you’d use this functionality so I see if I can make a recommendation for any alternatives.

    Could you please give me a bit more insight into how this functionality would work? Also, how would the integration ensure that orders coming from the online shop, which are assigned order numbers at random, don’t have order numbers that clash with the sequential order numbers?

    Thanks,

    Tamara

    Appreciate the reply. That was my fear, and not at all surprising. It seems like I keep hitting my head against the wall trying to do something which just doesn’t seem like it should be all that difficult.

    Here is a better explanation…

    Background: I am the president of a small non-profit, all volunteer dog rescue. I have a background in Networking and Sys Admin, which makes me the “tech guy” even though I don’t have a web-dev background at all. I built us a web page using WordPress and added on WooCommerce so we could sell shirts and other types of logo-wear on the site.

    Recently, the ladies of the rescue decided they want to sell tickets for a raffle drawing of donated goods as a fundraiser.

    Our Plan:
    Sell raffle tickets at our booths during a couple of festival events in December.
    Sell raffle tickets online and promote them on our social networks.
    Have a live “put-your-hand-in-a-bag” drawing at the end of the second festival event.

    I looked at raffle web sites and WordPress plugins; however, most of what I found really doesn’t work for what we want. They tend to focus mostly on things like generating winners, prize distribution, and pretty front ends. I have no issues building the front end and don’t really need most of the other features. Similar type of experience with various events/tickets type of plugins, which were largely full of needless (to us) features, such as reservations.

    My Plan:
    Buy two rolls of Raffle Tickets.
    Roll 1 – Ticket Numbers 657001-657999
    Roll 2 – Ticket Numbers 658001-658999
    Offline: Sell Roll 1 tickets for Cash Only. Whenever someone buys in cash, capture their Name, Phone #, Email, and 657XXX number(s) on a simple sales sheet, tear off the corresponding ticket, and put it in a bag.
    Online: For online and in-person Credit Card transactions, process via Woocommerce and capture their Name, Phone #, Email, and a sequential number for each purchased ticket starting at 658XXX.
    At the end of the Raffle Tickets Sales Deadline, we look up the number of online tickets sold, tear off that many tickets, and add them to the same bag as the offline/cash tickets.
    Draw a ticket…
    If it starts with 657, look at the sign-up sales sheet for the contact info of the winner.
    If is starts with 687, look up in Woocommerce to find that Order Number for the contact info for the winner.

    It looks like WooCommerce Sequential Order Numbers Pro would allow us to sync up the online Order Number with the physical roll of ticket number. Problem we would have is if the sequential numbers were not filtered/locked to a specific category or tag (such as raffle) would be that the numbers would no longer correspond to a specific ticket any longer if anyone buys anything else off our website at any point during the raffle period. My hope was that we could assign different starting numbers for each product category, each which it’s own custom order numbering scheme. It seems to be clashes with random numbers could easily be avoided by enforcing that when using “mixed mode” all product categories using sequential numbers would be forced to have a prefix set, such as raff-, whereas anything using random order numbers would not. Not allowing the same number of digits for both random and fixed would also avoid clashes.

    Sounded very simple in my head. Apparently I was wrong.

    I guess one possible solution would be to create and fully separate sand-boxed WordPress/WooCommerce and then frame it in to our main site, but that seems like a lot of work for something so silly.

    With appreciation -john

    Plugin Author SkyVerge

    (@skyverge)

    Hey John,

    I hope you had an awesome weekend! Thanks so much for such a detailed reply πŸ™‚

    I’m not sure of any plugins that would work well for you out-of-the-box. It sounds like the best alternatives here would be a custom-coded solution which saves the raffle numbers as post meta on the order and displays this in the admin and, if needed, the frontend, or a separate website for the raffle sales.

    If you’d like to look into the custom code route, we typically recommend reaching out to Codeable to find a developer to assist with these sort of projects. Our Codeable link will even get you 5% off your first project πŸ™‚

    I’m sorry I couldn’t be of much help here but I hope this was helpful nonetheless. Could I help you with any other questions?

    Thanks,
    Tamara

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.