Update your offers from a file or spreadsheet

Menu path

Main menu → Offer updates. This page is for an Authorized Supplier approved as a Seller, an Installer or both. Use it to update your own offers without opening each one, or to add offers for items already available in the Roraima catalogue. Owners use their product and booking pages instead.

You can upload a CSV file from your computer or have Roraima read a CSV link or Google Sheets automatically. A compatible management program is another automatic method. Your company uses one automatic method at a time, while manual CSV imports remain available.

Prepare the offer codes and values

Download my offers gives you the codes and current values of your existing offers. Download available catalog gives you the Roraima codes of the devices and installation services you are allowed to offer.

Your SKU identifies your offer within your company. Keep it unchanged when updating that offer. The Roraima code identifies the common catalogue item, so use it when adding or linking an offer for the first time. A product name is not a substitute for either code.

Use one row per offer. A device's quantity is the total stock available, not the number to add. Zero means no stock. For an installation service, leave quantity empty: even zero makes the whole row invalid, including its price and active status.

Prices must use the currency of the offer, at most two decimal places and no thousands separator. Use 1 to request activation or 0 to suspend an offer. Activation still depends on completing the company's and offer's selling requirements.

Upload a CSV file

Prepare a UTF-8 CSV file, within 8 MiB and 2,000 rows. Save a spreadsheet as CSV before uploading it.
Under File, select it. Leave Column separator on Auto, or choose comma, semicolon or Tab to match the file, then press Upload.
Match the file's columns to the offer fields. Leave unrelated columns unused and choose the price format that matches the file.
Use the update operation for existing offers. Choose the add-or-link operation explicitly when making the first connection to a catalogue item.
Apply the import and read the result. Correct the rejected rows and submit those rows again.

Uploading reads the file before any changes are applied. The result tells you which offers were updated or added and which rows could not be completed. Download the rows to correct when that option appears.

The column matching has these purposes. Match a column only when you intend to supply that value:

Value in your file	What to supply	When it applies
Your SKU	Your company's item code, unique among your offers. Preserve leading zeroes and letter case.	Required to identify the offer.
Roraima catalogue code	The code from the available catalogue download.	Required for a first link; optional for updates, but must agree with the existing link if supplied.
Price	The offer price, with at most two decimal places and no thousands separator.	Required for a new offer; optional for updates.
Device stock	The whole number of available devices, with zero for no stock.	Devices only. Leave installation-service cells empty.
Active status	1 to request activation or 0 to suspend.	Optional. Selling requirements still apply.

Choose the decimal convention separately to match the file, either 39.90 or 39,90. The operation choice applies to a manual import. Automatic updates use the existing links and do not offer an add operation.

Schedule updates from CSV or Google Sheets

Start with offers that are already linked to catalogue items. An automatic source updates existing offers and cannot add new ones.

In Automatic updates, choose Use CSV or Google Sheets.
Set Connection type to CSV or Google Sheets, then enter the File or spreadsheet link.
Choose Update frequency: Every hour, Every 6 hours or Every day. Press Read link to read the columns.
Match the columns and price format, then save and start the updates.
Review the connection's status and the result of its latest reading. Use its immediate-update action when you need a reading before the next scheduled time.

A CSV link must be readable without signing in. For Google Sheets, use a dedicated spreadsheet shared with anyone who has the link as Viewer, with downloading allowed. Open the sheet you want Roraima to read and copy its browser address. This uses the shared link and does not connect your Google account.

Pause scheduled updates when you need to work on the source. Resume them when it is ready, or disconnect the source when you no longer want Roraima to read it. Disconnecting a source does not remove your offers.

Only values changed in the source since the previous successful reading are applied again. An unchanged quantity therefore does not put back stock already sold on Roraima. When the source quantity changes, however, its new total replaces the stock held by Roraima. Your source must count sales on Roraima as well as sales elsewhere.

Use a management program for automatic updates

Your management program must support connecting to Roraima. Start the connection from that program, using your company's main account holder to authorize it. After authorization, return to Offer updates, choose Management software, select the program and confirm that it will provide the automatic updates.

If your program uses a personal API key, your Authorized Supplier's main account holder can create one in Seller tools → Connected AI and management software, under Offers API keys. Copy and keep the value when it is shown, then enter it in the program. In Offer updates, select the key's name under Management software and press Use this program for updates. See AI connections and offers API for creating and revoking keys.

Authorization alone does not select the program as your update method. Selecting it disables automatic CSV or Google Sheets updates for the company. Manual CSV imports remain available.

Creating a personal key also leaves the current update method unchanged. Revoking a selected key stops that program's access and does not switch an old file or spreadsheet connection back on.

The program can update prices, active status and device stock for offers already linked to your company. Installation services have no stock quantity. It cannot create catalogue items or new offers, and this connection does not handle orders or bookings.

Field reference

Label	Purpose	Instruction	Requirement or condition
File	Selects a manual CSV import.	Choose a UTF-8 CSV file within 8 MiB and 2,000 rows.	Required for a manual upload.
Column separator	Separates the file's columns.	Use Auto, comma, semicolon or Tab to match the file.	Manual upload.
Connection type	Chooses the automatic source.	Select CSV or Google Sheets.	CSV or Google Sheets automatic method.
File or spreadsheet link	Gives Roraima the source to read.	Enter a readable HTTPS CSV link or a shared Google Sheets link.	Required for a file or spreadsheet connection.
Update frequency	Sets the scheduled readings.	Choose Every hour, Every 6 hours or Every day.	File or spreadsheet connection.

Correct an import or connection problem

An optional empty cell leaves its existing value unchanged. Offers missing from the file are not deleted or suspended. Descriptions, photos, geographic coverage and tax settings are managed from their own pages.

For an unknown SKU, make the first catalogue link with a manual import before using automatic updates. For a mismatched Roraima code, correct the file instead of trying to change the existing catalogue association. Remove repeated rows so that each offer occurs only once.

If a Google sheet opens for you but Roraima cannot read it, check its link sharing, selected sheet and download permission. If column headings have changed, read the link again and update the column matches.

An interrupted import may have saved some changes already. Check the affected offers before retrying. An automatic source that was suspended after an interruption must be reviewed before resuming it. A rejected activation requires the selling conditions shown for that offer to be completed first.