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":