The easiest way (as an advertiser) to create a productfeed, is by using Excel. Some advertisers choose to do this. Generally, it is not prefered, because this means the productfeed will not be automatically updated. This means only advertisers that don't regularly change their prices or products should be creating their productfeed in Excel.
Making a productfeed in Excel
- Start with a Microsoft Excel document.
- On row 1, type out all the fieldnames (see 2. Fieldname standards) in seperate collumns.
A | B | C | D | |
1 | title | bandwidth_upload | bandwidth_download | subscription_duration |
All mandatory fields (see 2. Feeldname standards) should be added to the product feed, other fields are optional. It is also possible to add your own extra fields, to do this, use lower case characters and underscores (_) to seperate words.
- On the following rule, add your product's information.
2 | Alles-in-1 Light | 50 | 50 | 12 |
3 | Alles-in-1 Light | 50 | 50 | 24 |
- The values in the collumns correspond with the fields that are present in the top row.
A | B | C | D | |
1 | title | bandwidth_upload | bandwidth_download | subscription_duration |
2 | Alles-in-1 Light | 50 | 50 | 12 |
3 | Alles-in-1 Light | 50 | 50 | 24 |
- When all your products are present in the feed, save your sheet as a ".CSV" file.