Can anyone point me to the tables these data exist?
Difficult, but I’m sure we can figure it out. Could you please reformat the fields in such a way that I can see where the one ends and the other begins? That would be a nice start :D
Also, can he provide a short description of each field? The more the better!
Another vote for ErpNext - it is intuitive, rich in functionality, has a good community and is truly open source.
I have been using it for a while now though I have not integrated it with TB except for export-import of contacts through extracts.
There has been discussion on Erpnext forums to integrate with a good ecommerce system and it would be great to join forces to build a Erpnext-TB ecosystem that will be compelling to any business.
Hope this is better. We need the corresponding data (not the same names)
@mdekker, any progress on this ?
I vote for erpnext too!
So after a lot of digging I found what needs to be exported from the database. Question is how do I export it? Is there a query command to export all order data (eg what is displayed in the BO in the order detail) Should something else be used ?
I suggest to have a look at Datakick module or to contact Petr from Datakick (search forum). This module seems to shine in export and import processes and data manipulation of fields and tables.
@Pedalman I can’t use a module for that. I need the query because the erp system will execute it on the db to get the data it needs.
I already found this:
SELECT d.id_order, os.name AS tila, d.product_name, d.product_reference, d.product_price, d.product_quantity, o.payment,
o.date_upd, g.lastname, g.firstname, g.id_customer, ad.address1, ad.address2, ad.postcode, ad.city, ad.other, ad.phone, ad.phone_mobile, ai.address1, ai.address2, ai.postcode, ai.city, ai.other, ai.phone, ai.phone_mobile, g.email
FROM ps_order_detail d
LEFT JOIN ps_orders o ON (d.id_order = o.id_order)
LEFT JOIN ps_address ad ON (o.id_address_delivery = ad.id_address)
LEFT JOIN ps_address ai ON (o.id_address_invoice = ai.id_address)
LEFT JOIN ps_stock_available s ON (d.product_id = s.id_product)
LEFT JOIN ps_customer g ON (o.id_customer = g.id_customer)
LEFT JOIN ps_group_lang gl ON (g.id_default_group = gl.id_group) AND gl.name LIKE 'piiri%'
LEFT JOIN ps_order_state_lang os ON (o.current_state = os.id_order_state)
WHERE os.id_lang = 1
But it is missing some data. I am sure @datakick knows more on this What I basicly need is all data that is displayed in the Backoffice on the order detail page
@nickon you can install my module and create list that matches your criteria. Once you are satisfied, you can add
the the url and my module will tell you the query it used to retrieve the data. That could help you a bit.
Thanks @datakick nice tip. But what is the direct url to the list ?