Imports & Exports
Import historical transactions from a CSV and export your transactions for download.
The Settings area in Allomancy includes two tools for moving sales data in and out of your store: a transaction import for bringing historical sales into Allomancy, and a transactions export for downloading your store's sales as a CSV.
This page covers both Settings tools. For bringing customer records (not sales) into Allomancy, see Customer Import.
Where to find Imports & Exports
Both tools live on the Settings page at stores.allomancy.com/settings:
- Import sales opens the Import Transactions flow at stores.allomancy.com/settings/import.
- Export sales opens the Export Transactions flow at stores.allomancy.com/settings/export.
Importing historical transactions
Use this flow to bring sales records from another system into Allomancy. The import accepts a CSV with one row per transaction and asks you to map each unique product name in that CSV to one of your existing dispenser items.
Drop or pick a CSV file
Drag a CSV onto the 1. Upload the CSV File dropzone or click to select one. Allomancy reads the file.
Associate products with dispenser items
The page shows a Dispenser items mapping table under 2. Product Associations. Each unique product name from the CSV is listed in one row, and you pick an item from the dispenser item picker on the right.
Products without an association are highlighted in red and will be skipped during import. You can proceed with skipped rows after confirming, or go back and fix the associations first. If no products are associated at all, you must associate at least one before the import can proceed.
Submit
To start the upload, click Import Transactions
Wait for processing
Your transactions are processed in the background, and Allomancy notifies you when the processing finishes. To start over with a different CSV, click Import New File
Recognized CSV columns
Allomancy matches each CSV column name against familiar transaction words, regardless of capitalization. Most matches work when the word appears anywhere in the column name.
| If a column header contains | The value is read as |
|---|---|
date, time, or created | the transaction date |
payment, gross, price, cost, or paid | the gross L$ amount the customer paid |
net, received, net amount, or earning | the net L$ that ended up with the store |
amount without separate gross or net columns | both gross and net at once |
location or region | where the sale happened |
product or item | the product name, matched against your dispenser items |
payer, from, or buyer | the buyer's username |
payerid, payeruuid, fromkey, payer key, or buyer_key | the buyer's UUID |
receiver, to, recipient, or owner_name | the receiver's username |
receiverid, receiveruuid, tokey, receiver key, owner_key, or customer uuid | the receiver's UUID |
Headers Allomancy does not recognize are skipped. A column named order item id marks the file as a Second Life Marketplace import; if no location column is present, imported rows use MP Import as the location.
Exporting your transactions
The export flow lets you request a CSV of your store's transactions for an optional date range, then download it once Allomancy finishes preparing it.
Pick an optional date range
The Export Transactions page has a date range picker next to the export button. By default, all your transactions are exported. Use the picker to limit the export to a specific window.
Request the export
Click Request export to request the CSV. The button stays disabled for a short waiting period after each request and while another export is still being prepared.
Download when ready
Past requests appear in the Available Exports table below the button. Each row shows the Start Date, End Date, Ready status, Download button, and Generated date.
The Ready column shows while Allomancy is preparing the file, and when the file is ready. To download the CSV, click
Permissions
Settings, including the Imports & Exports tools, is visible only to the store owner. Managers do not see it from a managed store. See Store Managers for the full list of owner-only areas.
Related pages
Customer Import
Bring existing customer records into Allomancy from a CSV.
Sales & Reporting
Where imported and existing transactions show up after processing.
Payments
Track L$ flows in and out of your store.
Customers
The customer profiles that imported transactions are attached to.
Store Managers
See who can open Settings and other owner-only pages.