The product import feature allows you to manually add items to your catalog using the import tool, making them immediately available for your strategies.
Difficulty: Low.
When to use it?: When integrating your Connectif account and at any time as needed.
Before you begin: preparing the product file
The following table shows the fields that can be included in the CSV:
Name | Type | Description | Required | Example |
---|---|---|---|---|
productDetailUrl | Text | URL of the product page (the URL must be unencoded). This value is mandatory in the document. | Yes | http://exple.com/productA |
productId | Text | Unique identifier of the product (in the eCommerce system). This value is mandatory in the document. | Yes | 101 |
name | Text | Product name. This value is mandatory in the document. | Yes | Product A |
unitPrice | Decimal | Unit price of the product. This value is mandatory in the document. | Yes | 20.99 |
imageUrl | Text | URL of the product image. | No | http://exple.com/images/productA.jpg |
description | Text | Product description. | No | An innovative gadget for modern homes. |
thumbnailUrl | Text | URL of the product preview image. | No | http://expl.com/thumbs/productA.jpg |
categories | List of texts |
The category or categories to which the product belongs. To indicate multiple categories, use the "|" character to separate them. If the eCommerce system allows subcategories, the full path should be indicated, separating each level with the "/" character. For example: "/Computers/Keyboards/Logitech". |
No |
electronics/home/gadgets| electronics/home/accessories |
tags | List of texts | Tags associated with the product. To indicate multiple tags, use the "|" character to separate them. | No | innovative|gadget |
brand | Text | Product brand. | No | GadgetPro |
ratingCount | Integer | Number of reviews the product has. | No | 150 |
rating | Decimal | Product rating. | No | 4.5 |
reviewCount | Integer | Number of reviews the product has. | No | 75 |
relatedExternalProductIds | List of texts | IDs of related products. To indicate multiple products, use the "|" character to separate them. | No | 200|201 |
priority | Integer | Priority or preference level of this product. The default value is 0. | No | 5 |
unitPriceOriginal | Decimal | Original unit price of the product. | No | 25.99 |
unitPriceWithoutVAT | Decimal | Unit price without tax of the product. | No | 17.49 |
discountedPercentage | Decimal | Discount percentage, range from 0 to 100 without percentage symbol. | No | 20 |
discountedAmount | Decimal | Discounted amount of the product (must match unit_price_original - unit_price). | No | 5.0 |
publishedAt | Date | Date in ISO8601 format when the product first appeared in the store's catalog. | No | 2021-03-15T00:00:00Z |
inStockUnits | Integer | Number of product units in stock. | No | 120 |
availability | Text | Marked as instock or outofstock. Indicates whether the product is available or not. | No | instock |
isBlacklisted | Boolean | Marked as true or false. If set to true, the product will be excluded from recommendations. If not specified, the default value is false when the product is created. | No | false |
customField1 | Text | Custom property. | No | CustomValueA1 |
customField2 | Text | Custom property. | No | CustomValueA2 |
customField3 | Text | Custom property. | No | CustomValueA3 |
Below is an example of data extracted from the CSV:
name,productDetailUrl,productId,unitPrice,imageUrl,thumbnailUrl,description,categories,tags,relatedExternalProductIds,priority,ratingCount,rating,reviewCount,brand,unitPriceOriginal,unitPriceWithoutVAT,discountedAmount,discountedPercentage,publishedAt,inStockUnits,availability,isBlacklisted,customField1,customField2,customField3
Product A,http://example.com/productA,101,20.99,http://example.com/images/productA.jpg,http://example.com/thumbs/productA.jpg,An innovative gadget for modern homes.,electronics/home/gadgets|electronics/home/accessories,innovative|gadget,200|201,5,150,4.5,75,GadgetPro,25.99,17.49,5.0,20,2021-03-15T00:00:00Z,120,instock,false,CustomValueA1,CustomValueA2,CustomValueA3
Product B,http://example.com/productB,102,45.5,http://example.com/images/productB.jpg,http://example.com/thumbs/productB.jpg,A durable and reliable tool for professionals.,tools/professional/hardware|tools/professional/accessories,durable|professional,300|301,3,200,4.7,90,ToolWorks,50.0,37.92,4.5,10,2021-06-20T00:00:00Z,80,outofstock,true,CustomValueB1,CustomValueB2,CustomValueB3
STEP 1: Selecting the data source
1. Go to "Ecommerce > Catalog" and click on Import products.
2. In the section Select a data source choose the option Import from file.
3. Configure the import parameters.
3.1. Select Include header if the CSV file has a header with column names.
3.2. Choose, in Delimiter, the character that separates the columns in your file.
3.3. Select the option Overwrite existing if you want to replace the information of products that already exist in Connectif with the data included in the file.
3.4. Select the option Update only empty fields if you want only fields without information to be updated.
4. Click on Next .
STEP 2: Configuring fields to import
5. Select the name of each field from the imported file and drag it to its corresponding field in Connectif.
6. Click on Next .
STEP 3: Checking the import
7. Click on Go to import list .
8. Verify that the products and their information have been correctly imported.
9. If there are any errors, download the CSV error report by clicking on the button (Download error report in CSV).
Keep learning!
To make the most of your Connectif account, we recommend continuing with the following articles:
- Product Page, to learn about product tags and categories in your eCommerce.
- Product Synchronization and Verification, to take full advantage of Connectif's catalog capabilities.
- Product Segments, to learn how to have real-time groups of products available for use in different strategies.
-
Offer Recommender, to help undecided customers choose from the products on sale on your website.