Ecommerce involves a lot of comings and goings. Product in, product out. Data in, data out. Volusion helps you keep track of all your store’s moving parts with the Import/Export page.
Using this page, you can export data from your store to a variety of file types, as well as import data into your store using a simple CSV text file. You can easily edit this type of file in different spreadsheet applications, including Microsoft Excel. This can come in especially handy for updating your store’s Product database table.
By exporting the Products table to a CSV file, you can quickly update info such as prices and stock values, and then import these changes back into your store.
CSV Export Issues
Your store's Products table can be complex as a great deal of product information can be contained within this portion of your store database. As such, you may encounter some issues when editing your Products table in applications such as Microsoft Excel. This article will detail some of the ways you can circumvent these issues when updating your Products table using CSV files and the Import/Export page.
The tips included in this article specifically apply to Microsoft Excel 2010, 2007, and 2003 for Windows. These tips may not apply to other spreadsheet applications or versions of Excel for MacOS.
Minimize Exported Content
When exporting your product data to a CSV file, keep in mind that you can select which data fields within the Products table you want to export from your store. Volusion recommends you select only the columns in your Products table that contain data you need to update when generating your CSV export.
Doing this will minimize the number of columns and the amount of data within your CSV export - making the exported file easier to manage.
Save and Import vs. Launch From Browser
When downloading an exported CSV file, you'll be given the option to either save your CSV file or immediately open it in Excel. If this is the case, be sure to always download your CSV files and then import them into Excel as launching the file directly into Excel from your web browser may cause formatting issues that will prevent you from later importing it back into your store.
Import CSV Files Into Excel
Volusion recommends that you import your CSV files into Excel after launching it. This should ensure integrity of your CSV file content's format. To do this, simply launch Microsoft Excel and follow these steps:
Open the Import Text File window. If you're using Excel 2010 or 2007, click Data and select From Text. If you're using Excel 2003, click on Data in the menu options and select Import External Data. Next, select Import Data.
Find and select your CSV file.
With the CSV file selected, click the Open button.
In the first Text Import Wizard window, make sure the Delimited option is selected and click Next.
On the second Text Import Wizard window, ensure that the Comma option is the only Delimiter checked and click Next.
Near the bottom of the Text Import Wizard window, locate the Data Preview table. Select all columns in this table by holding down the SHIFT key and left-clicking each one.
Select the Text option and click Finish.
The Import Data box is displayed. This should show that you are importing data to "=$A$1" or "=Sheet1!$A$1", that is, the top left hand corner - row 1, column A. If it shows something else, click on cell 1A.
Now click OK.
These simple steps should help you to avoid some common issues with editing your store's product information using the CSV file import and export features. If you are experiencing persistent issues with importing your store's product data using these features, contact Volusion's technical support department for assistance.