fbpx
0
  Monday, 31 August 2020
  4 Replies
  1.2K 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.
up
up
1 year 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
9 months ago
·
#5466
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!
Support is Offline
Support Hours
Monday To Saturday
From 09:00 To 21:00 IST
Sellacious Time 00:00:00

Login

?
?
  • +91 9410060107
  • Email contact@sellacious.com