Help Topics

General Help Topics
Site Setup FAQ's Email - Set Up Domains Special Features FrameEZ Troubleshooting
Shopping Cart
Store Configuration Global Configuration Product Management Categories Manufacturers/Brands STN Import Tool Shipping Payment Processors Orders and Sales Shopper Groups Coupons & Discounts Taxes Safety Warnings POS-to-Web Sync
Import/Export Data Components
Contact Us Store Locator Newsletters - Letterman Front Page SlideShow Events Calendar QuickBooks Sync SEO Manager Media Manager Picture Gallery User Manager Banner Manager Language Editor
Wish List Mobile Lightspeed POS
Content Management
Inventory and Price upload E-mail
Import/Export Data - Importing CSVs
Wednesday, 05 December 2012 17:15

stn-video.jpg Video: Importing prices and quantity on hand from your POS

This page assumes you've already made a CSV with either Excel or Open Office, and are ready to upload it.

To do this you will need a program on your computer to edit CSV files and possibly Excel files depending on your POS system. We reccomend OpenOffice (http://www.openoffice.org/ ) which is a free and open source office program that is available for Mac and PC. Another good tool is Microsoft's Excel which is part of the Microsoft Office Suite (http://www.microsoft.com/office/). 

To get started you will need to be logged into the "Administrator" back-end and be in the shopping cart. On the shopping cart menu go to Products >> CSV Import/Export.


Step 1. Back up your data before overwriting it with an upload!
The link shows how to backup your data so it can be recovered.

screenshot001.gif


Step 2. Choose the delimiter and field enclosure that matches your CSV file.

 Open Office = ^ and ~

screenshot002.gif

Excel = , and "

csv-comma_and_quote.gif

 

Step 3. Select you upload Settings
Since we are updating items that are already on the site select "Update Existing Products" in the upload settings.

screenshot003.gif

DO NOT USE "Regular Upload" for a product update. This will add hundreds of empty SKUs to your site. You can then remove those SKUs with another CSV upload, but it's tedious and technical.


Next select the "Show More Options" link and select "Use column headers as configuration" and "Overwrite existing data". This will use the column headers to define what the items are that are getting updated. For more information on peparing your CSV file click here >>
screenshot004.gif


Now you will need to select the CSV file that you have previously prepared and is ready to upload. If you need more information on how to prepare your file for uploading click here>>

1. screenshot005.gif


2. screenshot006.gif

3. screenshot007.gif



After submitting the CSV file it could take quite awhile to update your site with the CSV infromation depending on big your CSV sile is. After is finished updating your site you will get a report of what was updated and what was skipped. In this report you will see that 828 items were updated and 7,372 items were skipped. It is the product SKU that syncs up the CSV data with the product on your site.

screenshot008.gif

 

For more information on how to prepare you CSV file please click here >>

 

 

Last Updated on Friday, 08 November 2013 09:56