Importing product references

Importing references allows you to add new products to your store or modify a large number of references quickly.

General considerations regarding the files to be imported

To import or update your products, you need to edit a file following the guidelines indicated on this page. There are two supported file formats: CSV and JSON.

CSV files are a type of document that allows you to represent data in the form of a table. JSON files are files used by software developers to exchange data and have a hierarchical tree-like structure. If you do not have programming knowledge, we recommend using CSV files as they use a simpler structure, easier to edit by people who are not used to editing this type of file professionally.

Once a CSV file is uploaded, the platform checks the validity of its data and updates the list of references taking into account the modifications. This operation will take a few minutes and once the file has been processed, we will send you an email informing you of the result. We will inform you about how many references have been updated, how many new ones have been created and, if they exist, how many references (rows in the file) have been considered invalid.

To update your products, you will need to download the file and edit the fields you want to modify. We call this process Export.

Please note that only Products are exported or imported. Service references are neither exported nor imported, so to modify your Services, you will have to do it one by one.

A limit of 250 has been established per file to import. If you want to import more references, please contact us.

Not all fields of your references are exported and you will not be able to modify certain fields by importing a CSV file. For example, neither images, nor SKUs (sizes, colors...), nor Shipping Services, nor Discounts can be modified using CSV files. It would make the operation more complex and only a few businesses would benefit from this more advanced functionality. Images of your products cannot be added or modified through this mechanism either. Remember that you can use the Bulk Management options of your Reference List or the Quick Edit option. Please check the import options via JSON file if you consider that you have the necessary knowledge.

Your product data can be of different types:

• Some include free text (Title,Description...),
• others are numeric data (Id,Price,Stock...),
• others are boolean data (they support two values, 1 (yes) or 0 (no), such asEco-friendly),
• and others can only have specific values, as established on the platform (Payment methods,Units of payment,Product prices,
• Measure and Subcategories).

For each data, in each variable, the specifications indicated below must be taken into account.

------------------

IMPORTANT: The program you use to edit your files (e.g. Microsoft Excel, LibreOffice Calc, a text editor, etc.) could add extra information to the file or format it in such a way that an exported file may give validation errors when imported. We recommend that in case of doubt, you use a text editor or an updated version of your spreadsheet program. Generally, different character encodings will not invalidate imported references, but it is preferable to use UTF-8 encoding for import to ensure there are no validation issues. Also, remember to use double quotes (" ") as a delimiter for text fields and the semicolon (';') as a field separator.

------------------

If you haven't started creating references yet

If you've just created your store and haven't started creating references yet, follow these steps to quickly import your product catalog:

1. From your  Control Panel, go to My References.
2. Under Bulk Actions, select Import References.
3. Download the Plantilla in CSV.
4. Fill it out to add new products, taking into account the specifications of each field/variable.
1. Please note that to add new references, it is necessary that the reference ID is empty, and that the cell does not contain any data.
5. From Bulk Actions, select Import References, and Send the file that you just modified.
6. If there have been no problems, the platform will update the list of references with the new ones you have entered. This operation will take several minutes, and once the file is processed, you will be sent an email informing you of the result.

New references are created in a Draft status, with a generic image and without associated Configurations or Transport Services. Modify this data manually and publish your references to make them available to your customers.

* A limit of 250 references per file to be imported has been established. If you want to import more references, please contact us.

If you have already created references and want to add new ones

If you have your product catalog created and want to use the import to add new references, follow these steps:

1. From your  Control Panel, access My References.
2. In Bulk Actions, select Import References.
3. Download the CSV file with your current products.
4. Fill it in to add new rows to the file for the new references, taking into account the conditions of each of the fields.
1. Please note that to add new references it is necessary that the reference ID is empty, that the cell does not contain any data.
5. From Bulk Actions, select Import References, and Send the file that you have just modified.
6. If there have been no problems, the platform will update the list of references with the new ones you have entered. This operation will take several minutes, and when the file is processed, an email will be sent to you informing you of the result.

New references are created in Draft status, with a generic image and without associated Configurations or Transport Services. They are created last, after the existing references in the Reference List. Modify your data manually and publish the new references so that they are available to your clients.

* A limit of 250 references per file to be imported has been established. If you want to import more references, please contact us.

If you want to update existing references

If you have your product catalog created and you want to use the import to modify data of your current references, follow these steps:

1. From your  Control Panel, access My References.
2. In Bulk Actions, select Import References.
3. Download the CSV file with your current products.
4. Modify the data you want to update for your references, taking into account the conditions of each of the fields.
1. It is important that you do not modify the reference ID, since this is the field that uniquely identifies it.
5. From Bulk Actions, select Import References, and Send the file that you have just modified.
6. If there have been no problems, the platform will update the list of references with the new ones you have entered. This operation will take several minutes, and when the file is processed, an email will be sent to you informing you of the result.

New references are created in a Draft status, with a generic image and without associated Configurations or Transport Services. They are created last, after the existing references in the Reference List. Modify your data manually and publish the new references so that they are available to your customers.

* A limit of 250 references per file to be imported has been established. If you want to import more references, contact us, please.

Specifications and validations when editing the CSV file

CSV files have a tabular structure that uses a character as a table separator. In the CSV file that you use to import references to your store, that reserved character must be ";" (semicolon). This is why the semicolon (";") should not be used in any field of the file, in any variable.

The use of "," (comma) is allowed in all text fields. Additionally, in the Active payment methods field, the comma (",") is considered to be the separator between different values.

In the export, in the text fields (Title and Description) that have double quotes (" "), these are replaced by single quotes (' ').

To consider a CSV file as valid, the fields must meet the specifications indicated below:

• ID: The ID of a reference is the unique identifier of the same. It is not a field that you can edit from the platform.
• Unique numeric field.
• To add new references, this field must be left blank (empty).
• It is only taken into account when updating references. Do not modify the ID of a reference that you are updating.

• Subcategories: The Subcategory of a reference is used to classify the different products on the platform. It is unique and belongs to a single Category, and this in turn to a single Department.
• Field that only allows one identifier as indicated in the following list of Subcategories. Any data that falls outside this list will not be considered valid.
• This field cannot be left empty; if it is not complete, this data will be considered an invalid reference.

• Title: The Title of a reference is used by buyers to identify the reference.
• Text type field that can be enclosed in double quotes (" "). It cannot be left empty; if this information is not complete, the reference will be considered invalid.
• The use of "," (comma) is permitted.
  
• In the export, any double quotes (" ") that may have been included in the title text are replaced by single quotes (' ') to avoid import errors..

• Price: This field refers to the Base Price (without discounts) of the Product, in Euro cents.
• Numeric field that can be left empty. If complete, the value must be an integer greater than 0.
• IMPORTANT: The Price must be set in Euro cents. For example, to indicate a price of €10 for a reference, you would have to fill in this field with the number 1000.

• Unit of measurement: In some sectors, such as the Food sector, merchants are required to indicate the price per unit of measurement for many of their products. The unit of measurement indicates the way in which you measure your product.
• This field can be left empty, but if you indicate a Unit of Measurement, you will also need to specify the Price per unit of measurement and vice versa.
• The field only accepts the numerical data corresponding to the identifier (ID), as indicated in the following list of Units of Measurement. Any data that falls outside this list will not be considered valid.

• ID - NAME OF THE UNIT OF MEASUREMENT
• 1 - The Unit
• 2 - The kilo
• 3 - The Liter
• 4 - The meter
• 5 - The square meter
• 6 - The cubic meter
• 7 - The dozen
• 8 - 100 g
• 9 - 100 ml
• 10 - The dose

• Price per unit of measure: In some cases, the price is 100 g.s sectors, such as the Food, merchants are required to indicate the price per unit of measurement for many of their products. The price per unit of measurement refers to the final price, including taxes, for the indicated unit of measurement.
• This field can be left empty, but if you indicate a Price per unit of measurement, you will also need to specify the Unit of Measurement and vice versa.
• If filled in, this field must have a number greater than 0.
• IMPORTANT: The Price per unit of measurement must be set in Euro cents. For example, to indicate a price per unit of measurement of €3, this field would have to be filled with the number 300.

• Description: The Description offers extended information about the reference, so that buyers know all the details of it.
• Text type field that must be between double quotes (" "). It cannot be left empty; if this information is not complete, the reference will be considered invalid.
• The CSV file supports some simple HTML tags for this field.
• When exporting, any double quotes (" ") that may have been included in the description text are replaced by single quotes (' ') to avoid import errors.

• Characteristics: In some sectors, such as Food and Fashion and Accessories, the characteristics of the products can be indicated in a parameterized way.
• This field must have a boolean value. The accepted values ​​are 1 or 0, where 1 is 'true' and 0 is 'false'.
• For example, to indicate that a product is organic, the Organic field must be filled in with the value 1.
• Only the characteristics of the sector/department of the reference are taken into account. The characteristics that do not correspond to the sector of the reference must be left empty, and those that do correspond must be filled in with one of the 2 accepted values.
• That is, to edit a reference in the CSV file from the department Fashion and accessories, the fields Organic and Gluten-free must be left empty, since they do not correspond to this department.
• If the sector or department of the reference is Food, the following characteristics must have a true or false value (this field is mandatory):
• Organic
• Gluten-free
• Proximity
• If the sector or department of the reference is Fashion and accessories,the fields Organic and Gluten-free must be left empty, since they do not correspond to this department.
• If the sector or department of the reference is Fashion and accessories,the fields Organic and Gluten-free must be left empty, since they do not correspond to this department. Add-ons, the following characteristics must have a true or false value:
• Man
• Woman
• Child

• Logistic Weight: The logistic weight is the weight to be taken into account in the transport of this product, including packaging, indicated in grams.
• Numeric field that can be left empty. If complete, the value must be an integer greater than 0.
• IMPORTANT: The Logistic Weight must be set in grams. For example, to indicate that a reference has a logistic weight of 5Kg, this field would have to be filled with the number 5000.

• Active payment methods: The Active payment methods for a reference establish how the payment can be made by the buyer.
• This field can be left empty, but for an Active payment method to be valid, in the Configuration of the Sales module of your store this Payment method must be enabled and configured.
• You can add more than one Active payment method, separating the different IDs with commas (",").
• The field only accepts the numeric data corresponding to the identifier (ID), as indicated in the following list of Active payment methods. Any data that falls outside this list will not be considered valid.

• ID - PAYMENT METHOD NAME
• 1 - PayPal
• 2 - Bank transfer
• 3 - Payment in hand
• 5 - Credit card

• Code: The Reference Code is information that can help you or the buyer to identify the reference.
• Optional text field that supports a maximum of 64 characters.
• The use of "," (comma) is allowed.
  

• Stock: The stock of a product is the availability of stock of said product.
• Numeric field that can be left empty or with an integer greater than or equal to 0.
• If the value is 0, it is considered that there is no stock available for said product.
• If the field is left empty, it is not specified whether or not there is stock of the product, so buyers are allowed to buy as many units as they want. That is, there is no limit to the units you can buy.