Field mapping
Last updated
Last updated
Each feed has a different structure across all networks, so you must perform field mapping for each feed.
Open your feed file in any CSV viewer, such as Excel. Next, set the column name from your file to the appropriate field in the plugin.
id - Unique ID of the product. This field must remain constant in your feed.
affiliate link – Link to the product with your affiliate parameter.
is in stock – Supported values: "1", "true", "on", "yes", "0", "false", "off", "no".
availability - Supported values: "in stock", "out of stock".
direct link – Direct URL to the original product page without redirects or affiliate parameters.
gtin - EAN 13-digit number, like 3001234567892.
Note that some fields are required, while others are optional.
with XML node attributes:
You can also use XPath syntax for more complex selectors, such as:
Example of XPath for a node with a namespace:
You can extract specific data from a feed field using a custom syntax that incorporates a regex pattern:
[regex][pattern][feed_field_name]
This allows you to define a pattern to match and extract the desired portion of the data within the specified feed field.
Example Use Case:
Consider a feed containing a "fields" field that combines multiple pieces of product data. To extract the value of a specific key, such as "from_price", you can use the following syntax:
Explanation:
[regex]: This indicates you are using a regex-based extraction.
/from_price:([\d.]+) EUR/: The regex pattern to match.
[fields]: The feed field from which data will be extracted.
Use capturing groups () to define the exact portion of the match you want to extract.
You can map any fields from your CSV feed as product attributes, which can then be used to import WooCommerce attributes or display attributes via shortcode.
For example, if your feed includes columns like delivery_weight and delivery_time that you want to map as attributes, add them to the "attributes" mapping settings as follows:
delivery_weight,delivery_time
These fields will then appear as product attributes:
To customize their display names, update the "attributes" mapping like this:
delivery_weight->Delivery Weight,delivery_time->Delivery Time
The result will appear as shown:
