Short answer: If you sell products that come from a supplier’s price list, you can use that list as the source of your product feed. Reshape the file so that it has the columns RSS Feed Creator reads, make every link point to the product page in your own shop, apply your margin so that the price equals the price on your page, publish the result as a CSV link and create a feed from it. The tool then builds the Google and Meta product XML and refreshes it on schedule. The two things to get right are the links and the prices.
Who this is for
Resellers, dropshippers and small retailers often have no product database of their own. Their catalogue is a file that a supplier sends or publishes: a price list with codes, names, prices, stock and pictures. The shop on their website shows those products, perhaps with a margin added. To advertise them on Google Shopping or in a Meta catalog, they need a product feed that matches the shop.
RSS Feed Creator is a good fit for this because it accepts a CSV link as a source, as described in CSV link to product feed: the columns RSS Feed Creator reads, and because it lets you change prices by a percentage and rewrite titles without touching the file’s origin. This article is about the specific problems of working from somebody else’s file.
What a supplier file looks like and what the tool needs
Supplier files come in all shapes. They may use semicolons instead of commas, local column names, prices with decimal commas, stock as a number of units and links to the supplier’s own pages. RSS Feed Creator expects a header row with specific column names and plain values:
| Supplier file | What the tool needs |
|---|---|
| Article code | A column called id |
| Product name | A column called title |
| Supplier’s product page | A column called link, pointing to your own shop |
| Picture addresses | A column called image_link, with full addresses |
| Wholesale price with a comma | A column called price, a plain number with a dot |
| Units in stock | A column called availability with in_stock or out_of_stock |
| EAN or barcode | A column called gtin |
The tool does not map column names by itself, so the file has to carry these names. That is the main piece of work, and it is done once.
Reshape the file
There are two practical routes. The first is to ask your supplier whether they can deliver the data in this layout, or in a standard product feed format that you can adjust with little effort. Some suppliers already offer a CSV with a fixed layout, and you only need to check the column names.
The second is to do the reshaping yourself in a spreadsheet. Import the supplier’s file into a sheet, create the new columns with the names above, fill them by formula from the supplier’s columns and publish the sheet, or export it, as a CSV at a public web address. RSS Feed Creator downloads that address on every refresh, so when the supplier sends a new file, you paste it into the source sheet and the feed follows. Keep the formulas, not the values, so that only one step is repeated.
Watch the details that break feeds: commas as separators, dots as decimal marks, full web addresses and no currency symbols in the price column. A short test file of ten rows saves a lot of time.
Links must point to your shop
This is the most common mistake in supplier-based feeds. The link column must hold the address of the product page where your customer can buy the product, on your own website. If it holds the supplier’s address, Google and Meta will send shoppers to a page that is not yours, and your products will be rejected, because the landing page does not match your domain.
The solution is to build the link in the sheet from a fixed pattern. If your shop uses addresses like https://shop.example.com/product/ABC123, a formula that joins the base address and the article code gives you every link. Check three or four links by clicking them; every one should open the right product in your shop. The same applies to the image: if possible, use the pictures that your shop already serves rather than the supplier’s.
Adding your margin with a percentage
If the supplier’s file holds wholesale prices and your shop adds a margin, the management page has a setting called “Change prices by %”. A value of 25 multiplies each price by 1.25, and the result is rounded to two decimals. The setting accepts values from minus 90 to plus 500 per cent. It applies to the price and the sale price, and the currency stays the same.
Before you rely on it, compare it with your shop. The price in the feed must equal the price on the product page, because Google and Meta compare them. If your shop rounds prices in a particular way, for example to end in .99, a plain percentage will not match it exactly. In that case, calculate the final price in your sheet with the same rounding as your shop and leave the percentage at zero. The reasoning is explained in price rules in product feeds: when and how to adjust prices, and the page and the feed must always agree.
Stock, titles and descriptions
Stock in supplier files is usually a number. Convert it in the sheet: a formula that writes in_stock when the number is above your threshold and out_of_stock otherwise. A new feed skips out-of-stock products by default, so that sold-out items drop out of the feed automatically. Because supplier stock changes quickly, remember the refresh time of the feed: every 3 hours on the free plan and every 30 minutes on paid plans, and the update frequency of the file itself, which is only as fresh as the last time you replaced it.
Titles in supplier files are often cryptic, with codes and abbreviations. The title template on the management page can place the brand and category around the title, as explained in product rules in RSS Feed Creator: stock, titles and prices, but it cannot repair a title that is unreadable, so clean the worst ones in the sheet. Descriptions should be written for your shop, not copied from the supplier: duplicate text hurts your pages and may be rejected.
A worked example
A small shop sells garden tools from one wholesaler. Every Monday the wholesaler e-mails an Excel price list with 300 rows. The owner keeps a spreadsheet with two sheets: one for the raw list and one called “feed”. Each row of the feed sheet takes its code, name and picture from the raw sheet, builds the shop link from the code, adds her margin and writes in_stock or out_of_stock from the units column.
She publishes the feed sheet as a CSV at a public address, creates a product feed from it in RSS Feed Creator and checks the preview: prices, currency, availability and links all look right. She then adds the feed address in Merchant Center and Meta. Each Monday she pastes the new raw list into the first sheet and does nothing else. The feed refreshes by itself, and products the wholesaler has dropped disappear when their rows do.
Rights and good practice
Pictures, descriptions and brand names in a supplier’s file may be covered by an agreement. Check that you are allowed to use them in advertising, and keep the feed honest: products must be available, prices real and policies in place. A feed is a technical tool, and the channels’ rules still apply to what you advertise.
Also remember that the feed fetches whatever the file says at the time. If the supplier discontinues a product and you do not replace the file, you will advertise it until you do. A short routine, such as a weekly replacement of the source sheet, is better than hoping.
Plans and limits
You can test the whole workflow on the free plan with product feeds of up to 50 products. The Store plan at €19 per month allows up to 2,000 products with 3 product feeds and a 30-minute refresh, and the Business plan at €39 per month covers 3 stores and 10 feeds. See the pricing page for all details.
Related reading
- CSV Product Feeds: How to Build One That Platforms Accept
- Product Feed Checklist: 25 Checks Before You Submit
- VAT and Tax in Product Feed Prices: Getting It Right
The bottom line
A supplier file can become a proper Google and Meta product feed if you reshape it once: right column names, links to your own shop, prices that equal your page and clean availability. Test with ten rows, use the percentage only where it matches your shop and refresh the source file regularly.
BUJ
Can I use my supplier’s CSV as it is?
Only if it already has the columns RSS Feed Creator reads, with a header row, commas and plain numbers. Otherwise reshape it in a spreadsheet.
Which link should the file contain?
The address of the product page in your own shop, not the supplier’s page.
How do I add my margin?
Either with the “Change prices by %” setting or by calculating final prices in your sheet. The feed price must equal the price on your product page.
What happens when a product runs out?
If the file marks it as out_of_stock and the skip option is on, the product is left out of the feed at the next refresh.
How many products can I include?
Up to 50 on the free plan, up to 2,000 on the Store plan and up to 20,000 on the Business plan.


