Preparing your CSV file


Preparing your CSV file

A CSV file contains plain text entries separated by delimiters. Each entry represents a cell in a spreadsheet, each line represents a new row, and each delimiter (comma, semicolon, or tabulation) indicates where one entry ends and another begins. You can view and edit CSV files in plain text editors like Notepad for Windows, Sublime Text, and TextEdit for Mac, or in spreadsheet editors like OpenOffice, LibreOffice, and Google Sheets.

 

Contents

Each line in a product import file represents a list of attributes associated with a certain product in your store, like name, SKU, description, price, etc. Each attribute is separated by a delimiter (comma, semicolon, or tabulation) that should be the same throughout the file.

The first line in the file represents the column headers. If your file contains column headers at the first line, you should check the "Skip first line" option in the import settings so that this line is not counted as product attributes.

Picture1.png Picture2.png


Delimiters

Delimiters indicate where one product attribute ends and another begins. Mopro supports three delimiters: a comma, a semicolon, and a tabulation. When you import your CSV file, select the same delimiter selected in your file’s import settings.

Picture3.png 

 

Encoding

Mopro supports more than ten charsets, such as UTF-8, UTF-16, US-ASCII, etc. When you import your CSV file, select the same encoding selected in your CSV file’s settings. If you don’t know which encoding is used in your CSV file, select UTF-8 which is the most universal charset.

Picture4.png

 

Numbers Format

The following are Mopro CSV import requirements:

  • Use a dot (a full stop) to separate decimals, e.g. 3.5 or 10.99
  • Do not use a comma in large numbers, e.g. 1350, not 1,350

 

File Format

Mopro recognizes 21 product attributes, so there can be 21 columns in your CSV file. Below are their descriptions:

Column Name

Type

Description

Required or Optional

Limits

SKU

String

Product SKU

SKU or Name field is required

255 characters

Name

String

Product name

SKU or Name field is required

255 characters

Description

String

Product description

Optional

No

Enabled

Boolean

Product availability (enabled/disabled)

Optional

"true", "yes", "on", "Y", "1" for enabled, any other values for disabled

Weight

Floating number

Product weight

Optional

Any valid floating number for weight, empty value for intangible product

Price

Floating number

Product price

Optional

Any valid floating number

Recommended price

Floating number

Product “Compare to” price

Optional

Any valid floating number

Quantity

Integer

Product quantity in stock

Optional

Any valid integer, empty value for unlimited quantity

Image

String

URL path to product image

Optional

http:// or https:// URLs are allowed

Category 1

String

Category name or path to category that the product belongs in (e.g. Books/Science/Biology)

Optional

255 characters for each category name in the path

Category 2

String

Path to the second category that the product belongs in

Optional

255 characters for each category name in the path

Category 3

String

Path to the third category that the product belongs in

Optional

255 characters for each category name in the path

Store front page

Boolean

Indicates that a product belongs to the store root category

Optional

"1" for true "0" or empty value for false

Fixed shipping rate

Floating number

Product shipping freight value

Optional

Any valid floating number

Fixed shipping rate only

Boolean

Indicates that the product has only fixed shipping rate

Optional

"true", "yes", "on", "Y", "1" for true, any other values for false

UPC

String

Product 'UPC' attribute (see also: Product types and attributes)

Optional

255 characters

Brand

String

Product 'UPC' attribute (see also: Product types and attributes)

Optional

255 characters

Page title

String

SEO field, meta title tag

Optional

55 characters

Meta description

String

SEO field, meta description tag

Optional

160 characters

Width

Floating number

Product dimension for shipping calculation (see also: Product dimensions)

Optional

5 characters

Height

Floating number

Product dimension for shipping calculation (see also: Product dimensions)

Optional

5 characters

Length

Floating number

Product dimension for shipping calculation (see also: Product dimensions)

Optional

5 characters

 

Sample CSV file

See our sample CSV file below to use as a template for creating your own. See the sample file attached. This provides an example product with comma-separated values. See the exact import settings for this file below:

PictureNEW.png 

Was this article helpful?
0 out of 0 found this helpful

Comments