Inventory and Price CSV file

If you don’t have Excel, you can use Open Office’s “Calc” program, which is free. It allows more control for delimiters, so we recommend it for anything more involved than uploading inventory, which is what we’re doing now. http://www.openoffice.org. We do not offer support for OpenOffice or Microsoft’s Excel.

How to make a CSV from Excel to update inventory and prices.

Most POS systems can generate an item list with your POS’ item numbers, prices and quantities. If your report includes more columns, simply delete them in Excel.


  important: Read the in-depth page about using Excel to make CSVs


For updating inventory you only want these three columns: product_sku, product_in_stock and product_price. Select the other columns and delete them.

screenshot009.gif

 



IMPORTANT: If you want to use auto-mapping (recommended), rename the top cells in each column to match your website’s naming convention. Underscores in the name must be included, and the names must be in the same casing as shown.

product_sku = Item numbers column 

product_in_stock = Quantity on hand

product_price = Prices

screenshot011.gif

 


note: You should have only numbers in your price and stock data. Make sure there are no dollar signs in your product_price column. Our system has some cleanup that it does in order to facilitate various number formatting issues, but it’s best to use clean number formatting. See examples below:

number values

 

 


 

Saving as a CSV from Windows

Save this file as a CSV (Comma Separated Value) file. 
Alert! Use the FIRST “(*.csv) option. There are three.

csv-from-windows.jpg

 

 


Saving as a CSV file from Apple Mac

Alert! : for Mac Users, you need to save the file as a “Windows CSV” format file.

csv-setting-for-mac.gif


To upload the inventory!

Since we created this file with Excel, and we are using just the 3 items to update the site, then prior to uploading the file we will want to select “,” and “none”. In the next example we will be using OpenOffice and we will be defining the delimiters

csv-comma_and_quote.gif

 

 

 

Scroll to Top