Sales Order Entry Shopify CSV import A new program has been developed to allow CSV or Excel format files exported from the online retail software Shopify to be bulk imported into WinMAGI as new sales orders. The CSV (or Excel) file is exported directly out of Shopify and can then be uploaded into WinMAGI. Validation […]
Excel
WinMAGI Redgum Warehouse Location Spreadsheet
A new utility has been developed that gives a visual representation of the available stocking locations within a warehouse using Excel. The user simply enters in the warehouse id and nominates the aisle component of the location field and all locations within the warehouse are automatically displayed to the screen in aisle sequence with a […]
Customer Sales Rebates
Quickly calculate customer rebates using the Rebates Pivot Table utility. Setup the rebate percentages based on customer, customer and product class and whether the rebates apply to overall sales or sales over and above nominated customer targets. The Rebates Pivot Table utility allows the rebate values to be broken down into month and year and […]
Auto Create Sales Orders from CSV, Excel or Text files
WinMAGI has the ability to import data from 3rd party sources to automatically load and create new sales orders. If your customer is able to supply a CSV, Excel or Text file with their order requirements, then WinMAGI can import this data and automatically create new planned sales orders. The incoming data can hold details […]
New Excel Pivot Table exports
WinMAGI now has additional Excel Pivot table interfacing functions. On a screen by screen basis, and a table by table basis, you can develop a standard Excel Pivot table simply with the click of a button. You can now let the power of the Excel Pivot tables help you to drill down into the WinMAGI data.