This program is used for to perform multiple product information lookup with calculation of prices based on constants such as base selling price, lowest selling price, GST.
- Make sure that you have python installed in your computer
- Download this file, and place it where it pleases
There are two input files. One is from MYOB and the user input
This file does not need to be changed often if there are no new product codes in the system. This essentially contains extra information on the items in the warehouse such as the supplier, description, the amount of selling units per buying units.
With this specific type of export in CSV, MYOB sometimes put "," in terms the fields, so this is better to be exported as txt file to be separated by tabs,
- Locate the file - This can be found in MYOB: File (Top-left corner) >> Import/Export Assistance
- Select Export Data. Press Next
- Select "Items" as the file to export.
- Select "Item Sales" as the type of sales.
- Select the date range (recommended is 1 Month before up to Today). Press Next
- Select the seperate data using "tabs", and Make sure the field "Include field headers in the file" is checked. Press next
- Export All fields
- Press Next to export and save as "ITEM.txt" inside the input/sets folder of the program. (You may need to change the save as type to "All Files", and change the format name)
- Fill this with information about the item you need. The code can either be a supplier code or a product code, either way this will work.
- See the sample files under the input section
Start by opening the program "start.bat"
The execution of the program will output 2 file:
- "lookup.csv" - contains the filled up information
- "nonMatchingCodes.csv" - contains the list of the codes that was not found in the system/ the file "products.csv" that is provided