Imports & Exports
Import historical transactions from a CSV and export your transactions as CSV or XLSX files.
Allomancy Stores includes two Settings 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 or XLSX file.
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 file 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.
Choose the format and options
Pick CSV or XLSX from the format dropdown; CSV is the default. Optionally tick Exclude redeliveries to leave redelivery rows out, or Include marketplace sales to add your Second Life Marketplace sales.
Request the export
Click Request export to request the file. Only one export prepares at a time, and a short cooldown follows each request before you can ask for another.
Download when ready
Past requests appear in the Available Exports table below the button. Each row shows the Start Date, End Date, Format, Ready status, Download button, and Generated date.
The Ready column shows while Allomancy is preparing the file, when the file is ready, and a red Failed when the export could not be generated. To download the file, click
To open an XLSX export in Microsoft's Office online viewer, click next to its download button; XLSX rows are the only ones that show it.
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.