Export the configurator data (Diagnostics)

Audience: operators & marketing · Scope: the Diagnostics menu group · Last reviewed: 2026-07-21

What this does — The Diagnostics group at the bottom of the menu holds two downloads and one shortcut. The downloads are the only way to see the whole catalog laid out in one place — useful for auditing the configurator, checking SKU codes in bulk, or handing a product list to someone outside the admin.

Nothing here changes anything. Both entries build a file and hand it to your browser; they are safe to click.

Before you start

• Be signed in — see Log in to the admin area.
• Click Diagnostics in the menu to expand it. It contains Configurator Data Sheet, Meta Commerce CSV, and Product list.
• Expect a wait. Both exports read the entire catalog, so the download can take a while to start. Click once and let it finish.

Configurator Data Sheet

Click it and the browser downloads Configurator Data.xlsx.

It is one big spreadsheet with one row per answer — so a product with 8 questions of 10 answers each contributes 80 rows. Read left to right, each row tells you the product, then the question it belongs to, then the answer itself:

Group of columns	What you get
Product	ID, title, subtitle, whether it's activated, whether it's discontinued, its CPQ configuration and ruleset
Question	ID, title, heading, whether it's activated, the question type, whether it's the luminaire question
Answer	ID, title, whether it's activated, the SKU-code segment, the calculation method, and the metric / imperial code variants
Codes	The question's imperial and metric length-of-fixture code segments, and whether the question appends to the catalog reference
Visibility	The customer groups the product is assigned to, by ID and by name
Links	Two "edit link" columns

The header row is bold and an auto-filter is already switched on, so you can filter by product, by activated/discontinued, or by any code column straight away.

What it's good for — finding every answer that is missing a code segment, checking a rename went through the whole catalog, comparing imperial against metric codes, or seeing at a glance which products are discontinued but still activated.

The two "edit link" columns don't work the way you'd hope. They point at www.betacalco.com/administrator/… — that is the live site (even when you ran the export somewhere else), and it is Joomla's own administrator login, which is a different login from the admin area you use. Treat those columns as a record of which product and question a row belongs to, not as clickable shortcuts. To open a record, use the ID from the row and the normal menu screens.

Meta Commerce CSV

Click it and the browser downloads Meta_Commerce_Product_Catalog.csv — a product feed in the format Meta's Commerce Manager expects, for showing the catalog on Facebook and Instagram.

One row per published product (not per answer), with the columns Meta asks for: id, title, description, availability, condition, price, link, image_link, brand.

How each is filled:

• id — the product's SKU, or PROD_<id> if the product has no SKU.
• title — the product title, with the subtitle appended after a dash when there is one.
• description — the product description with formatting stripped; the title is used if there's no description.
• availability — in stock, or out of stock for a discontinued product.
• condition — always new. brand — always Beta Calco.
• link — the product's own configurator page on this site.
• image_link — the product's thumbnail image on the live site.

Every product exports at the same price: 1000.00 USD. That is a fixed placeholder, not the product's real price — Beta-Calco products are quoted, not sold at a shelf price, so there is no single figure to publish. Before uploading this feed anywhere customer-facing, decide what should happen to the price column (Meta requires one to be present). If real prices ever need to appear here, that's a change for your Beta-Calco contact.

Product list

The third entry is not an export — it's a shortcut to the same product list you reach from Products at the top of the menu. See Add or edit a product.

Good to know

• Both exports read live data at the moment you click. There is no cache and no scheduled version, so what you download is the catalog as it stands right now.
• The two exports disagree on which products they include, on purpose. The Configurator Data Sheet covers everything, activated or not, so you can audit unfinished work. The Meta CSV covers published products only, because it feeds a public storefront.
• Nothing is sent anywhere. In particular, the Meta CSV is only downloaded to your computer — uploading it to Meta is a separate, manual job.

Troubleshooting

• The download never starts. These are large exports; give it a couple of minutes before retrying, and avoid clicking repeatedly — each click starts another full run.
• The spreadsheet opens with a warning about its format. That's normal for a generated .xlsx; open it anyway, or import it into Google Sheets.
• A product is missing from the Meta CSV. It is probably not published. Discontinued products are included — they come through as out of stock.

Screens and labels can differ slightly between environments — if a label doesn't match what you see, check with your Beta-Calco contact.