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
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...
Jumpers...Quantity...2....
Trousers..Sizes......28...
Trousers..Quantity...0....
2
Jumpers...Sizes......11...
Jumpers...Quantity...0....
Trousers..Sizes......28...
Trousers..Quantity...4....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.