MyCashflow's CSV identifiers

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.

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.

0: the customer is not allowed to log in

1: the customer is allowed to log in

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.

CustomerFirstName

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

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

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.

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

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

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.

ProductName

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

Text and numbers

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.

Product image file names separated by vertical bars (e.g. img1.jpg|img2.jpg)

ProductAddImagesFromURL

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

Product image URLs separated by vertical bars (e.g. https://example.com/img1.jpg|https://example.com/img2.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 vertical bars (e.g./Clothes/Trousers|/Clothes/Jeans)

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

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

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.

ProductSupplierID

The supplier's SupplierID identifier

An integer. Use only the existing supplier ID 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.

ProductTaxRate

The product's tax rate. The product's price without tax is calculated based on this and the ProductPrice column (or, alternatively, the price including tax based on the ProductPriceWithoutTax column).

Tax rate as a whole or decimal number (e.g. 25.5, it is recommended to use period as the separator). 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 this and the ProductTaxRate column.

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

A decimal or an integer

The product's price excluding tax. This is necessary only if the price including tax (ProductPrice) hasn't been specified. If both prices – including and excluding tax – have been specified, the one that comes later in the CSV remains valid.

To calculate the price including tax, the tax rate (ProductTaxRate) must be specified before the price excluding tax. If the tax rate is 0, you cannot specify the price excluding tax. Instead, specify the price including tax in the relevant column.

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

ProductWeight

The product's weight

A decimal or an integer

ProductParcelType

The package size used for shipping the product

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

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.

This is used only when advertising products via the Shopping Ads extension.

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.

This is used only when advertising products via the Shopping Ads extension.

Google's product category's identifier.

This is used only when advertising products via the Shopping Ads extension.

Designates the product as adult-only content, which limits its visibility in Google Shopping ads.

This is used only when advertising products via the Shopping Ads extension.

0: No advertising restrictions

1: Advertising restrictions, e.g. based on the audience age

ProductPurchasePrice

Product's tax free purchase price (the sum paid for a single product when acquired to the stock)

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

A decimal or an integer

ProductSupplierCode

The supplier's product code.

See the Finnish Customs' list of country codes (updated in 2023).

You can find the up-to-date tariff nomenclature on the Finnish Customs website.

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.

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

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: Sales suspended

1: 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

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.

The product category's ID number in external system.

Used mostly by API integrations.

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.

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.

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).

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

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

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.

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

1: the brand is visible in the selected store version

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.

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

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

0: Deletes the variation's own price

See the Finnish Customs' list of country codes (updated in 2023).

You can find the up-to-date tariff nomenclature on the Finnish Customs website.

0: stock management is not enabled for the variation

1: stock management is enabled for the variation

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

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

0: Deletes the variation's purchase price

0: the sales don't continue

1: the sales continue

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

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

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

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

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

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

A unique campaign code that customers enter at checkout

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.

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

Use this identifier when adding products to a campaign.

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

Use this identifier when adding products to a campaign.

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.

The product's discounted price in a campaign.

Prices are always imported with two decimal places, so any decimal parts longer than that are rounded automatically.

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.

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.

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

0: the discount coupon isn't active

0: the discount coupon is active

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.

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.

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

E.g. product/template-file