|
Data Export Walkthrough
AmeriCommerce gives you the ability to export all of your pertinent data in lists ranging from customers to orders to products. The steps for exporting are very similar to the import process. Like the import tools, export options are available under Global Settings > Data Export Tools.
Because the exporting process for each area is very similar, the Order Export will be outlined here. This tool allows you to download specific date-range information from each of your storefronts.
Setting Order Criteria
When you click on Order Export you should be taken to the Criteria for Export page. Several criteria can be set here. The options listed are as follows:
- Store - select the site from which you would like to export customer orders, or leave [All] to view orders from all stores
- Order Status - select the status type or leave [All] to view orders with any status
- Start Date - the beginning of your order date range
- End Date - the end of your order date range
- Each Item Detail on Separate Line - unchecked by default, checking this breaks down orders by placing each item in its own row
- Date Format - gives several formats so you can use the data with your own lists
After you have set the criteria, click Get Orders to proceed to the next page. You can also download your entire order history by leaving all criteria fields blank and clicking Get Orders. This will bring up the Output Format page.
Setting up the Output File
There are three columns in this page, and they are explained as follows:
- E? asks if you want to export this field. By default, all fields are exported
- AmeriCommerce Column is the name we use for the field
- Destination Column should be the name you desire for the field
Similar to mapping columns during a data import, this step allows you to change any AmeriCommerce column to a different name. If you have your own tables for importing and exporting data, it is important to properly pair each column of information. You may want to use our format, but choosing your own is not a hassle. Once you have mapped the columns the first time, you can save the configuration at the bottom. The next time you export this file, the settings will be applied automatically.
Exporting the Final File
The final step simply involves clicking on Export Data (Finish) and saving the file to a location on your computer. After exporting your data, you have the flexibility to use it for a variety of purposes.
- You can integrate customer data into your accounting system.
- Order lists can be exported into an order management program or shipping system.
- You can feed your catalog into product management software.
- You can update files and import them back into AmeriCommerce.
|