fbpx
0
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.
Replies (4)
bindCommerce Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
up
bindCommerce Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
up
Vijaya Sharma Accepted Answer Pending Moderation
Team
  1. Replied more than a month ago
  2. #Permalink
Hello,

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

Thank You & Stay Safe
Aditya Chakraborty Accepted Answer Pending Moderation
Team
  1. Replied one week ago
  2. #Permalink
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.
However, you are not allowed 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

?
?