/
Uploading Your Product Data

Uploading Your Product Data

Dec 19, 2022

Product Data Integration

There are two methods to integrate your product data with RMC:

 

Sub-categories which placed under main categories have to have different category code. Categories name can be same. Category tree can be; woman>woman_dress>woman_shoes, man>man_dress>man_shoes.

 

 

 

On this page:

 

1. Using CSV without headers

If you offer different product variations (such as size, color, material, etc) than your integration will slightly be different, please follow the guidelines on the Product Variant page.

You must comply with the following rules to ensure successful product.csv integration:

 

  1. The file must be accessible through HTTP.

  2. The file must be zip compressed.

  3. The file must be updated at least once a day.

  4. There must not be a header in the first line.

  5. The file must be UTF-8 encoded without BOM (byte order mark).

  6. Use semicolon to separate columns.

  7. If a product goes out of stock, stock column must be declared as 0 (zero) or the entire line must be removed from the file.

  8. If there is no discounted price, the original price must be written in the discounted price column as well, ensuring that both columns contain the same value.

  9. All product codes must be unique. 

  10. A product can have only 1 category. If a product is linked to multiple categories use only the default category.

  11. Product codes you sent from web site or mobile app must be the same as product codes in the Product Feed.

 

Example CSV File

to download and view a sample CSV file.

 

Columns must be ordered in the following way:

All columns must be defined with a value. If a column does not have a value, it must be defined with a blank value.

 

Column

Description

Example

 

Column

Description

Example

1.

Product Code

 

 

2.

Product Name

 

 

3.

Category Code

in hierarchical order

ELECT>CELLPHN>SMRTPDH

4.

Category Name

in hierarchical order

Electronics>Cell Phones>Smart Phones

5.

Brand

 

 

6.

Is Active

0 or 1

 

7.

Inventory

total quantity in stock

 

8.

Original Price

 

 

9.

Discounted Price

 

 

10.

Product URL

 

http://www.website.com/productURL.html

11.

Small Image URL

 

http://www.website.com/productImage.jpg

12.

Medium Image URL

 

 

13.

Large Image URL

 

 

14.

Rating

User Ratings

 

15.

Original Price Currency

 

USD

16.

Discount Price Currency

 

USD

17.

Same Day Delivery

0 or 1

 

18.

Free Delivery

0 or 1

 

19.

Number of Comments

 

 

20.

Discount Ratio

 

 

21.

Attribute 1

 

 

22.

Attribute 2

 

 

23.

Attribute 3

 

 

24.

Attribute 4

 

 

25.

Attribute 5

 

 

26.

Color

 

 

27.

Material

 

 

28.

ItemGroupID

 

 

29.

Gender

Gender Information

Use M for Male, F for Female, NULL for empty columns

 

30.

Age Group

 

 

31.

Commentator

 

 

32.

Comment

 

 

33.

Gifts

 

 

34.

Attribute 6

 

 

35.

Attribute 7

 

 

36.

Attribute 8

 

 

37.

Attribute 9

 

 

38.

Attribute 10

 

 

First 20 columns are mandatory. Even if you are not going to use them you have to include semicolons for the first 20 columns. Columns after the Discount Rate column are optional.

The following columns can not be left blank: Product Code, Category Code, Category Name, Inventory, Original Price, Discounted Price, Product URL, Original Price Currency.

At least one of the following columns must contain a valid URL of the product image: Small Image URL, Medium Image URL, and Large Image URL.

 

Once you have prepared the required file based on the rules and standards mentioned above, follow these steps below to validate it and schedule an automatic upload:

  1. Go to  Personalize > Settings > Product Integration.

  2. Enter the URL for the CSV file you have created. 

  3. Click “Test URL” to validate the URL and file.

  4. If you have no error in your Test Detail, click “Save URL”. 

  5. Click “Add Trigger” to schedule product data uploads. We also recommend that you synchronize the product data generation and upload frequency.

 

 

2. Using XML

If you wish to send your product information to RMC using Google Product Feed XML, you have to follow Google standards. 

Following tags have to be inside the <item> or <product> tags to run RMC Segment Reporting properly.

Example XML File

to download and view a sample XML file.

Tags

Description

Tags

Description

<product_code>

 

<product_name>

 

<category_code>

 

<category_name>

 

<brand>

 

<is_active>

 

<inventory>

 

<original_price>

 

<discounted_price>

 

<product_url>

 

<small_image>

 

<medium_image>

 

<large_image>

 

<rating>

 

<original_price_currency>

 

<discount_price_currency>

 

<same_day_delivery>

0 or 1

<free_delivery>  

0 or 1

<number_of_comments>

 

<discount_ratio>

between 0 and 100

<attribute1>

 

<attribute2>

 

<attribute3>

 

<attribute4>

 

<attribute5>

 

<color>

 

<material>

 

<itemgroupid>

 

<gender>

Gender Information

Use M for Male, F for Female, NULL for empty columns

<agegroup>

 

<commentator>

 

<comment>

 

<gifts>

 

<attribute6>

 

<attribute7>

 

<attribute8>

 

<attribute9>

 

<attribute10>

 

 

Uploading and Validating the Data 

To verify your product file format and content, you can use the Product File Integrator.

Choose; Cog Icon > Personalization Center > Recommendation > Product Integration

Validating Steps

  1. On the Product Integration page enter your product file’s url or ftp address and schedule the integration just a few minutes later than the current time you are in.

  2. Wait until your scheduled time and refresh the page to see the integration result.

  3. Click on Log Detail to see if there are any errors in your product file.

You can go to Recommend > Product Catalog from the menu on top to see the uploaded products.

 

3. Product Integration for Multi-Language, Multi-Currency and Location 

3.1. By Using CSV;

In this section, you can find the rules to be followed in product integration in order for the products recommended in the widgets of RMC Recommend to work responsively with websites that support multi-language and multi-currency.

 

Visilabs CSV product integration service has a structure that does not have header information, and fixed column order in CSV. Additions have been made to the existing integration file standards so that the products to be proposed in widgets on sites that support multi-language and multi-currency can be displayed in the language and currency preferred by the visitor.

The changes are briefly as follows:

  1. Including header information in CSV product integration file is mandatory for multi-language support. Details are explained in the "CSV File Header Information" section.

  2. The site's localization options (currency, product availability and language) and standard product information should be  provided.In other words, it is necessary to provide the correspondence of the standard columns according to the supported location options. Details are explained in the "Customizing Product Data" section.

  3. Consistency must be maintained in the product information, provided for localization. Details are explained in the "Consistency in Localized Product Information" section.

Copyright 2020 Related Digital