sale_price_effective_date: Definition

Use the sale_price_effective_date attribute to tell us how long you want a specific sale price to be shown to users.

When to use

• Optional for each product

If you used the sale_price attribute to indicate that a product is on sale, you can tell us how long the sale will run using the sale_price_effective_date attribute.  

Format

Follow these formatting guidelines to make sure we understand the data you're submitting.

Type	Date range (use ISO 8601 standard). Submit a start date and an end date with time and timezone of format YYYY-MM-DDThh:mm[±hhmm] or YYYY-MM-DDThh:mmZ, separated by slash ( / ) (e.g., 2016-02-24T13:00-0800/2016-02-29T15:30-0800)
Limits	0-51 characters
Repeated field	No

 

File format	Example entry
Text feeds	2016-02-24T13:00-0800/2016-02-29T15:30-0800
XML feeds	<g:sale_price_effective_date>2016-02-24T13:00-0800/2016-02-29T15:30-0800</g:sale_price_effective_date>

To format your data for Content API, see the Content API for Shopping.

Guidelines

Follow these guidelines to make sure you submit high-quality data for your products.

Minimum requirements

These are the requirements you'll need to meet to show your product. If you don't follow these requirements, we'll disapprove your product and let you know in the Diagnostics page in your Merchant Center account.

• There are no minimum requirements for this attribute. Keep in mind that you still need to follow the formatting guidelines or the information you submit can't be used.

Best practices

To optimize your product data's performance, follow these best practices:

• Include start and end times (including time zones) along with the date. If you don’t include a time, the sale price will start at 12 AM, midnight, on the start date and end at 11:59 PM on the end date. If you don’t include a timezone, we'll default to the UTC timezone.

Examples

Variants

If your product comes in multiple colors or sizes, you might also have different prices for each of these variants. For example:

Product	Google T-shirt
title	Google T-shirt - Green - Small
price	10.99 USD
sale_price	9.99 USD
sale_price_effective_date	2018-02-24T13:00-0800 / 2018-02-29T15:30-0800
color	green
size	s
id	9876-S-GRN
item_group_id	9876

Product	Google T-shirt
title	Google T-shirt - Blue - Small
price	8.99 USD
sale_price	5.99 USD
sale_price_effective_date	2018-06-23T13:00-0800 / 2018-02-29T15:30-0800
color	blue
size	s
id	9876-S-BLU
item_group_id	9876

Product	Google T-shirt
title	Google T-shirt - Yellow - Small
price	10.50 USD
sale_price	8.99 USD
sale_price_effective_date	2016-06-23T13:00-0800 / 2016-02-29T15:30-0800
color	yellow
size	s
id	9876-S-YELLOW
item_group_id	9876

Phone or tablet with a contract

You can submit a price as low as 0 for mobile phones or tablets that come with a contract. Learn more about the requirements.

Product	Google Nexus 6
title	Google Nexus 6 - 32 GB - Midnight Blue - With contract
price	299 USD
sale_price	0 USD
sale_price_effective_date	2018-03-14T13:00-0800/2018-04-29T15:30-0800
google_product_category	Electronics > Communications > Telephony > Mobile Phones

Apparel

Product	Black Skater Dress
title	Black Skater Dress - S
price	45.90 EUR
sale_price	25.00 EUR
sale_price_effective_date	2018-02-24T13:00-0800/2018-02-29T15:30-0800
color	black
size	s