Format date and time

This article explains how to format dates and times when submitting your product data. You’ll submit dates and times for attributes such as availability_date, sale_price_effective_date, and expiration_date

How it works

Use the ISO 8601 standard, which this article explains in more detail. Depending on the attribute, you’ll submit a date or date range, and you can include a specific time.

Format a date

Include the date in the following format: 

  • YYYY-MM-DD

For example, to submit May 11, 2017, use: 

  • 2017-05-11

Include a time

To add a specific time to your date:

  1. Follow the date by the letter T
  2. Add the time of day in 24-hour format: hh:mm:ss. For example: 13:00:14
  3. After the time, add the time zone. For example, for UTC-8, use: -0800

For example, to submit May 11, 2017 at 12:01:59 AM for the UTC-8 time zone, use: 

  • 2017-05-11T00:01:59-0800

If you don’t include a time, we’ll use the end of the day: 23:59:59

If you don’t include a time zone, we’ll use a default time zone:

  • Text and XML feeds will use the default time zone for your target country. 
  • The API will use UTC.  
Country Default time zone for Text and XML feeds
Australia +1000
Brazil -0300
Canada -0500
Central European countries +0100
Japan +0900
Mexico -0600
New Zealand +1200
Russia +0400
Singapore +0800
United Kingdom Z or +00:00
United States -0800

Format date ranges

Some attributes accept date ranges that include a start and end date. A date range is a start date and end date separated with a slash ( / ): start/end

For example: 

  • 2017-05-11T00:01:59-0800/2017-06-21T22:13:59-0800 for PST
  • 2017-02-24T11:07:31+0100 for Central European Time 

If you don’t include a time, the start date will use 00:00:00, and the end date will use 23:59:59.

Examples

Variants

An example of ads without placeholder images
Product Android T-shirt
title Android T-Shirt - Green - Small
price 10.99 USD
sale_price 9.99 USD
sale_price_effective_date 2016-02-24T13:00-0800/2016-02-29T15:30-0800
color green
size s
id 9876-S-GRN
item_group_id 9876

 

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

 

Product Android T-shirt
title Android T-Shirt - Red - Small
price 10.50 USD
sale_price 8.99 USD
sale_price_effective_date 2016-05-11T13:00-0800/2016-02-29T15:30-0800
color red
size s
id 9876-S-RED
item_group_id 9876

Product is available for preorders with a specific release date

Product Android Squishable
availability preorder
availability_date 2016-12-25T13:00-0800 

Expiration date

An example ad showing how you can select different sizes for a product
Product Lederhosen
title Lederhosen - brown - L
expiration_date 2016-12-25

Was this helpful?
How can we improve it?