How to customize the Welcome screen

The necessary files are stored in the Bin/Welcome directory and subdirectories of your osFinancials installation.

I started of by adding a font tag to enforce sans-serif font on the page. Then I added previous years figures for the totals for current and previous month as well as YearToDate figures. You will need to modify the osfmain.htm and create additional sql files named appropriately in the sql subdirectory.

How to print barcodes on labels (Reports-Stock-Print Labels)

I Googled for "3 of 9 barcode font", and found a free 3 of 9 font at http://www.barcodesinc.com/free-barcode-font/ Unzip it and copy the fonts to your Fonts folder, which you can open from the Windows Control Panel.

After that, you will need to make sure that the Barcode field is filled in for each product that you want to have a barcode under Input-Adjust Stock or other interface.

That was enough for my barcodes to start showing up, and maybe I didn't even need to download the barcode font. Correct, it isn't needed to install additional fonts as they are in the program already ;-)

Retrieve special pricing from osCommerce specials table

Ideally, an option to 1) store the sale price in price field 1, 2 or 3 2) detect addition of special pricing with each stock update (needs to first remove any special prices as it is not possible to detect which special prices have been deleted completely from osCommerce)

See https://sourceforge.net/tracker/index.php?func=detail&aid=1692119&group_id=169037&atid=848824

For 1) the following ZQProducts.txt will store the sale price in pricefield1 and the regular price in field 2 and 3.

 SELECT    products.products_id,    products.products_quantity,    products.products_model,    products.products_image,    products.products_price,    products.products_date_added,    products.products_last_modified,    products.products_date_available,    products.products_weight,    products.products_status,    products.products_tax_class_id,    products.manufacturers_id,    products.products_ordered,    products_description.products_name,   IF(specials.status, specials.specials_new_products_price, products.products_price ) as price1,   products.products_price as price2,    products.products_price as price3   FROM products join products_description using(products_id) left join specials using (products_id)      where   products_description.language_id = %s   and ((products.products_date_added >=  %s) and (products.products_last_modified is null or       products.products_last_modified =  00000000 ) or products.products_last_modified >= %s )    and ((products.products_date_added <=  %s) and (products.products_last_modified is null or    products.products_last_modified =  00000000 ) or products.products_last_modified <= %s )    order by products_id  

Option to have barcode sourced externally

Ideally, dynamic mapping of 'barcode' field in the sql dataset to the barcode field in osF. This would allow anyone to have a flexible way to source the barcode from data in osCommerce product and/or other table if they should desire to e.g.

• select model as barcode ...
• select products_id as barcode ...

See https://sourceforge.net/tracker/index.php?func=detail&aid=1692121&group_id=169037&atid=848824

The following code in ZQProducts.txt will put the products_id as barcode in osF

 SELECT    products.products_id,    products.products_quantity,    products.products_model,    products.products_image,    products.products_price,    products.products_date_added,    products.products_last_modified,    products.products_date_available,    products.products_weight,    products.products_status,    products.products_tax_class_id,    products.manufacturers_id,    products.products_ordered,    products_description.products_name,   products.products_id as barcode    FROM products join products_description using(products_id) left join specials using (products_id)      where   products_description.language_id = %s   and ((products.products_date_added >=  %s) and (products.products_last_modified is null or       products.products_last_modified =  00000000 ) or products.products_last_modified >= %s )    and ((products.products_date_added <=  %s) and (products.products_last_modified is null or    products.products_last_modified =  00000000 ) or products.products_last_modified <= %s )    order by products_id