[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

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
0
kbit
Asked:
kbit
1 Solution
 
Jason C. LevineNo oneCommented:
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now