Hey,
I'm on a steep learning curve with Thirty Bees, it's been great so far but I've hit a snag!
I want to export all my orders into one Spreadsheet where I can see all the different details, including private notes, delivery messages and personalised text.
Along with all the normal bits and pieces like order number and name and address etc.
I've found this from another post and I've altered it a little, but can't work out how to add private notes, delivery messages and personalised text...
The other issue is it's currently giving me 9 lines per individual product order. Is there a way to stop that happening without losing any info? For example I would like to see 3 lines if someone ordered 3 of exactly the same product. currently I would essentially see the same line 27 times. (I only say this because I could easily delete duplicate lines in my spreadsheet, but I don't want to accidentally delete orders if they do exist but appear the same on the spreadsheet)
I've searched a lot about SQL and what it means but I think I'd learn quicker if someone was able to help me build my query in relation to Thirtybees.
The forum has been a great source of info fo me so far! It's a great piece of software!