Imported Fields Format

Modified on: Mon, Apr 7, 2014 at 11:34 AM


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
  • Language. Two-letter language code.
    EXAMPLE: en
  • 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 Merchium 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 dd mmm yyyy 00:00:00 format.
    EXAMPLE: 25 Dec 2011 14:05:00
    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/store/var/downloads/backup/filename.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/store/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.
  • Detailed image. The full path to the detailed product image.
    EXAMPLE: /home/client/public_html/store/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 paragraph 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 Merchium).
    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 Merchium  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
  • 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
  • Store. Store that the item belongs to.
    EXAMPLE: Sample Store
  • SEO name. SEO name of the product.
    EXAMPLE: my-product


Did you find it helpful? Yes No

Can you please tell us how we can improve this article?