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
Category Assignments E-mail
Import/Export Data - Working with Data
Wednesday, 05 December 2012 16:57

When using the CSV import tools to import product into your cart system, there are special rules to follow for the product Category Assignments.

The column header is called category_path.

The values are text only, with no HTML.

When specifying that a product should be assigned to multiple categories, the category path must be separated by a pipe symbol (|).

E.g.: Furniture|Chairs|Teak

 

 pipe-symbol.jpgNote: The pipe symbol is created by using the Shift & Back slash key on your keyboard.

 

When specifying that a product should be assigned to a child category, the category path must be separated by a forward slash (/).

E.g.: Clothing/Boys
 
 child_categoriesNote: In this sample, Clothing is a parent category, and Boys is a child category of Clothing. (Toddlers and Girls are also children of Clothing.)
 

 

When specifying that a product should be assigned to a child category and multiple categories, the category path must be separated by a forward slash (/) and the pipe symbol.

E.g.: Furniture|Furniture/Chairs|Clothing/Boys
In this example the product would be assigned to these three categories
Furniture
Chairs
Boys (a child of the parent category "Clothing")
 

For the above reasons, do not include either a forward slash or a pipe symbol in your category names. The system will interpret these as location assignments.

When you use an apostrophe (') in a category name (E.g. Children's Books), you will need to code this with a leading back slash (\).

E.g.: Children\'s Books

 

Last Updated on Friday, 08 November 2013 09:51