Jiwa

Hi,

After Jiwa & Magneto integration I imported Magento Orders to Jiwa, which were successfully imported.

I just want to know that if Orders imported from Magento are listed anywhere (in one separate form) in Jiwa ?

Or how can we filter Magneto Orders in Jiwa Sales Orders section ?

Thanks

Hi Ahmed,

There are a few ways to do this.

One way is to make a plugin which adds a form showing which orders are Magento orders - we can identify those because the sales order in Jiwa has a custom field "magento_increment_id" which links it to the Magento order - so any orders which there value is not null or blank are a Magento sourced order.

Another way is to make a sales order search filter, showing the same orders.

The filter query would be:

Code: Select all

SO_Main.InvoiceID IN (SELECT InvoiceID FROM SO_CustomSettingValues WHERE SettingID IN (SELECT SettingID FROM SO_CustomSetting WHERE SettingName = 'magento_increment_id'))

To show how to do this, load the sales order form in Jiwa, press the search button to load the search dialog, then select the edit filters button:


Then when searching, you can select the newly added filter: