CSV Mapping - Custom Date Format

CSV Mapping - Custom Date Format

CartRover users can configure date formats for outgoing CSV files, such as WMS - Order file, CSV Carts - Confirm file, and CSV Carts - Inventory files.


CSV CartsWMS Interface
Order FileNot SupportedYes
Confirmation FileYesNot Supported
Inventory FileYesNot Supported

Date Format: 

To edit date formats, please go to the Edit CSV File page. This function is only available on Edit CSV File page. 


Commonly used date formats: 

Date Format StringResults
(leave blank)CartRover Default: 2001-03-10 17:16:18
Y-m-d H:i:s2001-03-10 17:16:18 
Y-m-d2001-03-10
cISO 8601 Date: 2004-02-12T15:19:21+00:00
F j, Y, g:i aMarch 10, 2001, 5:16 pm
m.d.y03.10.01


Date Format Cheat Sheet: 

Date

Description

Examples

dDay of the month, 2 digits with leading zeros01 to 31
DA textual representation of a day, three lettersMon through Sun
jDay of the month without leading zeros1 to 31
l (lowercase 'L')A full textual representation of the day of the weekSunday through Saturday
NISO-8601 numeric representation of the day of the week1 (for Monday) through 7 (for Sunday)
SEnglish ordinal suffix for the day of the month, 2 charactersstndrd or th. Works well with j
wNumeric representation of the day of the week0 (for Sunday) through 6 (for Saturday)
zThe day of the year (starting from 0)0 through 365

Week

---

---

WISO-8601 week number of year, weeks starting on MondayExample: 42 (the 42nd week in the year)

Month

---

---

FA full textual representation of a month, such as January or MarchJanuary through December
mNumeric representation of a month, with leading zeros01 through 12
MA short textual representation of a month, three lettersJan through Dec
nNumeric representation of a month, without leading zeros1 through 12
tNumber of days in the given month28 through 31

Year

---

---

LWhether it's a leap year1 if it is a leap year, 0 otherwise.
oISO-8601 week-numbering year. This has the same value as Y, except that if the ISO week number (W) belongs to the previous or next year, that year is used instead.Examples: 1999 or 2003
YA full numeric representation of a year, 4 digitsExamples: 1999 or 2003
yA two digit representation of a yearExamples: 99 or 03

Time

---

---

aLowercase Ante meridiem and Post meridiemam or pm
AUppercase Ante meridiem and Post meridiemAM or PM
BSwatch Internet time000 through 999
g12-hour format of an hour without leading zeros1 through 12
G24-hour format of an hour without leading zeros0 through 23
h12-hour format of an hour with leading zeros01 through 12
H24-hour format of an hour with leading zeros00 through 23
iMinutes with leading zeros00 to 59
sSeconds, with leading zeros00 through 59
uMicroseconds. Will always be 000000 since timestamp data is only available to the second.Example: 654321
vMilliseconds. Same note applies as for u.Example: 654

Timezone

---

---

eTimezone identifierExamples: UTCGMTAtlantic/Azores
I (capital i)Whether or not the date is in daylight saving time1 if Daylight Saving Time, 0 otherwise.
ODifference to Greenwich time (GMT) in hoursExample: +0200
PDifference to Greenwich time (GMT) with colon between hours and minutesExample: +02:00
TTimezone abbreviationExamples: ESTMDT ...
ZTimezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.-43200 through 50400

Full Date/Time

---

---

cISO 8601 date (added in PHP 5)2004-02-12T15:19:21+00:00
rยป RFC 2822 formatted dateExample: Thu, 21 Dec 2000 16:01:07 +0200

Escape Characters

If you need to use a character in your date formatting that is a reserved character from above, it must be escaped. Escape characters by preceding them with a backslash: \

Example Format: \D\a\y Y-m-d

Example Result: Day 2017-01-30 

CSV Date Format Sample: 

The following example will put YYYY-MM-DD in the CSV order_date field. 


This documentation page (and this page only) is licensed under Creative Commons Attribution 3.0. All other documentation is Copyright CartRover.

The "Data Format Cheat Sheet" portion of this page is originally from php.net and has been modified to reflect the specific implementation used by CartRover.


    • Related Articles

    • Setting Up CSV Files

      CSV Files are treated like any other shopping cart. To setup, add a new cart and select CSV Files from the list of options. The logo for it is the same as the one shown above. Integration Specs: Supported functions: Order Download Shipment ...
    • CSV Warehouse Mapping Instructions

      To setup your own custom CSV format for sending orders from CartRover to your warehouse, go to the WMS Setup tab. If you already have defined some formats, you can select them here, otherwise click the Customize CSV Fields button at the bottom of the ...
    • CSV Cart Mapping Instructions

      To setup your own custom CSV format for loading orders into CartRover, in the CSV cart's settings, make sure the CSV File Format is set to Custom. If you already have defined some formats, you can select them, otherwise click the Manage CSV Formats ...
    • How to Upload CSV Order Files into CartRover

      CartRover offers the ability to upload CSV order files either manually into the CartRover interface or via FTP.  For instructions on how to load via FTP, please click HERE.  The below instructions will show where to manually load CSV files in the ...
    • How to Load CSV Order Files via FTP into CartRover

      CartRover offers the ability to upload CSV order files either manually into the CartRover interface or via FTP. CartRover can also provide confirmation and inventory files via FTP as well.  For instructions on how to load manually upload CSV files in ...