Imported fields format

The CSV file can contain the following fields:

• Product code. This field is mandatory and must be unique for each product. It can contain numbers, letters or their combinations.

  EXAMPLE: B0002OG6NY
  

• Category. The full category path to the product. If there are several categories in it, they must be separated by Category delimiter which you specify on the Import products page. Please refer to point #4.2 in the Product import article.

  EXAMPLE: Computers///Desktops (the delimiter is ///).
  

• List price. The list price of the product. It must be in 0.00 format.

  EXAMPLE: 1750.00
  

• Price. The price of the product. It must be in 0.00 format.

  EXAMPLE: 1600.00
  

• Available. It must be Y if the product is available (displayed in the storefront), N - if not, H if the product is hidden, but can be accessed by a direct URL.
• Quantity. The quantity of the product.

  EXAMPLE: 50
  

• Weight. The weight of the product in units of weight defined by the weight symbol on the Settings page in the CS-Cart administrator panel (the link to this page is in the ADMINISTRATION side box on the right side). It is lbs by default in CS-Cart. The weight must be an integral number or a decimal fraction with no more than two symbols after the point.

  EXAMPLE: 20.25
  

• Min quantity. This field is not available now, it is designed for the next functionality.

  EXAMPLE: 1
  

• Shipping freight. The value of the shipping cost for this particular product. It is added to the ones calculated at checkout.

  EXAMPLE: 2.00
  

• Date added. The date when the product was added. In the month/day/year format.

  EXAMPLE: 12/25/2006
  

  NOTE: If this field is not defined, the date of the product creation is set up to the date of this product importing.
  

• Downloadable. It must be Y if product is downloadable, N - if not.
• Files. The full path to the file for the downloadable product.

  EXAMPLE: /home/client/public_html/cscart-135SP3/var/downloads/backup/filename1.pdf
  

  The file can be specified without a path (just its name) if you specify Files directory on the Import products page when importing. Please refer to point #4.4 in the Product import article. Several files must be delimited by comma.

  EXAMPLE: file1.pdf, file2.jpg
  

• Ship downloadable. It must be Y if the shipping cost is calculated for a downloadable product like for a tangible one, N - if not.
• Inventory tracking. This field describes the inventory tracking type: D - do not track, B - track without options, O - track with options.
• Free shipping. It must be Y if the product is shipped for free, N - if not.
• Feature comparison. It must be Y if the product can be added to the compare list, N - if not.
• Zero price action. This field describes the action when the product price is zero: R - Do not allow to add the product to cart, P - Allow to add the product to cart, A - Ask customer to enter the price.
• Thumbnail. The full path to the product thumbnail image.

  EXAMPLE: /home/client/public_html/cscart-135SP3/images/backup/thumbnail_image.jpg
  

  The image file can be specified without a path (just its name) if you specify Images directory on the Import products page when importing. Please refer to point #4.3 in the Product import article.

• Detailed image. The full path to the detailed product image.

  EXAMPLE: /home/client/public_html/cscart-135SP3/images/backup/detailed_image.jpg
  

  The image file can be specified without a path (just its name) if you specify Images directory on the Import products page when importing. Please refer to point #4.3 in the Product import article.

• Product name. The name of the product.

  EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  

• Description. The product full description.

  EXAMPLE: ClimaCool is softer than cotton and resists pilling better than other natural and synthetic fibers. The shape and placement of ClimaCool fibers help move moisture quickly to the outer surface, where it evaporates away from the body. Adidas Mens ClimaCool Short Sleeve Mocks features: 100% polyester Coolmax Extreme - UV protection; ClimaCool is a superior moisture management technology designed to regulate skin temperature, improve the flow of air and dry faster; ClimaCool is proven to reduce skin temperature and heart rate during exercise; Short sleeve mock; Coolmax Extreme rib knit mock; Set-in sleeve; Jacquard mesh side panels for added breathability; Open hem sleeves
  

• Short description. The product short description.

  EXAMPLE: 100% circular rib Coolmax« Extreme 1x1 mini-rib solid pique mock with UV and anti-microbial finish.
  

• Meta keywords. The product meta keywords.

  EXAMPLE: adidas, climacool, clima cool, mock turtleneck, golf shirts, uv protection, sun
  

• Meta description. The product meta description.

  EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  

• Search words. The product search words (search is not case-sensitive in CS-Cart).

  EXAMPLE: adidas, climacool, men
  

• Page title. The name of the page displayed in the browser.

  EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  

• Taxes. The name of the tax defined in your CS-Cart that will be applied to the product. It is required to create taxes on the Manage taxes page before (!) importing them. Several taxes must be delimited by a comma.

  EXAMPLE: VAT, test
  

• Features. The imported features must be in the Feature name: Feature value format where Feature name - the name of a feature, Feature value - the feature value. Several features must be delimited by a semicolon. Please note that it is required to create features on the Product features page before (!) applying them to the products.

  EXAMPLE: ISBN: 1233423423; Author: Shakespeare
  

• Options. The imported product options must be in the Option name: Option type[Variant1, Variant2, ..., VariantN] format where Option name - the name of the option, Option type - the option type (can be the following: S - select box, R - radio group, C - check box, I - simple input, T - text area), Variant1,2,...N - the name of the variant. Variants must be specified if the option type is a select box or radio group only. Several options must be delimited by a semicolon.

  Example of simple text options: Your age: I; Date of birth: I; Notes: T
  Example of options with variants: Color: S[Red, Green, Blue]; Size: R[X, XL, XX]
  

• Secondary categories. Additional categories, separated by Category delimiter which you specify on the Import products page. Please refer to point #4.2 in the Product import article. Several secondary categories must be delimited by a semicolon.

  EXAMPLE: Computers///New products; Computers///Desktops (the delimiter is ///).
  

• Manufacturer. The manufacturer's name. It is required to create manufacturers on the Manufacturers page before (!) importing them.

  EXAMPLE: Sony
  

• Pay by points. It must be Y if the product can be paid by points, N - if not.
• Override points. It must be Y if the points that a customer can earn by purchasing the product should be recalculated for the product, N - if not (the points specified for the category or global points will be taken).
• Override exchange rate. It must be Y if the price in points should be recalculated for the product, N - if not (the points specified for the category or global points will be taken).
• Supplier. The supplier's ID (number). The supplier must be already defined in your CS-Cart. In order to find out the suppliers ID click on the Suppliers link in the USERS side box on the left side of the administrator panel and look at the ID field.