How to map information from your Automatic imports into a specific fields

How to map information from your Automatic imports into a specific fields


How to map information from your Automatic imports into specific fields


The best way to do this is to write an Advanced Order Processing Rule (click on the ... button at the bottom of the screen next to the Advanced button).

What you can is select Shopify orders that do not have Custom Value 20 entered, i.e.

Select Use custom SQL with a value of :

[sSalesSource] = 'Shopify' AND [TOrder].[nState] 2 AND [TCustomValues].[C20] = ''

Then set the SQL to use if found to:

[TCustomValues].[C20]=[TOrder].[mNotes]

This can be adjusted and customized to suit your needs if you require more help please contact us.