Using CSV files in creating and updating products on Poleepo
What is the CSV format?
CSV is a file format used for importing and exporting a data table. It is a simple text file that can be generated or modified by the main spreadsheet processing software, such as Microsoft Excel or LibreOffice Calc or OpenOffice.
In this format, each row of the table is represented by a line of text, which in turn is divided into columns using a special separator character.
For correct import, we recommend saving files with “UTF-8” encode, using the “ | “ as a column separator and to use text delimiters ("") only if the cells in the file contain carriage returns.
Creation of new products
Poleepo is able to massively create your catalog by importing from .CSV files.
This operation will allow you to create multiple types of files:
Single products
Products with variations
Products with external supply
Furthermore, once you have created and saved your configuration, you will be able to program its execution automatically.
Single products
Example CSV file for creating individual products
Here you can download a csv file and an Excel file to convert to *.CSV with 2 sample products. If you want to use these files to upload your products, you can edit and import them directly into Poleepo. You can find the files at the end of this article.
CSV file structure for individual products
The first row of your product CSV file must include the headers of the information that will be contained in the underlying cells of that column. The subsequent lines of the file must contain the product data.
You will be able to insert the information described subsequently into the file, not necessarily in the same order and not necessarily all of that listed. Remember to create a column for each information you want to enter.
SKU – Strongly Recommended (If not indicated one will be created by Poleepo)
EAN 13 DIGITS (Barcode) – Strongly Recommended / Mandatory if you want to publish on sales channels: leroy merlin, eprice, ibs, amazon.
NAME – Mandatory
SALES PRICE EXCLUDING VAT or PURCHASE PRICE EXCLUDING VAT - One of the 2 fields is mandatory, both are recommended (If you enter only the purchase price, you will need to indicate a mark-up percentage that is the same for all products)
VAT – Mandatory (If not indicated in the file, you can select the same value for all products from the standard rates proposed by Poleepo) (The VAT rate in the file must be indicated in numerical values e.g. 22,10,5,4 and not as a percentage)
DISCOUNTED PRICE VAT INCLUDED
DISCOUNT PERCENTAGE
WAREHOUSE QUANTITY (If not indicated, the product will be created with quantity 0)
SHORT DESCRIPTION
LONG DESCRIPTION – Recommended
BRAND – Recommended
MPN
WEIGHT – Recommended
MEASUREMENTS – L x H x D expressed in cm
CATEGORY – Recommended
POSITION – Storage, Floor, Area, Shelf, Hole
DEFAULT IMAGE – Recommended. (Insert download link)
IMAGE 1
IMAGE 2
IMAGE 3
IMAGE 4
IMAGE 5 …etc.
Products with variations
Example CSV file for creating products with variants
Here you can download a csv file and an Excel file to convert to *.CSV with 2 sample products. If you want to use these files to upload your products, you can edit and import them directly onto the platform. You can find the files directly at the end of this article.
CSV file structure for products with variants
The first row of your product CSV file must include the headers of the information that will be contained in the underlying cells of that column. The subsequent lines of the file must contain the product data.
You will be able to insert the information described subsequently into the file, not necessarily in the same order and not necessarily all of that listed. Remember to create a column for each information you want to enter.
Unlike single products, for products with variants, you must indicate the Sku column of the parent product for each variant, and the attributes on which to create the variations.
SKU – Strongly Recommended (If not indicated one will be created by Poleepo)
PARENT SKU – Required only for creating products with variants
ATTRIBUTE 1 – Mandatory only for creating products with variants
ATTRIBUTE 2 –
ATTRIBUTE 3 – …etc.
EAN 13 DIGITS (Barcode) – Strongly Recommended / Mandatory if you want to publish on sales channels: Leroy Merlin, ePrice, Ibs, Amazon.
NAME – Mandatory
SALES PRICE EXCLUDING VAT or PURCHASE PRICE EXCLUDING VAT - One of the 2 fields is mandatory, both are recommended (If you enter only the purchase price, you will need to indicate a mark-up percentage that is the same for all products)
VAT – Mandatory (If not indicated in the file, you can select the same value for all products from the standard rates proposed by Poleepo) (The VAT rate in the file must be indicated in numerical values e.g. 22,10,5,4 and not as a percentage)
DISCOUNTED PRICE VAT INCLUDED
DISCOUNT PERCENTAGE
WAREHOUSE QUANTITY (If not indicated, the product will be created with quantity 0)
SHORT DESCRIPTION
LONG DESCRIPTION – Recommended
BRAND – Recommended
MPN
WEIGHT – Recommended
MEASUREMENTS – L x H x D expressed in cm
CATEGORY – Recommended
POSITION – Storage, Floor, Area, Shelf, Hole
DEFAULT IMAGE – Recommended (Insert download link)
IMAGE 1
IMAGE 2
IMAGE 3
IMAGE 4
IMAGE 5 …etc.
Single products and with variants with external supplier
CSV file structure for products with external supplier
The creation of products associated with a supplier involves the exact same logic applied to the 2 previous cases, but the "purchase price excluding VAT" and "quantity" fields will be inserted on the supply and not on the main product. It is therefore possible to create both single products and with variants and with an associated supplier.
It is strongly recommended to insert a column containing the "Supplier Code" for greater ease of identification during the update phase, which is especially necessary if the product has multiple supplies beyond the internal warehouse.
Product update
Poleepo is able to massively update your catalog by importing from .CSV files.
This operation will allow you to update multiple types of files:
Single products
Products with variations
Products with external supply
Furthermore, once you have created and saved your configuration, you will be able to program its execution automatically.
Single products
Structure of the update CSV file for individual products
The first line of your product CSV file must include the column headers containing the fields affected by the update, plus a key field that allows the product to be identified.
The subsequent lines of the file must contain the updated product data.
As for the update file for individual products, simply create a file with the following columns:
SKU or EAN – Key field. Obligatory
FIELD TO UPDATE 1 – Mandatory (For example, if you want to update only the quantity of a product, simply enter the quantity column in addition to the Sku or supplier code)
FIELD TO UPDATE 2 –
FIELD TO UPDATE 3 – …etc.
Products with variations
CSV file structure for products with variants
The first line of your product CSV file must include the column headers containing the fields affected by the update, plus a key field that allows the product to be identified.
The subsequent lines of the file must contain the updated product data.
As for the update file for products with variants, simply create a file with the following columns:
SKU or EAN – Key field. Required (enter variant Sku, not parent sku)
FIELD TO UPDATE 1 – Mandatory (For example, if you want to update only the quantity of a product, simply enter the quantity column in addition to the Sku or supplier code)
FIELD TO UPDATE 2 –
FIELD TO UPDATE 3 – …etc.
Single products and with variants with external supplier
CSV file structure by supplier
The first line of your product CSV file must include the column headers containing the fields affected by the update, plus a key field that allows the product to be identified.
The subsequent lines of the file must contain the updated product data.
To update supplier products, the "purchase price excluding VAT" and "quantity" fields will be updated on the supply and not on the main product.
As for the update file for products from an external vendor, simply create a file with the following columns:
SKU or SUPPLIER CODE or EAN – Key field. One of the 3 fields is required to identify the product
FIELD TO UPDATE 1 – Mandatory (For example, if you want to update only the quantity of a product, simply enter the quantity column in addition to the Sku or supplier code)
FIELD TO UPDATE 2 –
FIELD TO UPDATE 3 – …etc.