FGO Invoices for OpenCart — FGO invoices from orders, CUI and e-Factura

FGO Invoices for OpenCart 4.x, 3.x and 2.3 issues an invoice (factura) from an order in the Romanian service FGO through its API v2. The buyer enters the CUI and trade register number at the checkout, and the invoice appears in your series with the right buyer, rows and VAT (TVA) rates.

Which FGO subscription you need. FGO gives API v2 keys to companies on the Premium and Enterprise subscriptions. Reading the stock of the whole warehouse is a call FGO gives on Enterprise only. To try things out there is the FGO test environment (testuat.fgo.ro): in the module it is the “Environment: Live / Test” switch.

What the buyer sees

At the OpenCart checkout the buyer sees “CUI” and “Reg. Com.” (the module creates them with “Create the fields” for all customer groups, not compulsory). A buyer who enters a CUI is invoiced as a company; otherwise as a private person. A Romanian CUI with a wrong check digit is refused at the checkout with an explanation.

What the admin gets

Extensions → Modules → FGO Invoices: the Connection, Buyer, Invoice, Automation and Pro tabs. The connection needs the API key (FGO → eCommerce → API → Chei API), the CUI of your company and the shop address. The address must match the one registered in FGO (Setări eCommerce → API) character for character: the module shows the exact address it sends. “Save and check the connection” checks the key, shows its rights and reads the document types, VAT rates and warehouses from FGO. The key is stored encrypted.

The order page gets the “Invoice (FGO)” panel: the buyer, a preview of the rows (prices with VAT, the discount as a separate row per VAT rate, shipping), and the CUI can be corrected for this order. Once issued it shows the document number with a link to the PDF in FGO, the total and the state. Sales has a list of invoices with the filters In progress, Stopped, Issued, Storno and Cancelled. A stopped invoice can be retried or removed.

An invoice is never made twice: every request carries the order number as the external id and FGO checks for a duplicate, so after a lost answer the module picks up the invoice that already exists. The invoice total equals the order total to the ban, in a second currency too; when the rows do not add up to the order, the invoice is not sent and the module shows both totals.

In Pro the invoice is issued by itself at the order statuses you choose. Orders paid at the checkout are marked as collected in FGO right away, cash on delivery and bank transfer by status or with a button, with a separate payment type for cash on delivery. Invoices go to e-Factura (SPV): off, companies only or everyone, and the state is shown on the order. FGO e-mails the PDF to the buyer. A storno invoice for the whole order and cancelling work by button or by status; a storno can be taken back. The courier’s AWB number goes on the invoice before or after it is issued. Private buyers can have their own series.

Stock in Pro: invoice rows take the products out of the FGO warehouse (gestiune), and the quantity FGO returns after the invoice is written on the product in the shop. Reading the whole warehouse every hour works on the FGO Enterprise subscription. Products are matched by code (Model or SKU); the product’s own quantity is written, not those of option values.

How it works, step by step

1. Install the archive for your OpenCart version and switch the module on.
2. In FGO generate an API key and register the shop address (Setări eCommerce → API), and create a series in the document register.
3. On the Connection tab choose the environment, paste the key and the CUI of your company and press “Save and check the connection”.
4. On the Buyer tab create the CUI and Reg. Com. fields with one button; on the Invoice tab enter the series.
5. On the order page look at the rows and issue the invoice.
6. In Pro the invoice, payment, e-Factura, e-mail and storno follow the order statuses.

Under the hood

• FGO API v2; the key is encrypted and its rights are shown in the settings.
• The invoice total equals the order total; rows that do not add up stop the invoice before it is sent.
• No duplicates after a lost answer.
• You type the invoice series yourself: the FGO API has no list of series.
• A storno through the module covers the whole order; a partial one is made in FGO.
• FGO does not cancel an invoice that is collected in full or sent to SPV: use a storno for those.
• The CUI and Reg. Com. fields are standard OpenCart Custom Fields.
• OpenCart events, no core edits; uninstalling keeps the invoice tables.
• Interface in English and Romanian.

How to install

1. Extensions → Installer: upload the archive for your version without renaming it (OpenCart 4: cc_fgo.ocmod.zip, 3.x: cc_fgo-oc3.ocmod.zip, 2.3: cc_fgo-oc23.ocmod.zip).
2. For 3.x and 2.3: Extensions → Modifications → Refresh.
3. Extensions → Modules → FGO Invoices: install and edit.
4. Paste the API key and the CUI, check the connection, create the buyer fields and enter the series.
5. For Pro: paste the key or start the trial on the Pro tab.