[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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