I am attempting to import historical order data via GraphQL, using mutations. According to my research, an order record is a model schema with id: 8787. I am just wondering if you have documentation about an order record, what each field is used for or what it will be used for in the future? For example, I know that module_field_14/order_1 is the customer ID, order_2 is the customer email, order_3 is the order status, order_9 is the order total etc. but what about the other fields? It would be great if you could provide some more information regarding this, thanks a lot! also what fields are required and which ones are optional?
Hi Peter,
Sure, so we do not have all of these documented for now. However, you can easily find out what each field is, by doing a CLI pull of this site. Then navigate to:
form_configurations/modules/modules_14/order.liquidIn there is each field, the ID, the name, the data type and also if it is required. For example:
module_field_14/order_10:name: Currencytype: input_textlive: truehidden: falseorder: 0editable: truerequired: falsevalidation: {}Thanks!
Thanks @Emily. A follow up question though, where is the product information (e.g. product item, quantity etc.) for an order record located? As it seems the fields do not exist that hold this data. Is it in another record and linked somehow?
Hi @Peter Hanley ,
Sure, so you can also easily find this information out by doing a CLI pull of this site. The tables are named clearly, so you should be able to find where Products are found.
e.g.
module_14/orderis where Orders are storedI hope this helps!