Easy way to enter Product Data from Access Database to Sambapos

[markjw]

@adam100

the product data (UPC, Product Name, and Price) are in spreadsheet form

Export this into Excel, then follow the guide below to add formulas into Excel to generate the YAML code needed to import using the batch product create feature.

Excel file to sambapos

Search the 'net to find tools to convert CSV to YAML. Or use Excel to read the CSV data and use this formula in a Cell: =CONCATENATE("- Name: ", A2, CHAR(10), " GroupCode: ", "Imported", CHAR(10), " Barcode: ", C2, CHAR(10), " Portions: ", CHAR(10), " - Name: Normal", CHAR(10), " Price: ", G2) That produces YAML formatted data from your CSV file. Copy the formula to every row. You will probably want to clean up your CSV data file. There are duplicate Products, and some wi…