When editing or adding data to your online store by using a CSV import, in the heading row of the import file, you must use MyCashflow's CSV identifiers that connect the columns' contents with the correct fields in your online store.

Use the table below as reference material when working on CSV imports. The table lists identifiers used during CSV imports.

CSV exports also contain other data that cannot be edited with imports. These can be found on the admin panel's Reports > CSV Export page.

Customers

The following identifiers are available for imports of the Customers type.

IdentifierDescriptionAllowed values
CustomerID

The unique, numeral ID used for identifying customers. Created automatically for each customer during registration.

Use this identifier when editing customer information. Do not use it, when adding new customers to your online store.

Integers
CustomerCode

The customer number that you can, when necessary, define for the customer yourself.

The customer number is often used when the online store is integrated with an external system.

Text and numbers. Make sure that all customer numbers are unique.
CustomerLoginAllowedDefines whether the customer is allowed to log in to your online store's customer area.

0: the customer is not allowed to log in

1: the customer is allowed to log in

CustomerLanguage

The customer's language. Defines, among others, the language in which your online store is displayed to the customer.

Displaying your online store in different languages is only possible if your online store several language versions.

Text. Use here only the supported languages.
CustomerVersionIDThe VersionID of the store version the customer was using during registration.An integer. Use here only the identifiers of the existing store versions.
CustomerEmailThe customer's emailEmail

CustomerFirstName

Customer's first nameText
CustomerLastNameThe customer's surnameText
CustomerStreetAddressThe customer's street addressText and numbers
CustomerPostalCodeThe customer's postal codeNumbers
CustomerPostOfficeThe customer's post officeCity
CustomerCountryThe customer's countryA two-letter country code (e.g. us)
CustomerPhoneThe customer's phone numberPhone number
CustomerCompanyThe customer's companyCompany name
CustomerVatCodeThe customer's or customer's company's business IDBusiness ID
CustomerCommentsIn customer information, you can save comments that won't be displayed to the customer.Long text
CustomerGroupIDsThe CustomerGroupID identifiers of customer groups that the customer belongs to.ID numbers separated by pipes (e.g. 1|2|3)
CustomerEmailSubscription

Indicates whether the customer has subscribed to the newsletter (available only with the Email Marketing extension.

0: the customer hasn't subscribed to the newsletter

1: the customer has subscribed to the newsletter

CustomerSMSSubscription

Indicates whether the customer has subscribed to SMS marketing (available only with the SMS Marketing extension).

Note that without the customer consent sending marketing text messages to the customer is not possible.

If the setting's value is 0, the customer cannot be sent even text messages related to the customer's order.

0: the customer cannot be sent text message notifications or advertisements

1: the customer can be sent text messages

CustomerLastOrderThe date of the customer's last order.The date in the format 31.12.2018

Newsletter subscribers

The following identifiers are available for imports of the Newsletter subscribers type.

IdentifierDescriptionAllowed values
SubscriberID

The unique, numeral ID used for identifying newsletter subscribers. Created automatically for all subscribers.

Use this identifier when editing newsletter subscriber information. Do not use it, when adding new subscribers to your online store.

Integers
EmailThe subscriber's emailEmail
CountryThe subscriber's countryA two-letter country code (e.g. us)
LanguageThe subscriber's languageA two-letter language code (e.g. us)
Remove

Removes the email in the import row from the subscriber list.

The Email field must be included in the row that should be removed.

CONFIRM
VersionIDThe identifier of the version in which the newsletter was subscribed toIntegers

Text message campaigns subscribers

The following identifiers are available for imports of the SMS subscribers type.
IdentifierDescriptionAllowed values
SubscriberID

The unique, numeral ID used for identifying newsletter subscribers.

Use this identifier when editing newsletter subscriber information. Do not use it, when adding new subscribers to your online store.

An integer. Use only the already existing SubscriberID identifiers
MobileThe subscriber's cell phone numberThe phone number indicated in the customer information
CountryThe subscriber's countryA two-letter country code (e.g. us)
LanguageThe subscriber's languageA two-letter language code (e.g. us)

Products

The following identifiers are available for imports of the Products type.

Identifier

Description

Allowed values

ProductID

The unique, numeral ID used for identifying products. Added automatically to each new product at the moment of creation.

Use this identifier when editing product details. Do not use it, when adding new products to your online store.

An integer. Use only the already existing product ID numbers.

ProductEAN

The optional EAN code that can be created manually for a product.

Text and numbers. Make sure that all EAN codes you use are unique.

ProductCode

The optional product code that can be created manually for a product.

Often used if the online store is integrated with an external system.

Text and numbers. Make sure that all product codes you use are unique.

Basic product information and classification

ProductName

The product's name in the language of the selected store version

Text and numbers

ProductVisibilityDefines whether the product is visible in the selected store version

0: the product is not visible in the selected store version

1: the product is visible in the selected store version

ProductDescription

The product's description in the language of the selected store version

Long text + HTML/Textile markup

ProductInformation

Product information in the language of the selected store version

Long text + HTML/Textile markup

ProductImages

Product images you'd like to attach to the product.

Note that the images must already exist in your online store's file directory's tuotekuvat folder.

The file names of product images separated by pipes (e.g. image1.jpg|image2.png)

ProductAddImagesFromURL

Images from external URL addresses that you'd like to add to the product.

Product image URL addresses separated by pipes (e.g. https://www.example.com/image1.jpg|https://www.example.com/image2.jpg )

ProductKeywords

Product's key words

A list of keywords separated by commas or space characters

ProductCategoryNames

Product categories that the product belongs to.

If any of the indicated product categories doesn't exist, it will be created as hidden and listed as the last category on the list of the product's categories.

The product categories indicated in this field will overwrite all of the product's previous categories. To add new product categories to the product, use the ProductCategoryNamesAdd identifier.

To indicate the relevant product, use the ProductID identifier.

The paths of product categories separated by pipes (e.g./Clothes/Trousers|/Clothes/Jeans)

ProductCategoryIDsIdentifiers of the product categories to which the product belongs or to which it is being added.

The product categories indicated in this field will overwrite all of the product's previous categories.

Product category identifiers separated by pipes (e.g. 2|3|8)

ProductCategoryNamesAdd

Adds a new product category to the product. If any of the indicated product categories doesn't exist, it will be created as hidden and listed as the last category on the list of the product's categories.

To indicate the relevant product, use the ProductID identifier.

The paths of product categories separated by pipes (e.g./Clothes/Trousers|/Clothes/Jeans)
ProductCategoryNamesVisibleSimilar to ProductCategoryNamesAdd and ProductCategoryNames, but the new product categories are set to become immediately visible in the version to which the CSV file is imported.The paths of product categories separated by pipes (e.g./Clothes/Trousers|/Clothes/Jeans)

ProductSupplierID

The supplier's SupplierID identifier

An integer. Use the ID numbers of the already existing suppliers.

ProductSupplierNameThe supplier's SupplierName identifier. When necessary, the identifier creates the missing suppliers.Text and numbers

ProductBrandID

The brand's BrandID identifier. This identifier is used for defining the product's brand.

An integer. In the field, you can use the ID numbers of the already existing brands.

ProductBrandNameThe brand's BrandName identifier. This identifier is used for defining the product's brand. When necessary, the identifier creates the missing brands.Text and numbers

ProductTaxRate

The product's tax rate. The product's price including and excluding tax is calculated based on this field as well as the ProductPrice and ProductPriceWithoutTax fields.

The tax rate indicated as an integer (e.g. 24). In this field, use only the tax rates that are enabled in your online store.

ProductPrice

The product's price including tax. The price without tax is calculated based on the value indicated in the ProductTaxRate column.

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

A decimal or an integer

ProductPriceWithoutTaxThe product's price excluding tax. When you use the identifier, make sure that a tax rate (ProductTaxRate) has also been set for the product – only then will calculating the price including tax be possible.

If no tax rate has been set for the product, a tax rate of 0% will be used.

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

A decimal or an integer

ProductWeight

The product's weight

A decimal or an integer

ProductParcelType

The package size used for shipping the product

LETTER, BIG LETTER, REGISTERED LETTER, PARCEL, BIG PARCEL, LONG PARCEL, INSURED PARCEL, CARGO, DOWNLOADABLE

ProductWarrantyPeriod

The product's warranty period

An integer that indicates the product's warranty period in months

ProductFeatured

Defines whether the product should be featured

0: not featured

1: featured

ProductSimilarProductIDsDefines products similar to the product to be importedThe ProductID identifiers of the desired products separated by commas
ProductCompatibleProductIDsDefines the products that are compatible with the product in questionThe ProductID identifiers of the desired products separated by commas
ProductSparePartProductIDsSpecifies the product's spare part productsThe ProductID identifiers of the desired products separated by commas
ProductAddOnProductIDsSpecifies the product's accessory productsThe ProductID identifiers of the desired products separated by commas
WebDesigner-TemplateSpecifies the template to use for the product pageThe template's location in the theme directory, e.g. product/product-with-expanded-bundles
ProductAgeGroup

Specifies the age group for which the product is intended Required if the product belongs to Google's Apparel & Accessories product category or any of its subcategories.

Used only when advertising products via the Shopping Ads extension.

newborn, infant, toddler, kids, adult
ProductGender

Specifies the gender for which the product is intended. Required if the product belongs to Google's Apparel & Accessories product category or any of its subcategories.

Used only when advertising products via the Shopping Ads extension.

female, male, unisex
ProductGoogleCategoryID

Google's product category's identifier.

Used only when advertising products via the Shopping Ads extension.

An integer, see the list of all product categories in Google's documentation
The product's stock details

ProductPurchasePrice

Product's purchase price (the sum paid for a single product when supplied to the warehouse)

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

A decimal or an integer

ProductSupplierCode

The supplier's product code.

Text and numbers

ProductAvailabilityStart

The beginning of the availability period (if the product's availability is limited).

A date in the format 31.12.2014.

ProductAvailabilityEnd

The end of the availability period

A date in the format 31.12.2014.

ProductVisibleFromThe beginning of the visibility periodA date and time e.g. in the format 31.12.2014 09:00
ProductPurchasableFromThe beginning of the period during which the product can be purchasedA date and time e.g. in the format 31.12.2014 09:00
ProductOrderLimitMaximum order quantityIntegers
ProductOrderLimitMinMinimum order quantityIntegers

ProductStock

Enables and disables stock management. Stock details cannot be defined if ProductStock is disabled.

0: stock management isn't enabled.

1: stock management is enabled.

ProductStockPlace

The product's location in the warehouse

Text and numbers

ProductStockBalance

The product's current stock balance. Updates automatically when customers order the product.

Products' quantity

ProductStockBalanceChangeThe changes in the product's stock balance. Enter here the product quantity that should be added or substracted from the product's stock balance.Positive or negative integers (e.g. -5 if you'd like to decrease the stock by 5 pieces)

ProductStockReserved

The quantity of reserved products

Products' quantity

ProductStockContinueSelling

Defines whether the product's sales should continue after the product has run out of stock

0: the sales don't continue

1: the sales continue

ProductStockDeliveryPeriod

The delivery time for products that have run out of stock

The time in days

ProductStockAlarmLevel

The product quantity that activates the stock alarm (the notification that it is running low)

Products' quantity

Product categories

The following identifiers are available for imports of the Categories type.

IdentifierDescriptionAllowed values
CategoryID

The unique, numeral ID used for identifying product categories. Added automatically to each new product category at the moment of creation.

Use this identifier when editing the product category's details. Do not use it, when adding new product categories to your online store.

An integer. Use here only the CategoryID identifiers of the already existing product categories.
CategoryExternalID

The product category's ID number in external system.

Used mostly by API integrations.

A code of max. 36 characters
CategoryParentIDThe CategoryID of the parent product category. Defines the product category's location in the menu.

An integer. Use here only the CategoryID identifiers of the already existing product categories.

When making a product category into a child of another product category, use either the CategoryParentID or the CategoryParentPath identifier, never both of them.

CategoryParentPathParent category path. The online store's root product category – which is the Front page – can be indicated with the slash character /.

Indicate the paths in the format /Product category's name/Another category's name/

When making a product category into a child of another product category, use either the CategoryParentID or the CategoryParentPath identifier, never both of them.

CategorySortThe product category's sorting number with which you can define product categories' order in your online store's menu.An integer. The product categories are sorted in ascending order according to the indicated numbers.
CategoryNameThe product category's name in the language of the selected store versionText and numbers
CategoryDescriptionThe product category's description in the language of the selected store versionLong text + HTML/Textile markup
CategoryTypeThe display type that defines the layout and contents of the product category page

product list: sets the product category page to display a list of the products included in the category.

front page: sets the product category page to display the category's most popular products as well as the products from the potential subcategories (in product category settings Display window).

CategoryImageThe category's campaign imageThe filename of the campaign image (e.g. image1.jpg)
CategoryLinkThe campaign link of the product category (the link attached to the campaign image)Target address of the link
CategoryVisibilityThe product category's visibility

0: the product category is not visible in the selected store version

1: the product category is visible in the selected store version

Brands

The following identifiers are available for imports of the Brands type.

IdentifierDescriptionAllowed values
BrandID

The unique, numeral ID used for identifying brands. Auto-generated for each new brand at the moment of creation.

Use this identifier when editing brand details. Do not use it, when adding a new brand to your online store.

An integer. Use here only already existing brands' BrandID identifiers.
BrandNameThe brand's name in the language of the selected store versionText and numbers
BrandDescriptionThe brand's description in the language of the selected store versionLong text + HTML/Textile markup
BrandImageThe brand logoThe filename of the brand logo (e.g. image1.jpg)
BrandFeelImageThe brand's campaign imageThe filename of the campaign image (e.g. image1.jpg)
BrandLinkThe campaign link of the brand (the link attached to the campaign image)Target address of the link
BrandVisibilityBrand visibility

0: the brand is not visible in the selected store version

1: the brand is visible in the selected store version

Product variations

The following identifiers are available for imports of the Product variations type.

IdentifierDescriptionAllowed values
VariationID

The unique, numeral ID used for identifying variations. Created automatically for every variation.

Use this identifier when editing variation details. Do not use it, when adding new variations to your online store.

An integer. Use only the already existing VariationID identifiers.
The main product's details
ProductIDThe ProductID identifier of the main product.An integer. Use only the already existing ProductID identifiers.
ProductCodeThe ProductCode identifier of the main productText and numbers. Use only the already existing product codes.
ProductSupplierCodeThe product code of the main product's supplier.Text and numbers. Make sure that the product code you indicate corresponds to the product code of the main product's supplier.
Variation details
VariationCodeThe variation's product codeText and numbers
VariationSortThe variation's sorting number. Indicates the variation's location on the variation list in the product card. Variations are sorted in ascending order according to the indicated sorting numbers.Integers
VariationNameThe product variation's name in the language of the selected store versionText and numbers. You can assign desired properties to the variation by typing them in a format that can be processed by the variation splitter.
VariationWeightThe variation's weight (for the sake of shipping)The weight as an integer or a decimal
VariationPrice

The variation's price including tax. The price will be automatically decreased by the tax rate indicated for the main product.

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

The price as an integer or a decimal

0: Deletes the variation's own price

The variation's stock details
VariationEANThe variation's barcode.Text and numbers
VariationStockDefines whether stock management has been enabled for the variation. If VariationStock hasn't been enabled, you won't be able to define other stock details for the variation.

0: stock management is not enabled for the variation

1: stock management is enabled for the variation

VariationStockBalanceThe variation's stock balance i.e. the quantity of the products available in the warehouseIntegers
VariationStockBalanceChangeThe changes in the variation's stock balance. Enter here the product quantity that should be added or substracted from the product's stock balance.Positive or negative integers (e.g. -5 if you'd like to decrease the stock by 5 pieces)
VariationPurchasePrice

The variation's purchase price – the variation's price at the moment of acquiring it to the warehouse

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

An integer or a decimal

0: Deletes the variation's purchase price

VariationStockContinueSellingDefines whether the variation's sales should continue if it is out of stock

0: the sales don't continue

1: the sales continue

VariationStockDeliveryPeriodThe variation's delivery time when the product is out of stock.The time in days
VariationStockReservedThe quantity of reserved product variationsIntegers
VariationStockAlarmLevelThe product quantity that activates the stock alarm.Integers
Variation image details
VariationImageThe image attached to the variation, displayed along with the variation.The name of an image file (e.g. image1.jpg) located in the online store's file directory's /tuotekuvat folder.
VariationImageWithCaptionThe image attached to the variation and its caption displayed on the product page.The name of an image file located in the online store's file directory's /tuotekuvat folder and the image's caption (e.g. image1.jpg:Caption).
VariationAddImageFromURLThe image attached to the variation from an external URL address.The URL address of the image to be attached.

Product attributes

The following identifiers are available for imports of the Product attributes type.

Imports handle product attributes that are added to products and variations to become product features. These, in turn, are used to form product filters in the store's customer area.

See also an example of how to process product attributes by using CSV.

IdentifierDescriptionAllowed values
AttributeCodeA unique product attribute identifierLowercase letters (a-z, no åäö), numbers (0-9) and underscores (_).
AttributeLabel-LANGUAGECODE

The name of a product filter in the customer area

The language code for each translation is added to the end of the identifier.

E.g. AttributeLabel-fi

Text
Attribute values
AttributeValueCodeA unique identifier of a product attribute's valueLowercase letters (a-z, no åäö), numbers (0-9) and underscores (_).
AttributeValueSortThe value's ordinal number in the product filter menu.Integers
AttributeValueLabel-LANGUAGECODE

The name of a product filter's value in the store's customer area

The language code for each translation is added to the end of the identifier.

E.g. AttributeLabel-fi

Text

Product features

The following identifiers are available for imports of the Product features type.

Imports handle products' and variations' product features.

See also an example of how to process product features with products and attributes.

IdentifierDescriptionAllowed values
Products
ProductIDA unique, auto-generated product identifier. Used for identifying products.Integers (use only the identifiers of products that already exist)
ProductCodeA product code defined on the product form. Used for identifying products.Text (use only product codes of products that already exist)
ProductFeature-IDENTIFIERThe product attribute identifier that you specify when you create a product attribute.

Replace the rest of this CSV identifier with the attribute identifier. E.g. ProductFeature-_color

Lowercase letters (no åäö), numbers and underscores
Variations
VariationIDA unique, auto-generated variation identifier. Used for identifying variations.Integers (use only the identifiers of variations that already exist)
VariationCodeA product code defined on the variation form. Used for identifying variationsText (use only the product codes of variations that already exist)
ProductFeature-IDENTIFIERThe product attribute identifier that you specify when you create a product attribute.

Replace the rest of this CSV identifier with the attribute identifier. E.g. ProductFeature-_color

Lowercase letters (no åäö), numbers and underscores

Product documents

The following identifiers are available for imports of the Product documents type.

IdentifierDescriptionAllowed values
ProductDocumentIDThe product document's identifierIntegers
ProductDocumentSortThe product document's ordinal numberIntegers
ProductIDThe product's identifier. Used to identify the product whose product documents are being processedIntegers
DocumentIDThe identifier of the product document fileIntegers
DocumentFile

The name of the product document file (e.g. manual.pdf).

Don't include the entire path in the file name.

Product documents must be placed in the file directory's documents/ folder

Filename
DocumentTitleThe product document title, which is displayed as a download link for the document on the product page.Text

Campaign codes

The following identifiers are available for imports of the Campaign codes type.

Campaign codes created with a CSV import cannot be edited or deleted.

IdentifierDescriptionAllowed values
CampaignCodeID

The campaign code's numeral identifier created automatically for all campaign codes. Used for identifying the campaign code.

An integer (use only the CampaignCodeID identifiers of the already existing campaign codes)
CampaignID

The campaign's numeral identifier created automatically for all campaigns. Used for identifying the campaign.

An integer (use only the CampaignID identifiers of the already existing campaigns)
CampaignCode

A unique campaign code that customers enter at checkout

Letters, numbers and special characters

Campaign products

The following identifiers are available for imports of the Campaign products type.

IdentifierDescriptionAllowed values
CampaignProductID

The product's identifier in the campaign. The identifier is not the same thing as ProductID.

Use this identifier when editing the product's details in the campaign. Do not use it, when adding new products to the campaign.

Integers
ProductID

The product's unique, numeral identifier created automatically for all products.

Use this identifier when adding products to a campaign.

An integer. Use only the ProductID identifiers of already existing products.
ProductCode

The product's product code that is defined on the product form.

Use this identifier when adding products to a campaign.

Text and numbers
CampaignID

The campaign's numeral identifier created automatically for all campaigns.

You can target changes at campaign products by providing the CampaignID and ProductID in the same row. In this way, you can edit a product's details in multiple campaigns within the same import.

An integer. In this field, use only the CampaignID identifiers of the already exisiting campaigns.
CampaignProductQuantityThe product quantity that entitles to discount if the campaign includes quantity-based discounts.Integers
CampaignProductPrice

The product's discounted price in a campaign.

All prices are imported with up to two decimals. If a price includes additional decimals, the rest is rounded.

An integer or a decimal
CampaignProductOrderLimitThe product's order limit in a campaignIntegers
RemoveRemoves the product from the campaign.CONFIRM

Discount coupons

The following identifiers are available for imports of the Discount codes type.

IdentifierDescriptionAllowed values
DiscountCodeID

The discount coupon's unique, numeral identifier. Created automatically for all discount coupons.

Use this identifier when editing a discount coupon's details. Do not use it, when adding new discount coupons to your online store.

An integer. Use only the DiscountCodeID identifiers of the already existing discount coupons.
DiscountCodeThe discount code that the customer must indicate at checkout in order to activate discount.Text and numbers
DiscountCodeTypeThe discount coupon's type. Defines the way in which customers can use the defined discount.

DISCOUNT: discount coupon. A single-use coupon applied to pay for one order.

GIFTCARD: a gift card. Can be used as long as there's balance on the card.

CAMPAIGN: the customers can profit from the campaign discounts as long as they are active.

DiscountCodeProductReportID

The ID number of the saved search. The products to which the discount can be applied are selected based on the saved search.

Integers
DiscountCodeIsActiveDefines whether the discount coupon is active

0: the discount coupon isn't active

0: the discount coupon is active

DiscountCodeValidFromDateThe start date of the coupon's validity period.The date in the format 31.12.2019
DiscountCodeValidToDateThe end date of the coupon's validity period.The date in the format 31.12.2019
DiscountCodeAmountType

The type of discount (required)

The DiscountCodeDiscountFrom column specifies the subject of the discount.

EURO: the discount is a fixed sum.

PERCENT: the discount is a percentage.

DiscountCodeAmountThe amount of the coupon's discount. DiscountCodeAmountType defines whether the amount you indicate will be interpreted as a fixed sum or percentage.An integer or a decimal
DiscountCodeDiscountFromThe discount's object: the object to which the discount is applied.

PRODUCTS: the discount is applied to order products.

ORDER: the discount is applied to the order total.

SHIPPING_COSTS: the discount is applied to the order's shipping costs.

DiscountCodeMinimumOrderThe order's minimum sum that entitles to the discountAn integer or a decimal
DiscountCodeCommentsYour own comment to the discount coupon. Not displayed to the customers at any pointLong text

Search engine optimization fields

You can use these CSV fields with the following types of contents:

  • Products
  • Product categories
  • Brands
  • Chosen shipping methods
  • News
  • Content pages
IdentifierDescriptionAllowed values
SEO-TitleThe contents of the Title tagText
SEO-PageTitleThe page titleText
SEO-MetaDescriptionThe meta descriptionText
SEO-TemplateThe optional template file

The template file's name without the file extension, indicated in relation to the theme's root directory

E.g. product/template-file

Redirects

The following identifiers are available for imports of the Redirects type.

The identifiers can only be used if the Redirects extension is enabled in your online store.

IdentifierDescriptionAllowed values
RedirectIdThe ID of a saved redirect. Leave it empty when creating new redirects.Integers
RedirectPathA source link from which traffic should be redirected to another link.A store-internal, relative (e.g. /page/5) or an absolute link, where you can also use wildcards (e.g. https://www.address.com/*).
RedirectTargetA redirect's target link.A store-internal, relative (e.g. /category/5), or absolute link (e.g. https://www.example.com).