Custom WooCommerce Order Report
- or -
Post a project like this£17/hr(approx. $22/hr)
- Posted:
- Proposals: 5
- Remote
- #423982
- Expired
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the website: A report showing Customers who purchased a given product
Kind of development: Customization of existing website
Description of requirements/features: Im using WooCommerce along with the WooTickets Plugin and The Events Calendar plugin (both from Modern Tribe) to sell tickets for training courses.
Courses are setup as Events.
Each training course (Event) has a set number of seats (controlled via WooTickets).
Customers come onto the website and can purchase a place on the training course (handled via WooCommerce).
Due to the way WooCommerce, WooTickets and The Events Calendar work together, the existing "Sales By Product" report is not fit for purpose. And so I need it altering (or a new version creating) to work better.
I've created a proof of concept that pulls all the info I require. I now need an experienced developer to integrate this into a custom report and ensure that the report is working optimally.
~~~
A little more detail:
I want the report to show several pieces of information:
> Some meta information from the corresponding Event
> The Event Title
> The Event Category
> The Name of the customer who made the order
I want to be able to go into the "Sales by Product" report and then search for a "product" based on either an Event Title or code (a meta field within the Event) or a different code (a meta field within the WooTicket).
I will run report either before the course starts (so I can see who is attending) or after the course is over.
This report will show a table of customer names and a few other bits of info.
~~~
So, where to get all of this data?
Each WooCommerce Order, has an Order ID.
Once an Order is placed, this Order ID is recorded within the corresponding meta table of the "tribe_wooticket" post type.
Within this table, the corresponding Event ID is also recorded.
Let me give you an example using made-up data:-
I add a new Event ~ it has an ID 10
I then add some tickets to this Event ~ these tickets are a post type of their own so have an ID of 30
A customer purchases a place on this course, this Order (also a post type) has an ID of 50.
Into the WooTicket post, values of 50 and 10 are added to it's meta information, showing that an order has been placed and indicating which Event the ticket is for.
So, I can take the order number (50) and look for WooTickets that have this as a value within their meta data.
Once I've found that, I can find the corresponding Event ID and then grab all the info I need.
I've written some PHP which will show recent orders, pulling the Order ID and then finding the relevant information from the other post types. I can show this to you.
Caveat: my code is a proof of concept. Im sure there will be better/more efficient ways to doing that Im doing! I wont be offended if you decide to scrap what I have in place of something better!!
It sounds quite complicated but honestly once you've got your head around it, it's not too bad.
I've created a very short video walkthrough here which I hope demonstrates what Im after: http://vimeo.com/86926374
Specific technologies required: woocommerce, wordpress, mysql
Extra notes: Any Experience of The Events Calendar or WooTickets plugin (both by Modern Tribe) highly advantageous.
Kind of development: Customization of existing website
Description of requirements/features: Im using WooCommerce along with the WooTickets Plugin and The Events Calendar plugin (both from Modern Tribe) to sell tickets for training courses.
Courses are setup as Events.
Each training course (Event) has a set number of seats (controlled via WooTickets).
Customers come onto the website and can purchase a place on the training course (handled via WooCommerce).
Due to the way WooCommerce, WooTickets and The Events Calendar work together, the existing "Sales By Product" report is not fit for purpose. And so I need it altering (or a new version creating) to work better.
I've created a proof of concept that pulls all the info I require. I now need an experienced developer to integrate this into a custom report and ensure that the report is working optimally.
~~~
A little more detail:
I want the report to show several pieces of information:
> Some meta information from the corresponding Event
> The Event Title
> The Event Category
> The Name of the customer who made the order
I want to be able to go into the "Sales by Product" report and then search for a "product" based on either an Event Title or code (a meta field within the Event) or a different code (a meta field within the WooTicket).
I will run report either before the course starts (so I can see who is attending) or after the course is over.
This report will show a table of customer names and a few other bits of info.
~~~
So, where to get all of this data?
Each WooCommerce Order, has an Order ID.
Once an Order is placed, this Order ID is recorded within the corresponding meta table of the "tribe_wooticket" post type.
Within this table, the corresponding Event ID is also recorded.
Let me give you an example using made-up data:-
I add a new Event ~ it has an ID 10
I then add some tickets to this Event ~ these tickets are a post type of their own so have an ID of 30
A customer purchases a place on this course, this Order (also a post type) has an ID of 50.
Into the WooTicket post, values of 50 and 10 are added to it's meta information, showing that an order has been placed and indicating which Event the ticket is for.
So, I can take the order number (50) and look for WooTickets that have this as a value within their meta data.
Once I've found that, I can find the corresponding Event ID and then grab all the info I need.
I've written some PHP which will show recent orders, pulling the Order ID and then finding the relevant information from the other post types. I can show this to you.
Caveat: my code is a proof of concept. Im sure there will be better/more efficient ways to doing that Im doing! I wont be offended if you decide to scrap what I have in place of something better!!
It sounds quite complicated but honestly once you've got your head around it, it's not too bad.
I've created a very short video walkthrough here which I hope demonstrates what Im after: http://vimeo.com/86926374
Specific technologies required: woocommerce, wordpress, mysql
Extra notes: Any Experience of The Events Calendar or WooTickets plugin (both by Modern Tribe) highly advantageous.
Chris H.
100% (198)Projects Completed
165
Freelancers worked with
115
Projects awarded
13%
Last project
2 Dec 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies