OsFinancials Howto version 1.0

Jump to: navigation, search

Inhoud

[bewerken]

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 ;-)

[bewerken]

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 
 <@PREFIX>products.products_id, 
 <@PREFIX>products.products_quantity, 
 <@PREFIX>products.products_model, 
 <@PREFIX>products.products_image, 
 <@PREFIX>products.products_price, 
 <@PREFIX>products.products_date_added, 
 <@PREFIX>products.products_last_modified, 
 <@PREFIX>products.products_date_available, 
 <@PREFIX>products.products_weight, 
 <@PREFIX>products.products_status, 
 <@PREFIX>products.products_tax_class_id, 
 <@PREFIX>products.manufacturers_id, 
 <@PREFIX>products.products_ordered, 
 <@PREFIX>products_description.products_name,
 IF(<@PREFIX>specials.status, <@PREFIX>specials.specials_new_products_price, <@PREFIX>products.products_price ) as price1,
 <@PREFIX>products.products_price as price2, 
 <@PREFIX>products.products_price as price3
 FROM <@PREFIX>products join <@PREFIX>products_description using(products_id) left join <@PREFIX>specials using (products_id)   
 where
 <@PREFIX>products_description.language_id = %s
 and ((<@PREFIX>products.products_date_added >=  %s) and (<@PREFIX>products.products_last_modified is null or    
 <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified >= %s ) 
 and ((<@PREFIX>products.products_date_added <=  %s) and (<@PREFIX>products.products_last_modified is null or 
 <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified <= %s ) 
 order by products_id
[bewerken]

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 
 <@PREFIX>products.products_id, 
 <@PREFIX>products.products_quantity, 
 <@PREFIX>products.products_model, 
 <@PREFIX>products.products_image, 
 <@PREFIX>products.products_price, 
 <@PREFIX>products.products_date_added, 
 <@PREFIX>products.products_last_modified, 
 <@PREFIX>products.products_date_available, 
 <@PREFIX>products.products_weight, 
 <@PREFIX>products.products_status, 
 <@PREFIX>products.products_tax_class_id, 
 <@PREFIX>products.manufacturers_id, 
 <@PREFIX>products.products_ordered, 
 <@PREFIX>products_description.products_name,
 <@PREFIX>products.products_id as barcode 
 FROM <@PREFIX>products join <@PREFIX>products_description using(products_id) left join <@PREFIX>specials using (products_id)   
 where
 <@PREFIX>products_description.language_id = %s
 and ((<@PREFIX>products.products_date_added >=  %s) and (<@PREFIX>products.products_last_modified is null or    
 <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified >= %s ) 
 and ((<@PREFIX>products.products_date_added <=  %s) and (<@PREFIX>products.products_last_modified is null or 
 <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified <= %s ) 
 order by products_id
Retrieved from "http://osfinancials.com/mediawiki/index.php/OsFinancials_Howto_version_1.0"
Personal tools