CMS Product Import
From NewHaven Software Wiki
CMS has the ability to import products from predefined spreadsheets. There are six spreadsheets in total, although not all are used in every situation.
The six spreadsheets are:
CMS-Products
CMS-SKU
CMS-Inventory
CMS-PriceCategory
CMS-Warehouse
CMS-Prices
CMS-Products
CMS-Products is the base product spreadsheet containing data that is solely related to the main product code (without consideration for color/size/SKU). The fields roughly correspond to what you would see at the product level if you were looking at a product in the "Product Information" window. Besides the product code itself, the spreadsheet contains fields such as "InvoiceDescription", "Brand", "AllowDecimal", and "DoesNotShip".
This spreadsheet covers all of the essential top-level settings for a product and can be used to import basic product information.
CMS-SKU
CMS-SKU is the secondary product spreadsheet containing data related to SKU level properties. This includes fields like "Weight", "Length", "UPC", and "VendorSKU". This spreadsheet is related to the "CMS-Products" spreadsheet via the "ProductCode" field.
