Integration Manager

Updated on December 6th, 2022
-
Order Sources
- Test Category
- 1ShoppingCart
- Amazon Direct Fulfillment
-
Amazon Seller Central
- Error: Amazon MWS Developer Access is About to Expire
- Missing Amazon Seller Central Orders
- Amazon Inventory Error - An FBA offer already exists on this SKU
- Amazon Could Not Upload Tracking
- Amazon Inventory Sync Issue
- Amazon - Access to Orders.ListOrders is denied
- Amazon Marketplace Integration Overview
- Amazon Marketplace Alerts
- Amazon Marketplace Settings
- Amazon Marketplace Extra Fields
- Amazon - No valid marketplaces
- Amazon Ship Methods
- Setting Up Amazon Seller Central
- Amazon orders marked as late even when shipped same day
- Amazon Ship Confirmation Delays
- ApparelMagic
- ArcDynamic
- AspDotNetStorefront
- BigCommerce
- BlueCherry
- ByDesign Freedom
- Centra
- ChannelAdvisor
- Cin7
- ClickBank
- Cratejoy
- CS Cart
- CSV Cart
- Dear Systems
- DemandStream
- DSCO
-
Ebay
- eBay Integration Overview
- Setting Up Ebay
- eBay Settings
- Ebay Error - Variation level SKU should be supplied to revise a Multi-SKU item.
- How to find "Sales Record Number" in eBay?
- Inventory-based listing management is not currently supported by this tool - Ebay
- Ebay listings not syncing with Extensiv Integration Manager
- Ebay Auth token is expired
- You've reached the number of items you can list - Ebay
- Using eBay Global Shipping Program
- Ecwid
- Etsy
- Faire
- Feature List
- Forecastly
- Google Shopping
- Groupon
- Houzz
- Infusionsoft
- Integral Group
- Joor
- Lightspeed Retail
- Linnworks
-
Magento
- Setting Up Magento
- Setting Up Magento 2
- Magento 1 Settings
- Magento 2 Settings
- Supported Plugins - Magento
- Invalid api path - Magento
- Magento 2 Permissions Error
- Magento orders missing products
- SOAP extension is not loaded - Error Message
- Access Denied - Magento
- Invalid carrier specified - Magento
- Magento Shipment Emails Don't Include Tracking Number
- Neto
- NetSuite
- Nexternal
- OnBuy
- OpenCart
- OrderBot
-
OrderStream
- Performing tests inside CommerceHub Testing Portal
- Setting Up CommerceHub OrderStream
- CommerceHub OrderStream Settings
- CommerceHub OrderStream Invoices
- CommerceHub Required Resources
- CommerceHub Orders Late or Not Shipped
- CommerceHub Inventory Not Updating
- CommerceHub Confirmation Error - PO does not exist for this relationship
- CommerceHub Confirmation Error - PO is not in a state where this action can be applied
- Setting up Merchant SKUs and UPCs - CommerceHub
- CommerceHub Walmart.com
- Overstock.com
- PayPal
-
PrestaShop
- Setting Up PrestaShop
- PrestaShop Settings
- Error pulling mapping code from PrestaShop
- Internal error. To see this error please display the PHP errors. - PrestaShop
- Blank Tracking Number - PrestaShop
- Shipping Confirmation Error - PrestaShop
- Fatal Error - PrestaShop
- Internal Server Error 500 - PrestaShop
- Unexpected HTTP Status 302 - PrestaShop
- Pulse Commerce
- Quickbooks
- Radial
- Rakuten.com
- SalesForce
- Shift4Shop - 3DCart
- ShipStation
-
Shopify
- Shopify Payment Status Info
- Shopify Inventory Not Syncing
- Shopify Integration Overview
- Setting Up Shopify
- Shopify Settings
- Shopify API Subject to Breaking Changes
- Shipping Method Setup - Shopify
- Shopify Filter Order Rules
- Shopify - Line Items: must be stocked at the same location
- Shopify Custom Fulfillment Service - Routing Items
- Shopify Products say: Unavailable on Extensiv Integration Manager
- How to Ignore Shopify POS Orders
- Shopify - This action requires write_orders scope
- Shopify - All line items of a fulfillment must use the same fulfillment service
- Order Manager
- SPS Commerce
- Squarespace
- Teapplix
- UltraCart
- Uniware ClearConnect
- Unleashed
- Veeqo
- Vend POS
- Vin eRetail
- Volusion
- Walmart Marketplace & DSV
- Wayfair
- Web Shop Manager
- Wish
- Wix
-
WooCommerce
- Setting Up WooCommerce
- Setting WooCommerce Timezone
- WooCommerce Settings
- Sorry, you are not allowed to create resources - WooCommerce
- Fix WooCommerce Permissions
- Error adding notes to order - WooCommerce
- WooCommerce reported a file not found error
- Invalid response from WooCommerce
- WooCommerce Confirmation Methods
- WooCommerce Inventory Sync
- Conflicting Order Numbers - WooCommerce
- Cannot connect to WooCommerce site
- WooCommerce Ship Methods
- Cannot communicate securely with peer - WooCommerce
- API key provided does not have write permissions - WooCommerce
- XML Cart
- Yahoo Stores - Small Business
- Zoho Inventory
- BrightSites
Custom Date Format - CVS Mapping
Extensiv Integration Manager users can configure date formats for outgoing CSV files, such as WMS - Order file, CSV Carts - Confirm file, and CSV Carts - Inventory files.
CSV Carts | WMS Interface | |
---|---|---|
Order File | Not Supported | Yes |
Confirmation File | Yes | Not Supported |
Inventory File | Yes | Not 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 String | Results |
---|---|
(leave blank) | Integration Manager Default: 2001-03-10 17:16:18 |
Y-m-d H:i:s | 2001-03-10 17:16:18 |
Y-m-d | 2001-03-10 |
c | ISO 8601 Date: 2004-02-12T15:19:21+00:00 |
F j, Y, g:i a | March 10, 2001, 5:16 pm |
m.d.y | 03.10.01 |
Date Format Cheat Sheet:Â
Date |
Description |
Examples |
---|---|---|
d | Day of the month, 2 digits with leading zeros | 01 to 31 |
D | A textual representation of a day, three letters | Mon through Sun |
j | Day of the month without leading zeros | 1 to 31 |
l (lowercase 'L') | A full textual representation of the day of the week | Sunday through Saturday |
N | ISO-8601 numeric representation of the day of the week | 1 (for Monday) through 7 (for Sunday) |
S | English ordinal suffix for the day of the month, 2 characters | st, nd, rd or th. Works well with j |
w | Numeric representation of the day of the week | 0 (for Sunday) through 6 (for Saturday) |
z | The day of the year (starting from 0) | 0 through 365 |
Week |
--- |
--- |
W | ISO-8601 week number of year, weeks starting on Monday | Example:Â 42Â (the 42nd week in the year) |
Month |
--- |
--- |
F | A full textual representation of a month, such as January or March | January through December |
m | Numeric representation of a month, with leading zeros | 01 through 12 |
M | A short textual representation of a month, three letters | Jan through Dec |
n | Numeric representation of a month, without leading zeros | 1 through 12 |
t | Number of days in the given month | 28 through 31 |
Year |
--- |
--- |
L | Whether it's a leap year | 1 if it is a leap year, 0 otherwise. |
o | ISO-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 |
Y | A full numeric representation of a year, 4 digits | Examples: 1999 or 2003 |
y | A two digit representation of a year | Examples: 99 or 03 |
Time |
--- |
--- |
a | Lowercase Ante meridiem and Post meridiem | am or pm |
A | Uppercase Ante meridiem and Post meridiem | AM or PM |
B | Swatch Internet time | 000 through 999 |
g | 12-hour format of an hour without leading zeros | 1 through 12 |
G | 24-hour format of an hour without leading zeros | 0 through 23 |
h | 12-hour format of an hour with leading zeros | 01 through 12 |
H | 24-hour format of an hour with leading zeros | 00 through 23 |
i | Minutes with leading zeros | 00 to 59 |
s | Seconds, with leading zeros | 00 through 59 |
u | Microseconds. Will always be 000000 since timestamp data is only available to the second. | Example: 654321 |
v | Milliseconds. Same note applies as for u. | Example: 654 |
Timezone |
--- |
--- |
e | Timezone identifier | Examples: UTC, GMT, Atlantic/Azores |
I (capital i) | Whether or not the date is in daylight saving time | 1 if Daylight Saving Time, 0 otherwise. |
O | Difference to Greenwich time (GMT) in hours | Example:Â +0200 |
P | Difference to Greenwich time (GMT) with colon between hours and minutes | Example:Â +02:00 |
T | Timezone abbreviation | Examples: EST, MDT ... |
Z | Timezone 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 |
--- |
--- |
c | ISO 8601 date (added in PHP 5) | 2004-02-12T15:19:21+00:00 |
r | » RFC 2822 formatted date | Example: 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 Extensiv.
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 Extensiv.