Field Mapping

Only see what you want to see. Explore based on your business's tech stack.

Show/Hide Integrations

Integrations

E-Commerce Radio button checked Radio button unchecked

Sales Forecasting For Shopify

Radio button checked Radio button unchecked

BigCommerce

Radio button checked Radio button unchecked

Lightspeed

Radio button checked Radio button unchecked

Magento

Radio button checked Radio button unchecked

Magento 2

Radio button checked Radio button unchecked

Neto

Radio button checked Radio button unchecked

Prestashop

Radio button checked Radio button unchecked

Square

Radio button checked Radio button unchecked

WooCommerce

Radio button checked Radio button unchecked

Marketplace Radio button checked Radio button unchecked

Sales Forecasting For Amazon

Radio button checked Radio button unchecked

eBay

Radio button checked Radio button unchecked

Sales forecasting for Walmart

Radio button checked Radio button unchecked

IMS Radio button checked Radio button unchecked

Cin7

Radio button checked Radio button unchecked

Dear

Radio button checked Radio button unchecked

Ecomdash

Radio button checked Radio button unchecked

Linnworks

Radio button checked Radio button unchecked

Mintsoft

Radio button checked Radio button unchecked

Odoo

Radio button checked Radio button unchecked

Orderhive

Radio button checked Radio button unchecked

Ordoro

Radio button checked Radio button unchecked

QuickBooks Commerce

Radio button checked Radio button unchecked

Skubana

Radio button checked Radio button unchecked

Unleashed

Radio button checked Radio button unchecked

Lightspeed Retail X-Series

Radio button checked Radio button unchecked

Zoho

Radio button checked Radio button unchecked

ERP Radio button checked Radio button unchecked

ERP

Radio button checked Radio button unchecked

NetSuite

Radio button checked Radio button unchecked

Accounting Radio button checked Radio button unchecked

QuickBooks Desktop

Radio button checked Radio button unchecked

QuickBooks Online

Radio button checked Radio button unchecked

Xero

Radio button checked Radio button unchecked

Data Warehouse Radio button checked Radio button unchecked

Snowflake

Radio button checked Radio button unchecked

Shipping & Fulfilment Radio button checked Radio button unchecked

Shipbob

Radio button checked Radio button unchecked

Shiphero

Radio button checked Radio button unchecked

ShipStation

Radio button checked Radio button unchecked

WMS Radio button checked Radio button unchecked

Descartes Peoplevox

Radio button checked Radio button unchecked

Ongoing WMS

Radio button checked Radio button unchecked

Others Radio button checked Radio button unchecked

CSV

Radio button checked Radio button unchecked

Unselect All Radio button checked

Select All Radio button unchecked

	Shopify	Amazon	BigCommerce	Cin7	CSV	DEAR (Cin7 Core)	Ecomdash	eBay	Lightspeed	Linnworks	Magento	Magento 2	Mintsoft	Neto	Odoo	Ongoing WMS	Orderhive	Ordoro	Prestashop	QuickBooks Commerce	QuickBooks Desktop	Quickbooks Online	Shipbob	Shiphero	ShipStation	Skubana	Snowflake	Square	Unleashed	Lightspeed Retail X-Series	Walmart	WooCommerce	Xero	Zoho
This is the Product Name (Products and Variants have a parent/child relationship). info Product Title	check	check	check	check	check	check	check	check	check	check	check info This information is only returned for products with sales data.			check	check	check info If an article does not exist in Ongoing when a purchase order is pulled from Inventory Planner, a new article is created containing SKU and Product Title	check	check	check	check						check	check	check	check	check	check	check		check
This is the Product Name (Products and Variants have a parent/child relationship) info Variant Title	check	check	check	check	check	check	check	check		check	check	check	check	check	check	info Ongoing does not sync article data from Inventory Planner, instead it is synced from Webshop or ERP system.	check		check	check	check	check	check	check	check	check	check	check	check	check	check	check		check
Photo of the product or variant (from your connected sales platform). info Image	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check		check		check	check				check		check	check		check	check		check
This is the URL directly connected to the Product in your store. info Handle (Product URL)	check		check		check			check		check	check	check		check					check								check					check
The Stock Keeping Unit refers to a unique code you assign to your variant or product. This is set in your sales platform and cannot be edited in Inventory Planner. info SKU	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check info If an article does not exist in Ongoing when a purchase order is pulled from Inventory Planner, a new article is created containing SKU and Product Title	check	check	check	check		check	check	check	check	check	check	check	check	check	check	check		check
The FNSKU is an acronym for Fulfillment Network SKU. The FNSKU is the way that Amazon identifies a product as unique to the seller that has sent it to the Amazon fulfillment center. info FNSKU		check														info Ongoing does not sync article data from Inventory Planner, instead it is synced from Webshop or ERP system.											check
The UPC of a product. If your connected sales platform does not have a barcode field, you can import this information using a Single or Multiple Vendor Catalog. info Barcode	check	info Inventory Planner pulls the ASIN, part number, or product ID from Amazon in place of the Barcode.	check	check	check	check	check		check	check		check		check	check		check	check	check	check	check		check	check		check	check		check		check
The Amazon Standard Identification Number is a 10-character alphanumeric unique identifier assigned by Amazon. info ASIN		check																check									check
Vendor is the distributor with whom you place orders. For example, Running Shoe Distributors. info Vendor	check info The Vendor field on your Shopify product page will show as the 'Brand' in Inventory Planner.			check	check	check	check		check	check	info Inventory Planner can pull it if a custom attribute is created for it in Magento.	info Inventory Planner can pull it if a custom attribute is created for it in Magento.	check	check	check		check	check	check	check	check	check info Vendors are pulled into Vendors tab, but variants will be set to an 'unknown' vendor (must be assigned in Inventory Planner).		check		check	check		check	check				check
A product name given by your vendor. This can be noted on purchase orders and is helpful when you and your vendor have different names for the same item. If your connected sales platform does not have a vendor product name or supplier product title field, you can import this information using a Single or Multiple Vendor Catalog. info Vendor Product Name						check									check												check		check
Use this field in your purchase order when the vendor uses a different SKU or code than you use in your store. If your connected sales platform does not have a vendor reference or supplier SKU field, you can add this in the Vendor section of Inventory Planner or import this information using a Single or Multiple Vendor Catalog. info Vendor Reference			check	check	check	check	check		check	check					check		check	check	check	check				check		check	check		check			check
Imported from your store or inventory management system. Tags are used to help describe and filter products, orders and other information within your store. If you would like to set tags within Inventory Planner, use IP Tags (Inventory Planner tags). info Tags	check		check	check	check	check			check		check info The 'meta keywords' field is used for pulling tags into Inventory Planner.	check info The 'meta keywords' field is used for pulling tags into Inventory Planner.					check		check	check				check	check	check	check			check	check	check
The ability to pull multiple locations or warehouses from the connection. When multiple locations can be pulled, they can be enabled/disabled independently. They can also be included in a Combined Warehouse (aggregates sales & stock from multiple locations into one view). info Multiple Warehouse	check	check		check		check	check		check	check			check	check	check		check	check		check	check		check	check	check	check	check	check	check	check	check			check
The ability to distinguish unique sales channels within the sales orders from a single connection. For example, an individual warehouse could fulfill orders from 5 separate sales channels. Generally these sales are consolidated into a total view at the location/warehouse level. info Individual Sales Channels		check info Amazon users can filter product listings by sales channel (not analytics).																									check
The ability to pull parent/child relationships from the system (between Products and Variants). info Parent Product	check	check	check	check	check	check	check	check		check	check info This information is only returned for products with sales data.			check	check		check		check	check						check	check	check	check	check		check		check
The category (or product type) is a label for a group of similar products. For example, skis might be in a winter sports category. Replenishment and Reporting can be based on trends at the category level as long as categories are assigned and pulled into Inventory Planner. info Category (Product Type)	check	check	check	check	check	check		check	check	check	check	check	check	check	check		check	check	check	check		check		check	check	check	check	check	check	check	check	check		check
The name the product is sold under on your site. For example, Nike. info Brand	info For Shopify users, the Vendor field will show as the 'Brand' in Inventory Planner.	check info Inventory Planner pulls the 'manufacturer' field and displays it in the 'Brand' field by default. If 'manufacturer' is empty in Amazon, then we pull the 'Brand' field	check	check	check	check		check	check	check				check			check		check	check						check	check		check	check		check		check
Kits, bundles, or groups of variants can be designated as bundles. For inventory management systems that support bundles/kitting natively, Inventory Planner automatically detects bundles and associates sales with their respective components/variants. Note: Bundles still need to be classified as Produced or Non-Produced in Inventory Planner. info Bundles/Assemblies	check info Integration available through the Bundles by Gazebo application.			check info Only one BOM configuration per product syncs.		check info Only one assembly configuration per product syncs. If a product has both BOM and Production BOM, then the Production BOM is used.	check			check	info Inventory Planner can pull bundles if a custom attribute is created for it in Magento.			check	check		check	check		check	check	check		check info Kits in Shiphero are considered bundles in Inventory Planner by default.		check	check		check	check				check
Sizes, colors and other variant options that apply to that SKU or product. This is set in your sales platform and cannot be edited in Inventory Planner. info Options	check		check	check	check			check				check			check				check	check							check			check		check		check
Shopify users can use Collections to group products together - to make it easier for customers to find them by category. info Collections	check																										check
Price that other competitors have listed the product at in Amazon (merchant does not set the 'compare to' price). The competitive price is pricing for active offer listings based on two pricing models: New Buy Box Price and Used Buy Box Price. info Competitive Price		check																									check
Comparison price (set by the merchant). info Regular Price	check	check	check		check			check						check						check							check					check
Current product retail price from your sales platform (set in the sales platform, and cannot be edited in Inventory Planner). info Actual Price	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check		check	check	check	check	check	check		check	check	check	check	check	check	check	check	check		check
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order. If costs can be pulled from your platform, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform. info Cost Price	check		check	check	check	check	check		check	check	check info Inventory Planner can pull cost price if a custom attribute is created for it in Magento.	info Inventory Planner can pull cost price if a custom attribute is created for it in Magento.	check	check	check		check	check	check	check	check	check		check		check	check		check	check		check		check
Landing cost price is the total unit cost (inc. shipping, handling, etc). They can be set/initialized in Inventory Planner. Over time, this will be replaced by Inventory Planner's computed landing cost price as you create and receive purchase orders (as long as you set the shipping cost and select to update variants when a PO is saved). info Landing Cost																											check
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. info Shipping Fee	check	check						check							check		check								check	check	check				check			check
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. info Tax	check	check	check	check		check		check		check	check	check								check	check				check	check	check	check			check	check		check
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. info COGS																											check
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. info MOQ					check					check																check	check
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. info UOM					check					check																check	check
The amount of time it takes from ordering a product from a vendor to receiving it into inventory. This is an important factor for your forecast, and is configured directly in Inventory Planner. info Lead Time																											check
The minimum stock level desired for a product at any time. This is configured (if needed) directly in Inventory Planner. Otherwise 'Days of Stock' can be used in its place. info Days of Stock																											check
The minimum stock level desired for a product at any time. This is configured (if needed) directly in Inventory Planner. Otherwise 'Days of Stock' can be used in its place. info Safety Stock																											check
Number of units of inventory as of the most recent sync. info Current Stock	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check		check	check	check	check	check	check	check	check	info Stock information is currently not available in ShipStation due to limitations with their API.	check	check	check	check	check	check	check		check
Number of units sold to customers. Up to two years of sales syncs by default when connecting to Inventory Planner. info Historic Sales	check	check	check	check	check	check	check	check	check	check	check	check	check	check	check		check	check	check	check	check	check	check	check	check	check	check	check	check	check		check
After receiving units on a stock order, push updated stock information to the connected platform. info Increase Stock Feature	check		check				check				check	check		check					check								check	check				check
Ability to push Purchase Orders from Inventory Planner to another platform. When this is possible, adjustments or receiving should always take place in the connected platform (to adjust the stock there). info Purchase Orders (PUSH)		check		check		check			check	check			check		check	check info Ongoing does not create any new purchase orders in Inventory Planner but will update existing purchase orders both in Ongoing and Inventory Planner, when they have been received in the warehouse.	check	check		check	check	check	check	check		check	check		check	check			check	check
Ability to pull Purchase Orders from a platform into Inventory Planner. When this is possible, adjustments or receiving should always be received in the connected platform (to adjust the stock there). info Purchase Orders (PULL)		check		check	check	check			check	check			check	info 'On Order' quantities from Neto are not pulled.	check	check	check	check		check	check	check	check info We can only pull purchase order information if the POs are created within Inventory Planner.	check		check	check		check	check				check
Ability to push Warehouse Transfer Orders from Inventory Planner to another platform. When this is possible, adjustment or receiving should take place in the connected platform to adjust the stock there. If the source warehouse is an IP warehouse (virtual warehouse), then the transfer order can be received directly in IP. info Transfer Orders (PUSH)		check		check		check			check	check info Integration does not support Amazon Transfers										check			check			check info Integration does not support saving Amazon FBA transfers	check		check	check				check
Ability to pull Warehouse Transfer orders from a platform into Inventory Planner. When this is possible, adjustment or receiving should take place in the connected platform to adjust the stock there. If the source warehouse is an IP warehouse (virtual warehouse), the transfer order can be received directly in IP. info Transfer Orders (PULL)		check info FBA shipments are synced to Inventory Planner as 'Purchase Orders' by default, with an unknown Vendor (Amazon does not provide source location). Order type and source can be changed directly in Inventory Planner.		check		check			check	check info Integration does not support Amazon Transfers						info Ongoing does not sync article data from Inventory Planner, instead it is synced from Webshop or ERP system.				check			check info We can only pull transfer information if the transfer orders are created within Inventory Planner.			check info Synced transfers are considered 'Sent' out of the source warehouse	check		check	check				check
Ability to push Assemble Orders (for Bundles) from Inventory Planner to another platform. When this is possible, adjustment or receiving should take place in the connected platform to adjust the stock there. If the assembly warehouse is an IP warehouse (virtual warehouse), the transfer order can be received directly in IP. info Assembly Orders (PUSH)				check		check									check					check							check		check
Ability to pull Assembly orders (for produced bundles) from a platform into Inventory Planner. When this is possible, adjustment or receiving should take place in the connected platform to adjust the stock there. If the source warehouse is an IP warehouse (virtual warehouse), the transfer order can be received directly in IP. info Assembly Orders (PULL)				check		check									check					check							check		check
Discounts = gross revenue - revenue. The discounted price is taken from actual sales orders by comparing the listed price to the price in the sale order. info Discounts	check	check	check	check		check			check	check	check	check			check		check		check	check						check	check	check				check		check
When the product was imported or created in your sales platform. The 'created at' date will reflect when the product or variant was set up in your system and is different from 'published at' date. info Created At	check	check	check	check	check			check	check	check	check	check		check	check		check	check	check	check	check	check	check	check	check	check	check	check	check	check		check		check
This is the most recent date in which item details were adjusted/updated in the connected platform. info Updated At	check		check	check	check	check			check	check	check	check		check	check		check	check	check	check	check	check			check	check	check	check	check	check		check		check
The date that your product or variant became visible to your customers. Note: if a product is published, then unpublished, and published again, the 'published at' date will be the most recent date when the item became visible on your site. info Published At	check																										check
Determines whether an item is currently published (visible) or unpublished in the connected platform. info Publish Status	check	check	check				check	check	check		check	check		check				check	check	check				check	check	check	check	check	check	check		check		check

Field Mapping

Integrations

Smarter inventory planning starts here