fbpx
  Monday, 31 August 2020
  4 Replies
  3.8K Visits
  Subscribe
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.
4 years ago
·
#5008
up
4 years ago
·
#5086
up
4 years ago
·
#5087
Hello,

We apologize for missing this post. I am forwarding this to the team. I will update you soon.

Thank You & Stay Safe
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?
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
  • +1 (408) 821-8283
  • Email hello@sellacious.com