Information on the structure of the CSV file can be found here.
Step 1. Export products and articles from the current platform
Log in to the Merchant Pages and click on Products, then follow these instructions to export all products and articles:
Step 2. These columns need to be changed in the export file:
| Export column name |
Change to |
| your article id | sku |
| Fyndiq's article nos. | Remove the column |
| Fyndiq's product no. | legacy_product_id |
| Product | title:sv-SE |
| Article name* | See below |
| Product description | description:sv-SE |
| Sold | Remove the column |
| Price at Fyndiq | price:SE:SEK |
| Original price | original_price:SE:SEK |
| Number left | quantity |
| State | status** |
| Express delivery | Remove the column |
| (ISBN,EAN,MPN) | gtin*** |
| Category ID | category:1 |
| Brand name | brand |
| Platform article ID | Remove the column |
*Article name does not have a corresponding column in the new model. The information could however be relevant to add to the title of the article or as a property.
**status accepts the values "for sale" or "paused" to mark if the article should be put up for sale. The values exported in this column does not match those values and needs to be updated.
***ISBN,EAN and MPN can all be used as GTIN values. However you can't have more than one GTIN column so these needs to be reduced to one column. If there is no data in the ISBN or MPN column these can be removed and EAN can be renamed to GTIN.
Step 3. These columns need to be added:
Shipping time:
| Column name | Value |
| shipping_time:min:SE | Shipping time in working days, minimum. |
| shipping_time:max:SE | Shipping time in working days, maximum. |
Images (only main_image_url is required):
| Column name | Value |
| main_image_url | Link to the main image, you can't link to images hosted in our current platform. |
| other_image_url:<number> | Link to other images where <number> in the column names can be set to an integer 1 through 11 to add more pictures. |
Market
| Column name | Value |
| market:1 | This column requires the value SE for all articles |
Step 4. These columns needs to be added in order to create products:
Before you start working with these columns, please read the following articles:
https://support.fyndiq.se/hc/articles/360043458691
https://support.fyndiq.se/hc/articles/360043082952
| Column name | Value |
| parent_sku | SKU for one of the articles in the article group/product. |
| property:<property name>(:<language if it is a free text property>) | The articles value for the property. |
| variational_property:<number> | The property name of the property/properties that varies between the articles in the product. |