Checkbox Cashier Assistant

Description Checkbox Cashier Assistant

Checkbox integration into Google Sheets.

Feature description:

This script is designed to automate the cashier's work using the Checkbox API service integrated into Google Sheets. 

Key features:

• Cashier authorization via PIN code and license key.
• Open and close a cash shift, and check the current status of the shift.
• Generate sales receipts through a convenient pop-up form built directly into Google Sheet.
• Selection of products (name, price, quantity, product code) with the ability to add several items.
• Support for different payment methods: Gotivka, Cardka, Bezgotivkovyi rozrakhunok (various methods)
• Printing a receipt and getting a link to the PDF version of the receipt.
• Recording of data about the receipt in the table: fiscal number, check ID, etc.
• Logging errors in a separate Google Sheetsheet.

Why is it indispensable? 

• Integration with Checkbox provides legal generation of electronic fiscal receipts.
• Ease of use — all work with receipts takes place directly from Google Sheets, without the need to switch between applications.
• Flexible and easy to set up – easily adaptable to the needs of small businesses or freelancers.
• Security — authorization through API keys and cashier PIN code, without storing sensitive data in the table itself.
• Automating routine tasks saves time and minimizes human error.
• Logging of all actions helps to track errors and analyze work.

What you need to work: 

• Google Table with a connected Apps Script project
• Active account on Checkbox
• Get a license key (LICENSE_KEY)
• Find out the cashier's PIN code (CASHIER_PIN)
• Configured cash register (cash register) in the Checkbox.ua
• system Internet access to call external APIs
• Correctly filled out table structure, for example:
• Columns: Product Name, Price, Quantity, Product Code, Fiscal Receipt Number, Check ID, etc.
• Enabled Google Sheets APIs and UrlFetchApp
• First runs may require permission to access external URLs and services.

Conclusion:

"Checkbox Cashier Assistant" is the perfect assistant for any user who wants to simplify and automate the process of creating fiscal receipts through Google Sheets using the power of Checkbox.ua. It increases the transparency, accuracy, and speed of working with the cash register and financial documentation.