Hi Abhishek,
I am writing to you following our call yesterday.
In order to make a marketplace manageable by the Staff, it is necessary to ensure the dynamic connection between orders, order items and transactions.
It needs to choose which order states / order item states create transactions, approve them, and cancel them.
The same operation is necessary to manage the shipping costs paid by customers (and possibly reimbursed).
Furthermore, it is necessary to be able to manage the information to be entered in the notes field of the transaction table, because today the information is not significant for the seller (example P94935V0S873). We need to be able to enter local_sku, manufacturer_sku and / or seller_sku.
The first step in managing this improvement process is to have a field order_item_id in the transactions table (missing today)
I will already create it today in order to try to create a report for my client (and the next challenge will be to fill it starting from the information I have in the notes field)
ALTER TABLE `%%_sellacious_transactions` ADD `order_item_id` INT(11) NULL AFTER `order_id`;
ALTER TABLE `%%_sellacious_transactions` ADD INDEX(`order_item_id`);
I ask you to release a quick fix to fill order_item_id.
In the meantime, I will look for a way to fill it for the 1000 order items that have already been created.
Thanks for collaboration
Paolo