| KNOWLEDGEBASE

Imported Fields Format

Article ID: 15
Last updated: 18 Aug, 2011
A CSV file can contain the following fields:
  • Product code. This field is mandatory, and its value must be unique for each product (if its value is equal to the existing product code, this product data will be replaced with the imported data). It can contain numbers, letters or their combinations.
    EXAMPLE: B0002OG6NY
  • Category. Full category path to the product. If there are several categories in it, they must be separated by Category delimiter that you specify on the Import products page. Please refer to paragraph 4.2 in the Product import article.
    EXAMPLE: Computers///Desktops (the delimiter is ///).
  • List price. List price of the product. It must be in 0.00 format.
    EXAMPLE: 1750.00
  • Price. Price of the product. It must be in 0.00 format.
    EXAMPLE: 1600.00
  • Status. Status of a product (A - Active, H - Hidden, D - Disabled).
  • Quantity. Product amount.
    EXAMPLE: 50
  • Weight. Weight of the product in units of weight defined by the weight symbol on the Settings page in the Magicdust eShop administration panel (the link to this page is in the ADMINISTRATION side box on the right side). By default, it is lbs. The weight must be an integral number or a decimal fraction with no more than two decimal places.
    EXAMPLE: 20.25
  • Min quantity. Minimum product amount that can be purchased.
    EXAMPLE: 1
  • Shipping freight. Value of the shipping cost for this particular product. It is added to the ones calculated at checkout.
    EXAMPLE: 2.00
  • Date added. Date the product was added. In the month/day/year format.
    EXAMPLE: 12/25/2006
    NOTE: If this field is not completed, the date of the product creation will be the date this product was imported.
  • Downloadable. It must be Y if product is downloadable, N - if not.
  • Files. Full path to the file for the downloadable product.
    EXAMPLE: /home/client/public_html/cscart-2.1.1/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 paragraph 4.4 in the Product import article. Several files must be delimited by a 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. Full path to the product thumbnail image.
    EXAMPLE: /home/client/public_html/cscart-2.1.1/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 paragraph 4.3 in the Product import article.

    NOTE: Do not use the Image URL field for uploading an image as long as this field has a different designation. Furthermore, the Image URL field is not available for importing in the current version of Magicdust eShop anymore.
  • Detailed image. The full path to the detailed product image.
    EXAMPLE: /home/client/public_html/cscart-2.1.1/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. Name of the product.
    EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  • Description. Product's 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. Product's short description.
    EXAMPLE: 100% circular rib Coolmax« Extreme 1x1 mini-rib solid pique mock with UV and anti-microbial finish.
  • Meta keywords. Product's meta keywords.
    EXAMPLE: adidas, climacool, clima cool, mock turtleneck, golf shirts, uv protection, sun
  • Meta description. Product's meta description.
    EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  • Search words. Search words for the product (search is not case-sensitive in Magicdust eShop).
    EXAMPLE: adidas, climacool, men
  • Page title. Name of the page displayed in the browser.
    EXAMPLE: Adidas Men's ClimaCool Short Sleeve Mock
  • Taxes. Name of the tax defined in your Magicdust eShop installation which 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
  • Localizations. The name of the localization defined in your Magicdust eShop that will be applied to the product. It is required to create localizations on the Localizations page before (!) importing them. Several localizations must be delimited by a comma.
    EXAMPLE: USA, Europe
  • Features. All features that you import must be in the {Feature ID} (Group name) Feature name: Feature type[Feature value] format, where Feature ID - ID of the feature, Group name - Name of the feature group, Feature name - Name of the feature, Feature type - Type of the feature (C - checkbox, M - multiple checkboxes, S - text select box, N - number select box, E - extended selectbox, T - simple text, O - number, D - date), Feature value - Value of the feature (several values can be delimited by a comma). Several features must be delimited by a semicolon. Note, it is required to create features on the Product features page before (!) applying them to the products.
    EXAMPLE: T[1233423423]; Release date: D[05/05/07]; Color: S[Red]
  • Options. All product options that you import must be in the Option name: Option type[Variant1, Variant2, ..., VariantN] format, where Option name - Name of the option, Option type - Type of the option (S - select box, R - radio group, C - check box, I - simple input, T - text area), Variant1,2,...N - 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 that you specify on the Import products page. Please refer to paragraph 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 ///).
  • Items in a box. The minimum and maximum number of product items to be shipped in a separate box. It must be in min:[number];max:[number] format.
    EXAMPLE: min:1;max:5
  • Box size. Dimensions for a box. It must be in length:[number];width:[number];height:[number] format.
    EXAMPLE: length:10;width:15;height:15
  • SEO name. SEO name of the product.
    EXAMPLE: my-product
  • Pay by points. It must be Y if the payment by points is allowed for the product, N - if not.
  • Override points. It must be Y if the Override global PER setting is enabled for the product, N - if not.
  • Override exchange rate. It must be Y if the Override global/category point value for this product setting is enabled for the product, N - if not.
Prev   Next
Product Import     Example of Product Import