CSV rules
A regular rule sets one value for every matching product. A CSV rule gives each product its own value, straight from your spreadsheet. Use it to group products for ads, like Custom label 0 = best_seller, high_margin or clearance.
Import a file or a sheet
Prepare your sheet
Make one row per product. One column identifies it: sku, variant_id, product_id or offer_id. Name the other columns after the field they fill, like brand, gtin or custom_label_0. In Google Sheets, click Share and set access to Anyone with the link, then copy the link.
Need a starting point? In the import dialog, click Download template and pick Empty template or Current values of a feed.
Add your sheet
Go to Optimize and click Import CSV. Paste the Google Sheet link, or drop a .csv file instead. Use one source at a time. Click Continue.
Check and import
The preview shows how many products match and the value each one gets. A greyed-out value won't apply: Held by names the edit, rule or template that keeps it. Set the Template name, the Order (new templates start at 1) and Apply to feeds. Leave feeds empty to add them later.
Import
Click Import. The template joins your rules list on Optimize, with a sheet icon.
Open the feed
Go to Manage feed and open the feed. On the Conditions tab, the Optimize rules card lists the template with its number.
See the field
After the feed's next sync, open a product from your file on the Products tab. The field shows the value from your sheet.
Fields you can import
Title, Description, Image, Brand, GTIN, MPN, Condition, Google product category, Product type, No identifier, Color, Size, Size system, Size type, Gender, Age group, Material, Pattern, Custom label 0-4, Adult and Is bundle. Prices, shipping and returns can't be imported.
Manage your templates
Find templates under the Import CSV tab on Optimize. Click one to open Edit template: rename it or change its order and feeds on Basic info, upload a new file on Edit, or check the source and status on Details.
Deleting a template removes its values from your feeds and publishes them again right away.
Good to know
- The lower number wins. Templates and rules share one list. Your own edits on a product beat both.
- A new file replaces the old one. Columns and products missing from it are no longer set.
- Empty cells change nothing. The feed keeps its current value.
- Exclude rules still apply. A CSV can't bring back a product a rule removed.
- Product ID covers every variant. Use SKU or Variant ID for one variant.
FAQs
My feed still shows the old values. Why?
Values reach a feed on its next sync. Check the template is added to that feed, and that no rule or template above it sets the same field.
It says no product matches my store.
Check the ID column. Its values must match your products exactly.
It says the Google Sheet is not public.
In the sheet, click Share and set access to Anyone with the link.