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
Exporting Product Data E-mail
Import/Export Data - Exporting Data
Wednesday, 05 December 2012 14:38

You can use the cart's CSV Import/Export tools to export almost any product detail. This can be very useful for offline filtering, reporting or backup.

 


Warning!!: Exporting CSV reports is pretty much risk free, BUT IMPORTING CSV files can compeltely destroy your cart's product data if short order!

Only use the CSV Import tools when you full understand the process.


 

Open the tool:

Cart > Products > CSV Import/Export

 

 

Export settings:

1. Use the right-hand Export to CSV File settings block to select either Default Ordering (all suported product data fields) or My customized Ordering (only the field assigned in the Configuration tab).

2. select Include column headers if you want them (trust us, you likely do).

3. For an Excel friendly CSV file, you'll export using comma (,) and quotes (") as the delimiter and field enclosure characters.  For Open Office, or the backup CSV, we suggest caret (^) and tilde(~).

Note: Why these delimeters? One reason you use caret (^) and tilde (~) is when exporting complex data field, such as the product full description field, which contains html data that will often cause errors in field seperation when using comma (,) and quotes (")

4. After selecting the desired options, click Export all Products to CSV File, then save the file to your local hard drive.


CSV Import / Export Configuration Save Changes

The Configuration tab is used to set custom fields for Import and Export.

The minimal required fields are product_sku and at least one other field.

 

Click the Add a new Field link at the botton of the page to add one or multiple fields. 

Click Save Changes once you have the Field parameters set. 

 

notes: 

  • You cannot add a field more than once. If you try to add a field that is already used, the Configuration settings will revert to last saved options.
  • We highly suggest you setup field Ordering in a sequential series without skipping any steps. You can setup other field ordering if needed, but this is not typical

Click trash icon to remove a field

 


Backing Up Product Data

Backup your data with the Backup option.

 

Offline Backup your data by saving it to your computer. Export the first one with “default ordering,” using ^ and ~ (carat and tilde) as the Delimiter and Field Enclosure Characters.

This is the file you'll send to This e-mail address is being protected from spambots. You need JavaScript enabled to view it if you need to have everything restored.

 


Note: A product backup has limits: cannot be used to restore all product data such as sales information, and will not restore any deleted files such as images or linked PDF documents.


 

Last Updated on Friday, 04 August 2017 12:52