Troubleshooting price template imports from spreadsheets

If price template values import with incorrect amounts, duplicated entries, or old custom prices remain after an update, first validate the source spreadsheet structure before re-importing.

Common cause: extra populated columns

If the spreadsheet contains populated columns beyond the intended currency range, the importer may read records multiple times and create incorrect values. For example, when the sheet extends farther than the actual set of supported currencies, prices can be imported twice or with shifted / inflated values.

• Check the full used range of the sheet, not just the visible currencies you expect to import.
• Remove unused populated columns from the sheet before importing.
• If needed, create a clean copy of the spreadsheet that contains only the currencies that should be imported.

When you use price template IDs in the game client

If your client depends on specific priceTemplateId values, avoid deleting and recreating templates just to refresh prices. Deleting templates can force you to update integrations that reference those IDs.

Instead:

• Keep the existing templates.
• Clear custom prices inside each template if they need to be reset.
• Re-import prices from a cleaned spreadsheet.

Recommended recovery flow

1. Confirm which template IDs are actively used by the game client.
2. Do not delete those templates if the IDs must stay stable.
3. Clean the spreadsheet so it contains only the intended currency columns.
4. Clear outdated custom prices in the existing templates.
5. Import the cleaned spreadsheet again.
6. Verify several affected countries manually after import.

Validation checklist

• Countries removed from the spreadsheet should no longer retain stale custom prices after cleanup.
• Localized prices should match the expected currency and magnitude.
• Check country-to-currency mapping carefully (for example, Brazil should use BRL if that is your intended setup).

If a single country still shows a value that is 100x or 1000x too high after import, re-check whether the spreadsheet includes extra columns or whether the imported currency/value pair is misaligned.