Email Website
Contents
Search:

Home > Setup (Content) > Manage Products > Import/Export > Import Prices from Excel/XML

Import Prices from Excel/XML

From Products Menu, click Import/Export, then click Import Prices from Excel/XML.
On this page, store administrators can import Cost, MSRP, Price, Sale Price, and Inventory levels from the Excel file created through the Products > Import/Export > Export Prices To Excel/XML page.

The Excel file needs to stay formatted exactly as the export creates it, change nothing but the cell values.

Import Prices

  1. Click the Choose File button, locate the Excel file to import, then click Submit.
     

  2. A message will appear, indicating that the import was successful.
     
 

Many stores with a lot of products will want to use formulas within Excel to modified multiple prices at once. This will cause a problem, as Excel does not actually store the values you see in the cells, it stores the formula. Importing that will result in invalid information in your prices. To avoid this, make the desired changes to your file and then save it as a CSV (comma separated file). This removes the formulas, but stores the values. Once that's done, re-open the file and save it as an XLS (Excel) file again. It is now ready to import. You can instead copy/paste the data in the formula cells over the top of themselves using the right-click Paste option - Values to replace the formulas with the values they produce.



Actions
Print This Article
Bookmark
Email This Article
Previous Article
Next Article