Solved

Non-standard WooCommerce order report

Posted on 2014-03-10
1
390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
Learn about the eCommerce marketing trends for the year ahead.
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

749 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