Jump to content
thirty bees forum

Minimonkay

Members
  • Posts

    9
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Minimonkay's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Thank you so much. This helps massively!
  2. Unfortunately I couldn't find it in the datakick module it was in the SQL manager within the thirty bees back office.
  3. Hey Mark! I don't know if this helps you at all but i managed to pull the note for customer data with an SQL query. It's in the table 'customer' and the attribute is 'note'. Hope this helps!
  4. Apologies guys and gals. I think I've figured it out. Here's a part of a query I've found by a helpful forum member: SELECT d.id_order, o.payment FROM order_detail d LEFT JOIN orders o ON (d.id_order = o.id_order) My question was referring to the d and the o before the id_order and payment respectively from SELECT. After some fiddling about I've discovered these are specified after the tables being referenced in the FROM and LEFT JOIN parts. I.e. you change the 'd' after 'order_detail' to another letter, and then the 'd' before 'id_order' to match and it works. In short there is no 'prefix' that exists outside of this specific query. Is this correct? Sorry for trying to run before i can walk and bothering everyone. I should learn the language.
  5. Hey all, I'm beginning to build my own SQL Queries to get information from orders etc. Having a lot of fun, but struggling with the prefix's used. For example I've worked out that the g. prefix is connected to customer information table, but how can I find out the prefix's used for all the other tables? I've searched for ages and I can't find anything. Thanks, Sam
  6. Hey Petr, Thanks for the info! So am I right in thinking there's no way for me to pull the notes I add to people's orders into a spreadsheet? Also I have a custom field on the product that the customer fills in, is there a way of bringing that in? Thank you for your help!
  7. Thanks! The stock available change helped with the 9 lines per order problem. I don't understand what the language condition would fix? It seems to generate ok without changing that line, and when I change it it returns the error: When multiple tables are used, each attribute must refer back to a table. Undefined "checkedFrom" error My next issue is getting the private note I've added to some orders.. I'm also building a list in datakick as this seems like a very useful module, but again I can't find the private note option in any of the data sets?
  8. These are all fantastic suggestions thank you. I'm having a look at datakick now. I've just tried your code Mediacom87 and it returns 'FROM does not exist' I've renamed it order_detail instead of the prefix ps_ as I'm running thirtybees instead of prestashop. I've also changed the other table names. But still no luck, any suggestions? Thanks all!
  9. 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!
×
×
  • Create New...