Magento Order Listings in Jiwa Sales Orders  Topic is solved

Find general Jiwa support here.

Magento Order Listings in Jiwa Sales Orders

Postby Ahmed » Thu Jul 14, 2016 8:44 pm

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
Ahmed
Occasional Contributor
Occasional Contributor
 
Posts: 14
Joined: Fri Feb 26, 2016 9:26 pm

Re: Magento Order Listings in Jiwa Sales Orders  Topic is solved

Postby Mike.Sheen » Sun Jul 31, 2016 3:05 pm

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:
MagentoFilter.PNG
Add Magento Filter


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

MagentoFilterUse.PNG
Filter Selection
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755


Return to Core Product Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron