Load technical specifications from WooCommerce’s importer

Imprimir

In this article, we will explain how to load data from Mercado Libre’s technical specifications into a WooCommerce product using WooCommerce’s default data importer. It’s important to note that we are working to further optimize this process. For now, it’s an option for stores that have many listings and experience using WooCommerce’s data importer.

Content

→ 1. The WooCommerce product must have an assigned connection template
→ 2. Identify the IDs of the technical specifications attributes
→ 3. Format of the values for these attributes
  ↳ Example 01
  ↳ Example 02
  ↳ Example 03
→ 4. Assemble an Excel template for importing
→ 5. Importing with WooCommerce

1. The WooCommerce product must have an assigned connection template

The connection template represents the listing category on Mercado Libre. Therefore, it’s crucial to know which attributes of the technical specifications can be completed. If the product doesn’t have an assigned connection template, the technical specifications fields will not appear. Attributes often vary depending on the category type you’re working with.

2. Identify the IDs of the technical specifications attributes

You need to access the product details in WooCommerce, under the WM Technical specifications tab, and verify the identifiers of the technical specifications fields. Keep this value in mind as it will be used in the following steps.

3. Format of the values for these attributes

KEY-IN-GRAY || DATA-TYPE :: VALUE

#Example 01

BRAND||value_name::Brand = Used for custom attributes (i.e., a value not in the selectable field found in WM Technical specifications).

BRAND||value_name::Disney

BRAND||value_name::Mercado Libre

BRAND||value_name::Apple

….

#Example 02

BRAND||value_id::52035 = Used for options available on Mercado Libre (i.e., a value within the selectable field).

You should consult these identifiers directly from the URL of the category attributes on Mercado Libre: (http://api.mercadolibre.com/categories/MLB31447/attributes).

      {
        "id": "14810",
        "name": "Adidas"
      },

For this example, Adidas has the ID 14810

#Example 03

SECTION_WIDTH||number_unit::245::mm = Used when working with units (grams, ml, percentages, etc.).

SECTION_WIDTH||number_unit::245::% = Used when working with units (grams, ml, percentages, etc.).

SECTION_WIDTH||number_unit::245::” = Used when working with units (grams, ml, percentages, etc.).

Just like the previous case, identifiers are obtained from the route to view attribute details, which is (https://api.mercadolibre.com/categories/MLB31447/attributes) where you can see the identifiers of the technical specifications for a specific category. You can see the category code in the connection template (in this case, it’s MLB31447).

4. Assemble an Excel template for importing

To import values as WooCommerce metadata, you should have an Excel document where you create a column with the header meta:_wm_attribute, and you place all the values previously set in the step above, separated by commas. For example:

2121,”BRAND||value_id::252310,LINE||value_name::Line TEST,MODEL||value_name::HT-S100F”

Where:

The WooCommerce product ID is 2121.
The brand (BRAND) is MERCADOLIBRE (252310).
The line (LINE) is “LINE TEST”.
The model is “HT-S100F”.

It’s important that this information appears in quotes, as shown in the example. An example document that can be used to load the information is attached: SEE.

5. Importing with WooCommerce

The import is performed from the WooCommerce importer, selecting the metadata options. The steps are:

a. Upload the .CSV file using WooCommerce’s data importer.

Choose the .CSV file from your computer and tick the option “only update existing products.” Remember that WooCommerce has an option that allows you to update existing products that match by ID or SKU and skip products that don’t exist. It’s advisable to have this option enabled.

b. Column Assignment

Once WooCommerce has correctly processed the file, it will allow you to relate the WooCommerce product columns with the columns of the previously uploaded .CSV file. Two (2) columns should appear (if you only have two columns in the file). One would be the ID or SKU of the WooCommerce product, and the other would be a metadata column called meta:_wm_attribute. If they are correctly related, you can proceed to the next step. If not, check the document’s format.

c. Import and verify

By now, the technical specifications data should have been correctly added to the products. Check with some products. It’s important to note that the data remains and only the fields included in the document are modified.

For more details on this procedure, click on this link

Related Links:

Buy now