ArtFire Help Center
The ArtFire Sales Data Exporter Posted On: 04/22/2011 Last Updated: 04/28/2011
The ArtFire Sales Data Export tool is a fast and flexible way to generate a common separated values (CSV) document of your ArtFire sales history. To get to the Export Tool, go to the "Orders" tab in your MyArtFire, and click on the "Export My Sales Data" on the left. The step by step process of the exporter makes it easy to select the date range, date format, order data, and column titles. These options enable you to download a CSV file of your orders that is tailored to your specific needs.
The sales data exporter itself has a step by step process that explains how to customize every aspect of your CSV record.
Hint: If you just want the default settings and ALL of your orders in a CSV you can click download right away. You only need to complete a step if you want to change the presets already there.
Hint: If you see any XXXXXXXX entries in a spreadsheet program, this generally means the column is too thin to display the data entry. Widen the column to see the full date display.
Step 1: The Date Range:
Complete this step to define the date range for orders that you'd like to export. You could choose January 1st 2010 to December 31st 2010 to export order information for all sales in 2010, or any other date range you'd like. You can leave these fields blank to simply pull all orders on file.
Step 2: The Date Format:
If there is a specific date format you need this step lets you set that format. The standard format is MM-DD-YYYY.
Step 3: Order Data to Export:
In your CSV file, each row will be information about one order. This tool can export up to 9 different pieces of data about a single order on ArtFire. On top of selecting what shows up on the CSV, you can also define where the date will be located (which column). Each column has a drop-down for you to select the data to appear there. If you do not need all 9 columns just select "omit column" for the extras.
Here are the definitions for each piece of order data that can be exported:
- Order # - The ArtFire order number
- Order Date - The date the order was placed on ArtFire
- Buyer Name - The first and last name of the buyer of the order
- Item Total - The total of all items in an order
- Shipping Total - The total of all shipping charges for the order
- Order Total - The grand total of the order
- Country - The shipping country for the order
- State - The shipping state for the order
- Source - The "Source" will always display as "ArtFire.com" and can be a useful column if you are combining order data from multiple venues
- Omit Column - This isn't actually a piece of order data, but it is the option that you would select if you have extra columns that you don't need
Step 4: Change the Column Names
The column headers will default to the exact name of a piece of order data from above. Some software requires that columns be named something specific. A program might specify that the second column should be the purchasers name and be titled "Payee." If that were the case you would make sure "Buyer Name" was selected for column 2, and you would rename column 2 to "Payee."
Once all the steps you need to complete have been finished you're ready to download the CSV file. If you don't have any software that can open and display the information in a CSV both Open Office Calc and Google Docs Spreedsheet are free programs that can open CSV files.