Improve company productivity with a Business Account.Sign Up

x
?
Solved

Non-standard WooCommerce order report

Posted on 2014-03-10
1
Medium Priority
?
398 Views
Last Modified: 2014-03-13
Hi,

I've been asked to investigate the possible use of WooCommerce as an online store. To do this, I've done a quick installation and it ticks just about every requirement but there's one I'm stuck on.

Products are set up with sizes, for example:

Jumpers........sizes 11, 12, 13, 14, 15
Trousers.......sizes 28, 30, 32, 34, 36

An order is placed as follows:

Order Number: 1
Date: 09/03/2014
Jumpers: size 11, quantity 2..............size 14, quantity 4
Trousers: size 30, quantity 1.............size 32, quantity 3

and another:
Order Number: 2
Date: 10/03/2014
Jumpers: size 12, quantity 7..............size 13, quantity 5
Trousers: size 28, quantity 4.............size 36, quantity 6
 
My question is...is it possible to run an order report that will show orders placed between 2 dates, reading the detail left to right, by size, as below:

Order Number
1
Jumpers...Sizes......11...12...13...14....15
Jumpers...Quantity...2....0....0....4.....0
Trousers..Sizes......28...30...32...34....36
Trousers..Quantity...0....1....3....0.....0

2
Jumpers...Sizes......11...12...13...14....15
Jumpers...Quantity...0....7....5....0.....0
Trousers..Sizes......28...30...32...34....36
Trousers..Quantity...4....0....0....0.....6

I've done this report before in VBA in MS Access but can it be done in Wordpress and if so, how would I go about it?

Many thanks in advance
0
Comment
Question by:kbit
1 Comment
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 39917715
It's not a standard WooCommerce report.

What you can do is download the MyODBC driver from mysql.com and install it/create a connection to the WordPress database.  You then import the MySQL stuff as linked tables in  Access and use your existing skills to recreate the needed report.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

By following these Magento e-commerce development tips, you can increase your website's conversion and profitability. Read this post for more details.
Product Customization Software has become the need of the hour for businesses to grow and gain better ROI. Know what makes it a must-have tool for your business to thrive.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question