Export price list into CSV file.
Keywords: export price list into CSV file.
You can use Beigesoft™ EIS to make price lists in different price categories, e.g. "Price for shop1", "Price for customers A". Pricing is available in the "Web-Store" part of Beigesoft EIS.
There are no standards to make a price list in a CSV file for a POS. For example, different POS require different tax formats. For example, consider making CSV file for multiple-tax TAX5% and TAX6% and 3 items: product1(TAX5%,TAX6%), product2(TAX5%), product3(non-taxable):
POS1 requires this format:
Product,ProductCode,Price,TaxMethod
product1,1,12.4,TAXMETH1
product2,2,11.41,TAXMETH2
product3,2,4.6,
POS2 requires this format:
Product,ProductCode,Price,UseTax5%,UseTax6%
product1,1,12.4,true,true
product2,2,11.41,true,false
product3,2,4.6,false,false
POS3 requires this format:
Product,ProductCode,Price,Tax5%,Tax6%
product1,1,12.4,5,6
product2,2,11.41,5,0
product3,2,4.6,0,0
there are else similar formats
Beigesoft™ EIS allows you to make a CSV file for numerous requirements.
Example of exporting price list into CSV file.
Assume we have three sales taxes: STG4.7%, STG6.4%, STS11%. A POS expects a CSV file with this format:
Product,ProductCode,Cost,Markup,Price,Tax,IsTaxIncudedInPrice,Discount,Supplier,Place,Quantity,Category,Variant,isService,isAvailable
product1,1,1.00,20.00,1.20,11.1,0,0.00,,room1,12,food,regular,0,1
product2,2,1.00,25.00,1.25,4.7,0,0.00,,room1,11,food,large,0,1
product3,3,2.00,25.00,2.50,0,0,0.00,,room1,11,drink,regular,0,1
there the tax means an aggregate tax rate (percent). The product1 has the tax category#1 (STG4.7%, STG6.4%), the product2 has the tax category#3 (STG4.7%), the product3 is not taxable.
First, add a "CSV Method" with the data retriever "Product price list" in menu - "main"-"..."-"CSV Methods":