Here I rewrite a question left suspended in the month of July.
I added the field order_item_id on table #_sellacious_transactions and I updated the historical row with the query:
UPDATE `#_sellacious_transactions` AS tr
LEFT JOIN `#_sellacious_order_items` AS oi ON oi.item_uid=REPLACE(SUBSTRING_INDEX(tr.`notes`, 'Articolo: ', -1), '.', '') AND oi.order_id=tr.order_id
SET tr.order_item_id=oi.id
Please, could you fill in this crucial field every time you create a record in the table? Otherwise it becomes very difficult to make analyzes.
I added the field order_item_id on table #_sellacious_transactions and I updated the historical row with the query:
UPDATE `#_sellacious_transactions` AS tr
LEFT JOIN `#_sellacious_order_items` AS oi ON oi.item_uid=REPLACE(SUBSTRING_INDEX(tr.`notes`, 'Articolo: ', -1), '.', '') AND oi.order_id=tr.order_id
SET tr.order_item_id=oi.id
Please, could you fill in this crucial field every time you create a record in the table? Otherwise it becomes very difficult to make analyzes.
Hi,
I have a few queries regarding this,
1) For what kind of transactions, do you want to put order_item_id?
2) If you could tell what kind of analysis or statistics you're trying to do, maybe we can find an alternative solution.
3) From your query, you seem to be searching "Articolo" in transaction notes, is that some kind of requirement?
I have a few queries regarding this,
1) For what kind of transactions, do you want to put order_item_id?
2) If you could tell what kind of analysis or statistics you're trying to do, maybe we can find an alternative solution.
3) From your query, you seem to be searching "Articolo" in transaction notes, is that some kind of requirement?
Hello,
We apologize for missing this post. I am forwarding this to the team. I will update you soon.
Thank You & Stay Safe
We apologize for missing this post. I am forwarding this to the team. I will update you soon.
Thank You & Stay Safe
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Sellacious Time 00:00:00
Important Links
Company
Important Links
Information
Shortcut Links
Shortcut Links
Important Links
- +1 (408) 821-8283
- Email hello@sellacious.com