How to create a CSV feed file (in Oct8ne format)
To perform bulk product uploads to populate the Oct8ne catalog, we use feed files to supply our servers with your product data. These files have a specific format and naming convention, which we will review below.
CSV
A CSV (comma-separated values) file is a text file with a specific format that allows data to be saved in a structured table format. Excel is commonly used to read these files, but it's not the only software that can be used.
A CSV file consists of columns and rows. Each column represents an attribute, and each row describes a product. The columns representing the attributes must be separated by commas (the most common method), but they can also be separated by tabs, semicolons, or other characters. The file itself defines how the columns are separated. Consequently, the rows must follow the same separator.
Use a single row for each product.
More information:
The columns (product attributes) we use to import the data are the same as the standard Google Merchant format.
In other words, we are basing our work on the columns as defined in the Google Merchant standard document for basic product data. (The column names must be IDENTICAL, exactly as shown here.)
COLUMNS:
id
• MANDATORY
• Use a unique value for each product. Use the product's SKU code whenever possible.
• Keep the same ID when uploading your data.
• MANDATORY
• Use a unique value for each product. Use the product's SKU code whenever possible.
• Keep the same ID when uploading your data.
title
• MANDATORY
• Product Name
• Title your product accurately.
• Do not include promotional text (such as "Free Shipping"), do not write in all capital letters, and do not use foreign characters.
• For variations, it is recommended that you include a distinguishing feature, such as color or size.
description
• MANDATORY
• Describe your product accurately. You can use the same description as on your website.
• Do not include promotional text (such as "Free Shipping"), do not use all capital letters, and do not use foreign characters.
• Do not include HTML tags and try to keep your description under 1,000 characters.
• Include only product information. Do not include links to your store, sales information, or details about your competitors, other products, or accessories.
link
• MANDATORY
• Product landing page
• Use your verified domain name.
• The URL must start with 'http' or 'https'.
• Use a URL encoded to comply with RFC 2396 or RFC 1738. For example, the comma should be written as "%2C".
image_link
• MANDATORY
• URL of the main product image
• This must link to the main product image.
• The URL must begin with 'http' or 'https'.
• Use a URL encoded according to RFC 2396 or RFC 1738. For example, the comma should be written as "%2C".
• Use an accepted format: JPEG (.jpg/.jpeg), PNG (.png), GIF (.gif), BMP (.bmp)
additional_image_link
• OPTIONAL
• URL of an additional product image
• You can add more than one image, separated by commas.
price
• MANDATORY
• Product Price
• Add the product price and currency; these must be accurate and match the price shown on the landing page.
The link field is very important, as it's what allows us to track products. This field tells us which product the customer is viewing, and we can display it in the Oct8ne viewer. For this to work, the link field must be identical to the canonical URL of each product page.
* If the page does not have the rel=’canonical’ tag, the link field must be IDENTICAL to the page URL.
If the file contains more columns than those described above, those will not be imported into the Oct8ne catalog. They will be ignored by our system.
An example file is attached. It normally opens with Excel, but when saving, be careful to preserve the formatting, as it's very easy to corrupt the file.
We recommend opening this type of file with a text editor (Notepad++, etc.) to better see the separators.
Related Articles
How to create an XML feed file (in Oct8ne format)
To perform bulk product uploads to populate the Oct8ne catalog, we use feed files to supply our servers with your product data. These files have a specific format and naming convention, which we will review below. XML A file with the '.xml' extension ...Downloading statistics via API
These instructions are intended for people with a basic understanding of the web programming language: JavaScript. If this doesn't apply to you, we recommend contacting your developers and providing them with these instructions. Installation will be ...Instal Oct8ne into your website
Oct8ne can be integrated into any website in three different ways, depending on your platform and needs. 1. Via Plugin. If your website is built on one of the most common platforms, Oct8ne provides a specific “plugin/add-on” for each platform, which ...Oct8ne custom widget design
These instructions are intended for people with a basic understanding of web programming languages: HTML and CSS. If this doesn't apply to you, we recommend contacting your developers and providing them with these instructions. Installation will be ...API for sending transactional or bulk messages from WhatsApp
Introduction WhatsApp Delivery API allows you to automate the delivery of WhatsApp templates via Oct8ne. The following operations are available: Send template to WhatsApp Get delivery status Get deliveries Get message details Security All API calls ...