Page Comparison

Orders use an optimisation cache that updates automatically as data ages

Administrators can update the cache manually anytime from the sales order screen

Image Added

Soulfresh Global Pty Ltd 

Columns that do not match up with one of the import names will be ignored and the first line on the import result will be a list of the ignored columns

Useful Google Sheet calculations:

1. Look for a material in the suppliers name (use named ranges) =INDEX(Materialresultlist,MATCH(TRUE,ISNUMBER(SEARCH(Materiallist,B2)),0))
   1. Note ensure the list of materials is sorted longest at the top - then "Shiny Red" will be found before "Red"
   2. Export from the item Profile for Material to find a list of possible values for that material
2. If the supplier provides the name all in caps = Proper(a2)
   1. may need to adjust Ml to ml etc after