Link to home
Start Free TrialLog in
Avatar of kbit
kbit

asked on

Non-standard WooCommerce order report

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
ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial